Column or multiple subreport issue

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

Guest

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
 
r. howell said:
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.
Click to expand...


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.
 
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?
 
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.
 
Back
Top