Print Page | Close Window

creating a report

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1409
Printed Date: 02 May 2025 at 7:40pm


Topic: creating a report
Posted By: vijay sandoria
Subject: creating a report
Date Posted: 29 Sep 2007 at 11:39am
i am new in crystal reports can any one help me to create a report?
 
i want to create a report in which i want to show every invoice on diffrent page i have two tables invoice and invoice_detail in invoice i have invoice Information and in invoice_detail i have product information related to that invoice. The primery key is invoice_no in invoice table.
 
 
can any one help me to create this type of invoice through wizard?
 
 


Replies:
Posted By: BrianBischof
Date Posted: 29 Sep 2007 at 6:01pm
I'm not sure how much detail you need, so I'll start off simple and you can let me know if this got you what you wanted.

1. Create a new report using the wizard and choose those two tables as your datasoure.
2. On the Links tab, make sure they are linked by Invoice_No.
3. On the Fields tab, select the fields you want to print.
4. Click Finish to end the wizard.
5. In the report designer you now have a decent looking report. Move things around and format the fields to make them look the way you want.

Get all that working first.
6. Now, to make each invoice print on a new page, Right-click on the gray area to the left of the Report Footer section and choose Section Expert.
7. Click on the option New Page After.
8. Close the expert and preview the report.

Each invoice should now be printing on a new page.


-------------
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>

Posted By: vijay sandoria
Date Posted: 01 Oct 2007 at 11:54am
what i have to do after clicking New Page After
what formula will be as i have to see the every invoice on new page

Posted By: BrianBischof
Date Posted: 01 Oct 2007 at 12:17pm
no formula needed. just click the checkbox. it forces a new page after each invoice automatically.

there can be a extra blank page at the very end, so to prevent that enter a formula of 
Not OnLastpage
and that prevents it from happening.


-------------
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>


Print Page | Close Window