Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Multiple data Post Reply Post New Topic
<< Prev  Page  of 2
Author Message
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:33am

yes, if I put in the main report and ungroup it I get all the data but it is repeating. The report needs to show each name only once.

 Can I send you a personal email so I can share the data with you?


Edited by crystalgal - 14 Jun 2011 at 9:34am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jun 2011 at 9:35am
sorry can't take email with data...
the duplicate rows are likely a cartesion product.
so I can't envision what you want it to look like.
can you explain the desired design with grouping and content?
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:42am
this is the survey report students do at the end of semester. some courses are taught by multiple teachers. so each course has its own survey questions and answers with survey name(course title and course number) as a group header. all the answers are in group footer. I need the different teachers names along with survey name on the group header for each course. right now, if I put the teachers name field on the detail section, it shows all the names but are repeated for each question. If i put the field in header section, all the names do not show together. 1st page shows one name and 2nd page shows other name.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jun 2011 at 9:47am
group (1) on the course name
group (2) on the teacher name
suppress details
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:50am
just gives me one name
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jun 2011 at 9:54am
do not place the name on the group one header but create a second grouping
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:58am

I did. it is repeating for each question so it looks like:

course name
mr. t
mrs. t
mr.u
mr.i
1) how was teacher
course name
mr. t
mrs. t
mr.u
mr.i
2)  how was course
etc...
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 10:01am
I have to leave now but thank you very much for your help. will try to play with group headers tomorrow.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jun 2011 at 10:03am
group 3 on the question
IP IP Logged
<< Prev  Page  of 2
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