Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Report using parameters to choose invoices to prin Post Reply Post New Topic
Author Message
samme
Newbie
Newbie


Joined: 06 Sep 2007
Location: United States
Online Status: Offline
Posts: 6
Quote samme Replybullet Topic: Report using parameters to choose invoices to prin
    Posted: 06 Sep 2007 at 3:01pm
I created an invoice report for a client that allows them to choose the particular invoice from the database that they wish to print.  It works fine if they choose one invoice number, but if they choose a range of invoice numbers to print, it combines on one report.  I want each invoice to print individually.  There is a report header and a page header a and a page header b.  I have tried everything that I know how to do to get this to work. Can anyone assist me?  thanks in advance!  samme
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 06 Sep 2007 at 4:37pm
You can split them up this way:
 
1.  Group by Invoice Number.
2.  Move the objects from the Page Headers and Report Header to Invoice Group Header sections.
3.  On the section where you've place what used to be the report header, set the Suppress formula to something like: {table.Invoice#} = previous({table.Invoice#})  This way it will print only at the beginning of an invoice.  Also set any other section options (like New Page After) that you had set on the original Report Header section.
4.  On the Invoice Group Footer section, do the following:
     a.  Turn on "Reset Page Number After"
     b.  Turn on "New Page After"
     c.   In the New Page After formula put: Not OnLastRecord.  This will prevent a blank page at the end of the report.
 
-Dell
IP IP Logged
samme
Newbie
Newbie


Joined: 06 Sep 2007
Location: United States
Online Status: Offline
Posts: 6
Quote samme Replybullet Posted: 06 Sep 2007 at 5:07pm
Thanks!  I'll give this a try when I get back to work tomorrow!
IP IP Logged
samme
Newbie
Newbie


Joined: 06 Sep 2007
Location: United States
Online Status: Offline
Posts: 6
Quote samme Replybullet Posted: 07 Sep 2007 at 9:05am

The suggestions worked except I'm having some issues.

 I have four groups set up.  Group #1 - ARInvoice.InvoiceNo - This has the Logo, Cust Address, Inv. #, date and general invoice information and should only print on the first page of the invoice; Group #2 - ARInvoice.InvoiceNo - needs to print on the subsequent pages after page one.  This has the logo and invoice number; Group #3 - ARInvoice.InvoiceNo - this is the labels and should print on all pages.  Group #4 - @date - this one works fine.  It is grouped by date and prints the date, items associated with that date and prints the subtotal.  I want the total to print on the last page of the invoice with the last record.
 
What is happening - my Group #2 doesn't print until the first page of the second invoice, my group #3 Prints on the first page of each invoice and not on any other pages, my total prints on the last page by itself.  Please help!  Thanks!!!
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 07 Sep 2007 at 10:28am

Group 1, 2, and 3 are all on the same field.  Make it just one group with 3 header sections. 

For section 1, put in the section suppress formula: PageNumber > 1
For section 2, put: PageNumber <> 2
For section 3, put: PageNumber < 3
 
Make sure you have the "Reset Page Number" setting as I noted in my previous message.
 
Or, you can do the header info for page 1 in just one section and set the suppress as I noted.  Then put the header data in the report header of each of the subreports instead of in sections on the main report.
 
-Dell
IP IP Logged
samme
Newbie
Newbie


Joined: 06 Sep 2007
Location: United States
Online Status: Offline
Posts: 6
Quote samme Replybullet Posted: 18 Sep 2007 at 12:13pm
I still cannot get this to work.  These are the requirements:
Client wants to print multiple invoices in a range.  Parameter is set.
 
Group Header #1a - includes company logo, address, invoice number, customer id, etc.  This should appear only on page 1 of each invoice.
 
Group Header #1b - includes company logo and invoice number (should print on all pages of the invoice except the first page.)
 
Group Header #1c - includes column headings such as qty, unit of measure, and description. (should print on all pages of the invoice including the first page).
 
Group Header #2.  It is a date.  All line items of the invoice are grouped by date.  There should be only one date and associated data per page with a subtotal for each date.  The invoice is sorted by this group in ascending date order. The total is on the last page of the invoice.  Not alone but with the last group of data.
 
Of course the detail section includes the description, qty, price, etc.
 
Please help.  I tried the suggestions but have not been able to get this to work.  I did not try a subreport as I would like to try to get the existing report to work if possible.
 
Thanks!
 
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.