Crystal Reports Conditional Merge of Cross Tab Report
Posted on 2015-01-08
I have written a report that generates past due orders per machine for our manufacturing facility. The report shows hours booked per machine, grouped by week end. However, it is showing dates (week buckets) in the past. I need to do an if statement to evaluate if the date field is less than today, i want to move that data to a new column names "Past Due". I have a strong vba background and am quickly discovering that none of the vba language rules apply in crystal, unfortunately.
So far, I can do:
if desired_ship_date <today then
everything here doesn't work.
What would be the proper syntax to pass the cross tabbed data to a variable and insert a column titled "Past Due" and insert this data in that field?
Thanks so much!