If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
columns in report footer
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 |
#2
|
|||
|
|||
columns in report footer
tgavin wrote:
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) -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
columns in report footer
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 "tgavin" wrote: 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 |
#4
|
|||
|
|||
columns in report footer
On Sun, 28 Oct 2007 13:41:36 -0600, Marshall Barton
wrote: tgavin wrote: 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) 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 -- |
#5
|
|||
|
|||
columns in report footer
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" wrote: On Sun, 28 Oct 2007 13:41:36 -0600, Marshall Barton wrote: tgavin wrote: 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) 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 -- |
#6
|
|||
|
|||
columns in report footer
On Mon, 29 Oct 2007 07:28:04 -0700, tgavin
wrote: 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" wrote: On Sun, 28 Oct 2007 13:41:36 -0600, Marshall Barton wrote: tgavin wrote: 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) 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 -- 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 |
#7
|
|||
|
|||
columns in report footer
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. -- Marsh MVP [MS Access] tgavin wrote: 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. "tgavin" wrote: 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. |
#8
|
|||
|
|||
columns in report footer
On Sun, 28 Oct 2007 12:05:00 -0700, tgavin
wrote: 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 -- |
Thread Tools | |
Display Modes | |
|
|