Crystal Reports Subreport within Subreport

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Subreport within Subreport

Author	Message
cagirl95864 Newbie Joined: 17 Apr 2009 Location: United States Online Status: Offline Posts: 4	Topic: Subreport within Subreport Posted: 29 Apr 2009 at 4:55pm
	Crystal XI - I am having a problem running a sub report within another sub report. To make it easier to explain: Master Report (A) -->> Sub Report (B) -->> Sub report (c) C is a sub report embedded in B and B is a sub report embedded in A. From A i can see B but not C. If I run B on its own, I can see C. Is this even possible in Crystal? Edited by cagirl95864 - 29 Apr 2009 at 4:55pm
	-cagirl95864
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 29 Apr 2009 at 9:08pm
	Sorry, pretty sure you cannot have a sub report of a subreport.(B in a and C in B) You can have multiple subreports in one report. (both B and C in A)
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 30 Apr 2009 at 6:09am
	I am going to say no. If you have a main report and add a subreport to it. You cannot add a subreport to this subreport...there is no option. So I am willing to bet that if you create a report with a subreport and then set it as a subreport to another report, that Crystal will only look 1 level down and will ignore the 2nd subreport.
	IP Logged

rahulwalawalkar Senior Member Joined: 08 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 731	Posted: 01 May 2009 at 1:36am
	Hi Is it possible for you to modify the SQL and combine the subreport query in single query , if you see subreport links are basically left joins in SQL ,so if you could combine the data in one single query it will be nice. the reports will also run faster.... yes lockwell is correct you can't have a subreport within subreport Cheers Rahul
	IP Logged

cagirl95864 Newbie Joined: 17 Apr 2009 Location: United States Online Status: Offline Posts: 4	Posted: 01 May 2009 at 1:15pm
	Thanks for the replies. Bummer I can't do a sub within a sub. I'll give the combined SQL w/left joins a try - thanks for the suggestion!
	-cagirl95864
	IP Logged

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