October 7, 2009 at 2:11 pm
I have a query that returns a list of Purchase Orders for each supplier. The query is to be used in a report (this may be a report forum post?).
What do I want to achieve.... The report groups by Customer so I have
Customer A
..............Order 1000
..............Order 2000
..............Order 3000
..............Order 4000
Customer B
..............Order 5000
..............Order 6000
..............Order 7000
..............Order 8000
I want the report to output:
Customer A
1..............Order 1000
2..............Order 2000
3..............Order 3000
4..............Order 4000
.
.
300...........Order xxxx
Customer B
1..............Order 5000
2..............Order 6000
3..............Order 7000
4..............Order 8000
.
.
250...........Order xxx
Hope that makes sense.
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
October 7, 2009 at 2:24 pm
I have found the solution:
RowNumber("grpSupplierName")
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply