Print Page | Close Window

"Select Expert - Record"

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13764
Printed Date: 02 May 2025 at 5:47pm


Topic: "Select Expert - Record"
Posted By: stevetothink
Subject: "Select Expert - Record"
Date 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}


Replies:
Posted By: sharona
Date 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


Print Page | Close Window