Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4239
  • Last Modified:

SSRS Subreport Not Displaying in Main Report

I'm using BIDS to develop a report in SSRS 2012.
The main report shows responses to a survey on courses being taken; there are five questions, the first four allowing answers in the format 1 to 4 (i.e. 1= Poor, 2 = Satisfactory etc.). The fifth question is a simple Yes/No. The report aggregates the responses and shows as a percentage, so for example, English Language may have 13% saying the course content is 4 (Excellent). So far so good for the first four questions.
However, because the fifth question is in a different format I've created a sub-report so I can show the responses as % Answering yes v No.

The main report has no parameters and has groupings on course and course Level; the sub report also groups on Course and Course Level, and takes input parameters on Course, Course Level and a third parameter (@Recommend) which tells the stored procedure it only wants to see the responses to the fifth question. The @Recommend parameter is hard-coded into the subreport datasource; the other two parameters are entered manually if the report is run stand-alone, or are passed from the main report.

The sub-report works fine if run on its own. It also works if I embed it within the Tablix of the main report which I tried to test if it was passing the parameters correctly. However, if I place it below the tablix of the main report it does not display. Is there something I'm missing or doing wrong?
0
Karl_mark
Asked:
Karl_mark
  • 2
1 Solution
 
Karl_markAuthor Commented:
Actually, scrub some of the question! I figured out why it wasn't displaying at all; The main report was missing the grouping on Course Level.
So, the question now becomes, how can I get the subreport to appear for each group and not at the end of the report?
0
 
planoczCommented:
The  sub-report has to be placed inside the group. Also make sure that your subreport is running correctly (the sub-report is just a regular standalone report  that is added to the main report). And that your parameters right being imported into the subreport.
0
 
Karl_markAuthor Commented:
Thanks Planocz. I did figure out the putting it inside a group bit, but I'll give you the points anyway!
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now