Crystal Reports Print repeated

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Print repeated
	<< Prev Page of 2

Author	Message
nalfein Groupie Joined: 07 Jul 2008 Online Status: Offline Posts: 47	Posted: 27 Apr 2009 at 7:27am
	This is exactly what I've to do I'll try and let you know
	IP Logged

nalfein Groupie Joined: 07 Jul 2008 Online Status: Offline Posts: 47	Posted: 27 Apr 2009 at 8:10am
	Sorry when you say Create group 1 on Ord#[...] You mean that i've to go to insert > group and after place the field Ord# in the group header that i've just created? This is what you mean?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 27 Apr 2009 at 8:17am
	Close...When you go to insert group, select the ORd# as the field to group on. Crystal will automatically insert a field called group #1 name (this is basiocally the ORD# field). You do not have to palce the ORD# on this header. Now right click on this Header field and go to common tab and suppress it. Now suppress the Header 1 in the Section Expert as "Supress blank section" Continue to follow the rest of the other instructions Edited by DBlank - 27 Apr 2009 at 8:18am
	IP Logged

nalfein Groupie Joined: 07 Jul 2008 Online Status: Offline Posts: 47	Posted: 28 Apr 2009 at 7:57am
	Ok all works fine but only if I print one order at a time When I print i.e. from order 1234 to order 1236 from my program linked to CR all is a mess due to the delivery date. If one order have 2 delivery date and one not it will print for both orders two rows and the delivery date are also the same for all orders printed regarless the difference in each order Order 1234 delivery date 2 may Order 1235 delivery date 3 may / 4 may will result in a 4 row print with order 1234 delivery date 3 may / 4 may and order 1235 delivery date 3 may / 4 may It seems that he's taking the last delivery date regardless of each delivery date of single order but not sure I hope that I've explained exactly the situation if you need more info please feel free to ask Thank you again
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 28 Apr 2009 at 8:37am
	Did you create a second group on the deliverdate field and place the items on groupFooter2 and suppress the details (no data on the details line at all)? What I am trying to do is first group on the Order ID#. This will keep all of these records together. UNder hat you group on the Date keeping all of the together for each. YOu only want to display the inforamtion once so you can use the group footer for the second grouping to do this. Example data: Order # Delivery Date Client Amount 1234 1-2-09 John 3 1234 1-2-09 John 3 1234 1-3-09 Jane 3 1235 1-2-09 John 3 1235 1-3-09 Mary 3 1237 1-3-09 Mike 3 Grouped on Order date then Date looks like: GH1 - 1234 GH2 - 1-2-09 Details 1234 1-2-09 John 3 Details 1234 1-2-09 John 3 GF2 1234 1-2-09 John 3 GH2 - 1-3-09 Details 1234 1-3-09 Jane 3 GF2 1234 1-3-09 Jane 3 GF1 GH1- 1235 GH2 - 1-2-09 Details 1235 1-2-09 John 3 GF2 1235 1-2-09 John 3 GH2 - 1-3-09 Details 1235 1-3-09 Mary 3 GF2 1235 1-3-09 Mary 3 GF1 GH1- 1237 GH2 - 1-2-09 Details 1237 1-3-09 Mike 3 GF2 1237 1-3-09 Mike 3 GF1 By placing the feilds on the group footer 2 you will get the first record from your details in that double grouping. The rest of it all needs to be suppressed (marked in RED) to get rid of duplicate presentation of information and make it all appear on one line. Is this how you have it set up and does this clear it up for you?
	IP Logged

nalfein Groupie Joined: 07 Jul 2008 Online Status: Offline Posts: 47	Posted: 29 Apr 2009 at 7:45am
	I've done exactly what you've said What you have said is exactly what I need but S H I T (sorry mods) the problem is the same I.e. I have ord 1234 delivery 1-2-09 and ord 1235 delivery 1-3-09 and 1-4-09 the result is Order # Delivery Date Client Amount 1234 1-2-09 John 3 1234 1-3-09 John 3 1234 1-4-09 John 3 1235 1-2-09 Mary 3 1235 1-3-09 Mary 3 1235 1-4-09 Mary 3 Instead of Order # Delivery Date Client Amount 1234 1-2-09 John 3 1235 1-3-09 Mary 3 1235 1-4-09 Mary 3 It seems that he's taking the last delivery dates and auto assign to all orders printed regardless of their own delivery dates You are so polite and sorry for boring but really I dunno what to do now Thank you again
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 29 Apr 2009 at 9:31am
	This looks more like a data join problem. Are you pulling from more than 1 table? If so, how are you joining the tables? Looks to be more on a date then a primary key... If that is not the case, can you post a few sample lines of the raw data with all collumns. Maybe I can tease it out from there because I do not see why it is doing waht it is absed on your other sample data. Thanks
	IP Logged

phimtau123 Newbie Joined: 10 Mar 2009 Online Status: Offline Posts: 22	Posted: 29 Apr 2009 at 4:24pm
	Hey this is a problem that I've been facing for a while too and cant seem to find a way to fix. May I email you a screen shot of my report output and maybe you can guide on how to fix?
	IP Logged

nalfein Groupie Joined: 07 Jul 2008 Online Status: Offline Posts: 47	Posted: 29 Apr 2009 at 11:33pm
	*Originally posted by DBlank* This looks more like a data join problem. Are you pulling from more than 1 table? Yes I am pulling all data except delivery date from one table and delivery date from another If so, how are you joining the tables? Looks to be more on a date then a primary key... I dunno exactly what you mean I've created a new file and in the Database Expert I've choosen Create new connection > Access / Excel and I've selected my Access DB, then from that the 2 table that i need. Is that what you mean? If that is not the case, can you post a few sample lines of the raw data with all collumns. Again dunno what you need. Need you a row of two Access tables? Thank you again Edited by nalfein - 29 Apr 2009 at 11:52pm
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 30 Apr 2009 at 7:13am
	When you put two tables into your report you should join the tables. Usually you would do this on a primary key. Crystal will also often auto-join the tables if it can find like column names or shared keys between the two tables. Go into the Datbase Expert. If there is more than one table in you report you will see a LINKS tab. Click on it. You will get a visual representation of the 2 tables and there may or may not be a black line (or many lines) connecting the 2 tables. In here make sure you only have a sinngle link between the 2 tables on a primary key. Most likely it will be Order#.
	IP Logged

<< Prev Page of 2

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.063 seconds.