1534811 - How to get the data at the end of the Crystal Reports?

SAP Knowledge Base Article - Public

1534811 - How to get the data at the end of the Crystal Reports?

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 BusinessViews Manager , How To

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2