Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
Password Reminder
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 17th, 2004, 02:18 AM
Authorized User
Join Date: Jul 2003
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Page numbering in crystal report 9.0


I'm new to crystal report and require a help urgently.
My requirement is something like this.
I have a main report from where I call 2 subreports,
say summary and details.

The main report has a group based on a certain column and say this
results in "n" distinct groups. The details of each group I'm getting
from a subreport.
(For eg., If I have 5 distinct customers, I will group by customer name
and get the details for each customer from the subreport by linking with
the customer name)

I need to reset the page numbering after each group. This means each
group should have its own page numebring starting from 1. I need to
display 3 fields on the main report:
one which displays how many total pages were created for all the groups,
second which displays the total number of pages created for that group
and third which displays the current page number for that group.

And also I have to create a summary page at the beginning of the report
which displays each group and the total number of pages created for that
group something like:

Customer1 3 pages created
Customer2 5 pages created
Customer3 8 pages created

I'm generating the summary by way of a subreport by calling from the
main report.

Can anyone tell me how I can set these dynamically. Is there any option
in Crystal report which helps me to do this? Your help is highly


Reply With Quote
  #2 (permalink)  
Old December 2nd, 2004, 10:47 AM
Registered User
Join Date: Dec 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

I have the same problem. Do you have the solution?

Reply With Quote
  #3 (permalink)  
Old December 10th, 2004, 11:29 AM
Authorized User
Join Date: Dec 2004
Location: flushing, ny, USA.
Posts: 80
Thanks: 0
Thanked 0 Times in 0 Posts

hi did u get solution for this. if not try this. I am assuming here that you r getting the details of the group in a sub report and placing that subreport in group footer section.
step 1 :- have pagenumbers shown in subreports.
step 2 :- in sub reports write a formula and place this in subreport footer and supress it.
shared numbervar x;
x:= TotalPageCount;
step 3 : - in main report call this shared variable in a formula and place this in the main report near group header.
shared numbervar x;
step 4 :- click on section expert for group header and select new page before.
Let me know if you need any further help.
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Numbering in Report View anukagni Access 7 March 7th, 2006 07:34 AM
Page numbering athanatos XSLT 4 May 13th, 2005 06:12 PM
Report Page numbering leehambly Access 1 March 17th, 2005 05:33 AM
Crystal Report 9.0 Page numbering rajeshnerenki Crystal Reports 0 June 23rd, 2004 01:51 PM
Numbering in Access Report mateenmohd Access 5 April 3rd, 2004 11:55 PM

All times are GMT -4. The time now is 02:27 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.