Building an Invoice Application with ASP.NET and Crystal Reports

Print Add To Favorites Email To Friend Rate This Article
Building an Invoice Application with ASP.NET and Crystal Reports - Part 1

page 6 of 9

by Vince Varallo
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 19392/ 863

Article Contents:

Step 7: Create the page footer section

The last step in designing the report is to add the page number to the page footer section.

1. Right click in the Page Footer section and select InsertàSpecial FieldàPage N of M from the pop-up menu.

2. Drop the field in the report's page footer section.

3. Make the field the entire width of the page.

4. Right click on the field and select Format Object from the pop-up menu.

5. On the Common tab, change the Horizontal Alignment to Centered and click OK.

If you preview the report you should notice that the page number gets reset to 1 after each SaleOrderNumber change.

Figure 19

« (Page 5)

View Entire Article

(Page 7) »

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 8 and 7 and type the answer here:

User Comments

Title: Thank you
Name: Tabitha
Date: 11/18/2009 10:00:57 AM
Comment:
Thank you very much!!!

Title: Thanks for doing such an awesome article!
Name: Julius
Date: 10/28/2009 9:16:06 PM
Comment:
Very good article. Really appreciate it.

Title: Awesome tutorial!
Name: Nivi
Date: 9/13/2009 12:22:10 AM
Comment:
Thanks for the awesome tutorial. It really helped me.
Thanks again

Title: Excellent Article
Name: sai
Date: 9/1/2009 9:11:15 AM
Comment:
Thankyou so much for such a wonderful article on Crystal Reports.

Title: Landsailor
Name: Pete Lyons
Date: 8/31/2009 8:34:22 PM
Comment:
Vince- What an amazing tutorial. There are many ways to skin a cat when it comes to reports delivery, but this is by far the most insightful way to tie-in .net with my crystal skills. Thanks again :)))))) ~Pete

Title: Error in Sum formula
Name: Pavan
Date: 8/25/2009 10:28:17 AM
Comment:
I am not sure where I made mistake but I started from scratch again making sure I check the Preview after each field added to the report and it worked this time.

I have a quick question, Since we are using pull method, Do we need to use BindReport method? Why cant we just use the reportviewer.selectionformula?

Thanks for the wonderful tutorial!!

Title: Error in Sum formula
Name: Pavan
Date: 8/25/2009 2:31:29 AM
Comment:
Hi,
Error in formula . 'Sum({SalesOrderDetail.LineTotal}, {SalesOrderHeader.SalesOrderNumber}) ' The result of selection formula must be a boolean.

Help please.
Thanks

Title: Best for beginner
Name: murugaperumalwin
Date: 8/7/2009 8:30:36 AM
Comment:
hai Vince Varallo...

this is very useful for a people who still have't knowledge

about crystal report.

thanks
MP

Title: superb article
Name: Raj
Date: 7/30/2009 2:27:41 AM
Comment:
very great article

Title: good article
Name: john
Date: 7/30/2009 2:25:06 AM
Comment:
very good article.........

Title: Great Article
Name: Caitriona
Date: 6/11/2009 8:50:55 AM
Comment:
I found this article extreemly useful. Thank you so much for sharing your talents!

Caitriona

Title: Child Nodes not allowed
Name: Paul
Date: 5/27/2009 11:05:56 AM
Comment:
Hi,
I am getting an error like:-
Child nodes not allowed from the web.config file.
I am using ASP.NET2005 and SQL2005.
Is it because of this I got this error?
Thanks,
Paul

Title: Link for the Adventure Works database
Name: Vince
Date: 5/27/2009 7:58:34 AM
Comment:
The page that has the download is http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=18407

Click on the SQL2008.AdventureWorks All Databases.x86.msi link.

Title: Thanks so much
Name: Paul
Date: 5/26/2009 5:23:07 AM
Comment:
Hi Vince,
It is really an excellent article.
I could not find the Adventure database in the downloads.
Where can I find it?
Thanks so much,
Paul

Title: Thanks - How about a version for VB users?
Name: Art
Date: 5/22/2009 10:07:14 AM
Comment:
Thanks Vince!

I know some people are never satisfied ;-) but how about adding the "version b" listings for those of us who use VB?

Title: dr
Name: kola
Date: 5/11/2009 11:12:06 AM
Comment:
good

Title: Thanks
Name: Suresh Kumar Gundala
Date: 5/8/2009 5:04:13 AM
Comment:
Hi Vince,

Nice article. Actually i dont know anything about crystal reports. Now i got an idea.. This is a wonderful article.
Great work yaar. Thank you very much for writting such a nice article

Title: Good Article for a Quick start
Name: Niki
Date: 5/5/2009 7:44:10 AM
Comment:
Thank you Vince, A very good article for a quick start on crystal report designing.We expect more articles from you in the same space

Product Spotlight