how to prevent the white space occupied by the hidden footer
Hi, I have a report which is of 3 pages. i have a footer which should be visible for the first page only and should not be visible for the remaining pages. I have used the visibily tab and made it visible only on the first page, but when i am printing the report ithe footer is occupying the white space for the remaining pages also. What should i do so that the footer does not occupy this white space for the other 2 pages?? Please let me know.
October 6th, 2010 10:06pm

when you made this visibility expression did you just select each cell in that row or did you do it on the overall row property?
Free Windows Admin Tool Kit Click here and download it now
October 6th, 2010 10:16pm

I have some text box's inside one rectangle and to this rectangle visibility properties i used the expressions..
October 6th, 2010 11:06pm

ok sorry i misread your post, the footer area cannot be disabled by placing an invisible rectangle in it. One work around is creating a somewhat hardcoded "1st page" in the report body. If the first page has a table or list, filter it out that it only shows the rows that can fit on the first page, then include a fake footer area and force a page break after this. Then finally insert a table that filters out the rows that were added on the first page. Pretty hackish but I believe something like this is the only way to accomplish what you're trying to do.
Free Windows Admin Tool Kit Click here and download it now
October 7th, 2010 2:25am

hi, its a statement that i am woring on and i have a table which might have 3 or 4 rows of data, and the footer part i am talking about has to be in the lowest area of the first page, because the paper would be a perforated one and if i use the footer part in the body because of this table, depending on the rows it might go up or even come down and go to next page. so i am confused now. and at the same time can you please let me know how can you filter out the table with only these many rows as you have said???
October 8th, 2010 5:44pm

you are correct, if there are fewer anticipated rows then your fake footer section will come up some but you can prevent it from being pushed to the next page by setting the control positions and page margins to prepare for the most rows that can fit on the first page. To filter out a certain number of rows go to the filter section in the table properties and use the "Top N" or "Bottom N" functions, depending on the order your data is sorted.
Free Windows Admin Tool Kit Click here and download it now
October 8th, 2010 8:13pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics