How to generate a report containing multiple single page reports

How to generate a report containing multiple single page reports

• Morri1234

  hi heta,

  this type of reports we hv done.

  what we are doing is , we are generting reports based on Syscode.

  so for individual report we can generate only one report per syscode but in main report we hv to generate same report for all syscodes.

  for this what we have done is we have created on Main.rdl report. there in dataset we are refering the master table which contains all syscodes.

  the we are calling the individual report as subreport in Main.rdl

  then just right click on subreport. go to the parameters and there u will have to match the paramters.

  ie syscode of individual report = syscode(master table which we are refering in main report)

  this should solve ur problem

  sandeep

  
  
  

• ciberch

  Hi,

  You want a single report or .PDF file which should have each page, each ID provided. This what I understood. Correct me If I am wrong.

  use table and group it with "ID" and check on "page break at end". This will create single page with given ID. export it to PDF it gives you a single file with multiple ID pages. hey I dont think this simple. Do you mean this :-))

  Or do you mean

  each ID contains one report which should print it on single page. Is that what you want

  Amarnath

  
  

• TMP72

  You seem to be on the right track.

  The list control will iterate based on the number of rows returned from the query. Since your're getting three pages, I'm assuming you've already added a query to the main report which returns one row per value the user selected. If that's the case, it sounds like the only thing you're doing wrong is handing the original report parameter in to the subreport rather than handing in the value of the field (which was returned from the original query).

  So the structure of your report(s) should look like this:

  Main report contains Parameter1 (which is a multivalue parameter)

  Main report contains Query1 (which returns all of the items for the user to select from)

  Parameter1 derives its selection list from Query1

  Main report contains MainQuery which is: Select Field1 from Table1 where Field1 IN (@Parameter1)

  Main report contains List1 (with no group expressions) which is bound to MainQuery

  List1 contains SubreportControl1 which is bound to your parameterized subreport

  SubreportControl1 passes =Fields!Field1.Value as the value of SubParam1 (the parameter in your parameterized subreport).

  Note: Depending on the contents of your subreport, you might be better off doing this all in a single report. You can put the entire contents of the subreport into a list instead of using the subreport mechanism. This will only work if the subreport only has a single main query, however. But if it does, may be more efficient than executing separate queries for each subreport. If your typical case is only 3 subreports, this may not matter for you.

  
  

• Nikolay Shustov

  nvm figured it out i wasn't using a list on the form... duh!

  
  

• Shane Stevens

  can you send me the report file that you used I'm having trouble duplicating these steps ... i'm creating a print all feature which an id will get passed in and a year and all the records for the given ID should be printed to a appending report of the same type just with different data. I have a temp table and my code correctly inserts and updates the records, I'm just having trouble creating multiple reports from the data. At best one report is printed.
  

• egen-Vipul

  Thanks for help.

  I am doing exactly what you have mentioned. But somehow it's not working. If i pass 3 parameters, it displays three page report with the same information in all three pages.

  I cannot use list control instead of using subreport because my subreport has multiple main queries.

  Any more ideas

  Thank you.

  
  
• How to generate a report containing multiple single page reports