Can you use shared variables in the record selection formula editor?
I have a Amount in the main report and a Paid in the subreport and want to print out only the ones that are not equal sorted by a Code.
In the record selection editor I used the following formula:
{EMCHD.HD_EMC_CD} = {?Code}...
I need to search a field in a file for all records that have a "-" in the third position and print yes. If it doesn't search a different file and print out that field.
if {cust.PH_NMBR} [3] = "-" then "YES" else {rs.MODE}
My problem is that my else doesn't work.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.