Symptom
How to get the data at the end of the Crystal Reports?
Environment
- Crystal Reports XIR2
- Crystal Reports 2008
Resolution
1. Put the required text field in the Page Footer.
2. Write a formula 'test' as given below:
stringVar GetLastPage:= mid(CStr(PageNofM),InStr(CStr(PageNofM),"f")+2)
3. Place this 'test' formula in the Page footer and suppress it.
4. On the 'Suppress' condition of the text field (which is placed in Page Footer in step 1
above) write the following code:
stringVar GetLastPage;
stringVar GetPageNumber:= ToText(PageNumber,0);
if GetLastPage=GetPageNumber then false else true
Keywords
Text field,end of report, Crystal Reports , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To