**** grouping

hey peeps

well ive been stuck on this for a long time ... if anyone can help, i would appreciate it very much ....

in the database where im getting the data from, the data is displayed in the following way:

PART_ID PART_NAME PROD_TYPE DESC PASS_TYPE PASS_CNT
-----------------------------
4 BERT 5 CASH 0 15
6 BORO 5 CASH 0 1
6 BORO 5 CASH 3 4
etc
etc

here's my problem. when i try and display this in crystal, i group it by part_id and by prod_type but i still get two rows for CASH ...
example:

PRODUCT OPERATOR ADULT YOUTH
---------------------------
5 (CASH) 6 (PART_ID) 1 (PASS_COUNT)
5 (CASH) 6 (PART_ID) 4 PASS_COUNT

So what im trying to do is basically display it in one row....
NOW, ideally i want the above to be like this:

PRODUCT OPERATOR ADULT YOUTH
--------------------------
5 (CASH) 6 (PART_ID) 1 (PASS_COUNT) 4 PASS_COUNT

can anyone help ....
thanksK.
Lemme try this.

Firstly, if PASS_COUNT is a sumable value, it'll b a somewhat easier solution.
Make a formula field on your report that sums the pass_cnt field.
then place that field into the place of the other field.

Otherwise you can just make a sumed result set in your sql.
like

select ....,
sum(pass_cnt)
from <table>
where <conditions>
group by part_id,
part_name,
prod_type,
desc

but remember to leave out pass_type and pass_cnt. That is to elimenate the multiple rows.

Hope this helps somewhat.