Print Page | Close Window

Can you put a report in a report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19536
Printed Date: 02 May 2024 at 2:03am


Topic: Can you put a report in a report
Posted By: swatts
Subject: Can you put a report in a report
Date Posted: 14 May 2013 at 8:00am
Or a launcher?

I have a report that has all of my stuff then I have 2 reports that have signatures in subreports.  Is there a way to launch those 2 reports in my big report?


Replies:
Posted By: DBlank
Date Posted: 14 May 2013 at 8:45am
not sure i follow you set up but in general you cannot have a subreport inside of a subreport.

Posted By: swatts
Date Posted: 14 May 2013 at 8:54am
I know, that's why I had the problem to begin with. One of smaller reports has nothing in common link-wise to the Big report or the other report, so I cannot add it into the big (main report), so I decided to make it a separate report, but I need to be able to launch it within the big report.

Posted By: DBlank
Date Posted: 14 May 2013 at 9:00am
does it require run time parameters?
You can place any report inside another report and have them be completely unrelated data wise.

Posted By: swatts
Date Posted: 14 May 2013 at 9:13am
Yes they all have run time parameters.

Posted By: DBlank
Date Posted: 14 May 2013 at 9:38am

I assume that is where you are getting stuck.

If so just make the paramters for the sub reports as main report params.
Make these params a formula field in the main report
Now link the main report to the sub report on those formual fields and it will pass teh param values down to the subreport so you can filter your data that way without linking on nay other actual DB value.

Posted By: swatts
Date Posted: 20 May 2013 at 8:46am
One of the smaller reports has nothing in common in its table with the big one.

Posted By: DBlank
Date Posted: 20 May 2013 at 8:56am
the dont have to have anything in common.
Say it is a number.
in the main report set up a numeric param (e.g. ?ID)
make a formula field called whatever and just drop the param field into it (e.g. {?ID})
now you can use this formula field as a link. In any section inthe main report it always has the same value in it, (whatever the user typed into the param when they ran the report)

Posted By: swatts
Date Posted: 21 May 2013 at 4:45am
Since that is the case, let me ask this... In database expert, do all the databases have to be linked?

Posted By: DBlank
Date Posted: 21 May 2013 at 4:53am
in the main report? Technically No. Although I am pretty sure that if you do not link them they will do a cartesion join which gives you every permutation of join all the tables together, which can explode your results to millions. You will not see the cartestion result until you actually use a field from each table (same as not enforcing a join).


Print Page | Close Window