Dynamic subreports
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13107
Printed Date: 04 May 2024 at 10:08pm
Topic: Dynamic subreports
Posted By: laoujin
Subject: Dynamic subreports
Date 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.
So anyone know if this is possible? :)
Thanks!
Wouter
|
Replies:
Posted By: BrianBischof
Date 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>
|
Posted By: Keikoku
Date 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.
|
Posted By: laoujin
Date 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.
|
|