SSRS: Main report outputs just a blank page

1
votes

SSRS: I have a main report with 2 sub-reports. First sub-report contains 4 tables and 2 charts and second sub-report contains 9 charts.

The main report has 6 parameters to choose from. The deal is when sub-reports are ran separately, its working fine(shows-up tables/charts/matrices even when it doesn't contain any data). But when main report is ran, it just shows-up blank page (no tables or charts or matrix..). This happens only for very few parameters(that has data to feed just charts on sub-report-1)

Did any of you face a similar problem and fixed it? I would really appreciate all your help! Thanks!

1
sql-serverreporting-services
1 lesson I learned with SSRS is that you don't need subreports unlike Crystal reports. You can create datasets that are driven by your parameters. – maSTAShuFu
Usually this issue occurs if the subreport is not in the same directory as the main report. Can you confirm they are in the same location? I assume it is not working in VS? Also which versions are you using? – Holmes IV
Try hard coding the parameters to the sub reports and seeing if it works then. If it does then double check what you think you are passing in – Jason Webber
This is an indication that a report is not running because required parameters are missing. – niktrs
@HolmesIV - sub reports are in the same location and yes it doesn't work in the VS and Reporting Services as well. I use SQL Server Data Tools 14.0.60629.0 – Sri

1 Answers

0
votes

I had to just return zeros for that data field of the dataset and ran the main-report and it worked fine! I hope this helps if anyone has similar issues..