Line break in SSRS expression
UseEnvironment.NewLine instead of vbcrlf
reporting-services
Select All as default value for Multivalue parameter
Try setting the parameters’ “default value” to use the same query as the “available values”. In effect it provides every single “available value” as a “default value” and the “Select All” option is automatically checked.
Could not load file or assembly ‘Microsoft.ReportViewer.WebForms’
This link gave me a clue that I didn’t install a required update (my problemed concerned version nr, v11.0.0.0) ReportViewer 2012 Update ‘Gotcha’ to be aware of I installed the update SQLServer2008R2SP2 I downloaded ReportViewer.msi, which required to have installed Microsoft® System CLR Types for Microsoft® SQL Server® 2012 (look halfway down the page for … Read more
How do I open SSRS (.rptproj) files in Visual Studio 2013?
It can be opened with Microsoft SQL Server Data Tools – Business Intelligence for VS2013: http://www.microsoft.com/en-us/download/details.aspx?id=42313 The download is live again as of 6/2/14
Passing multiple values for a single parameter in Reporting Services
Although John Sansom’s solution works, there’s another way to do this, without having to use a potentially inefficient scalar valued UDF. In the SSRS report, on the parameters tab of the query definition, set the parameter value to =join(Parameters!<your param name>.Value,”,”) In your query, you can then reference the value like so: where yourColumn in … Read more
Reporting Services Remove Time from DateTime in Expression
Something like this: =FormatDateTime(Now, DateFormat.ShortDate) Where “Now” can be replaced by the name of the date/time field that you’re trying to convert.) For instance, =FormatDateTime(Fields!StartDate.Value, DateFormat.ShortDate)
Is there an easy way to rearrange tablix columns in SSRS design mode?
There is a way to move columns through the designer: insert the number of blank columns you want to move in your destination spot shift-left-click on the cells (NOT the header column) you want to move right-click and select the Cut command right-click on top of the destination columns and select Paste delete the now … Read more
In SSRS, why do I get the error “item with same key has already been added” , when I’m making a new report?
It appears that SSRS has an issue(at leastin version 2008) – I’m studying this website that explains it Where it says if you have two columns(from 2 diff. tables) with the same name, then it’ll cause that problem. From source: SELECT a.Field1, a.Field2, a.Field3, b.Field1, b.field99 FROM TableA a JOIN TableB b on a.Field1 = … Read more
Display Parameter(Multi-value) in Report
You can use the “Join” function to create a single string out of the array of labels, like this: =Join(Parameters!Product.Label, “,”)
SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8… why?
Ultimate solution (works in SSRS 2012 too!) Append the following script to “C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\js\ReportingServices.js” (on the SSRS Server): function pageLoad() { var element = document.getElementById(“ctl31_ctl10”); if (element) { element.style.overflow = “visible”; } } Actually I don’t know if the div’s name is always ctl31_ctl10: in my case it is (instead over SQL … Read more