Joined: 08 Jan 2010
Online Status: Offline
Posts: 3
Topic: Dynamic subreports Posted: 04 May 2011 at 12:44am
Hello everyone,
I was wondering if it possible to create a crystal report with a standard first and last x pages and load a different "content" report in between those pages. What we need is pretty much a "dynamic external subreport" (ie one template report with a placeholder for an at design time unknown external subreport).
Right now we do this by splitting up the reports into three different rpt files, and then merge the 3 reports into 1 PDF.
We are considering upgrading to the full version of Crystal Reports and this would be a great feature for us.
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 04 May 2011 at 7:17am
You can't do dynamic subreports, but one way around this is to create multiple sections and have a different subreport in each section. Then use the conditional formatting formula to suppress all the subreports except for the one that you want to show in the current report. This formula will need some way to look at the report data and determine which subreport needs to be shown.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Posted: 04 May 2011 at 7:24am
In addition to brian's method, you could prompt the user to select a report that they wish to view and then use that value for conditional section suppression.
Joined: 08 Jan 2010
Online Status: Offline
Posts: 3
Posted: 04 May 2011 at 9:43pm
Thanks, but that is pretty unfortunate :(
Putting everything in one report and using multiple (surpressed) sections would clutter up the report too much. It would be pretty hard to both maintain and keep the overview. (right now already over 25 sections/pages need to be surpressed)
I guess we will stick to the PDF merging strategy.
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