April 19, 2011 at 1:01 am
Hi All,
I am creating a report which has 9 subreports.
Each of the subreport has a chart. When I run the subreport rdls independently it works fine. But when I add it to a report as a subreport and set up the parameters, it behaves in the following way:
1. If the dataset for the sub report has rows, a chart is displayed.
2. If no rows are present, there is a blank space in the parent report where the subreport should have been present.
If I pass the same parameters to the subreport directly(when its not embedded in the main report) and no data is returned, I get the data not available message displayed.
I was hoping to get the same thing in the main report as well but it just gives the blank space.
Can anyone point me in the right direction on how to tackle this issue?
I am using SSRS 2008.
Your suggestions are really appreciated.
Regards,
Manish
April 19, 2011 at 3:11 am
Hi All,
I have found out a workaround to this issue.
For some reports in which the title was getting the report names from the dataset. These reports had 2 data sets
1. To get name based on parameter for title
2. Details for preparing chart.
In these reports, i get the data not available message for the chart.
To test that whether this is the issue, I added datasets with queries like
Select 'A' to the reports which were not getting displayed and it worked.
Though I don't like this solution a bit, it does gets the chart displayed.:-P
If anyone knows how to solve this issue in a more elegant way please let me know. I'll try a few more things and update if they work out.
Thanks,
Kratos
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply