I am assuming that you are using the Report designers Data Grouping. Try this. Make a report variable (lets call it 'lnPage') that stores the variable _pageno and resets when the data grouping changes. Next make a report variable (let's call it 'lnTotalPages') that SUMS this Expression "IIF(lnPage=_pageno,0,1)". Make sure 'lnTotalPages' is ABOVE 'lnPage' in the Variables list. Since '_pageno' gets incremented before variables are evaluated, 'lnPage' will have the previous page number. And since Variables are evaluated in the order they are listed, lnTotalPages will Always increment by one. Let me know if you have any problems..Thanks
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only