Crystal Reports Print report once for each value

Report Design

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

Topic: Print report once for each value

Author	Message
lorif747 Newbie Joined: 24 Jan 2007 Online Status: Offline Posts: 5	Topic: Print report once for each value Posted: 20 Nov 2008 at 2:33pm
	I have an invoice report for which a user is first prompted for a client code. That client code can be attached to several different invoice numbers so the user is next presented with a list of invoice numbers under the client code from which they can pick multiple values. If they pick 10 difference invoice values I want the report to print once for each invoice value, not combine all the invoice data onto one report. Is there a way to do that?
	IP Logged


rahulwalawalkar Senior Member Joined: 08 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 731	Posted: 21 Nov 2008 at 3:44am
	Hi, I hope you have created Dynamic Cascading Parameters, Try this Create a Group on Invoice Number field this will group all the Invoice Numbers and corresponding values together then in Group Footer right Click Select Section Expert Then in Common Tab of Section Expert against New Page After Click the X+2 button and enter the code below Not OnLastRecord this is to avoid page breaks on last page. New Page After will start new page for each Invoice Number so this was you will have separrate pages for the Invoice Numbers and values you have selected. Then Simply print the report to get separate pages for each invoice value Cheers Rahul
	IP Logged

lorif747 Newbie Joined: 24 Jan 2007 Online Status: Offline Posts: 5	Posted: 21 Nov 2008 at 7:07am
	It puts the details on separate pages but I really want is the report in its entirety to print over from report header down to report footer for each of the invoice numbers.
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 21 Nov 2008 at 1:24pm
	Instead of using the Report Header and Report Footer, put that part of your invoice in their own Page Header and Page Footer sections. Will your invoices always be only one page or can they be multiple pages? If they can be multiple pages, you'll also want to do the following: 1. Assuming you're grouping on invoice number, on the invoice number group footer, in the Section Expert turn on "Reset Page Number After" and "New Page After". This will set the page number to 1 at the end of each invoice. 2. In the Section Expert for the Page Header and Page Footer sections, click on the button to the right of "Suppress" and enter the following: PageNumber > 1 -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

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