Skip to content

ErcanOPAK.com

  • ASP.Net WebForms
  • ASP.Net MVC
  • C#
  • SQL
  • MySQL
  • PHP
  • Devexpress
  • Reportviewer
  • About

Category: Reportviewer

Reportviewer

How to use Switch in Reportviewer

- 06.10.21 | 06.10.21 - ErcanOPAK comment on How to use Switch in Reportviewer

= Switch(Fields!YourField.Value = “Value1”, “The result of the first condition”, Fields!YourField.Value = “Value2”, “The result of the second condition”, Fields!YourField.Value = “Value3”, “The result of the third condition”, 1 = 1 , “That is for the default value” ) 1=1 refers to default in switch case.   IF you want to use IIF then You […]

Continue Reading ..
Reportviewer

How to set hyperlink to open in new window in Reportviewer

- 06.10.21 - ErcanOPAK comment on How to set hyperlink to open in new window in Reportviewer

The MSDN lists supported HTML in SSRS, quoting that article: • Hyperlinks: <A HREF> • Fonts: <FONT> • Header, style and block elements: <H{n}>, <DIV>, <SPAN>, <P>, <DIV>, <LI>, <HN> • Text format: <B>, <I>, <U>, <S> • List handling: <OL>, <UL>, <LI> Only the href attribute on a tag is supported. That means target attribute will be ignored. To set hyperlink to open in new window in Reportviewer, you must set the “HyperlinkTarget” property of Reportviewer […]

Continue Reading ..
Reportviewer

How to format decimal number like “00.00” in ReportViewer

- 27.07.21 - ErcanOPAK comment on How to format decimal number like “00.00” in ReportViewer

=Format(CDbl(Fields!YourDecimalNumber.Value),”00.00″) OUTPUT for 3,2: 03.20 for 34: 34.00  

Continue Reading ..
Reportviewer

How to display total sum of seconds in hh:mm:ss format in ReportViewer

- 27.07.21 - ErcanOPAK comment on How to display total sum of seconds in hh:mm:ss format in ReportViewer

=Format(DateAdd(“s”, Fields!MySecondsField.Value, “00:00:00”), “HH:mm:ss”)  

Continue Reading ..
Reportviewer

How to split numeric and decimal parts in ReportViewer

- 27.07.21 - ErcanOPAK comment on How to split numeric and decimal parts in ReportViewer

‘Int’ Function returns the integer protion of a number. For integer part: =Int(3.14159) -> This gives the number 3 or you can use with that value comes from DataSource =Int(Fields!TheDataSourceField.Value) For decimal part: =3.14159 – Int(3.14159) -> This gives a value close to 0.14159 or you can use with that value comes from DataSource =Fields!TheDataSourceField.Value […]

Continue Reading ..
Reportviewer

Rename Report while exporting to PDF or Excel in Microsoft ReportViewer

- 31.12.19 - ErcanOPAK comment on Rename Report while exporting to PDF or Excel in Microsoft ReportViewer

ReportViewer1.LocalReport.DisplayName = “The_Name_For_My_Report”; or ReportViewer1.ServerReport.DisplayName = “The_Name_For_My_Report”;

Continue Reading ..
Reportviewer

How to make some specific word(s) Bold or Underline in ReportViewer

- 02.02.19 | 22.11.19 - ErcanOPAK comment on How to make some specific word(s) Bold or Underline in ReportViewer

Click into the text box (so your cursor is in the text box) Right Click and select “CREATE PLACEHOLDER” In Markup Type select “HTML – Interpret HTML tags as styles” In Value: Bold: =”This is a <b>Queue</b> Builder” Underline: =”This is a <u>Queue</u> Builder”

Continue Reading ..
Reportviewer

How to control “a checkBox is checked or not” in RDL reportview

- 02.02.19 | 22.11.19 - ErcanOPAK comment on How to control “a checkBox is checked or not” in RDL reportview

1. If you don’t want to use embedded indicators of ReportViewer then you can use the characters from charmap. That is the easiest way. In that case, you will put the ballot box and ballot box with X with the code. =iif(Fields!<<fieldname>>.Value.ToString() = “1”, “☒”, “☐”)

Continue Reading ..
Reportviewer

How to change ReportViewer Date Format

- 02.06.18 | 30.08.20 - ErcanOPAK comment on How to change ReportViewer Date Format

=Format(Fields!Date,Value,”dd.MM.yyyy”)

Continue Reading ..
May 2022
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Apr    

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (331)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (220)
  • Find numbers with more than two decimal places in SQL (191)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (190)
  • Confirm before process with ASPxButton in Devexpress (189)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (189)
  • How to make some specific word(s) Bold or Underline in ReportViewer (189)
  • Devexpress ASPxGridview Column Grouping in Code (177)
  • Add Constraint to SQL Table to ensure email contains @ (174)
  • Tense Changes When Using Reported Speech (167)

Recent Posts

  • How to put text inside MVC Razor code block
  • How to solve 0xc0000135 application errors after Windows 11 Update
  • How to get the integrity value for a jquery version of script reference in a web page
  • How to get session value in Javascript
  • How to get value from resx file in C#
  • How to lock the ciritical code part in C#
  • How to make theater mode the default for Youtube
  • How to turn off YouTube annotations and cards
  • How to hide Youtube chat windows permanently
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server

Recent Posts

  • How to put text inside MVC Razor code block
  • How to solve 0xc0000135 application errors after Windows 11 Update
  • How to get the integrity value for a jquery version of script reference in a web page
  • How to get session value in Javascript
  • How to get value from resx file in C#

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (331)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (220)
  • Find numbers with more than two decimal places in SQL (191)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (190)
  • Confirm before process with ASPxButton in Devexpress (189)

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter

powered by XBlog Plus WordPress Theme