Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: "Select Expert - Record" Post Reply Post New Topic
Author Message
stevetothink
Newbie
Newbie


Joined: 18 Oct 2010
Online Status: Offline
Posts: 37
Quote stevetothink Replybullet Topic: "Select Expert - Record"
    Posted: 15 Jul 2011 at 3:37am
I'm modifying an existing subreport and I am having a hard time following the formula being used in the subreport's "select expert - record". It looks like it just repeats the same thing twice. Can anyone help me understand what this formula is doing in the "select expert -record" feature of crystal?

({ROTConfirmationofRelease_TD.Pid } = {?Pm-ROTConfirmationofRelease.Pid}) and

{ROTConfirmationofRelease_TD.Pid } = {?Pm-ROTConfirmationofRelease.Pid} and

({ROTConfirmationofRelease_TD.Transaction Key} = {?Pm-ROTConfirmationofRelease.Release Key}) and

{ROTConfirmationofRelease_TD.Transaction Key} = {?Pm-ROTConfirmationofRelease.Release Key}
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 15 Jul 2011 at 5:07am

when you have a sub report linked to a main report right click on the subreport edit joins. if you remove them and go to the sub report the record selection should be blank. what happens sometimes is if they are removed from the subreport by report right click on the subreport edit joins, they dont always come out of the record selection.

if you delete them from the record selection in the sub the right click on the subreport edit joins and remove them.
then add them in you should only see it once in the sub report record selection.
sharona
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.