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
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)) )
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
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
Try setting the table’s “Visibility.Hidden” property to this expression: =CountRows() = 0
There is some good advice and queries for generating reports on this in the following article. For example, if you want to see the most used reports, you can do the following: SELECT COUNT(Name) AS ExecutionCount, Name, SUM(TimeDataRetrieval) AS TimeDataRetrievalSum, SUM(TimeProcessing) AS TimeProcessingSum, SUM(TimeRendering) AS TimeRenderingSum, SUM(ByteCount) AS ByteCountSum, SUM([RowCount]) AS RowCountSum FROM (SELECT TimeStart, … Read more
Thanks for the suggestions provided here. We have found a solution and it did turn out to be related to the parameters. SQL Server was producing a convoluted execution plan when executed from the SSRS report due to ‘parameter sniffing’. The workaround was to declare variables inside of the stored procedure and assign the incoming … Read more
It’s because of lack of privilege for the user you are running the report builder, just give that user or a group a privilege to run report builder. Please visit this article Or for shortcut: Start Internet Explorer using “Run as Administrator” Open http://localhost/reports Go to properties tab (SSRS 2008) Security->New Role Assignment Add DOMAIN/USERNAME … Read more