Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Page Count Question
Message
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Miscellaneous
Thread ID:
01186301
Message ID:
01186365
Views:
18
We have a repot viewer dialog. It has a set of 'Page 1 of nnn' textboxes. I want to know the
total number of pages so I can populate the 'Of' field.


>What exactly are trying to do? Display page count while printing? Determine how many pages there will be before printing? Determining the final number of pages? Crystal, like Fox, can't know page numbers until it actually prints.
>
>>We are using the following code to determine the page count:
>>
>>
>>
>>WITH ThisForm
>>
>>	oPrintingStatus = .oCRReport.PrintingStatus
>>
>>	sErr = ON("ERROR")
>>	ON ERROR lErrored = .T.
>>
>>	.txtTotalPages.Value = oPrintingStatus.NumberOfPages()
>>
>>	ON ERROR &sErr
>>
>>	oPrintingStatus = .NULL.
>>
>>	.txtTotalPages.Refresh()
>>
>>ENDWITH
>>
>>
>>
>>The problem is that this causes Crystal to call the SQL stored proc to
>>get the data. Then the proc is called again when the report shows.
>>
>>Is there a different way to get the page count?
>>
>>Thanks
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform