Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Printing two pages Post Reply Post New Topic
Author Message
TokyoAnt
Newbie
Newbie


Joined: 16 Feb 2007
Online Status: Offline
Posts: 30
Quote TokyoAnt Replybullet Topic: Printing two pages
    Posted: 22 Feb 2007 at 8:57pm
Hi,
 
I have needed to edit a report serving as an invoice. It looks ok & is generating the correct values, BUT, it prints an extra page.
 
The additional page is a copy of the previous page from the group header to the group footer (basically everything except the page Report header & the page header which is suppressed).
 
The structure of the report is as follows:
 
Report header = invoice header
Report footer = suppressed
Group header #1a = holds subreport a.
Group header #1b = holds subreport b
Group header #1c = two drawing objects & some fields
 
Details = Unused (suppressed)
 
Group footer #1a = Holds sub Report
Group footer  #1b = drawing objects & fields
Group footer #1c = suppressed (unused)
 
page footer = special field
 
I'm quite desperate & would be very thankful for any ideas anybody might have.
 
Thanks kindly in advance.
 
Ant
 
 
 
 
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 22 Feb 2007 at 10:05pm
Usually when I see duplicate data like this, it's due to joining two tables and in the right most table there are two matches instead of just one. A way to test it would be to temporarily modify the report and just print it as a detailed report and see if the record shows up twice. If so, then you need to check on the data in the second table to make sure you either understand how it works or make sure there isn't garbage in it.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
TokyoAnt
Newbie
Newbie


Joined: 16 Feb 2007
Online Status: Offline
Posts: 30
Quote TokyoAnt Replybullet Posted: 22 Feb 2007 at 10:46pm
Hmm, sounds reasonable. Better go check ther backend Cry.
 
Thanks very much. I'll get back if I have any more questions.
 
Many thanks!
 
Ant
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 23 Feb 2007 at 12:11am
Honestly, since I don't have your report in front of me it is hard to say what the problem could be. But I've had similar problems many times and once I check the backend data I usually find that the "one to many" relationship was actually a "many to many". Using the DISTINCT keyword in the SQL helps clean this up as well.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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.