Grouping Order

[RepRider]

SQL and CRXI

A current report shows a variety of demographic data by client that is used for verification and updating at our "fornt window." The only problem is a particular grouping of information re: contact information repeats out of order and I dont know how to make it stay together. It's probably simple too!

There are six groups:
Employee last name (suppressed)
Schedule entry start stamp (by day) (hidden)
Schedule entry start stamp (by minute) (hidden)
Schedule entry client ID (asc)
Contact Info - relation to source (asc)
Insurance payor plan (asc)
Details (hidden)

Generally there is only one contact that shows (emergency) and there could be multiple insurance that show.
However, if there is an additional contact, say guardian, then it shows up AFTER the insurances and then the insurances repeat all over again.

This is set up like a form and each header that displays will have additional data fields that display like address or group insurance number etc.

This runs daily and includes only the clients going to be seen that day.

Can someone tell me why the second contact info (group header 5) will show up again after the the group header 6 and then group header 6 duplicates again after that?

What do you need to know to help me?

Thanks in advance!!

 

[lbass]

Your contact table is forcing the details to repeat, so you might consider removing that table from the main report and adding this info in a subreport, perhaps in a GH_b for Client ID.

-LB

 

[RepRider]

Hmmm.. I am not sure how to do that.

Group header 6 repeats when there are multiple insurances and stays together. Does it stay together because there are no other groups after it?

 

[RepRider]

Hey, I just stumbled through my first subreport and its working!
I didn't remove it from the first report... will that make a difference?

 

[RepRider]

Thanks lbass! I also did the same thing with the insurance information (subreport) GH_c for client ID and it works perfectly!!