I had some troubles with this one as well. Microsofts own documentation states a simple comma delimited list of values in the Value box should work. This is confusing because IT DOESN’T. At least it didn’t for me and I am using SSRS 2012 with Visual Studio 2010. It turns out that when you are … Read more
If you want it as a string use: =Format(Fields!CUL1.Value, “F2”) As a number use: =FormatNumber(Fields!CUL1.Value, 2) This will ensure it exports out to excel correctly as a number.
New preview release of SSDT November 2015 Preview in Visual Studio now supports .rptproj extensions. ETA: SQL Server Data Tools are now GA (Generally available) as of 2016-06-01
It’s a bit wonky from what I’ve managed to dig up. In your grouping pane, select advanced mode, then select your outermost static row. You should then see the “RepeatOnNewPage” property. Update: finding Advanced Mode: The comment by @HCL links to the other answer by @user359904, that has the info on how to find and … Read more
Format with Currency format string =Format(Fields!Price.Value, “C”) It will give you 2 decimal places with “$” prefixed. You can find other format strings on MSDN: Adding Style and Formatting to a ReportViewer Report Note: The MSDN article has been archived to the “VS2005_General” document, which is no longer directly accessible online. Here is the excerpt … Read more
I tried the example that you have provided and the only difference is that you have True and False values switched as bdparrish pointed out. Here is a working example of making an SSRS Texbox visible or hidden based on the number of rows present in a dataset. Step-by-step process: SSRS 2008 R2 In this … Read more
To refer to any report objects you can use ReportItems Collection. In your header textbox put a expression like this to refer to textbox in the list: =ReportItems!TextBoxList1.Value Remember SSRS is case sensitive. Make sure you get the right name of the text box object you are referring to. MSDN article on ReportItems
Open the report’s .rdl file in a text editor and locate the <Page></Page> section. In that section, insert the following: <InteractiveHeight>0in</InteractiveHeight> <InteractiveWidth>8.5in</InteractiveWidth> In SSRS, an interactive height of 0 means the report has an infinite length and therefore, it will exist on a single page.
=iif(isNothing(Fields!FV1.Value), Fields!FV2.Value, Fields!FV1.Value)
First, be sure to replace Reports/Pages/Report.aspx?ItemPath= with ReportServer?. In other words, instead of this: http://server/Reports/Pages/Report.aspx?ItemPath=/ReportFolder/ReportSubfolder/ReportName Use this syntax: http://server/ReportServer?/ReportFolder/ReportSubfolder/ReportName Parameters can be referenced or displayed in a report using @ParameterName, whether they’re set in the report or in the URL. You can attach parameters to the URL with &ParameterName=Value. To hide the toolbar where parameters … Read more