= 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 […]
Tag: report
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 […]
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”;