Group Header Display issue

[dev1212]

I have 5 fields
Accnt_nb
Trxn_id
Arl_id
trxn_value_text
arln_item

I inserted group on accnt_nb, trxn_id, arl_id
and i am displaying trxn_value_text in second group header (Trxn_id).
I have values in trxn_value_text like 'node1', 'node2', 'node3'

Report displaying
==============================

Acct223346463544
Trxn325515631 node1
Arln2576

Report required
===============================

Acct223346463544
Trxn325515631 node1
node2
node3
Arln2576





when i refresh report i see 'node1' i.e., the first value in second group header but i want to display all 3 values.

when i am displaying trxn_value_text in second group footer (Trxn_id) i am getting 'node3' i.e., the last value.

If i display it in details section i can see all the 3 values but i want it in 2nd group header.

Is there any way i can display all three values in 2nd group header?(which is the requirement)

 

[dev1212]

Any ideas guys..?

 

[Madawc]

Do you have more than one record for values like 'node1'? If so, group on this field, within your other grouping. Display a value in your G2 group header or footer. Suppress the detail lines (which you are probably doing already).

This of course would give you two displays of 'node1' in your example. The simplest solution is to suppress it using a running count on the field, with the 'Distinct Count' option. WHen it is 1, suppress the G2 header (or whatever).

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

It's also a good idea to wait longer than 73 minutes before posting a reminder. You can make it less likely that anyone will check because they will think someone else has answered. Better to leave it a day or two.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

Are the three values always different from each other? Or can they be the same? You could use formulas like:

Nthlargest(1,{table.node},{table.Trxn_id})

Change the 1 to 2 and 3 in two additional formulas.

Otherwise, you could also insert a subreport that displays only the node values that is linked on the first two group fields (but not the third group).

Another option would be to insert a crosstab in the group #2 header that has the node text as both row (or column) and summary field. Then suppress the label and remove the grid.

-LB

 

[dev1212]

Hi Madawc,
There seems to be a misunderstanding. Let me put it this way.
I want to display detail records in group header section.
All the detail records.
Note: If i drag and drop the detail field in header then it gives me the first value of that record. If i drop it in footer then it gives me last value of that record. But i have a requirement to display all the details in Group Header section. Underlaying is not an option because i want to display the detail records in GH2 and my report has 3 groups already. so if i use underlay then it will be displayed in GH3 section but not in GH2.

Thanks

 

[dev1212]

lbass,
thanks for your reply.

The values can be same and different.

Let me try your solutions.

Thanks

 

[dev1212]

Cross tab solution worked...

Thanks a lot lbass..