columns in report footer

[tgavin]

I have a directory that actually contains 3 subreports. It is to print as a
booklet. The first section only prints in the second column (right side of
the boolket, opening page). I have this in the report header and it works
fine. The center prints as 4 columns, 2 on each "page" of the booklet. I have
this in the detail and it is working fine. The final piece is 2 column,
meaning one column on each page of the booklet. It will not work. They all
come up in the left side. I have it in the report footer. I have each of the
page setups set on the individual subreports and they work, but when I put it
into the 1 report, the report page setup over writes it and it has to be set
for the 4 columns for the other 2 to come out.

The same report is also giving me a challenge putting page numbers on both
the left and right side.

Any help would be appreciated.

Thanks
Terri

 

[Marshall Barton]

I have a directory that actually contains 3 subreports. It is to print as a
booklet. The first section only prints in the second column (right side of
the boolket, opening page). I have this in the report header and it works
fine. The center prints as 4 columns, 2 on each "page" of the booklet. I have
this in the detail and it is working fine. The final piece is 2 column,
meaning one column on each page of the booklet. It will not work. They all
come up in the left side. I have it in the report footer. I have each of the
page setups set on the individual subreports and they work, but when I put it
into the 1 report, the report page setup over writes it and it has to be set
for the 4 columns for the other 2 to come out.

The same report is also giving me a challenge putting page numbers on both
the left and right side.

I think your problem with the report footer subreport is
because a CanGrow subreport can only use Across then Down
snaking. Can you predict the size of the subreport and use
that to set the subreport control's Height at design time?

You can get the page numbers you want by using an expression
like:
=2 * Page - 1
on the Left side page number text box and on the right:
=2 * Page - 2 + IIf(Page = 1, 1, 0)

 

[tgavin]

Marsh, thanks. The page numbers worked great. However, the report still isn't
working. That report would be just over 8 pages (7 1/2" after margins) which
is too long to leave it as a no grow. Setting the snaking as Across put the
directory (part 2) to 1 column instead of 4 and did not help the footer
report.

Any other ideals????

Thanks
Terri

 

[Chuck]

I think your problem with the report footer subreport is
because a CanGrow subreport can only use Across then Down
snaking. Can you predict the size of the subreport and use
that to set the subreport control's Height at design time?

You can get the page numbers you want by using an expression
like:
=2 * Page - 1
on the Left side page number text box and on the right:
=2 * Page - 2 + IIf(Page = 1, 1, 0)

Marsh,

Another @#%!!?<~%$# booklet report.
This one made up of three sub reports and each sub report to be treated
differently within the one report. It wasn't stated, but I suspect that the
data displayed on facing pages are supposed to be related somehow. Possible,
probably. But it's going to take a lot of code (manipulation) to make it
happen. Conceivably some pages could be blank.

If you don't have the complete exact database to work with, the chance of
getting it right are problematic.

Chuck
--

 

[tgavin]

Actually, they are not relateded. Unfortunately, it is just one of those
things that need to all go in the yearly directory.

The first is a 1 page board of directors, on the right side of the page. It
works! and althought the names will change, I don't ever see it being a
problem.

The second is the membership. 4 columns of names, addresses, phones and
email. The number of pages will change each year but it works, and I don't
see a problem for the future.

Finally, the third is the By-Laws. It is the one that is not working. It is
about 8 pages, ideally, I would love for it to start on the page after the
names and addresses finish but if it needs to always start on the next left
page, I can live with it. I just can not live with all the pages coming out
on the left side of the page. If having a copy of the db can help someone
help me solve the problem, tell me where to send it either zipped or with the
ext changed to txt.

Thanks
Terri

 

[Chuck]

Actually, they are not relateded. Unfortunately, it is just one of those
things that need to all go in the yearly directory.

The first is a 1 page board of directors, on the right side of the page. It
works! and althought the names will change, I don't ever see it being a
problem.

The second is the membership. 4 columns of names, addresses, phones and
email. The number of pages will change each year but it works, and I don't
see a problem for the future.

Finally, the third is the By-Laws. It is the one that is not working. It is
about 8 pages, ideally, I would love for it to start on the page after the
names and addresses finish but if it needs to always start on the next left
page, I can live with it. I just can not live with all the pages coming out
on the left side of the page. If having a copy of the db can help someone
help me solve the problem, tell me where to send it either zipped or with the
ext changed to txt.

Thanks
Terri

One solution is to print the three sub reports individually then manually
assemble then in the desired arrangement.

Booklets with many pages are not really all that handy. Take 20 pieces of
printer paper and fold them in half. If they go one inside another, The open
edges do not line up. If they go one beside another, you don't need to print
them as a booklet, just print on 8.5 by 5.5 paper.

If you absolutely must have a booklet, try the following. Printing different
formatting for different parts of the booklet may be a problem.

From Bob Howard's post of 6/23/05 8:45 AM

I finally decided to use a software product called FinePrint
(www.fineprint.com) which acts as a Postscript printer. I give it the
appropriate settings to configure the result as a booklet, and it takes care
of the whole thing.

End Bob Howard's post

I think the product costs about $50.00. If so very well worth it.

Chuck

 

[Marshall Barton]

I don't see how setting the part3 subreport's snaking could
have any effect on either the main report or the other
subreports.

You said that part3 is the bylaws, but that doesn't sound
like a list of data records. It sound more like a big block
of boilerplate text. I need a more detailed explanation the
the part3 subreport and its data records before I can even
think about an approach to this problem.

 

[Chuck]

I have a directory that actually contains 3 subreports. It is to print as a
booklet. The first section only prints in the second column (right side of
the boolket, opening page). I have this in the report header and it works
fine. The center prints as 4 columns, 2 on each "page" of the booklet. I have
this in the detail and it is working fine. The final piece is 2 column,
meaning one column on each page of the booklet. It will not work. They all
come up in the left side. I have it in the report footer. I have each of the
page setups set on the individual subreports and they work, but when I put it
into the 1 report, the report page setup over writes it and it has to be set
for the 4 columns for the other 2 to come out.

The same report is also giving me a challenge putting page numbers on both
the left and right side.

Any help would be appreciated.

Thanks
Terri

There is a problem with the terminology. One sheet of paper will have 4
booklet pages. You can have two columns on each booklet page.

When your report is finished, it will be a booklet - presumably made of 8.5" by
11" sheets of paper folded in half. And at least some of the pages will be
printed on both sides. If the finished booklet will have the folded pages
placed one inside another, then very a special order of the printed pages is
required. If the sheets are to be cut in half and held together somehow,
simply cut before printing and print as normal on 5.5 by 8.5 paper.

Take two pieces of paper, fold them in half, place them together like you
booklet. Lay them on a desk like a book. Label the top page (cover) 1. Open
the booklet. Label the left page 2 and the facing page 3. Turn page 3 over.
Label the left page 4 and the facing page 5. Repeat labeling pages 6 and 7.
Turn over last page and label it 8.

Now take the booklet apart and open the sheets full to 8.5 by 11. Examine the
location of each page of the booklet. If page 1 is facing up, it will be on
the right hand side of the open sheet and page 8 will be on the left hand side.
If page 2 is facing up, it will be on the left side of the sheet and page 7
will be on the right. It is obvious that simply making columns in landscape
mode is not going give you what I think you are asking for.

It is possible to write a sorting equation that will accomplish this, but it's
very time consuming. And the equation changes depending on the total number of
records the booklet will have and how many records will be printed on each
booklet page. Thus the suggestion that you use the FinePrint (or other booklet
software) program that does this for you.

Chuck
--