Topic: creating a report 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?
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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>
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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>
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