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

Page breaks based on emp id

Started by smtest, 01 May 2008 04:19:21 PM

Previous topic - Next topic

smtest

hi,
I have two - three different queries. They all have emp id in it. I have a prompt that filters all the three queries with the same emp_id. I want to break the page based on emp_id. As user can select multiple emp_ids. I know the way to do it using page break. But it only works, if i have one query but with multiple queries. It does not work

please advice

rockytopmark

Create a Page Set, and group it on EmpID.  This is done from the Page Explorer --> Report Pages.

Whenever the EmpID changes, you'll get a new page.

If you have multiple query-based objects (Lists, XTabs, Charts) these may have to have Master Detail relationships set to the Page Set query, EmpID = EmpID.

smtest

thanks for the reply!
i tried master detail relationship, but when ever i try that, i get only one empl id and doesnt get any others? dont know what i am doing wrong.
the way i do is ;
select the list (query), click on the master detail relationship and create a join to another query based on emp_id.
please advice

thanks

smtest

it worked.
thank you very much