Multiple Passes

[pcapozzi]

I need to generate a report from a query with several
buckets see example below.

Query

FileNo TranCode Coverage Amount
1 300 1 10.00
1 300 2 5.00
1 400 1 6.00
2 300 1 4.00
2 400 1 5.00

I would like report to look like this

File Combo 1 Combo 2 Combo 3
{300 + 1} {300 + 2} {400 + 1}
1 10.00 5.00 6.00
2 4.00 0 5.00

Currently I am getting this.

File Combo 1 Combo 2 Combo 3
1 10.00 0 0
0 5.00 0
0 0 6.00
2 4.00 0 0
0 0 5.00

I would like the report to only have one line.

Thanks
Pieter

 

[SA]

Pieter:

You need to have your report's underlying query group by FileNo. Then set
the other fields in the query to have a "Max" value.