Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: CR9 / Access DB - record selection Post Reply Post New Topic
Author Message
Tekkie140
Newbie
Newbie


Joined: 03 Nov 2017
Online Status: Offline
Posts: 3
Quote Tekkie140 Replybullet Topic: CR9 / Access DB - record selection
    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






IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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
IP IP Logged
Tekkie140
Newbie
Newbie


Joined: 03 Nov 2017
Online Status: Offline
Posts: 3
Quote Tekkie140 Replybullet Posted: 08 Nov 2017 at 2:01am
thanks for the reply but that sounds like it is beyond my skill level
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 08 Nov 2017 at 2:26am
can you create a stored procedure or a view or crystal command as your data source?
IP IP Logged
Tekkie140
Newbie
Newbie


Joined: 03 Nov 2017
Online Status: Offline
Posts: 3
Quote Tekkie140 Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.