Hello,
I need to design a report that pulls the same record multiple times if certain keys apply. Here's a simplified example of the DB and the desired output:

USER	BOAT	HOUSE	CAR	BIKE
BOB	Y	Y
BILL		Y	Y	Y
JOHN		Y		Y
JIM	Y			Y
MARK		Y	Y
OUTPUT
BOB	BOAT
BOB	HOUSE
BILL	HOUSE
BILL	CAR
BILL	BIKE
JOHN	HOUSE
JOHN	BIKE
JIM	BOAT
JIM	BIKE
MARK	HOUSE
MARK	CAR

thanks for the reply but that sounds like it is beyond my skill level

I could not tell you. I saw nothing like that in Crystal 9.

But here's what I did do as a workaround.

Using the example above, I created four sub-reports named:

boat.rpt, house.rpt, car.rpt, bike.rpt

I put them in a master report and running that gave me what I needed.