Detail Headings in Group Header Instead of Page Header

I'm trying to create a report in Access (2007).  I have used the wizard to start the report.  When the wizard completed it created my detail fields correctly but the detail headings are created in the Page header grouping.  I do not want the column headings to repeat only for each page.  Instead, I want the column headings to repeat for each  first level grouping that I created.

As an alternative, if I try to simply "add an existing field" into the the detail, I can't move the bound label to the group heading.

There has got to be a simple way to do this, but I have not found it yet.
jlexerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
You will need to create a group header. Move/Drag  the controls from the page header to the new group header. Set teh Grop header's repeat property to No.
0
jlexerAuthor Commented:
I've tried this many times.  I cannot move the control from the Page Header.  If I drag the object, it just resizes the height of the Page Header.  

If I cut and paste the object, it pastes the heading label but also deletes the bound object from the Detail section.  I could then manually add the field back to the detail section, but then I've lost the heading to detail binding and would have to manually set all the properties for each object to ensure the formatting and alignment stay in sync throughout the rest of the design.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
One of the reason I do not use the Report wizards is that it always groups the controls with makes the report harder to modify.

You will need to un group the controls.

0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Look on the Arrange tab

 UnGroup
0
jlexerAuthor Commented:
The "Ungroup" option never seems to be enabled for me.  Whether I selected all of the detail objects and linked headings or only selected one detail object and its heading from the Page Header section, the ungroup icon was always disabled.

I have since then found my own solution.  It seems to be more steps than I would have expected (it would not surprise me if there is an easier way):
1. Manually add each data field that you wish to the Detail section.
2. Manually, create a label in the Group Header for each field that you have added to the Detail section
3. Select all of the detail objects and heading labels at the same time
4. Right-Click the selected objects
5. From the pop-up options, select Layout -> then Tabular

Again, I don't know if this is the 'best' way to do this, but it worked for me.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jlexerAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for jlexer's comment http:/Q_27512185.html#37350123

for the following reason:

I don't know if it is the best solution, but I discovered a working solution myself.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
<<I don't know if it is the best solution, but I discovered a working solution myself.>>
Your working solution did use  my answer to your question. Which was to use a group header. See the very first reply.

You then had a second issue of how to apply it.  This issue you had was not with the correct solution of using a Group Header  but the method you had to use with your report to apply the solution.  My first reply was the solution you used.
0
South ModModeratorCommented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for jlexer's comment http:/Q_27512185.html#37350123
Assisted answer: 250 points for TheHiTechCoach's comment http:/Q_27512185.html#37347500

for the following reason:

All,<br />&nbsp; <br />Following an 'Objection' by TheHiTechCoach (at <a href="http://www.experts-exchange.com/Q_27513204.html">http://www.experts-exchang<wbr />e.com/Q_27<wbr />513204.htm<wbr />l</a>) to the intended closure of this question, it has been reviewed by at least one Moderator and is being closed as recommended by the Expert.<br />&nbsp;<br />At this point I am going to re-start the auto-close procedure.<br />&nbsp;<br />Thank you,<br />&nbsp;<br />SouthMod<br />Community Support Moderator
0
jlexerAuthor Commented:
The idea of using a group heading was not originally suggested by TheHiTechCoach.  It was always part of the question.  Please see the original quetion posting.  I clearly state,
Instead, I want the column headings to repeat for each  first level grouping that I created.

The whole question is based on using user created groupings; of which a heading comes as a result.  The scope of the issue and solution should be obvious that it take place within a Group Heading.

While I certainly appreciate TheHiTechCoach taking the time to respond to my question, his/her suggestion did not assist in the solution at all.  I would be happy to award him/her some 'thank you for participating points' if that it possible?  However, as a frequent searcher for solutions, my greater concern is that TheHiTechCoach's comments get flagged as a partial solution.  As they did not actually assist me, and in fact [for whatever reason], were not even enabled.  As a future user searching for a solution to this problem, the only comment that I would want to see flagged with the green box as the accepted solution is my comment, ID:37350123.  If this can be done and award TheHiTechCoach the points, then you have my approval to do so.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Not sure why jlexer could not get the ungroup to work.  Sorry we never got the chance to resolve the main issue of  ungrouping the controls.

Maybe next time.

Good luck with your project.










0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.