Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Sub Report linkage Post Reply Post New Topic
Author Message
pakhurst
Newbie
Newbie


Joined: 15 Nov 2011
Location: United Kingdom
Online Status: Offline
Posts: 2
Quote pakhurst Replybullet Topic: Sub Report linkage
     Posted: 15 Nov 2011 at 1:36am
Can anyone tell me if it is possible to link a sub report to more than one parameter in the main report. (eg when a main report is paramacised for both a 'startdate' fieldĀ and an 'enddate' field and It is necessary to apply the same date constraints to the same fields in the sub report).?
If so - what is the process?
thanks
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Nov 2011 at 4:00am
Yes.
one way (if you cannot use the param directly as the link is to make two formual fields in the main report
name=startdate
and just insert the ?startdate param field
name=enddate
insert the ?endddate param
now right click on the subreprt and change subreport links
use the @sratdate and @enddate formula fields to link on
hit OK
int he subreport use the 2 new params that were created in the select expert
{table.datefield} in {?Pm-@startdate} to {?Pm-@enddate}
IP IP Logged
pakhurst
Newbie
Newbie


Joined: 15 Nov 2011
Location: United Kingdom
Online Status: Offline
Posts: 2
Quote pakhurst Replybullet Posted: 15 Nov 2011 at 9:42pm

Thanks DBlank - I'll give it a try

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