How to avoid these cells shouldn’t appear on “First page”?

[vani65]

Hi All,
I have a master /detailed report (102 pages) with 4 sections A, B, C, and D respectively. A, B and C-sections comes as first page and 4th (D) section comes in second page.
In the Section D contains single block/Table and 3 cells – according to our requirement I made a break on all columns on this block, so that these details should appear on individual page. This is perfectly working.
Only problem with these cells, they also should appear as heading – on each page except First Page, so I ticked the option “Repeat on Every page “ from cell Format. Because of activating this option these cell are appearing all pages including first page.
Now my question-- how to avoid these cells shouldn’t appear on “First page”? May be page break will do the trick – if so how to apply a page break on these cell, So that they can appear on other pages not on first page.

 

[skrandel]

You need to remove the break header using Format Break. Then you need to add it back doing Format Block.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[naga5566]

You can either do this way.
Go to appereance Tab in cell format and select hide cell option and place =Page()=(1) in the formulae box.
I think this should work

 

[vani65]

Hi Steve / Naga5566,
Probably, I mayn’t explain my problem clearly. Ok, I would try to explain it again:
Basically my report consists of 4 section as I mention earlier.
Total report sorted on “manager name” followed by “contract no”, So there will be a “master page” for individual manager followed by his contract details (details page). We have total 15 managers ( Tom, Dic and Harry).
Tom has 10 contact
Dick has 20 contracts
Harry has 15 contracts
Each manager has different contacts. Because the report is sorted on Manager name, it shows as follow:

Master page for Dick (so called “first page” for Dick)
All details :
X} --> A block
Y} --> B block--> all three blocks in Different Section in one page
Z} --> C block
20 Detailed pages for Dick contracts:
Contract 1 -->individual page } ->block D }
Contract 2 -->individual page } -->block D } – in one Section
Contract 3 -à individual page } ->block D }

Like 21 pages for Dick followed by 16 pages for Harry and 11 for Tom, total 48 pages.

Currently my report meeting all requirements and working fine, means it is showing individual manager details as master pages followed by his contracts in individual pages.
Now I inserted a 3 individual cell in block D to make them as Block TTTLE (please note they are not block headers) Ex:

Title 1 --> Cell
Title 2 --> Cell
Title 3 --> Cell

Detailed pages for Dick contracts:
Contract 1 -->individual page } --> block D
Contract 2 -->individual page } --> block D
Contract 3 -->individual page } --> block D


Title 1 --> Cell
Title 2 --> Cell
Title 3 --> Cell

Detailed pages for Harry contracts:
Contract 1 -->individual page } --> block D
Contract 2 -->individual page } --> block D
Contract 3 -->individual page } --> block D


Up to this stage every thing seems to be fine, but when I go to print preview of the report, I got these Titles (cells) as block Titles (that is OK), but they are also coming at the bottom of each master pages of managers which are totally in the different blocks and different sections. When I go to “page layout”, each cell appearing twice (6 titles) on second page of the report.
When I try to hide the cells with page()=2 in cell format it is hiding only one pair, second pair still exist.

I tried all possibilities but failed, could not resolve the issue, hence I approached you guys.

 

[vani65]

Hi All,
Any help in this regard will be very highly appreciated