If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to display table in one page instead of multiple pages.

Started by crn.siva, 28 Apr 2009 02:48:57 AM

Previous topic - Next topic

crn.siva

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.


vij

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

:)

crn.siva

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.

crn.siva

Hi All,


Please give me any solution for above problem?

Thanks in Advance. :)

CognosPaul

Use a simple Boolean variable.

PageNumber() = 1

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

crn.siva

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,

CognosPaul

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.

NaviGator

changing "Rows Per Page" property works fine with me ..
Never Stop Learning ..

CognosPaul

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.

crn.siva


Thanks PaulM for your replays

Yes PaulM,  exactly is showing like that,

Any Solution PalM let me know, its very urgent.

Thanks,

CognosPaul

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.

david.stachon

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)