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
|
|||
|
|||
report footer in multiple column report
Hi, all:
I usually put a line at report footer to indicate the end of the report. In multiple column report, if the report ends at the first column, the line at report footer is ok. If the report ends at 2nd or 3rd column, the report footer with a line falls on its own last blank page. How to solve it? Thanks. |
#2
|
|||
|
|||
report footer in multiple column report
Hello Song Su,
I have watched your post and waited to see if someone with a lot more experience than I would answer because I am a new user and don’t want to steer you in the wrong direction. But since no one has replied thus far, maybe the answer I received for my report question will also help you. Like yours, my db is also for a school and includes a multicolumn report. The settings I had in my report we 1. Force New Page set to “None”. 2. Report Keep Together (Sorting and Grouping) was set to “No”. I received a reply from Marshall Barton, Access MVP, that resolved my problem. You may want to try it as well. Here is his reply: "Because the report footer spans the entire width of the report, it's not really appropriate for what you want. You probably need to use a group footer, which will be in a single column." "To do that, insert a new group level at the top of the sorting and grouping list using a constant expression (e.g. =1). Then put the grand total text box in this new group footer section. " When I asked a follow-up question about the meaning of “= 1” his reply stated: "If you look at the heading over the first column in the sorting and grouping window, you will see that it is '"Field/Expression". When you use an expression, it must start with an = sign. In this case, the expression is a trivial constant such as =1, but it could be anything that is not the name of a field. E.g. you could use: ="My Dummy Footer" to the same effect)." Just so you know the background, I was trying to create a calculated control at the end of one of the columns. What was happening is that the calculation was alone on a single page and I couldn’t get it with the rest of the report. Like I previously stated, I’m a new user and this may not be what you’re looking for. But it's been quite a while since you posted your question. You may want to try this while you wait for someone with more experience and maybe a different solution. I hope this helps you as well. -- Aria W. "Song Su" wrote: Hi, all: I usually put a line at report footer to indicate the end of the report. In multiple column report, if the report ends at the first column, the line at report footer is ok. If the report ends at 2nd or 3rd column, the report footer with a line falls on its own last blank page. How to solve it? Thanks. |
#3
|
|||
|
|||
report footer in multiple column report
Dear Aria,
It works great! Instead of report footer, using group footer solve the problem. Thank you for your help. Song "Aria" wrote in message news Hello Song Su, I have watched your post and waited to see if someone with a lot more experience than I would answer because I am a new user and don’t want to steer you in the wrong direction. But since no one has replied thus far, maybe the answer I received for my report question will also help you. Like yours, my db is also for a school and includes a multicolumn report. The settings I had in my report we 1. Force New Page set to “None”. 2. Report Keep Together (Sorting and Grouping) was set to “No”. I received a reply from Marshall Barton, Access MVP, that resolved my problem. You may want to try it as well. Here is his reply: "Because the report footer spans the entire width of the report, it's not really appropriate for what you want. You probably need to use a group footer, which will be in a single column." "To do that, insert a new group level at the top of the sorting and grouping list using a constant expression (e.g. =1). Then put the grand total text box in this new group footer section. " When I asked a follow-up question about the meaning of “= 1” his reply stated: "If you look at the heading over the first column in the sorting and grouping window, you will see that it is '"Field/Expression". When you use an expression, it must start with an = sign. In this case, the expression is a trivial constant such as =1, but it could be anything that is not the name of a field. E.g. you could use: ="My Dummy Footer" to the same effect)." Just so you know the background, I was trying to create a calculated control at the end of one of the columns. What was happening is that the calculation was alone on a single page and I couldn’t get it with the rest of the report. Like I previously stated, I’m a new user and this may not be what you’re looking for. But it's been quite a while since you posted your question. You may want to try this while you wait for someone with more experience and maybe a different solution. I hope this helps you as well. -- Aria W. "Song Su" wrote: Hi, all: I usually put a line at report footer to indicate the end of the report. In multiple column report, if the report ends at the first column, the line at report footer is ok. If the report ends at 2nd or 3rd column, the report footer with a line falls on its own last blank page. How to solve it? Thanks. |
#4
|
|||
|
|||
report footer in multiple column report
Dear Aria,
Your solution works great. Using group footer instead of report footer solve the problem. Thank you very much. Song Su "Aria" wrote in message news Hello Song Su, I have watched your post and waited to see if someone with a lot more experience than I would answer because I am a new user and don’t want to steer you in the wrong direction. But since no one has replied thus far, maybe the answer I received for my report question will also help you. Like yours, my db is also for a school and includes a multicolumn report. The settings I had in my report we 1. Force New Page set to “None”. 2. Report Keep Together (Sorting and Grouping) was set to “No”. I received a reply from Marshall Barton, Access MVP, that resolved my problem. You may want to try it as well. Here is his reply: "Because the report footer spans the entire width of the report, it's not really appropriate for what you want. You probably need to use a group footer, which will be in a single column." "To do that, insert a new group level at the top of the sorting and grouping list using a constant expression (e.g. =1). Then put the grand total text box in this new group footer section. " When I asked a follow-up question about the meaning of “= 1” his reply stated: "If you look at the heading over the first column in the sorting and grouping window, you will see that it is '"Field/Expression". When you use an expression, it must start with an = sign. In this case, the expression is a trivial constant such as =1, but it could be anything that is not the name of a field. E.g. you could use: ="My Dummy Footer" to the same effect)." Just so you know the background, I was trying to create a calculated control at the end of one of the columns. What was happening is that the calculation was alone on a single page and I couldn’t get it with the rest of the report. Like I previously stated, I’m a new user and this may not be what you’re looking for. But it's been quite a while since you posted your question. You may want to try this while you wait for someone with more experience and maybe a different solution. I hope this helps you as well. -- Aria W. "Song Su" wrote: Hi, all: I usually put a line at report footer to indicate the end of the report. In multiple column report, if the report ends at the first column, the line at report footer is ok. If the report ends at 2nd or 3rd column, the report footer with a line falls on its own last blank page. How to solve it? Thanks. |
#5
|
|||
|
|||
report footer in multiple column report
Hi Song Su,
I was nervous about offering advice when I am inexperienced with Access. But I didn't want your question to remain unanswered if there was a possible solution. I am so glad the answer I received helped you as well. -- Aria W. "Song Su" wrote: Dear Aria, Your solution works great. Using group footer instead of report footer solve the problem. Thank you very much. Song Su "Aria" wrote in message news Hello Song Su, I have watched your post and waited to see if someone with a lot more experience than I would answer because I am a new user and don’t want to steer you in the wrong direction. But since no one has replied thus far, maybe the answer I received for my report question will also help you. Like yours, my db is also for a school and includes a multicolumn report. The settings I had in my report we 1. Force New Page set to “None”. 2. Report Keep Together (Sorting and Grouping) was set to “No”. I received a reply from Marshall Barton, Access MVP, that resolved my problem. You may want to try it as well. Here is his reply: "Because the report footer spans the entire width of the report, it's not really appropriate for what you want. You probably need to use a group footer, which will be in a single column." "To do that, insert a new group level at the top of the sorting and grouping list using a constant expression (e.g. =1). Then put the grand total text box in this new group footer section. " When I asked a follow-up question about the meaning of “= 1” his reply stated: "If you look at the heading over the first column in the sorting and grouping window, you will see that it is '"Field/Expression". When you use an expression, it must start with an = sign. In this case, the expression is a trivial constant such as =1, but it could be anything that is not the name of a field. E.g. you could use: ="My Dummy Footer" to the same effect)." Just so you know the background, I was trying to create a calculated control at the end of one of the columns. What was happening is that the calculation was alone on a single page and I couldn’t get it with the rest of the report. Like I previously stated, I’m a new user and this may not be what you’re looking for. But it's been quite a while since you posted your question. You may want to try this while you wait for someone with more experience and maybe a different solution. I hope this helps you as well. -- Aria W. "Song Su" wrote: Hi, all: I usually put a line at report footer to indicate the end of the report. In multiple column report, if the report ends at the first column, the line at report footer is ok. If the report ends at 2nd or 3rd column, the report footer with a line falls on its own last blank page. How to solve it? Thanks. |
#6
|
|||
|
|||
report footer in multiple column report
Do you know how, using this method, I can sequentially number the columns to
appear as pages? That is, I have a 2 column report, and I want, at the top (or bottom) of each column to include a page number - so the second column (appearing on the first physical page) would appear as page 2? "Aria" wrote in message ... Hi Song Su, I was nervous about offering advice when I am inexperienced with Access. But I didn't want your question to remain unanswered if there was a possible solution. I am so glad the answer I received helped you as well. -- Aria W. "Song Su" wrote: Dear Aria, Your solution works great. Using group footer instead of report footer solve the problem. Thank you very much. Song Su "Aria" wrote in message news Hello Song Su, I have watched your post and waited to see if someone with a lot more experience than I would answer because I am a new user and don't want to steer you in the wrong direction. But since no one has replied thus far, maybe the answer I received for my report question will also help you. Like yours, my db is also for a school and includes a multicolumn report. The settings I had in my report we 1. Force New Page set to "None". 2. Report Keep Together (Sorting and Grouping) was set to "No". I received a reply from Marshall Barton, Access MVP, that resolved my problem. You may want to try it as well. Here is his reply: "Because the report footer spans the entire width of the report, it's not really appropriate for what you want. You probably need to use a group footer, which will be in a single column." "To do that, insert a new group level at the top of the sorting and grouping list using a constant expression (e.g. =1). Then put the grand total text box in this new group footer section. " When I asked a follow-up question about the meaning of "= 1" his reply stated: "If you look at the heading over the first column in the sorting and grouping window, you will see that it is '"Field/Expression". When you use an expression, it must start with an = sign. In this case, the expression is a trivial constant such as =1, but it could be anything that is not the name of a field. E.g. you could use: ="My Dummy Footer" to the same effect)." Just so you know the background, I was trying to create a calculated control at the end of one of the columns. What was happening is that the calculation was alone on a single page and I couldn't get it with the rest of the report. Like I previously stated, I'm a new user and this may not be what you're looking for. But it's been quite a while since you posted your question. You may want to try this while you wait for someone with more experience and maybe a different solution. I hope this helps you as well. -- Aria W. "Song Su" wrote: Hi, all: I usually put a line at report footer to indicate the end of the report. In multiple column report, if the report ends at the first column, the line at report footer is ok. If the report ends at 2nd or 3rd column, the report footer with a line falls on its own last blank page. How to solve it? Thanks. |
#7
|
|||
|
|||
report footer in multiple column report
You can get the number of a column by using a text boxes
with expressions Left column: =2 * Page Right column: =2 * Page - 1 However, the only thing you can make appear right under the last detail in a group is the group footer section. Unless you can guarantee that an entire group will fit in a single column, you may not get a desireable result from using the group footer. The Page Footer section is guaranteed to appear at the bottom of every page (unless you do something to hide it), so maybe that would be better to use. Since the page footer section spans the entire width of the page, you will need one text box in the left side of the section and another on the right side. -- Marsh MVP [MS Access] Joseph Greenberg wrote: Do you know how, using this method, I can sequentially number the columns to appear as pages? That is, I have a 2 column report, and I want, at the top (or bottom) of each column to include a page number - so the second column (appearing on the first physical page) would appear as page 2? "Aria" wrote I was nervous about offering advice when I am inexperienced with Access. But I didn't want your question to remain unanswered if there was a possible solution. I am so glad the answer I received helped you as well. "Song Su" wrote: Your solution works great. Using group footer instead of report footer solve the problem. "Aria" wrote I have watched your post and waited to see if someone with a lot more experience than I would answer because I am a new user and don't want to steer you in the wrong direction. But since no one has replied thus far, maybe the answer I received for my report question will also help you. Like yours, my db is also for a school and includes a multicolumn report. The settings I had in my report we 1. Force New Page set to "None". 2. Report Keep Together (Sorting and Grouping) was set to "No". I received a reply from Marshall Barton, Access MVP, that resolved my problem. You may want to try it as well. Here is his reply: "Because the report footer spans the entire width of the report, it's not really appropriate for what you want. You probably need to use a group footer, which will be in a single column." "To do that, insert a new group level at the top of the sorting and grouping list using a constant expression (e.g. =1). Then put the grand total text box in this new group footer section. " When I asked a follow-up question about the meaning of "= 1" his reply stated: "If you look at the heading over the first column in the sorting and grouping window, you will see that it is '"Field/Expression". When you use an expression, it must start with an = sign. In this case, the expression is a trivial constant such as =1, but it could be anything that is not the name of a field. E.g. you could use: ="My Dummy Footer" to the same effect)." Just so you know the background, I was trying to create a calculated control at the end of one of the columns. What was happening is that the calculation was alone on a single page and I couldn't get it with the rest of the report. Like I previously stated, I'm a new user and this may not be what you're looking for. But it's been quite a while since you posted your question. You may want to try this while you wait for someone with more experience and maybe a different solution. "Song Su" wrote: I usually put a line at report footer to indicate the end of the report. In multiple column report, if the report ends at the first column, the line at report footer is ok. If the report ends at 2nd or 3rd column, the report footer with a line falls on its own last blank page. How to solve it? |
#8
|
|||
|
|||
report footer in multiple column report
See, but this is what I don't understand - when I use column printing, I
only have one column defined in my report - the column printing takes care of printing it on the right side of the page. If i use a group footer (and in my case it's all one group, it's a phone directory), there is only one per page/column. And if i use page footer, i only get the physical page number, not the column number. any other ideas? "Marshall Barton" wrote in message ... You can get the number of a column by using a text boxes with expressions Left column: =2 * Page Right column: =2 * Page - 1 However, the only thing you can make appear right under the last detail in a group is the group footer section. Unless you can guarantee that an entire group will fit in a single column, you may not get a desireable result from using the group footer. The Page Footer section is guaranteed to appear at the bottom of every page (unless you do something to hide it), so maybe that would be better to use. Since the page footer section spans the entire width of the page, you will need one text box in the left side of the section and another on the right side. -- Marsh MVP [MS Access] Joseph Greenberg wrote: Do you know how, using this method, I can sequentially number the columns to appear as pages? That is, I have a 2 column report, and I want, at the top (or bottom) of each column to include a page number - so the second column (appearing on the first physical page) would appear as page 2? "Aria" wrote I was nervous about offering advice when I am inexperienced with Access. But I didn't want your question to remain unanswered if there was a possible solution. I am so glad the answer I received helped you as well. "Song Su" wrote: Your solution works great. Using group footer instead of report footer solve the problem. "Aria" wrote I have watched your post and waited to see if someone with a lot more experience than I would answer because I am a new user and don't want to steer you in the wrong direction. But since no one has replied thus far, maybe the answer I received for my report question will also help you. Like yours, my db is also for a school and includes a multicolumn report. The settings I had in my report we 1. Force New Page set to "None". 2. Report Keep Together (Sorting and Grouping) was set to "No". I received a reply from Marshall Barton, Access MVP, that resolved my problem. You may want to try it as well. Here is his reply: "Because the report footer spans the entire width of the report, it's not really appropriate for what you want. You probably need to use a group footer, which will be in a single column." "To do that, insert a new group level at the top of the sorting and grouping list using a constant expression (e.g. =1). Then put the grand total text box in this new group footer section. " When I asked a follow-up question about the meaning of "= 1" his reply stated: "If you look at the heading over the first column in the sorting and grouping window, you will see that it is '"Field/Expression". When you use an expression, it must start with an = sign. In this case, the expression is a trivial constant such as =1, but it could be anything that is not the name of a field. E.g. you could use: ="My Dummy Footer" to the same effect)." Just so you know the background, I was trying to create a calculated control at the end of one of the columns. What was happening is that the calculation was alone on a single page and I couldn't get it with the rest of the report. Like I previously stated, I'm a new user and this may not be what you're looking for. But it's been quite a while since you posted your question. You may want to try this while you wait for someone with more experience and maybe a different solution. "Song Su" wrote: I usually put a line at report footer to indicate the end of the report. In multiple column report, if the report ends at the first column, the line at report footer is ok. If the report ends at 2nd or 3rd column, the report footer with a line falls on its own last blank page. How to solve it? |
#9
|
|||
|
|||
report footer in multiple column report
Joseph Greenberg wrote:
See, but this is what I don't understand - when I use column printing, I only have one column defined in my report - the column printing takes care of printing it on the right side of the page. If i use a group footer (and in my case it's all one group, it's a phone directory), there is only one per page/column. And if i use page footer, i only get the physical page number, not the column number. any other ideas? I'm getting confused by your use of the word "column". What is "column printing" when you say there is "one column defined in my report"? What about the page number is different from the "column number" when there is "one per page/column"? Did you try the expressions I posted? If you did, what was wrong with it? -- Marsh MVP [MS Access] |
#10
|
|||
|
|||
report footer in multiple column report
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? "Marshall Barton" wrote in message ... Joseph Greenberg wrote: See, but this is what I don't understand - when I use column printing, I only have one column defined in my report - the column printing takes care of printing it on the right side of the page. If i use a group footer (and in my case it's all one group, it's a phone directory), there is only one per page/column. And if i use page footer, i only get the physical page number, not the column number. any other ideas? I'm getting confused by your use of the word "column". What is "column printing" when you say there is "one column defined in my report"? What about the page number is different from the "column number" when there is "one per page/column"? Did you try the expressions I posted? If you did, what was wrong with it? -- Marsh MVP [MS Access] |
|
Thread Tools | |
Display Modes | |
|
|