I have a formatting issue regarding Repeating Column Headers after page break. I tried quite a few ways suggested by people in the listserve. Still, I am not getting it.
This report has a few breaks, and totals are calculated at the bottom (which are part of the table). I added some lines above the column headers as the “Section Header”, but really they are not master detail. I applied “Start a New Page” for the objects I did breaks. The report does start a new page, but the column heading seems not appearing on the following page when data goes over to the next page. I used “Format Table–>Page Break Header after Page Break”, it works for some. However, I have the totals at the bottom of each break, they are actually part of the table, the header would appear on the top of the “Total” part.
I wonder what I can do to achieve this. Also, I got a few blank pages. I guess it is because of the “Start a New Page”.
Any help and suggestion will be greatly appreciated.
I have only a general tip to help you:
You really have to differentiate between your page break settings for your Breaks, and those of your Table. It may be most helpful if you do not use any Headers for your Breaks, and use only the Table Headers.
But I do need the headers to function as “Section Headers”, and the Table Headers are the ones I need to repeat when the data for each “Section” goes to the next page. Any other ideas? Thanks a lot.
I am sorry to confuse you. I am confused too. Let me give you an example. I have different levels: Lender, Province, Mortgage Center and Month. These are the ones that appear on the top of the table, user wants “Start a New Page” for each Lender, each Province, each mortgage Center and each Month. I did breaks for these four objects, I didn’t use master detail. Under the headers, the table contain detailed info. When the data for each Month is not finished on one page, when the talbe goes to the following page, I am unable to get the column headings to be repeated on the next page.
I used Break Header on , but not using “Format Table --> Show Header”. I hope this makes my question more clear.
You have 4 breaks. For each break, in the Break and Pages section, select ‘Start a New Page’ and ‘Repeat Break Value on New Page’. Also for each break, in the Break Definition section, unselect ‘Break Header’. Now select the Table, Format Table, on the General tab, select ‘Show Header’ and on the Page Layout tab, select 'Repeat header on every page.
HTH
I followed what you suggested, most of the pages turned out to be good. However, in some pages, the column headings are not there when there are totals above them. At the footer of each break, I have totals. I wonder where the column heading could be. I checked “Repeat Break Values on New Page” for the first column. I don’t know what I am missing.
I have had this happen after having tried multiple formatting changes on a document. I usually resort to removing my rows with totals and re-applying them after my breaks are set. There is a selection on the format Break window in the Definition part called ‘Break Footer’. You may have to select/de-select this, starting with your lowest level break to find out which break has the problem. Also you can try ‘Avoid Page Break’.
I am gonna try that now, but I have one concern. Since the rows with totals occupy quite a few rows for each break, when one page is not enough, the rows with totals will go to next page. Do you think that will affect the result of the formatting?
This is how I do it: Format all breaks without the subtotal and total rows. I sum one column which will insert the row for totals. Then on that same row, I insert the other total variables in the cell for their appropriate column. (I prefer using variables rather than the formula that is the result of the sum, count, etc. function buttons.) If you prefer using the function buttons to get totals, you can cut and paste the formula result from its additional row to the footer row you want your totals on, then delete the extra row.
I also view the cell delimiters to delete empty spacing rows that just take up space and I auto adjust row height to the font size. I do leave one empty row between the last detail data row and the total row for clarifying the total line. Let me know if this doesn’t make sense to you.
BTW - after defining my total row variables, I usually delete the extra formulas in the variables window - I’m a little nutty about dangling calculations that are not actually used in my docs.
Hope this helps.
I did more or less the way you described. I did insert some cells above the column heading as the “Section Headers” for Lender, Provnce, Month, and Mortgage Center. Do you think it will work properly?
For some pages, I get the rows with totals on the top, then a new “Section” with all these headers, but the users want each Lender, Province, Month or Mortgage Center should be on a new page.
By the way, what do you refer to when you say “Cell Delimiters”? I don’t use Master Detail, because the space between one section and the next one is too big, also, when doing the calculation at the footer of the table, some will repeat for each section.
Cell delimiters show the outline of each cell in each column and row of your table. From the Toolbar, select View, Cell Delimiters (and/or Section Delimiters, Page Margins and Grid). I turn them all one when formatting a complex report. You may discover cells or rows you did not realize were there and appear as ‘space’. You can also see all the report elements by viewing in Structure mode, which makes for quicker changes.
You can adjust the space between the Master cell and the table if you would rather use the Master/Detail. To do this, select Table, Format Table, Appearance Tab, adjust the Vertical Position Relative To the Upper Section (master section). You can delete the unwanted rows.
You should not need to insert the extra row for column headings, they should automatically appear when you Format Table, Show Header, Repeat Header on every page and Avoid Page Break in Block (this should correct the total lines from crossing pages). You can type over the text in the Table Header cells if they are not the columns headings you prefer.
What version are you using? I am on 5.0.2. If these tips still do not get you to the desired result, I would be happy to look at the document formatting. My e-mail is available on BOB profile.
I am on 5.1.5. I did the formatting and calculation at the footer of the table in View->Structure mode. I know the headers for the breaks are there, but there are so many empty cells. Users want them to be above the table, I inserted cells above the column headings, and make them look like a section. That’s why sometimes when the calculation at the footer of the table has couple of rows one the top, the new will appear on the same page. If you’d take a look at the formatting I am doing, that will be great.
(BOB member since 2002-06-21)
(BOB member since 2002-06-21)