crystal report issue 1

[sarah1147]

i am new to crystal report..and following is the problem that i am facing.

1-The Report result will be exported and viewed in excel only. No need of printing it.
2-The Report is based on Stored Procedure.(oracle 10g). sp = (P_FCT_CONTRACT_DATA)
3-The ideal report will have 1 line for each agreement number (AGMT.NBR)
FOR this reason, currently the report is filtered to only 1 agreement number "L84".
4- The idea is to have all the fields in one row, and then remove the filter.
to get 1 line per agreement number.
Problem:
5- 1 (one) agreement bringing 4 rows because each line represent
different category. categories like (Gathering-Processing-Other-Low)

6- For now the report show 4 lines in detail.
Solution required:
7- some kind of SORTING or Grouping should be applied to get all the values in 1 row.
8- Repeatitive value should be displayed once.
for example:
agr-cola-colb-colc-cold-cole-colf- colg- colh - coli - colj
------------------------------------------------------------------
L84 A B C E G I J
L84 A C E F G I J
L84 A C E G H I J
L84 A C D E G I J

agr-cola-colb-colc-cold-cole-colf- colg- colh - coli - colj
------------------------------------------------------------------
L84 A B C E G I J


The possible solution, is to create 4 different groups, and group each group by each category.
Gh1- ABC-E-G-IJ (gathering group)
Gh2- A-C-EFG-IJ (processing group)
Gh3- A-C-E-GHIJ (other group)
Gh4- A-CDE-G-IJ (low group)

NOW maybe in detail or any group footer or any new group...
have some formula which can "CALL" the missing info from each group and put the result set in 1(one row) for each agreement.

it is because.. the report will have 90 to 150 agreement number.
and if the repeat as doing right now... report will strecth out very long.

The final result would look like..
L84- ABCDEFGHIJ

please help asap. i am trying this from last 2 days, and my head is spining now.

report is attached. saved with data.
suppresing is not working. neither on section nor format level.
creating variable and calling it, making line repeatition.
remember if we suppres the field..it will suppress only that field...the whole row would still show up.

 

[lbass]

Your example isn't very clear, since your first explanation of the desired result shows some, but not all, single values. You later seem to want to show all values that appear in any row. Assuming that is true, all you need to do is group on the agreement number, place all other fields in the detail section, and then right click on each and insert a maximum on each field. Then either drag the groupname into the group footer, or move the summaries to the group header. Then suppress the detail section and the empty group header (or footer).

-LB