Group By

[tweetyng]

Could you please help with this question? can I add these records to only one line with group by patient_no such as:


Patient_no RX Meds dose

1252 INH 600 mg
1252 RIF 800 mg
1252 B6 50 mg
1252 EMB 1250 EA

I would like to show on the report only one line such as:

Patient_No Meds
1252 INH 600mg, RIF 800mg, B6 50mg, EMB 1250mg

Thanks

 

[IdoMillet]

Group on Patient_No

Reset a global stringVar to "" in a GH1 formula
Append to the string variable in a detail formula
Remove the last ", " in the string variable and display its content in a GF1 formula.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[tweetyng]

Thanks for your reply IdoMillet. However, I don't quite understand much what you said. Could you please explain more detail on this one. Thanks

 

[Madawc]

Here's something similar I did for collecting postcodes.

// Accumulate using a formula field (suppressed) in the detail line.  Allow for nulls and blanks.
whileprintingrecords;
if not isnull({Recc.Postcode}) and {Recc.Postcode} <> " "
then stringvar pst := pst + {Recc.Postcode} +", "
else if length(pst) = 0 
then stringvar pst := pst + "Excluding blanks; "
else stringvar pst := pst

// Show in using a formula field in the group footer.
whileprintingrecords;
stringvar pst;
left(pst,len(pst)-2)

//  Clear using a formula field using in the group header.
whileprintingrecords;
stringvar pst := "";

Note that clearing in the footer avoids problems with group headers repeating on a new page, which does clear everything for the group. Provided the 'clear' is placed in the section AFTER the display, it will do them in that order.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[tweetyng]

Thanks Madawc Williams. It worked. Thanks for millions.