Multiple column footer to single column report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I do this?

The subreport for the footer works just fine on its own.
But I got the multiple columns via "page setup", which I suspect is what is
messing me up now.

Many thanks if you can help me.
 
r. howell said:
The subreport for the footer works just fine on its own.
But I got the multiple columns via "page setup", which I suspect is what is
messing me up now.
Click to expand...


You can make the report as wide as the paper less margins bu
using the File - Page Setup - Columns menu item. Just
uncheck the Same as Detail check box and specify the column
width manually.
 
I have a report which needs to have a footer which contains the name,
specialty, and address of our company, and then, parallel to our company on
the same lines the same information for each of the consultants on the job.
If I can figure out how to do it, it ought to be centered, so that if there
are no consultants, our firm's information is centered at the bottom of the
page, but if there are two consultants they should be spread out across the
bottom.

This is currently being done manually in a word processing program.

I am trying to automate things so that once the necessary information is
entered into the database, the requisite form can be created withthe push of
a button.
 
I must be doing something wrong, but that gets me a three column report, even
though the "same as detail" box has been unchecked.
 
r. howell said:
I must be doing something wrong, but that gets me a three column
report, even though the "same as detail" box has been unchecked.
Click to expand...

With that unchecked though you can go into the design of the report and make
the sections wider. It won't affect the detail section and group sections
(which will still use columns), but it will allow you to place more stuff to
the right in the report header/footer and the page header/footer.
 
If I go through the report selecting the sections, and going to "Page Set-up"
and changing the width or number of columns, I seem to get whichever value I
apply last applied to the whole page.

Is there some other way to get the footer only to have more columns than the
body of the report?
 
r. howell said:
If I go through the report selecting the sections, and going to "Page
Set-up" and changing the width or number of columns, I seem to get
whichever value I apply last applied to the whole page.

Is there some other way to get the footer only to have more columns
than the body of the report?
Click to expand...

Page Header/Footers and Report Heade/Footers don't support columns period.
All sections are the same width and there is only one page setup for the
report (not per section). However; unchecking the "same as detail" option
allows you to have columns that are a fixed width while you make the section
width in design view wider to accomodate having more objects in the Page and
Report Header/Footer sections.

Crude example:

This text is in the Report Header section
THIS TEXT IS IN THE PAGE HEADER SECTION
While is as
The using defined
Detail narrow in
Section columns page setup
 
Aargh! We live and learn. I've learned a whole lot about queries getting
this thing so it has the right data. Now you are telling me it cannot be
formatted this way.

Any suggestions, besides telling my superiors that their standard format has
to change in this brave new world?

Do I have to try to write this as a generated Word Document?

The report is supposed to look like this

OVERALL REPORT
Lots of details

Our Company Consultant 1 Consultant 2
Architects/Planners Job Description Job Description
City, State City, State City, State

With the above 3 groups of items lining up, as they will probably not do in
discussion group formating.


Thanks
 
r. howell said:
Aargh! We live and learn. I've learned a whole lot about queries
getting this thing so it has the right data. Now you are telling me
it cannot be formatted this way.

Any suggestions, besides telling my superiors that their standard
format has to change in this brave new world?

Do I have to try to write this as a generated Word Document?

The report is supposed to look like this

OVERALL REPORT
Lots of details

Our Company Consultant 1
Consultant 2 Architects/Planners Job Description
Job Description City, State City, State
City, State

With the above 3 groups of items lining up, as they will probably not
do in discussion group formating.
Click to expand...

Might be able to get what you want with a sub-report. Only caveat is that
when a sub-report has columns you either have to set CanGrow on the
sub-report control to NO or use "Across, Then Down" columns instead of
"Down, Then Across".
 
This has been a report with a subreport (the subreport has the columns in its
detail section) , with the subreport was located in the footer section of the
main report. I think I fixed both the canGrow and the Accross then Down
columns.

She's a no work.

Maybe I have to get fancy and try to get different reports to open based on
how many consultants we have on a project.
 
Back
Top