Hello:
I have created a report where I am displaying fields from the database: Sequence #, Account, Amount, Site ID.
However, I need only the ones that have more than one record with combination of Sequence # and Account (ex. Seq # 202 with Account 34567). First, I wrote a formula (@SeqAcct) to combine Seq # and Account (Seq # + Account).
I wrote a formula and put it in the Suppress part of the Details section, which works but only display the first record of the multiples I want to display. This is the formula in the Suppress part: (@SeqAcct) <> (Next(@SeqAcct))
So, right now it is like this:
202 34567 258.36 001
I want to get it like this:
202 34567 258.36 001
202 34567 25.54 002
Does anyone have any suggestions on how to get it to display more than just the first record?
Thanks,
L.
I have created a report where I am displaying fields from the database: Sequence #, Account, Amount, Site ID.
However, I need only the ones that have more than one record with combination of Sequence # and Account (ex. Seq # 202 with Account 34567). First, I wrote a formula (@SeqAcct) to combine Seq # and Account (Seq # + Account).
I wrote a formula and put it in the Suppress part of the Details section, which works but only display the first record of the multiples I want to display. This is the formula in the Suppress part: (@SeqAcct) <> (Next(@SeqAcct))
So, right now it is like this:
202 34567 258.36 001
I want to get it like this:
202 34567 258.36 001
202 34567 25.54 002
Does anyone have any suggestions on how to get it to display more than just the first record?
Thanks,
L.