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?
Depending on the data you could do a page break on the employee. That way the header and detail information are bound together.
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.
Thanks shailendra32, it appears that your first suggestion works. after figiting with the list options, I managed to get it to work properly.