Crystal Reports Can you put a report in a report

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Can you put a report in a report

Author	Message
swatts Groupie Joined: 17 Mar 2010 Online Status: Offline Posts: 83	Topic: Can you put a report in a report 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?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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.
	IP Logged

swatts Groupie Joined: 17 Mar 2010 Online Status: Offline Posts: 83	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.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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.
	IP Logged

swatts Groupie Joined: 17 Mar 2010 Online Status: Offline Posts: 83	Posted: 14 May 2013 at 9:13am
	Yes they all have run time parameters.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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.
	IP Logged

swatts Groupie Joined: 17 Mar 2010 Online Status: Offline Posts: 83	Posted: 20 May 2013 at 8:46am
	One of the smaller reports has nothing in common in its table with the big one.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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) Edited by DBlank - 20 May 2013 at 8:57am
	IP Logged

swatts Groupie Joined: 17 Mar 2010 Online Status: Offline Posts: 83	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?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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).
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.