group

[Swetal2004]

Hello!
part of my data set from a table
ID Code priority code
012655100191 36.01 01
012655100191 36.07 02
012655100191 37.22 03

I want to create a crystal report to display the above data as below
ID Code Code Code
for for for
priority priority priority
code of 01 code of 02 code of 03
012655100191 36.01 36.07 37.22

I would like to see each ID and all their code as one record according to their priority code

 

[synapsevampire]

You might cheat this by using a crosstab, placing the priority code in the column, the max of the code in the details, and the ID in the rows.

Not the exact look, but it's close.

Otherwise you'll need to create formulas to accomplish the tabular look and feel.

-k

 

[Swetal2004]

Due to the nature of the report I cannot use crosstab. Can you please help me with the formula?

I tried it by grouping by ID and creating fromula but only the first code shows up rest of the code are blank.

Thanks

 

[lbass]

You would create a series of detail level formulas like:

//{@01}:
if {table.prioritycode} = "01" then {table.code}

//{@02}:
if {table.prioritycode} = "02" then {table.code} //etc.

Then right click on each formula and insert a maximum. Drag the group name (ID) and then suppress the detail section and group header.

-LB

 

[Swetal2004]

Thank you very much.
It worked perfectly and sorry for the delay in writing you back