While running report if user make some selection which reflects no data I want display some default message instead of blank screen. How it can be achieved
SQL Server Reporting Services
While running report if user make some selection which reflects no data I want display some default message instead of blank screen. How it can be achieved
There is a NoRows property on the table and the matrix that you can use.
Put your message in there and it will be displayed when the table/matrix has no rows.
BobP
Charts also have the NoRows property, but I have not been able to get it to work. I have a report with approximately 10 charts (all of which use the same data set), and when the result set is empty, I get an error -
An unexpected error occurred in Report Processing.
Object reference not set to an instance of an object.
Thanks,
Marianne
I would look at your expressions first. The NoRows on the chart works. I just tested it.
Maybe there is an expression looking for a value that is not there.
BobP
Hi BobP,
Thanks for suggestion.
I tried to search for NoRows property related to table and matrix but I couldnt manage to do it.
Also I modified the XML related to my report and added NoRows tag as a child tag in Report tag. However its not working.
Do you have any idea regarding this
Mahesh Kulkarni
BobP,
I think I found where the issue is. In addition to the charts, I have a text box that looks like a button that jumps to another report (it passes parameters to the second report). The second report has three tables, and also has a "button" that jumps back to the graph report.
When I remove the text box from the graph report, the NoRows property works. The NoRows property works on the table report even when the text box is there.
Any idea why the graph report wouldn't work with the text box
Thanks,
Marianne
Here are the details of Microsoft Visual Studio installed on my macine
Microsoft Visual Studio 2005
Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework
Version 2.0.50727
Installed Edition: IDE Standard
SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 9.00.1399.00
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 9.00.1399.00
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 9.00.1399.00
Are there any configurations which i should do before starting report development
I would suggest you download and install SP2 for SQL Server 2005.
BobP
Thank you very much BobP
I will install SP2 for SQL server 2005 and try the same.