faisalsham
Programmer
hello all,
this is what I want my result set to look like:
ID counter
-------------
100 1
100 1
123 2
123 2
135 3
136 4
I want the counter to increment anytime I have a new ID. I have the following code in a formula in the details section:
but that returned all 1's ... it didn't increment like I thought it would.
Am I doing something wrong here??
thanks in advance...
this is what I want my result set to look like:
ID counter
-------------
100 1
100 1
123 2
123 2
135 3
136 4
I want the counter to increment anytime I have a new ID. I have the following code in a formula in the details section:
Code:
dim intcounter as number
if PreviousValue ({rptInvoiceList.Workflow_Id}) <> {rptInvoiceList.Workflow_Id} then
intcounter = intcounter+1
end if
formula = intcounter
but that returned all 1's ... it didn't increment like I thought it would.
Am I doing something wrong here??
thanks in advance...