Skip to Content
May 22, 2014 at 08:22 PM

Using WhilePrintingRecords


Hello all,

I'm looking for a formula/sample/example...

What I want to do I think is pretty straight forward (i think) , however I just can't seem to figure it out.

Basically I want to display multiple sets of results for a specific user at a specific location.

I saw the following link which looks similar but not exact and wondered if you could point me in a more specific direction. (the link:

What I need is more :

Location 1 location2 (etc...)

User1 1/2/4 2


User3 (etc...)

Basically user1 shows up in location 1 in the months of Mar, Apr, May…1, 2, and 4 times, and shows up in Location2 just 2 times for the same period.

I need to be able to display the multiple results with out displaying user1 multiple times.

I currently retrieve all the data I need, but I end up with User1 showing on the left multiple times.

Thanks for any thoughts. And Like I said if you could just point me in the right direction, I would be grateful.