Showing Data

[vafishing]

I am using CR8 and here is my situation. I have on the detail line a column of information. Name and Group. I want to show the name and the group they belong to on the same detail line. However if a name belongs to another group, crystal repeats the name and put them on a different detail line. I want to be able to show the name once (suppress if duplicate) and show their various groups in columnar fashion on the same detail line (horizontal) not vertical as crystal does by default (ie
Name GroupA GroupB
John Smith x x

Crystal does it this way
Name
John Smith GroupA
John Smith GroupB

 

[hneal98]

Sort by name and then group.

 

[synapsevampire]

Use Insert->Cross-tab and place the Group in the details as a maximum, and the name in the rows.

Place the cross-tab in the report header or report footer.

This assumes that "I have on the detail line a column of information. Name and Group." means that you have 2 columns, not a column.

Instead of X's you'll get the group name.

If you need that format exactly, let us know.

-k

 

[vafishing]

Yeah could you send the exact format as you indicated. I am trying to visualize what you are saying. Are you saying put the Name in the row section and the group in the column section and use a formula to differentiate the groups or something else?

 

[Madawc]

Just follow synapsevampire's advice; choose Crosstab and it gives you the options. (At least it does in Crystal 8.5).

Madawc Williams (East Anglia, UK)

 

[lbass]

Use the name as the row field, use {table.group} as the column field, then create a formula {@x}:

if not isnull({table.group}) then "x"

Use {@x} as your summary field, and choose "maximum" as the summary.

-LB