:confused: I have inheritted a system with reports that were probably written by a novice access programmer. My problem is a report with a dozen subreports in them. I had to add another subreport to that report. Many subreports set a global variable that is used to sum grand totals later. When I added my report, placed in the middle of the report, I found that the grand total subreport, which is placed after my subreport, is opened prior to my subreport. My subreport adds a value to that grand total. Because my report opens after, it is not included in the grand total subreport.
How do I determine or set the order of subreports on the main report?
Al
:confused:
2  3322  PEB 1,418
Expert 1GB
:confused: I have inheritted a system with reports that were probably written by a novice access programmer. My problem is a report with a dozen subreports in them. I had to add another subreport to that report. Many subreports set a global variable that is used to sum grand totals later. When I added my report, placed in the middle of the report, I found that the grand total subreport, which is placed after my subreport, is opened prior to my subreport. My subreport adds a value to that grand total. Because my report opens after, it is not included in the grand total subreport.
How do I determine or set the order of subreports on the main report?
Al
:confused:
Hi,
Ohh My Got it's easier to recreate the report isn't it! Reelly I don't have any idea why it's like this...
Try setting group headers and footers. By putting the subreports in footers and that grandtotal subreport in the report footer this should help.
:confused: I have inheritted a system with reports that were probably written by a novice access programmer. My problem is a report with a dozen subreports in them. I had to add another subreport to that report. Many subreports set a global variable that is used to sum grand totals later. When I added my report, placed in the middle of the report, I found that the grand total subreport, which is placed after my subreport, is opened prior to my subreport. My subreport adds a value to that grand total. Because my report opens after, it is not included in the grand total subreport.
How do I determine or set the order of subreports on the main report?
Al
:confused:
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Don Sealer |
last post by:
I have a report that includes 5 different subreports. I'd like to be
able to open this report using a date function (Start Date and End Date).
I'd like all five subreports to show the data from...
|
by: manning_news |
last post by:
Using A2K. I've been asked to modify a report currently requiring only
one date parameter to now accept a date range. The main report has 2
subreports and is not bound to a table or query. The...
|
by: Henrootje |
last post by:
I have a report concerning a customer.
In this report we find four subreports. They are in layout identical
but data comes from different tabel.
Now on the main report I count the totals of each...
|
by: David |
last post by:
Folks,
I have four subreports in a report in the detail section. I suppose I
could move them to the footer of the report. Anyway, if any of them
have data, I want the main report to force a...
|
by: DeanL |
last post by:
Hi all,
I'm currently pulling out my already thin hair and need a little help
if possible. I have an Access 97 db that is used to store inspection
information for different regions. My report...
|
by: billygotee |
last post by:
Hi,
I'm having an issue with VS .NET 2k5.
I have a master report that is the parent of several subreports (the
report got too big to keep it all in the same report). For a while
this worked...
|
by: MartinaN |
last post by:
Hello,
I have a MS Access 2000 question.
I created a main report that consists of different subreports in the Detail section. I have a couple of queries that create tables for certain cities (the...
|
by: Brett Barry: Go Get Geek! |
last post by:
Hello,
I have a main report with a Record Source, a DateToday table, that has
the current Month and Year. I have about 60 queries, each pulling
different data via ODBC, that I am creating...
|
by: glenfernandez |
last post by:
HI there,
Need a little help with the reporting component of my MS Access 2002 project and would appreciate any insight / help from the experts. Please bear with me as I am still learning Access...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
