A
Arnon
I am building a Profit and loss report which list the accounts that are part
of a sub total. I cannot run one report since some of the subtotals are then
calculated by a text box. For example: sub total salaries + sub total G&A are
summed up to a higher level.
What I did is I built two subreports which are the same except for the fact
that one query salaries and the other G&A. I then inserted them to the "main"
report and with a text box got the subtotal for each one of them. Then I add
a text box which add salaries+G&A into one line.
I can do the report by adding all those subreport (in my case 10 subreports)
but was wandering if there is a clever and more ifficient way, since if I
need to make a change, say, adding a variance field, I will have to do it 10
times.
Thanks in advance for your help,
Arnon
of a sub total. I cannot run one report since some of the subtotals are then
calculated by a text box. For example: sub total salaries + sub total G&A are
summed up to a higher level.
What I did is I built two subreports which are the same except for the fact
that one query salaries and the other G&A. I then inserted them to the "main"
report and with a text box got the subtotal for each one of them. Then I add
a text box which add salaries+G&A into one line.
I can do the report by adding all those subreport (in my case 10 subreports)
but was wandering if there is a clever and more ifficient way, since if I
need to make a change, say, adding a variance field, I will have to do it 10
times.
Thanks in advance for your help,
Arnon