Columns Report Trouble

[Softec]

Well, i've got a trick one, so i wonder if anyone could help me out on this....

I've got a report whit 10 columns, and it works fine, but the issue is that i can't get the Section header and footer to span acroos the page widht just like the page header or footer!!!

In graphics, i wanted to do this:

----------------------------------------------------------------
Page header ----- SPANNED ------------>

----------------------------------------------------------------
Section header ----- SPANNED ------------>

----------------------------------------------------------------
Detail
Column 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6 | And so on

----------------------------------------------------------------
Section footer ----- SPANNED ------------>

----------------------------------------------------------------
Page footer ----- SPANNED ------------>

----------------------------------------------------------------

Here's what i get:

----------------------------------------------------------------
Page header ----- SPANNED ------------>

----------------------------------------------------------------
Section header|
Col 1 Width |
----------------------------------------------------------------
Detail
Column 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6 | And so on

----------------------------------------------------------------
Section footer |
Col 1 Width |
----------------------------------------------------------------
Page footer ----- SPANNED ------------>

----------------------------------------------------------------


Does anyone knows how to get this on a Access 2000 databases????

I'm getting desperate....

Thanks for all the help...

 

[Liv Manto]

drag the section label to page header, then on View, Sorting and Grouping, choose section, set keep together = whole group

 

[Softec]

drag the section label to page header, then on View, Sorting and Grouping, choose section, set keep together = whole group

Well, that way i get all the headers in a single page, and i already had the report that way, but it gets a lot of pages, so that's why wanted to "compact" various headers spanned across the page in a single page...

I've enclosed an image that illustrates what i want to accomplish...

Of course that on the bottom image i want the headers to be the full page width....

If anyone could help me, i really appreciate!!

TIA

 

[Liv Manto]

Just to make sure I understood it, when you said column , you are referring to the column format that could be access by File, page Setup and Columns, correct?

You are not referring to your tables having 10 columns a.ka. fields.

Do you think you can send me the report with the table?

Thanks.

 

[Softec]

Hi!!

I gladly would, but from your profile i can't do ti, since it syas you "refuse to recieve emails"...

I could even send you the entire database, since it is in a "crude" way yet, but this report is giving me a hard time...

If you can, drop me a line....

Thanks!!!!!!

 

[Liv Manto]

did you get my message?

Still waiting for your email, Sent you my work email address.

 

[Softec]

Yes, i did get your e-mail...

I've sent you the database....

Please let me know what you accomplish, since i'm quite "stuck"...

 

[Liv Manto]

I created reports A with Subreport ASUB.


Check the source, I created a string out of the four groupings you want so I used this new string to link it to the subform.

BOth of the forms have the same query source. The sub however has 31 columns while the parent is a single column.


I deleted the code inside, so kindly just put it back.

Thanks.

 

[Softec]

Hi!

Thanks!

I've already tryed with the subreports, but they get too slow loading, so i just give up...

I'll see what you've up to, and thank you for all the help!!!

 

[Softec]

Hi!

Thanks you for all the help!

Your reports work great, but it's weird, since that without the code, they run fairly fast, but with code, they get real slow...

Anyway, i can't figure out any other way to spped up them, maybe with some code cleaning....

But it's really what i wanted!!!!!

THANKS!!!!

If there's anything i can do for you, just ask!