Solved

Remove or Exclude Page Header from a Group Header - Access 2007

Posted on 2010-11-17
7
641 Views
Last Modified: 2012-06-21
I've got a report set up in Access 2007. It is a list of charges grouped by Projects. I have a Group Header with a summary of the Charges for that Particular Group. Then in the Details I have the listing of Charges. I would like to have a Header for the Details without having the same header on the Group Header.

So is there a way to not have the Page Header on a Group Header? I know you can exclude it from the Report Header.

Or is there a way to have a page header on the Details only.?
0
Comment
Question by:thomas-sherrouse
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 30

Expert Comment

by:hnasr
ID: 34158787
Do you mean column headers?
0
 
LVL 30

Expert Comment

by:hnasr
ID: 34158812
I mean column labels
0
 

Author Comment

by:thomas-sherrouse
ID: 34158980
Yes. I've got my Details and I'd like to have Labels for those Columns w/o having a label for each line.
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

Accepted Solution

by:
thomas-sherrouse earned 0 total points
ID: 34159073
Ok I figured it out by:

Creating a Seperating Grouping by Project Number and Created a Header for that Grouping after the Project Summary Page. The clicked on "Yes" on the Repeat Section Property in the 2nd Project Number Grouping Header. This Header has the Title for the Detail that follows.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34159153
The detail section will repeat for each record, so if you put a header in the detail section, it would repeat to.
I can visualize fixes and workarounds for this, but it could get messy.

My next question would be, why can't the headings stay in the group header?
I can't visualize how your request would make the report appear any different?
(Perhaps you have a unique design here?)

Can you simply post a screenshot of your report in Print Preview and mark it up to indicate what is wrong with the current layout.
And also indicate how these "New" headers would/should appear.
Also post a screenshot of the report in design view.

A sample file would also be helpful:
Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Delete any objects that do not relate directly to the issue.
5. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
6. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
7. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
8. Compile the code. (From the database window, click: Debug-->Compile)
9. Run the compact/Repair utility.
10. Remove any Passwords and/or security.
11. Post explicit steps to replicate the issue.
12. Test the database before posting.

In other words, ...post a database that we can easily open and immediately see the issue.


Notes:
The headings are in different report locations based on the layout you selected in the Report Wizard.
For example, with a grouped report:
Stepped or Block Layout, ...the headers are in the page header.
With the outline layout, they are in the group header.


JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34159158
OK
0
 

Author Closing Comment

by:thomas-sherrouse
ID: 34186439
I figured it out.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Get average for unknown number of cells per degree.. 3 39
can you help get  64bit version of these 3 APIs? 4 35
copy down array 24 36
Outlook mail to Access 8 31
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question