[Webinar] Learn how to a build a cloud-first strategyRegister Now


SSRS Subreport Not Showing

Posted on 2009-04-23
Medium Priority
Last Modified: 2012-05-06
I have two reports, one the Company for DC report is the parent.  The Gift Expenses for DC report is the subreport.  I'm just passing 1 parameter between the reports: SpendDateCalendarYear.  I'm getting an error stating that the subreport can not be shown.  I'm passing in the subreport parameter as follows:  =First(Fields!ParameterValue.Value, "SpendDateCalendarYear").  On the subreport, the parameter name is also named SpendDateCalendarYear, it is hidden and has no available values, and I have a default of 2008.  I'm not sure what I'm doing wrong, why the subreport won't appear.  I can email the reports to somebody who wants to help.
Question by:Kaporch
  • 3

Author Comment

ID: 24217968
Update: when I hardcode the parameter I'm passing in the parent report as '2008', the subreport appears correctly.  Also, if I don't pass in any parameter to the subreport, it appears correctly.  Using the value of Parameters!SpendDateCalendarYear.Value to pass in from the parent to the subreport doesn't work.  Also, using a field in the dataset (which I know has a valid value of 2008, I tested on the report) doesn't work.  What's the valid format to pass parameters into a subreport?

Author Comment

ID: 24242721
The first subreport is showing ok using =Parameters!SpendDateCalendarYear.Value as the value being passed in, but the 2nd report using the same parameter value is giving the report can not be displayed error.  Also, the 3rd report with no parameters being passed in does not display either.

Accepted Solution

Kaporch earned 0 total points
ID: 24250059
I found out the problems I had had to do with using headers & footers in the child reports.  Moderator, please refund my points.
LVL 31

Expert Comment

by:James Murrell
ID: 24257481
http://www.experts-exchange.com/help.jsp check it for how to close and get points

Expert Comment

ID: 25791571
Kaporch, so are header and footers in child reports necessary or to be avoided, or is there a way to use them? I don't have any in my child report and yet still get "Error: Subreport could not be shown", even tho i've checked and rechecked the params i pass.
I was not successful doing this: "when I hardcode the parameter I'm passing in the parent report as '2008', the subreport appears correctly." But if i set a default in the child report for the report param, the child on it's own appears fine according to that param value.
So what's the deal with headers and footers, can you describe briefly?

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

868 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question