I have a report, purchase order, with the following in my report:
Report Header
Page Header
Page Header a
Page Header b
Page Header c
Group Header #1
Group Header #1a: cvw_PorPrint.PurchaseOrder - O
Group Header #1b: cvw_PorPrint.PurchaseOrder - O
Group Header #1c: cvw_PorPrint.PurchaseOrder - O
Details
Group Footer #1: cvw_PorPrint.PurchaseOrder - O
Report Footer (Suppressed)
Page Footer
What i desperately trying to is to set the "Visible Records" to the following:
IF >= 17 THEN 16 ELSE 25 = count({cvw_PorPrint.MStockCode}) 'This will be then the total number of data records returned by SQL'
So for page 1 i want to print 16 or less data records, and fitting on the same page will be the Group Footer and Page Footer.
If there is 17 or more records, i want to print 16 records on page 1 but 25 from page 2 onwards, with the last page with records on printing the Footer parts.
I've already managed to suppress the header and footer parts according to formulas that depends on the page numbers, however when adding a variable in the Visible Records formula field, i am bombarded with errors.
Any help please.