Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Multiple data Post Reply Post New Topic
Page  of 2 Next >>
Author Message
crystalgal
Groupie
Groupie
Avatar

Joined: 20 Feb 2009
Location: United States
Online Status: Offline
Posts: 66
Quote crystalgal Replybullet Topic: Multiple data
     Posted: 14 Jun 2011 at 7:26am
Hello,
 
I need some help with the report I am working on. I need the report to show multiple names but when I run the report, it just shows the Primary person(which is inidcated with 'Y' in database).
I tried a subreport and it shows all names but names are repeated many times.
 
Any help is appreciated.
 
Thanks is advance.
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jun 2011 at 8:30am
what is your select statement?
IP IP Logged
crystalgal
Groupie
Groupie
Avatar

Joined: 20 Feb 2009
Location: United States
Online Status: Offline
Posts: 66
Quote crystalgal Replybullet Posted: 14 Jun 2011 at 8:46am
I have a long statement and all the data is shown correctly in toad but when I  put in Crystal I have the issue.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jun 2011 at 8:50am
so you have no seperate crystal select statement?
and you are placing the name field on the detail section?
IP IP Logged
crystalgal
Groupie
Groupie
Avatar

Joined: 20 Feb 2009
Location: United States
Online Status: Offline
Posts: 66
Quote crystalgal Replybullet Posted: 14 Jun 2011 at 8:55am
Yes, on the detail section of a subreport and linked with the main report with various fields.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jun 2011 at 9:08am
where is the subreport placed in the main report and is one of your links on the name itself?

Edited by DBlank - 14 Jun 2011 at 9:09am
IP IP Logged
crystalgal
Groupie
Groupie
Avatar

Joined: 20 Feb 2009
Location: United States
Online Status: Offline
Posts: 66
Quote crystalgal Replybullet Posted: 14 Jun 2011 at 9:10am
it is on the group header of the main report and I did try with the name link also and did not work.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jun 2011 at 9:13am

for some clarity, is your data missing from the main report or from the sub report(s) or both?

 
IP IP Logged
crystalgal
Groupie
Groupie
Avatar

Joined: 20 Feb 2009
Location: United States
Online Status: Offline
Posts: 66
Quote crystalgal Replybullet Posted: 14 Jun 2011 at 9:16am
on both reports all the names(upto 4) do not show. Each section is 1-2 pages and 1 page shows one name and other page shows other name. I need all the names to show in each page.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jun 2011 at 9:27am

so in the main report,

if you ungroup and just place the name field in the detail section do you get all of the rows you expect? f not what is missing?
IP IP Logged
Page  of 2 Next >>
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.