location A [group1]
invoice 1 [group2]
invoice 2 [group2]
location B [group1]
invoice 1 [gpoup2] - (same value as found in location A but doesn't respond to invoice#=previous(invoice#) formula to set a condition)
And correct, a particular invoice# only shows up once under each location.
The goal is to have any invoice# change color if it shows up more than once anywhere in the report.
I don't understand why this is happening. It seems like other reports work fine with a similar setup. Might I have a wrong setting somewhere .. or does this seem like it needs a more involved formula...
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 30 Nov 2016 at 10:22am
Ahhh
Your location group is splitting up the invoice.
That is why previous/next wont work as it is the order in which it is displayed in the report, not the source table.
That is a bit tricky. There are not likely any good ways to do this with creating another data point to use.
Do you have rights to creating a stored procedure or a crystal command?
If so you can create a count of the invoices and then join that to the data set and use the count value to conditionally set your font color.
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
