Reporting with Crystal v.10, off MS-SQL Server data ...
I have a spreadsheet I am to duplicate that calculates for each row a dollar amount from the number of days a student is in one of our facilities w/in a prompted date range & multiplied by a dollar constant.
My difficulty is I need a page total that is the total for that page only. Seems like it should be simple, but I can't figure out how to reset the formula to zero upon page break. Would have liked to create a page formula of my own, but can't group by that as it would have to be set whileprintingrecords. Thought of using a running total, but as the sum is based on a runtime formula, not a field, couldn't.
Any help would be appreciated.
Brad M.
I have a spreadsheet I am to duplicate that calculates for each row a dollar amount from the number of days a student is in one of our facilities w/in a prompted date range & multiplied by a dollar constant.
My difficulty is I need a page total that is the total for that page only. Seems like it should be simple, but I can't figure out how to reset the formula to zero upon page break. Would have liked to create a page formula of my own, but can't group by that as it would have to be set whileprintingrecords. Thought of using a running total, but as the sum is based on a runtime formula, not a field, couldn't.
Any help would be appreciated.
Brad M.