SomeoneNew
Member
Hi List,
Please bear with my long message as I try to explain my dilemna.
I need help with the R03B5001 (Statement Print) UBE. The report is called as the final output of R03B500X (Statement Generation). This is a Parent/Child issue of sorts.
The standard report is designed to calculate and display the total balances of various customer accounts (AN8) - imagine these to be branches of the same company.
I am trying to calculate these balances by Parent Number (PA8) - imagine this to be the head office - on which I have a LBFooter.
Throughout the report (of about five different sections) I accumulate the total balance of all the AN8 accounts into a grand total by PA8 in the level break footer. Whenever the Grand Total is less than or equal to zero (-ve or 0), I need to hide the whole statement for the PA8.
The only way I can think to conditionally hide a whole page is by data selection and my variable - Grand Total cannot be picked up in the data selection.
Alternatively, I have created a global variable to hold the calculated value and to 'hide section' or 'supress section print' when the condition is true. Problem is the condition is only true when the report runs through all the sections and gets to the footer at which point the previous sections have already been displayed.
I would appreciate an suggestions.
Thanks,
Someone New.
OneWorld B7332 SP13.1
Please bear with my long message as I try to explain my dilemna.
I need help with the R03B5001 (Statement Print) UBE. The report is called as the final output of R03B500X (Statement Generation). This is a Parent/Child issue of sorts.
The standard report is designed to calculate and display the total balances of various customer accounts (AN8) - imagine these to be branches of the same company.
I am trying to calculate these balances by Parent Number (PA8) - imagine this to be the head office - on which I have a LBFooter.
Throughout the report (of about five different sections) I accumulate the total balance of all the AN8 accounts into a grand total by PA8 in the level break footer. Whenever the Grand Total is less than or equal to zero (-ve or 0), I need to hide the whole statement for the PA8.
The only way I can think to conditionally hide a whole page is by data selection and my variable - Grand Total cannot be picked up in the data selection.
Alternatively, I have created a global variable to hold the calculated value and to 'hide section' or 'supress section print' when the condition is true. Problem is the condition is only true when the report runs through all the sections and gets to the footer at which point the previous sections have already been displayed.
I would appreciate an suggestions.
Thanks,
Someone New.
OneWorld B7332 SP13.1