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

Master Detail relationships

Started by jmills, 09 Jul 2012 03:38:07 PM

Previous topic - Next topic

jmills

I'm trying to create a master detail relationship with 2 list reports.  one list report shows the monthly details by employee, while the 2nd shows YTD totals, and rather than place them in one wide list report, i'd like to stack them.

I've tried creating a Master Detail relationship, however am not getting the expected results.  I have two lists where list 1 shows the detail of the current period by employee, and then list 2 by employee.  Ideally, i'd like to show Employee 1 detail AND YTD info together.

Does anyone have any suggestions in how to build this?

LOUM

Depending on the data you could do a page break on the employee. That way the header and detail information are bound together.

shailendra32

First of all you can't make stack of two list report.there are only two ways to create master detail relationshipa as below :

1)Use a parent frame for the master query and a nested frame for the detail query.

2) Associate a report page with the master query and use a data container, such as a list or crosstab, for the detail query

Here is the detail link on this.
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cr_rptstd.8.4.0.doc/ug_cr_rptstd_id12005cr_rptstd_modrep_create_master_deta.html

I would suggest the first method . Take YTD Total and Employee Name in 1 list (which would contain second list in it) and then take second list in it and put other columns like month total and other details in it.

Please let me know if you still not get your job done.

jmills

Thanks shailendra32, it appears that your first suggestion works.  after figiting with the list options, I managed to get it to work properly.