Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: passing parameters to sub report Post Reply Post New Topic
Author Message
edwong
Newbie
Newbie


Joined: 02 Dec 2011
Online Status: Offline
Posts: 3
Quote edwong Replybullet Topic: passing parameters to sub report
     Posted: 09 Jul 2012 at 3:30pm
I created a main report and made 2 sub reports (copying the main report and made into sub report.)  The report is a sales & comm report with one subreport analyse sales by customers and the other sales by commodity group.  All reports worked fine and numbers correct but when running the report the main and the sub reports parameters all shows and need input values.  I've done the sub report link but still not able to pass.  The main and subreport have the same report selection formulae.  the selection formula require input of month end date (the start date are specified in the selection as 2 years before the month end date so extract also comparative values for last year todate.  then a pararmeter for selecting sales agent (discrete) and in the selection specify the territory code(s) for the agent, other selection criteria are exclusion of certain account type, zero dollar invoices etc. 
 Your help in Anyone advising me the right way in handling this would be much appreciated.
 
Thanks
 
EW
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 10 Jul 2012 at 7:07am
When you set up your subreport links, do NOT use the default "PM_..." parameter that appears in the Linking Expert.  Instead, drop-down that list and select the actual parameter name that is already set up in your subreport.  This will link the param in the main report to the correct parameter in the subreport.
 
-Dell
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