use a count
Create a running total for your details section in the sub report that resets at each change in the group. Then, in the sub report detail section, use the section expert to enter the formula {#RunningTotalField} > 5 to supress all records after 5 have been printed.
regards,
Karen
Use a group footer instead
The only way around your problem is to not use the page footer, but to create a “dummy” group and then use the group footer instead which will quite happily continue over many pages. You can use the field that you are sorting by to create the group.
Regards,
Karen
Sub Reports
As you are trying to get 2 different pieces of information on a single line, create a sub report with the three groups to calculate the sum for each cost centre for each project for each date. Put the calculation into the correct section (probably the cost centre footer). Now add...
For your first problem you should look at using the DayOfWeek function. This will allow you to use a loop to calculate the number of days as long as the weekday is Monday to Friday. You can then not increment the count if the day is Saturday or Sunday. Try using DayOfWeek(datefield...
Exporting Options
Try exporting the report to either HTML or PDF. Your users wil then be able to open the report in Internet Explorer or other browser or using Adobe Acrobat Reader, which is free. Your users do not need any special software to view the reports and they will not be able to...
I have created 3 formula fields.
The first sets a boolean variable to False and is located in the inner group header section.
The second sets the boolean variable to true on certain conditions using if statements and is located in the details section.
The third just displays the value of the...