COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Starfish2201 on 06 Dec 2012 06:59:49 PM

Title: Master-detail report
Post by: Starfish2201 on 06 Dec 2012 06:59:49 PM
Hi Cognos Experts,

I am pretty new to cognos and I need your help.

I have requirement in which the top section of the report is the Summary Report having EmployeeID. The rest of the report page has different sub-sections, like EmployeeAddress, EmployeePersonalInfo, EmployeeAllocation etc..

Now when I run the report I should only see the Summary Section and all other section (which are placed vertically one below the other) collapsed. If I click the Address bar, then the address section would open up showing the Employee Address Info. But the rest of the sections (like PersonalInfo and Allocation) remains collapsed/unopened. And it should open only when I click on the section header.

Is this possible using Master-Detail report in cognos? I have used master-detail report, where detailed data contained is droped INTO the master. But I am not sure if the detailed can be outside the master.

Any solution/pointers will be really helpful.

Thanks a lot in advance !!!
Title: Re: Master-detail report
Post by: norkos on 07 Dec 2012 02:14:55 AM
Hi,

I think you have to use javascript to accomplish this because Cognos doesn't have such feature, and it's not even related to master-detail relationships.

You can find a good article on Cognos on Steroids blog from a solution of a quite similar problem, so check this:
http://www.cognosonsteroids.com/2012/02/create-report-with-collapsible.html (http://www.cognosonsteroids.com/2012/02/create-report-with-collapsible.html)

NoRkoS
Title: Re: Master-detail report
Post by: venkatgowda on 07 Dec 2012 01:01:47 PM
Nice Article ......

Thank You...!!!!!!!!!!