Grouping problem?

[tweetyng]

I have a grouping on PatientNo and then a grouping on CollectedDate,
This is sample of my table:
PatientNo Specimen CollectedDate Culture Smear
101 Blood 11/01/2006 Pos ---
101 Blood 11/01/2006 --- Neg
101 Blood 11/05/2006 Neg ---
101 Blood 11/05/2006 --- Neg
102 Other 11/02/2006 Pos ---
102 Other 11/02/2006 --- Pos

Please help me to get the result like this

PatientNo Specimen CollectedDate Culture Smear
101 Blood 11/01/2006 Pos Neg
101 Blood 11/05/2006 Neg Neg
102 Other 11/02/2006 Pos Pos

Thanks



TN (USA). I'm using Windows XP, Crystal Reports 10 and SQL Server

 

[lbass]

I think you could drag your fields into the Group #2 header with the exception that you would insert a maximum on {table.smear} and drag that summary into the Group #2 header. Then suppress all other sections.

-LB

 

[tweetyng]

I did what you said, drag all fields into group header #2 and in the report selection formulas group i code:

{LABFILE.Smear} = maximum({table.Smear},{table.PatientNO})
Then run the report, it show only the Smear colums and left the Culture columns blank such as

PatientNo Specimen CollectedDate Culture Smear
101 Blood 11/01/2006 Neg
101 Blood 11/05/2006 Neg
102 Other 11/02/2006 Pos


TN (USA). I'm using Windows XP, Crystal Reports 10 and SQL Server

 

[lbass]

That was not my suggestion. Remove the group selection formula and instead right click on {table.smear}->insert summary->maximum at the group level. Then drag the resulting summary, which will appear in the GF#2 footer, into the GH#2 header.

-LB

 

[tweetyng]

Stars and kisses to you, lbass
Thanks, it works great
tweetyng

TN (USA). I'm using Windows XP, Crystal Reports 10 and SQL Server