Newbie question re: grouping/formattings …

[cksmith]

I have a data set that looks like this

 

ID, Provider, Appt Date, Patient, Note Date, Notes, etc…

 

Code:

1234, Dr. Jones, 12/19/2006, John Q Public, 12/18/2006, Mr Public …
1234, Dr. Jones, 12/19/2006, John Q Public, 12/19/2006, Patient looked fine…
1234, Dr. Jones, 12/19/2006, John Q Public, 12/22/2006, Lab results came in …

I want the report to look like this …

1234, Dr. Jones, 12/19/2006, John Q Public, 12/18/2006, Mr Public …
 	12/19/2006, Patient looked fine…
        12/22/2006, Lab results came in …

I’ve got a grouping so that all the 1234 records are together and separated but I’d like to remove the duplicative data resulting from the join in the first 4 columns.

 

Thanks in advance,

Chad

[scottmacpherson]

It sounds like you just need to create a group in the report, with a condition something like

Code:

$F{Field1}+$F{Field2}+$F{Field3}+$F{Field4}

Put those 4 fields in the group header, then put the remaining fields in the detail section.

Jasper will then start a new group, and display fields 1-4 when any of them change, and list the broken-down data below the heading.

[cksmith]

that worked - thx :)