Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / October 2005

Tip: Looking for answers? Try searching our database.

Column or multiple subreport issue

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
r. howell - 26 Sep 2005 20:56 GMT
I've asked this question before, without resolution, but I've learned a lot
more about different sorts of coding since then, and perhaps I can now ask it
more clearly and understand the answer.

I have a report which needs a footer which is designed to have consultants
and their addresses listed side by side at the bottom of the page, each
consultant's name over its address.

Consultants vary on projects and we can have anywhere from 1-5 consultants
on a project.

Because number of columns is something that happens at a page level, I have
not yet succeeded in putting a subreport into a page footer with three
columns while keeping the body of the report at 1 column.  If somebody can
tell me how to get this to work, that would be one method of solving my
problem.

The other way to work around this is to write multiple reports and allow the
end-user to decide how many consultants there are and to choose an
appropriate report accordingly.  This is clumsy but I would settle for it.  
My problem is that I do not understand how to write the subreports so that
each one would choose the "next" consultant.  I can pick first or last, but
not next.  I am convinced that this must be a relatively simple programming
job, but I don't know how to do it.

Thanks
Marshall Barton - 26 Sep 2005 22:22 GMT
>I've asked this question before, without resolution, but I've learned a lot
>more about different sorts of coding since then, and perhaps I can now ask it
[quoted text clipped - 20 lines]
>not next.  I am convinced that this must be a relatively simple programming
>job, but I don't know how to do it.

I have no problem doing that.

Some things to keep in mind when doing this:

The Page header/footer sections can not grow or shrink so
you must make the page footer section and the subreport
control large enough to display  it's maximum number of
records.

When the subreport is open in design view, make sure its
Width is small enough to display all three columns.  Use the
File - Page Setup menu item to specify its number of
columns.

Signature

Marsh
MVP [MS Access]

r. howell - 28 Sep 2005 15:21 GMT
Here's what happens.  I designed the subreport, very careful to specify
everything on the page setup field.  I check that it works.  No problem.

I put the subreport in the report field, and link it properly.  There is
plenty of room for it to open with multiple columns.

I open the main report.  It shows one record in the subreport.

I check the design.  The subreport has reverted to one column.  I change it
back to three columns.  I check it.  I save it.  I save the report.  I close
out and open the main report.  It shows one record in the subreport.

When I check the design the subreport has again reverted to one column.  I
have repeated this process numerous times.  What am I missing?

You have actually succeeded in getting a multiple column footer on a single
column report?

> >I've asked this question before, without resolution, but I've learned a lot
> >more about different sorts of coding since then, and perhaps I can now ask it
[quoted text clipped - 34 lines]
> File - Page Setup menu item to specify its number of
> columns.
Marshall Barton - 03 Oct 2005 16:15 GMT
That sounds very weird and I have never seen that behavior.

The number of columns reverting sounds kind of like a bug in
A2000 that was fixed in the first Service Release.  If you
are using A2000, check to make sure you have all the updates
installed.

And, Yes, I have what I think you are describing working
just fine so I am at a total loss to explain what you're
seeing.
Signature

Marsh
MVP [MS Access]

>Here's what happens.  I designed the subreport, very careful to specify
>everything on the page setup field.  I check that it works.  No problem.
[quoted text clipped - 52 lines]
>> File - Page Setup menu item to specify its number of
>> columns.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.