Joined: 12 Jun 2007
Location: United States
Online Status: Offline
Posts: 1
Topic: Select expert same selection for main & sub-report Posted: 12 Jun 2007 at 7:47am
Having a problem in my main report and sub-report where I have a field used for selection criteria (shift)-----both reports need to select the same value from the main. Any help??? I looked at shared variables but have not been able to get this to work.
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 12 Jun 2007 at 9:09am
Yeah, I just got done writing about this in my subreport chapter. I assume that you are using a parameter to set which data to filter on? In the Subreport Links dialog box (right-click on the subreport object and choose Set Subreport Links), for the main report select the parameter that the user enters. For the link field in the bottom left hand corner of the subreport, choose the EXISTING parameter that is used in the records selection formula for the subreport. Crystal Reports will want to create a new parameter for you and put it in that link box, but just ignore it and click the dropdown list to pick the existing parameter. By choosing the existing parameter then your subreport automatically links to the main report's parameter.
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>
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
IP Logged
