 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / November 2005Subreport problem
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 building two subreports which are the same except for the fact that one queries 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 adds salaries+G&A into one line. The problem is that if I need to make a change, say, adding a variance field, I will have to do it 10 times. Since this is just one P&L report out of many that I need to build, I was wondering if there's a way to make this process better and faster. Thanks in advance for your help, Arnon Add a new column to the table. Call it GroupingCode. Use it to control which types get summed. >I am building a Profit and loss report which list the accounts that are >part [quoted text clipped - 22 lines] > > Arnon Thanks for your answer. Can I use just one sub report then, to what section of the subreport should I add the groupingCode field. Does it mean that in the main report I paste the same subreport 10 times (instead of 10 different subreports like I am doing now, which is a hassle)? If yes, how do tell for each one of the 10 pastes which groupingCode to take? Again, thanks in advance Arnon > Add a new column to the table. Call it GroupingCode. Use it to control > which types get summed. [quoted text clipped - 25 lines] > > > > Arnon You would use only a single subreport. The subreport would have a group heading and so it would automatically break after each change in the group code. > Thanks for your answer. > [quoted text clipped - 41 lines] >> > >> > Arnon After doing it I get detail of accounts then the sub total of the account category. So let's say salaries accounts+Sub-total salaries, then Direct cost accounts+sub-total direct cost. What I would like to have is after the sub-total for direct cost add a line that add the two sub-totals together. Is that possible to do using just onw report, if yes then how. Because what I have done using the example above is creating two sub-reports, one for salaries and the other for direct cost, pasted both into the main report and then added the line which adds the two together. I cannot seem to understand how to add those lines using just one report. Thanks, Arnon > You would use only a single subreport. The subreport would have a group > heading and so it would automatically break after each change in the group [quoted text clipped - 45 lines] > >> > > >> > Arnon Put controls in the report footers of each subreport that sum the amounts. Then add a control to the main report that references the subreport. =Nz(Subreport1.SumField,0) + Nz(Subreport2.SumField,0) > After doing it I get detail of accounts then the sub total of the account > category. So let's say salaries accounts+Sub-total salaries, then Direct [quoted text clipped - 76 lines] >> >> > >> >> > Arnon So, based on your answer, there is no way of doing this using just one subreport instead of ten, correct? Arnon > Put controls in the report footers of each subreport that sum the amounts. > Then add a control to the main report that references the subreport. [quoted text clipped - 80 lines] > >> >> > > >> >> > Arnon |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.