Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: 2 report description fields from the 1 DB field Post Reply Post New Topic
Author Message
paulmcm
Newbie
Newbie


Joined: 25 Mar 2012
Online Status: Offline
Posts: 11
Quote paulmcm Replybullet Topic: 2 report description fields from the 1 DB field
    Posted: 25 Mar 2012 at 11:54pm
Hi on my report I have Secretary and Executive fields which is mapped to the same DB field but I distinguish between the two with an ID field (0 = Secreaty, 1 = Director). My problem is that for a company with both my report looks like this:
CompanyName    Secretary     Director
Test                    ABC           
                                              DEF
                                              123

how can I remove the blank space from the first row on list of Directors?


Edited by paulmcm - 26 Mar 2012 at 12:01am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 26 Mar 2012 at 4:00am
I don't really see a way in just 1 report
 
CR prints 1 row on the report for each row of data.  The data is coming out as 3 rows, and the logic doesn't allow them to over lap.
 
The only option that I can see is to use a subreport for the field, and to change this from a detail line to a group header or footer (so that it only appears once on the report).  The subreport would print the data, and each one would be separate from the other, so they would not have a blank space at the top.
 
HTH
IP IP Logged
paulmcm
Newbie
Newbie


Joined: 25 Mar 2012
Online Status: Offline
Posts: 11
Quote paulmcm Replybullet Posted: 26 Mar 2012 at 4:38am
Thanks for the advice, I will try what you have suggested.
IP IP Logged
paulmcm
Newbie
Newbie


Joined: 25 Mar 2012
Online Status: Offline
Posts: 11
Quote paulmcm Replybullet Posted: 26 Mar 2012 at 5:32am
On my new subreport can I pass the selected company name parameter that was selected initially on the main report to load the data into my subreport?

Ignore this I found the answer here:
http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=2241

Edited by paulmcm - 26 Mar 2012 at 5:35am
IP IP Logged
paulmcm
Newbie
Newbie


Joined: 25 Mar 2012
Online Status: Offline
Posts: 11
Quote paulmcm Replybullet Posted: 27 Mar 2012 at 1:53am
lockwelle I've created my SubReport which is only returning the 1 record that I want, I've added this subreport into the details section of my main report and I'm getting the record return on each row.
You have said above "The only option that I can see is to use a subreport for the field, and to change this from a detail line to a group header or footer (so that it only appears once on the report). The subreport would print the data, and each one would be separate from the other, so they would not have a blank space at the top."
Do i create a group in my Main report and put all the fields into the header/footer of this group? Or should the group e created in the SubReport?

This is no longer an issue - I've used the RecordNumber special field to count the records in my Main report details section and added the following suppression formula to my SubReport: If RecordNumber > 1 Then True this seems to be working like i want.

Edited by paulmcm - 27 Mar 2012 at 3:19am
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.016 seconds.