How to add subReport to main report to display similar data

  • I created a main report with 2 parameters, StartDate and EndDate (Where StartDate = @StartDate AND EndDate = @EndDate)

    Now, I want to create a subreport which displays certain information using same parameters, StartDate and EndDate (Where StartDate = @StartDate AND EndDate = @EndDate).

    Why is it not working for me?

    I kept getting following error:

    ERROR: subreport could not be shown.

    Does anyone know where to fix this problem?

    I just want to show different information based on startDate.

    Thanks a lot in advance

  • Unfortunately that error message is a little vague however take the following steps...

    1. Run the report (that is used in the sub report) in Visual Studio ensuring it works...

    2. Build and deploy the report being used as the sub report.

    3. On the master report (the report containing the sub report) ensure the Parameters are mapped successfully, left click on the sub report, click on parameters, are the parameters used on both Master report and sub report spelled correctly and mapped correctly? For example I used a Parameter on the master called "ClientID" and also on the sub report called "ClientID". Then mapped to the settings found in the screen-shot...

    Hope this helps!

  • Thanks a lot. Everything is working now.

    I really appreciate it.

  • Not a problem at all... Just wait till you start playing with visibility and page numbers, outputting etc using sub reports.... All i have to say is migrane!!!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply