CR9 / Access DB - record selection
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22493
Printed Date: 02 May 2024 at 6:49am
Topic: CR9 / Access DB - record selection
Posted By: Tekkie140
Subject: CR9 / Access DB - record selection
Date Posted: 06 Nov 2017 at 1:23am
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
|
|
|
|
|
Replies:
Posted By: DBlank
Date Posted: 07 Nov 2017 at 3:26am
|
use a command as your data source with a few union statements to only select the one value per statement
|
Posted By: Tekkie140
Date Posted: 08 Nov 2017 at 2:01am
thanks for the reply but that sounds like it is beyond my skill level
|
Posted By: DBlank
Date Posted: 08 Nov 2017 at 2:26am
|
can you create a stored procedure or a view or crystal command as your data source?
|
Posted By: Tekkie140
Date Posted: 09 Nov 2017 at 2:27am
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.
|
|