Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Category: Reportviewer

Reportviewer

How to solve extra blank page at end of Microsoft Reportviewer

- 31.07.23 - ErcanOPAK comment on How to solve extra blank page at end of Microsoft Reportviewer

To solve that problem you need to set the property ConsumeContainerWhitespace to True (in the properties dialog, F4).

Read More
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 […]

Read More
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 […]

Read More
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  

Read More
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”)  

Read More
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 […]

Read More
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”;

Read More
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”

Read More
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”, “☒”, “☐”)

Read More
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”)

Read More
November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (981)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (653)
  • Add Constraint to SQL Table to ensure email contains @ (609)
  • Average of all values in a column that are not zero in SQL (570)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (547)
  • Find numbers with more than two decimal places in SQL (475)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit
  • SQL Server: Fix ROW_NUMBER Ties Reordering Between Identical Runs
  • C#: Fix an Enum HasFlag Returning True for the Zero Value
  • WordPress: Fix Featured Images Vanishing After a CDN Migration
  • Photoshop: Fix Content-Aware Fill Smearing a Repeating Pattern
  • Asp.Net Core: Fix Antiforgery Tokens Rejected Behind a Reverse Proxy

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (981)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com