Labels on both columns of a report

[Gramps]

Hi All,

Hope you can help solve this strange one. I have searched the web on this topic and have not found any real useful information.

I have a report, a phone list, which has two columns, see the attached file for a screen shot.

The Employee Name, Mobile Phone and Desk Phone text is in the "Page Header". The Data fields that retrieve from the table are in the "Detail" section. The whole report is 8.89cm wide. The two columns fit perfectly across a portrait A4 sheet.

When I run the report to Print Preview, I get the two columns fine, but the Employee Name, Mobile Phone and Desk Phone text doesn't repeat at the top of the second column. Is there some way of achieving this? I want the part I have circled in RED to appear over the top of the second column as well.

I would have thought there would be a simple check box somehwere that would be something like : "Repeat Page Header on multiple columns", or something as equally useful. Strange that this is so difficult to do, as am sure that this sort of thing is something that lots of people would want to do?

Any ideas?

[JHB]

Add a grouping to the report ex. "Employee Name", move "Employee Name, Mobile Phone and Desk Phone" text controls into the added grouping header, set the property "Repeat Section" for the grouping to "Yes".

[Gramps]

Thanks for the reply JHB.

While I was waiting for someone to reply, I had a play with that exact scenario. The attached screen shot shows the result. It repeats the Group Header for EACH entry. Is there another option somewhere that I have to set to make it only do it at the top of the page and at the beginning of a new column?

[Mihail]

Originally Posted by JHB

Add a grouping to the report ex. "Employee Name", move"Employee Name, Mobile Phone and Desk Phone" text controls into the added grouping header, set the property "Repeat Section" for the grouping to "Yes".

If you will follow JHB's advice all should be OK.

[JHB]

Try as I suggested in post no. 2, the result would be as shown in the attached picture.

[Gramps]

Hi All,

Still no luck!

I have attached a database that has the report and the table with some dummy data in it.

What have I done wrong? It still repeats the Group Header for each entry...

[Mihail]

I can't understand why your report don't work.
A single word bring up in my mind: "corrupted".
So, I've designated other report (I've used copy-paste for the controls that already you have) then I set the row source. And all seems to be OK (see attached).

[JHB]

Originally Posted by Gramps

Hi All,

Still no luck!

I have attached a database that has the report and the table with some dummy data in it.

What have I done wrong? It still repeats the Group Header for each entry...

Yes I see, you've to add a dummy value, like I've done in the attached database, open report "tblPhoneList1".

[Gramps]

Hi JHB,

Thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou!

You little ripper!

Your solution is so elegant, it almost made me cry!

I sort of worked out something similar, but I have since put your solution into the database instead because it beats my idea hands down!

I worked out that the reason why I was getting the labels repeating for each entry was because I needed a way for Access to see all the table records as a group. Since none of the items in the table shared any group characteristics, I needed to invent one. I decided to create a new field in the table, called it ReportGroup, put the value "Grp" into each record and set the field to Automatically populate with the value Grp when a new record was created. Then I was able to do a group on ReportGrp, which worked, but your way is MUCH MUCH better.

I have learned so much from everyone on this site by reading all the forums and I doubt I would have been able to create what I have so far without you all.

Thanks again!

[JHB]

You're welcome, good it succeed at last.
Luck with your project.