If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
P&L report - subreport question
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
subreport not displaying in main report | JohnLute | Setting Up & Running Reports | 15 | November 17th, 2005 04:02 PM |
Survey Results | SAm | Running & Setting Up Queries | 10 | May 17th, 2005 08:32 PM |
Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |