.rdlc Report – Cannot create a data reader for dataset ‘DataSet1’
I have same problem that “Cannot create a data reader for dataset ‘zzz’” The answer is ReportDataSource(string xxx, DataTable yyy) You should use the right name. xxx should be zzz
reporting-services
Reporting Services Deployment
We use rs.exe, once we developed the script we have not needed to touch it anymore, it just works. Here is the source (I slightly modified it by hand to remove sensitive data without a chance to test it, hope I did not brake anything), it deploys reports and associated images from subdirectories for various … Read more
How to get named excel sheets while exporting from SSRS
Necromancing, just in case all the links go dark: Add a group to your report Also, be advised to set the sort order of the group expression here, so the tabs will be alphabetically sorted (or however you want it sorted). ‘Zeilengruppe’ means ‘Target group’ ‘Gruppeneigenschaften’ means ‘Group properties’ Set the page break in the … Read more
Value expression error: “[BC30456] ‘RdlObjectModel’ is not a member of ‘Reporting Services’
Found this bug report which exactly explains the problem I had: http://connect.microsoft.com/SQLServer/feedback/details/757358/pasting-objects-with-expressions-pastes-fully-qualified-functions Summary of the above: When you copy/paste reporting services expressions from one place to another (I copied an entire tablix, with expressions in it) all the pieces of that expression get expanded to their full names. There is a bug specific to when … Read more
SSRS Query execution failed for dataset
I enabled remote errors to pinpoint the problem. I identified that a column in a particular dataset (one of my views) was throwing an error. So using a tool “SQL Delta”, I compared the development version of the database with the live version on the reporting server. I noticed that one of the views had … Read more
SSRS – Checking whether the data is null
try like this = IIF( MAX( iif( IsNothing(Fields!.Reading.Value ), -1, Fields!.Reading.Value ) ) = -1, “”, FormatNumber( MAX( iif( IsNothing(Fields!.Reading.Value ), -1, Fields!.Reading.Value ), “CellReading_Reading”),3)) )
How do I best display CheckBoxes in SQL Server Reporting Services?
I, along with others in my shop, have used images, toggling the hidden attribute based on the field value (true or false). We haven’t had any problems with blurring or scaling, unless we tried to increase the scale of the image beyond 100% obviously. Another option I’ve used is similar to the wingdings idea, but … Read more
Can’t see “Report Data Pane” when creating reports
For users facing the problem now, using Microsoft Visual Studio 2012 Shell (Integrated), Business Intelligence Development Studio / SQL Server Data Tools, if you find Report Data pane missing or you close it accidentally,do the following: Click the ‘Design‘ of the report or the ‘Design‘ pane of report Now in the ‘Menu bar‘ on the … Read more
Download all SSRS reports
There is a complete & simpler way to do this using PowerShell. This code will export ALL report content in the exact same structure as the Report server. Take a look at the Github wiki for other options & commands #—————————————————— #Prerequisites #Install-Module -Name ReportingServicesTools #—————————————————— #Lets get security on all folders in a single … Read more
SQL server reporting services: how to stop a report firing when opened
I found that I had to set at least one of the report parameters to not have a default to keep the report from autorunning. I had to use this configuration (notice that all 3 of the parameters I left without defaults accept Nulls so the users can just click the Null checkboxes): [screenshots missing] … Read more