Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: umbrella report to host 8 subreports - Post Reply Post New Topic
Author Message
maverikk
Newbie
Newbie


Joined: 25 Jul 2012
Location: United Kingdom
Online Status: Offline
Posts: 20
Quote maverikk Replybullet Topic: umbrella report to host 8 subreports -
     Posted: 25 Jul 2012 at 4:26am
Hi there. i am looking for some advice pls. i am using crystal9 and have 8 reports that i have to run, each with the same parameters. it would be way quicker if i could update only 1 set of parameters to run them all so i am trying to set up an umbrella style report to house each of the individual reports, but my set parameters userform is just listing each parameter for each report. can anyone help pls?

Also, do i need to attach a database to the umbrella one as a starting point? Thanks. paul
IP IP Logged
z9962
Senior Member
Senior Member
Avatar

Joined: 04 Jul 2012
Online Status: Offline
Posts: 161
Quote z9962 Replybullet Posted: 25 Jul 2012 at 4:59am

In the main report you will need to create parameters that match the type in the subreports.

 

Then link these to the subreports...

 

1. right mouse click on each subreport, select change sub report links

2. select the newly created parameters on the left and move to the right

3. on the right side select the first parameter

4. below the left list, there is a comboBox subreport parameter field to use, from this list select the corresponding parameter, repeat for all parameters and subreports

 
Hope this solves your issue?
IP IP Logged
maverikk
Newbie
Newbie


Joined: 25 Jul 2012
Location: United Kingdom
Online Status: Offline
Posts: 20
Quote maverikk Replybullet Posted: 25 Jul 2012 at 5:10am
Thank you z9962. i mustve been going wrong with the bottom combobox on change links. i will try it out now.
thanks for your time.
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 25 Jul 2012 at 6:39am
Hi
 
As you said you have 8 reports and need to run with same parameter values. To previent re-entry of parameters you can insert all reports in one report. 
 
Create a blank report with parameters (if these are static then no database connection or selection is require; if these paramters are dynamic then you should have database connectivity)
 
Insert multipul Report Footer sections and suppress rest of the sections
 
Insert each report in report footer
 
Now right click on each sub report and go in Change Subreport Links and link main report parameters to sub report parameters.
 
Now Execute your main report this will take parameter values once and will pass it to your sub reports.
 
 
Thanks,
Sastry
IP IP Logged
maverikk
Newbie
Newbie


Joined: 25 Jul 2012
Location: United Kingdom
Online Status: Offline
Posts: 20
Quote maverikk Replybullet Posted: 25 Jul 2012 at 8:45am
Thanks sastry. this is kinda where i started. however, i was inserting the sub reports into extra details sections, not footers. Yhanks for your time, will try this tomorrow when i get to work.
IP IP Logged
maverikk
Newbie
Newbie


Joined: 25 Jul 2012
Location: United Kingdom
Online Status: Offline
Posts: 20
Quote maverikk Replybullet Posted: 25 Jul 2012 at 9:36pm
Thanks for this. i am now faced with all of the parameters on the refresh userform. I guess i need to wnter something in the select expert to limit the choices?
The parameters i am using are @period, @centre, @visitors and @type.

Thanks for your help.
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 26 Jul 2012 at 2:47am
Hi
 
If you see the same parameters multipul times in your refresh pane, it means, there linking of sub reports to main report parameter is not proper.
 
Check the links once again in 'Change Sub Report Links; option.
 
 
Thanks,
Sastry
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 26 Jul 2012 at 4:09am
The parameters need to be defined in the subreports first.  Then you need to link the parameters from the main report directly to the corresponding parameter in the subreport - not to the default "PM-" parameter that is created by the link.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
maverikk
Newbie
Newbie


Joined: 25 Jul 2012
Location: United Kingdom
Online Status: Offline
Posts: 20
Quote maverikk Replybullet Posted: 15 Aug 2012 at 5:49am
Thanks to everyone- solved now. just need to follow the instructiond better! Thnks.
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.