473,322 Members | 1,562 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Layered Sub-Report Headings for Every Page

43
I am pushing the limits in Access 2003 with 7 layers of subreports defined.

For each item of the report there can be a group of sub-items, each of these sub-items can have a group of sub-items, and so on down 7 layers.

I am attempting to create a report that shows each item with it's sub-items in a layered format. I have the item listed in the detail section with a sub-report pasted just below it. The sub-report contains a sub-report and so on down 7 layers. The border of each sub-report is turned on and indented slightly for each group of sub-items.

It reports all the data but I want to make it more readable where one of these boxes spans more then one page.

To do this in the top level I copied fields from the detail section to the Page Header section. This adds the header to the top of each page in addition to the detail the top-most item. When that item has several sub-items spanning multiple pages on the report it also puts that item at the top of each subsequent page.

You might think that the sub-reports would behave the same way but they do not. When I add the Page Header section to each sub-report, it prints it on the first occurance only and does not print it on subsequent pages. As a result it is difficult to tell what sub-report item you are on.

I have tried using the various events available to assign unbound fields in the Page Heading of the sub-report with the sub-report's current item. It does not seem to help.

When I run the sub-report by itself, as a main report, then it works as expected, printing the item at the top of each page.
May 30 '13 #1
1 1130
zmbd
5,501 Expert Mod 4TB
I think you need to try the solution for this here:Including Footers on Subreports in Access by using the group header (post#8).

Hopefully this will work for you too!
Jul 10 '13 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Henry Hartley | last post by:
I've got a PHP system working on a development server (Windows 2000/IIS5/PHP 4.3.3) but it doesn't seem to be working quite right on the testing server (same except PHP 4.2.3). I upgraded the PHP...
11
by: The Bicycling Guitarist | last post by:
Oh lords and ladies of ciwah, I have already been told by one person that the <h1> on my home page doesn't look like proper semantic markup to them. That person suggested a <p> with style by CSS....
3
by: bdwise | last post by:
I generate a querystring on page #1 and want that querystring to stay on every other page the user chooses, regardless of session or postback issues. What is a good way to handle that? Thanks.
1
by: MattB | last post by:
I'd like to preface every page in my application's title with some text. I have what I think is a good idea on how to do this, but I'm not sure how to refer to the current page from...
3
by: Ron James | last post by:
I would like to add a CSS link to every page on my site - "<LINK href="BLT.css" type="text/css" rel="stylesheet">". This links needs to go in the <HEAD> of my page. I was hoping that I could...
0
by: HackingPSP | last post by:
I saw a lot of requests for a program like this, so I wrote it. Yeah, my site has "PSP software by Auri" but in this case it means "Pretty Sweet Programming" :) There's both a VS2005 add-in and a...
2
by: Eric Marthinsen | last post by:
Hello- I need to run some code on every one of my ASP.NET pages (1.x). The code basically registers some client script blocks. I've been trying to find a way to do this that doesn't involve me...
3
by: JackBlack | last post by:
Hi, all! Using ASP.Net (2.0 framework) with VB.Net code-behind... Is there any way to execute a particular piece of code on each and every page load in a website, without specifically putting...
2
by: GD | last post by:
I have an ASP .Net 1.1 app where I am trying to store some values in a session object. The problem I am encountering is that the Session appears to restart for every page loaded and also for every...
0
by: petejones | last post by:
I have a directory of PDF files which contain Headings/Sub Headings and Page Numbers. I wish to write a script to open the PDF, read the Headings and any sub headings and write them out to a file....
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.