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

multiple lists on a single PDF Page

Started by mrcool, 29 Jun 2011 07:17:27 AM

Previous topic - Next topic

mrcool

Hi All,

I have a report with 8 list reports and the default run option is PDF. This report is basically a letter which has address on the top and the 8 lists below it which will be delivered through post to different branches in a company.
I have a repeater for the address which caters branch address per page and all the 8 lists have master detail relationship with repeater table.
Aim of doing above step is to get details of each branch on different page along with address.
Any suggestions to accommodate all the lists on a single PDF page?
I have tried all possible options like
*putting all the lists in separate list header
*Setting 'Keep with Header' in pagination property to 1.
but no luck..
Any help would be highly appreciated..

Thanks,
Mrcool..

mrcool

Guru's waiting for your reply... ::)

mrcool

Hi All,

Finally by reducing the size of font and removing some unecessary blocks I am able to fit all reports on a single page.
Now the challenge is, because of page set I have used to page break on branch performance is very poor.. When I observed in back end cognos is sending same queries again and again depends on the number of branches. for ex if the user selects 10 brands on prompt page 10*8 queries are passing to DB? I have tried with master detail even that is working the same way..
Is there anyway to restrict the queries? I tried using 'Local cache','Share resultset' options but didn't work...

cheers

mrcool


tehfixxx

Greetings MrCool,

What I'm about to suggest is not a direct solution to your problem, but I do know that it will work. I would recommend you combining all your queries into one if you currently have multiples. Then instead of having multiple lists container, you would only need one. Once it's in the same list container, it's easier to control row breaks between pages. Regarding your performance issues, it's resending the same queries again multiple times is because you've multiple lists containers. Unless I've additional information, I won't be able to help you further.