Displaying a message if data in same group(Crystal Report) breaks into multiple pages

In Crystal Reports, group header can be repeated in each page if the group is spanning to pages. However, what if user wants a custom message like, 'data is continued from previous page'. How to achieve it?
By using the below code snippet in Crystal Reports, it is possible to display a message if data in same group breaks into multiple pages.

First creat a formula with the below code:
//Variable declaration
shared stringvar Array Student_Array;
local stringvar disp;
shared numbervar i;
shared stringvar array Student_Pno_Array;
shared numbervar j;

 //checks if previous Student no is not in array (not displayed in report) before assigning it to Student_Array
if not ({Student.STUDENT_NBR} in Student_Array) then
   ( i := i + 1;
   Redim Preserve Student_Array[i];
   Student_Array[i] := {STUDENT.STUDENT_NBR};
   // Adds value to Student_Pno_Array
   j := j + 1;
   Redim Preserve Student_Pno_Array[j];
   Student_Pno_Array[j] := {STUDENT.STUDENT_NBR}+totext(pagenumber);
   disp:="";) // Text message to be displayed must go in here
//The line below ensures that only new values are added to the array.
   if not(({STUDENT.STUDENT_NBR}+totext(pagenumber)) in Student_Pno_Array) then
      ( j := j + 1;
      Redim Preserve Student_Pno_Array[j];
      Student_Pno_Array[j] := {STUDENT.STUDENT_NBR}+totext(pagenumber);
      disp:="display message")
   else disp:=""; // Text message to be displayed must go in here

Then place this formula in all the sections where you want to display the custom message if the group is breaking into multiple pages.

No comments:

Post a Comment

Please refrain for marketing messages and unnecessary back links.

Workflow errors on New Hire and Add employment instance

User tries to hire a new person or tries to add a new organization relationship encounters a series of error messages related to workflow...

Trending in this Blog this month