Print Data Only Once . . .

[smilbert]

Normally, I can do this with GROUPS, but I'm having trouble here.

I have 2 groups
ENCOUNTERID
SEQUENCEID (may be multiple per ENCOUNTER)

EACH SEQUENCEID has an associated ROOMID.
When there are multiple SEQUENCEIDs, they MAY or MAY NOT have the same ROOM ID.

I'd like to print some information for each SEQUENCEID, but I only want to print that info ONCE per ROOM ID.

If each SEQUENCEID has a different ROOMID, it's not a problem. However, if there are two SEQUENCEIDs with the SAME ROOMID, I get a dup.

A THIRD group won't work--Any ideas?

TECH INFO: MS SQL, CR XI

 

[lbass]

You could change your second group to group on a concatenation of sequenceID and RoomID.

-LB

 

[smilbert]

Thank you for the reply. I haven't tried it yet, but would that work for me?

For ENCOUNTERID = 658

SEQID = 1 ROOM = 3
SEQID = 2 ROOM = 3

Those concantenated ids would be different, so I'd get two copies??

 

[synapsevampire]

Flesh out WHAT it is that you intend to display, and from what example data.

Saying "I'd like to print some information for each SEQUENCEID" isn't decriptive.

-k

 

[lbass]

I think I misunderstood, so as SV suggested, please show some samples of the display you are getting and a second sample of how you would want the same data to look.

-LB

 

[smilbert]

Sorry, here is some more info. All help is appreciated!

The report is run with an ENCOUNTERID parameter, so it runs for only one encounter at a time.

The report shows our logo, address, etc at the top. Then the Client name, address, etc

Then, for each SEQUENCEID, I print information about a client's appointment (Description of what will be done, appt time, date, notes)

Next, there is a list of questions/requirements for the ROOMID where the appt will be held (unique for each room)

Often, a client will have more than one procedure(SEQUENCE). Sometimes they are done in the same room, and other times they are done in different rooms.

If all procedures are in different ROOMS, we can simply print all questions. However, if more than one procedures are in the same ROOM, I don't want to print the SAME list of questions multiple times.

 

[lbass]

Please SHOW sample data.

-LB