I would appreciate some help with a little problem that has occurred with a financial report (a statement for an individual service user) I have created.
The main report shows payments made.
PROBLEM 1 - if there are no payments I cannot get the textbox that calculates the total payments (in this case 0) to be displayed.
There are two subreports within the main report, each providing a total of different types of service charges for the individual and generated from temporary tables which relate to the services used by the individual.
PROBLEM 2 - If either of the temporary tables is empty (because the user hasn't used that particular type of service) the subreport doesn't appear, because there is no data. I therefore have no total to display.
PROBLEM 3 - Because of problems 1 and/or 2 I can't get the balance to display in the textbox at the foot of the report, because there is missing data from the subreports or from the total payments (if it is 0).
I'm not sure that I have explained this very clearly! Sometimes you get too close to something and can't see the wood for the trees.
However, any advice you can give me that would help resolve these problems would be much appreciated.
Thanks in advance for your time.
John R
The main report shows payments made.
PROBLEM 1 - if there are no payments I cannot get the textbox that calculates the total payments (in this case 0) to be displayed.
There are two subreports within the main report, each providing a total of different types of service charges for the individual and generated from temporary tables which relate to the services used by the individual.
PROBLEM 2 - If either of the temporary tables is empty (because the user hasn't used that particular type of service) the subreport doesn't appear, because there is no data. I therefore have no total to display.
PROBLEM 3 - Because of problems 1 and/or 2 I can't get the balance to display in the textbox at the foot of the report, because there is missing data from the subreports or from the total payments (if it is 0).
I'm not sure that I have explained this very clearly! Sometimes you get too close to something and can't see the wood for the trees.
However, any advice you can give me that would help resolve these problems would be much appreciated.
Thanks in advance for your time.
John R