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 |
#11
|
|||
|
|||
report footer in multiple column report
Joseph Greenberg wrote:
I am using column printing from the page setup menu - my report is defined as 2 columns (for illustration sake, I am trying to print 2 pages of a phone directory on 1 8.5x14 piece of landscape (legal) paper. I have .5 inches between columns and .25 inch margins so I each "page" in the report (and the available width of the report area) is 6.25". I have my fields placed on the report, with appropriate grouping. That is, I have ONE LastName field placed on the report. The column printing (down first) takes care of creating the first column of names, and then goes back up to the top on the right hand column. So.... There is only 1 "side" to my report - it's not like I've manally created columns in the report. I have my report laid out, and I expect Access to repeat it in columns - which it does. So if I were to have say 3 columns defined on the page setup screen instead of 2, I'd want the bottom of the first column to say "Page 1", the bottom of the second column to say "Page 2", and the bottom of the 3rd column say "Page 3" - even though they all appear on the same physical piece of paper. The the first column on the second physical piece of paper would say "Page 4", etc. If I place a [Page] in the group footer, I get the physical page number, same as if I placed it in the page footer. The thing to keep in mind is that there is not real "grouping" at a high level - all the last names are part of the same group. The other grouping variables I have defined are to take care of children records and ordering, and that sort of thing. Does this now make any more sense? Ok, you're using real report columns. I got that part, but how do you guarantee the each group will fit in a single column? I still think you should use the page footer with a text box positioned so that it appears under a column. Instead of using just =Page, set each text box expression to reflect the number of columns: =3 * (Page - 1) + 1 =3 * (Page - 1) + 2 =3 * (Page - 1) + 3 -- Marsh MVP [MS Access] |
#12
|
|||
|
|||
report footer in multiple column report
I don't worry about if each group fits on a single page - there is only one
"group" - the list of names. I have a group header that breaks to a new page at each letter of the alphabet, but realistically it is all just one list of names. So I have set up as one "column" of fields/data, and Access, using the column printing feature, makes it into 2. If I put something in the page footer, it only shows up under the first (left hand) column - my problem is getting something under the right hand column also. "Marshall Barton" wrote in message ... Joseph Greenberg wrote: I am using column printing from the page setup menu - my report is defined as 2 columns (for illustration sake, I am trying to print 2 pages of a phone directory on 1 8.5x14 piece of landscape (legal) paper. I have .5 inches between columns and .25 inch margins so I each "page" in the report (and the available width of the report area) is 6.25". I have my fields placed on the report, with appropriate grouping. That is, I have ONE LastName field placed on the report. The column printing (down first) takes care of creating the first column of names, and then goes back up to the top on the right hand column. So.... There is only 1 "side" to my report - it's not like I've manally created columns in the report. I have my report laid out, and I expect Access to repeat it in columns - which it does. So if I were to have say 3 columns defined on the page setup screen instead of 2, I'd want the bottom of the first column to say "Page 1", the bottom of the second column to say "Page 2", and the bottom of the 3rd column say "Page 3" - even though they all appear on the same physical piece of paper. The the first column on the second physical piece of paper would say "Page 4", etc. If I place a [Page] in the group footer, I get the physical page number, same as if I placed it in the page footer. The thing to keep in mind is that there is not real "grouping" at a high level - all the last names are part of the same group. The other grouping variables I have defined are to take care of children records and ordering, and that sort of thing. Does this now make any more sense? Ok, you're using real report columns. I got that part, but how do you guarantee the each group will fit in a single column? I still think you should use the page footer with a text box positioned so that it appears under a column. Instead of using just =Page, set each text box expression to reflect the number of columns: =3 * (Page - 1) + 1 =3 * (Page - 1) + 2 =3 * (Page - 1) + 3 -- Marsh MVP [MS Access] |
#13
|
|||
|
|||
report footer in multiple column report
I have been trying to explain that the page footer (not
group footer) needs a text box with my suggested expression **for each column**. If you have two columns, then the page footer needs two text boxes, one on the left and another on the right. Similarly for three columns using three text boxes. -- Marsh MVP [MS Access] Joseph Greenberg wrote: I don't worry about if each group fits on a single page - there is only one "group" - the list of names. I have a group header that breaks to a new page at each letter of the alphabet, but realistically it is all just one list of names. So I have set up as one "column" of fields/data, and Access, using the column printing feature, makes it into 2. If I put something in the page footer, it only shows up under the first (left hand) column - my problem is getting something under the right hand column also. "Marshall Barton" wrote Joseph Greenberg wrote: I am using column printing from the page setup menu - my report is defined as 2 columns (for illustration sake, I am trying to print 2 pages of a phone directory on 1 8.5x14 piece of landscape (legal) paper. I have .5 inches between columns and .25 inch margins so I each "page" in the report (and the available width of the report area) is 6.25". I have my fields placed on the report, with appropriate grouping. That is, I have ONE LastName field placed on the report. The column printing (down first) takes care of creating the first column of names, and then goes back up to the top on the right hand column. So.... There is only 1 "side" to my report - it's not like I've manally created columns in the report. I have my report laid out, and I expect Access to repeat it in columns - which it does. So if I were to have say 3 columns defined on the page setup screen instead of 2, I'd want the bottom of the first column to say "Page 1", the bottom of the second column to say "Page 2", and the bottom of the 3rd column say "Page 3" - even though they all appear on the same physical piece of paper. The the first column on the second physical piece of paper would say "Page 4", etc. If I place a [Page] in the group footer, I get the physical page number, same as if I placed it in the page footer. The thing to keep in mind is that there is not real "grouping" at a high level - all the last names are part of the same group. The other grouping variables I have defined are to take care of children records and ordering, and that sort of thing. Does this now make any more sense? Ok, you're using real report columns. I got that part, but how do you guarantee the each group will fit in a single column? I still think you should use the page footer with a text box positioned so that it appears under a column. Instead of using just =Page, set each text box expression to reflect the number of columns: =3 * (Page - 1) + 1 =3 * (Page - 1) + 2 =3 * (Page - 1) + 3 |
#14
|
|||
|
|||
report footer in multiple column report
ok, and what I"ve been trying to explain is that i only have one column
defined in my report. There is ONE last name field. Access, in the multi-column printing functionality automatically puts the second column on the right side of the page. I don't "define" a second column. So let's say I have 500 people in my directory. My detail section has a field called LastName (and other things but we don't care about that right now). So it prints each last name down the page. Lets's say it gets 50 on a page. If I was using standard printing, it would fill up 10 pages, right? But since I'm using column printing, instead of going to the next page, it actually puts the 51st name at the top of the first page, but in wahat appears to be a second column, even though i only have one column width of fields defined in my report. So the first page will now contain 100 names (50 in both columns). And of course the report will now be only 5 pages. So, if I put a page footer in my report, it only prints once at the bottom of a page. A group footer will print twice (under both columns), but it still shows the PAGE number - the last page will have two page numbers, both saying page 5. What I'm not getting is where do I put the second text box you are referring to? Sorry if I'm not making myself clear, and for your persistence. "Marshall Barton" wrote in message ... I have been trying to explain that the page footer (not group footer) needs a text box with my suggested expression **for each column**. If you have two columns, then the page footer needs two text boxes, one on the left and another on the right. Similarly for three columns using three text boxes. -- Marsh MVP [MS Access] Joseph Greenberg wrote: I don't worry about if each group fits on a single page - there is only one "group" - the list of names. I have a group header that breaks to a new page at each letter of the alphabet, but realistically it is all just one list of names. So I have set up as one "column" of fields/data, and Access, using the column printing feature, makes it into 2. If I put something in the page footer, it only shows up under the first (left hand) column - my problem is getting something under the right hand column also. "Marshall Barton" wrote Joseph Greenberg wrote: I am using column printing from the page setup menu - my report is defined as 2 columns (for illustration sake, I am trying to print 2 pages of a phone directory on 1 8.5x14 piece of landscape (legal) paper. I have .5 inches between columns and .25 inch margins so I each "page" in the report (and the available width of the report area) is 6.25". I have my fields placed on the report, with appropriate grouping. That is, I have ONE LastName field placed on the report. The column printing (down first) takes care of creating the first column of names, and then goes back up to the top on the right hand column. So.... There is only 1 "side" to my report - it's not like I've manally created columns in the report. I have my report laid out, and I expect Access to repeat it in columns - which it does. So if I were to have say 3 columns defined on the page setup screen instead of 2, I'd want the bottom of the first column to say "Page 1", the bottom of the second column to say "Page 2", and the bottom of the 3rd column say "Page 3" - even though they all appear on the same physical piece of paper. The the first column on the second physical piece of paper would say "Page 4", etc. If I place a [Page] in the group footer, I get the physical page number, same as if I placed it in the page footer. The thing to keep in mind is that there is not real "grouping" at a high level - all the last names are part of the same group. The other grouping variables I have defined are to take care of children records and ordering, and that sort of thing. Does this now make any more sense? Ok, you're using real report columns. I got that part, but how do you guarantee the each group will fit in a single column? I still think you should use the page footer with a text box positioned so that it appears under a column. Instead of using just =Page, set each text box expression to reflect the number of columns: =3 * (Page - 1) + 1 =3 * (Page - 1) + 2 =3 * (Page - 1) + 3 |
#15
|
|||
|
|||
report footer in multiple column report
I understand what you are saying, but we still seem to be
talking past each other. A group footer will not help here, at least not without a ridiculous amount of fooling around. Put BOTH text boxes in the Page Footer. The one on the left side of the footer would use the expression: =2 * (Page - 1) + 1 The text box on the right side of the Page Footer: =2 * (Page - 1) + 2 I think at least part of your confusion might be because you have the File - Page Setup - Columns - Same As Detail box checked so your page footer is the same width as the detail section (about half the page width). If that's the case, make note of the report width, then go into File - Page Setup - Columns, un check the Same As Detail box and make sure the Column Width is set to the noted value. Then go back to the report and drag the report width so the page footer spans the width of the printed page. Now you can position the two text boxes as I have been saying. Note: in a multi column report, you almost always want to un check the Same As Detail box because the report header, report footer, page header and page footer sections look pretty stupid crammed into one column's worth of space. -- Marsh MVP [MS Access] Joseph Greenberg wrote: ok, and what I"ve been trying to explain is that i only have one column defined in my report. There is ONE last name field. Access, in the multi-column printing functionality automatically puts the second column on the right side of the page. I don't "define" a second column. So let's say I have 500 people in my directory. My detail section has a field called LastName (and other things but we don't care about that right now). So it prints each last name down the page. Lets's say it gets 50 on a page. If I was using standard printing, it would fill up 10 pages, right? But since I'm using column printing, instead of going to the next page, it actually puts the 51st name at the top of the first page, but in wahat appears to be a second column, even though i only have one column width of fields defined in my report. So the first page will now contain 100 names (50 in both columns). And of course the report will now be only 5 pages. So, if I put a page footer in my report, it only prints once at the bottom of a page. A group footer will print twice (under both columns), but it still shows the PAGE number - the last page will have two page numbers, both saying page 5. What I'm not getting is where do I put the second text box you are referring to? . "Marshall Barton" wrote I have been trying to explain that the page footer (not group footer) needs a text box with my suggested expression **for each column**. If you have two columns, then the page footer needs two text boxes, one on the left and another on the right. Similarly for three columns using three text boxes. Joseph Greenberg wrote: I don't worry about if each group fits on a single page - there is only one "group" - the list of names. I have a group header that breaks to a new page at each letter of the alphabet, but realistically it is all just one list of names. So I have set up as one "column" of fields/data, and Access, using the column printing feature, makes it into 2. If I put something in the page footer, it only shows up under the first (left hand) column - my problem is getting something under the right hand column also. "Marshall Barton" wrote Joseph Greenberg wrote: I am using column printing from the page setup menu - my report is defined as 2 columns (for illustration sake, I am trying to print 2 pages of a phone directory on 1 8.5x14 piece of landscape (legal) paper. I have .5 inches between columns and .25 inch margins so I each "page" in the report (and the available width of the report area) is 6.25". I have my fields placed on the report, with appropriate grouping. That is, I have ONE LastName field placed on the report. The column printing (down first) takes care of creating the first column of names, and then goes back up to the top on the right hand column. So.... There is only 1 "side" to my report - it's not like I've manally created columns in the report. I have my report laid out, and I expect Access to repeat it in columns - which it does. So if I were to have say 3 columns defined on the page setup screen instead of 2, I'd want the bottom of the first column to say "Page 1", the bottom of the second column to say "Page 2", and the bottom of the 3rd column say "Page 3" - even though they all appear on the same physical piece of paper. The the first column on the second physical piece of paper would say "Page 4", etc. If I place a [Page] in the group footer, I get the physical page number, same as if I placed it in the page footer. The thing to keep in mind is that there is not real "grouping" at a high level - all the last names are part of the same group. The other grouping variables I have defined are to take care of children records and ordering, and that sort of thing. Does this now make any more sense? Ok, you're using real report columns. I got that part, but how do you guarantee the each group will fit in a single column? I still think you should use the page footer with a text box positioned so that it appears under a column. Instead of using just =Page, set each text box expression to reflect the number of columns: =3 * (Page - 1) + 1 =3 * (Page - 1) + 2 =3 * (Page - 1) + 3 |
|
Thread Tools | |
Display Modes | |
|
|