Showing detail info in group header 1

[furthur]

I have data something like this:

Call_ID Answer
1 red
1 blue
2 blue
2 green
2 orange

There can be multiple Answers for each Call_ID. Is there a way to show in the group header (for Call_ID) all the Answers? Such as:

Call_ID: 1 Answers: red,blue
Call_ID: 2 Answers: blue,green,orange

 

[kenhamady]

Yes, as long as the result won't go over 254 characters.

This requires a fairly sophisticated use of variables and running totals. Read the FAQ on running totals, especially the 3 - formula technique. You use a running total that accumulates a stringVar instead of numerics and you reset it to "" at the beginning of each group. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[FoxG]

Hi,
this is quite easily achieved with a running total field and two simple formulas.

If you can send an email to geoff.fox@salford.gov.uk I will send you a sample crystal report (version 7) showing how to achieve this.

Hear from you soon,
Geoff Fox (Senior IT Services Officer)