COGNOiSe.com - The IBM Cognos Community

Hi All,

In my Report Page body one table and below one list is there, if i run the report, it gives 3 pages result,

i want to display table in first page only, but it is displayed in all the pages, please i want solution for this.

And i used "case stmt ( case when pagenumber() =1 then 'yes' else 'no')" and i placed that table into conditional block and i assigned that variable to that block, it'll not work properly.

And also i used properties of the table, there is a pagination property. uncheck repeat on every page.

please give me soultion for this.

HI kss001 ,

what all the contents there in Table?

e.g. If you have list  in your table then select the "List" and go to the Properties pane and select "Rows Per Page" and set the data record that you want on the first page like you can set as 1000000.
so you will get all the records in that perticular list on a single page only.


hope it will help you
 

regards,
vij

:)

Hi Vij,

Thanks for your replay,

My client requirement is it will show in pdf format, so it is coming 3 pages.

is there any way to solve this solution.

thanks in advance.

Hi All,


Please give me any solution for above problem?

Thanks in Advance. :)

Use a simple Boolean variable.

PageNumber() = 1

Attach that variable to the conditional block and put the table in the Yes block.

Hi PaulM,

Thanks for your replay,  I tried this way also,  it is also not working,  If I use this way total table was disabled.

if you have any other solution please let me know asap.

Thanks,

Okay, I've done some experimentation. Pagenumber variables work in HTML, but not in PDF. In fact, for some reason Cognos is treating every page in a pdf as pagenumber 9999999.

There is a very ugly work around, but it will only show the table on the first page.

Drag a new list in right under the table. Click on the List Column Title and delete the class. Unlock the report, and drag the table into the List Column Title box.

changing "Rows Per Page" property works fine with me ..

Can you be more specific?

From what I understand, the issue is as follows

The structure of the report is as follows:

Table with data.

List spanning several pages.

The top table should only appear on the first page, even though the list spans n pages. The normal behavior is the table repeats for every page the list spans.

Thanks PaulM for your replays

Yes PaulM,  exactly is showing like that,

Any Solution PalM let me know, its very urgent.

Thanks,

What happens with the ugly work around I suggested?  By putting the table into the header of a dummy list, it will only appear on the first page.

I think you're on the right track Paul.

I tested this as well....

Another option is to add an "Overall Header" row to this list, and place the table in there. (depending on how the list is, this is a pretty easy option)