Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Chandrasekar on 15 Nov 2014 06:31:15 AM

Title: Create drill through in same page
Post by: Chandrasekar on 15 Nov 2014 06:31:15 AM
Hi Gurus,

I have 2 lists in same report page. One is Master list. Another list is detailed list placed in block. This block rendered by ParamDisplayValue(p_Productline) is null.

I will create a drill through based on product line. Drill through details,

  Report - Same report selected.
  Action  - run the report.
  Parameters :- Name - p_Productline, Type - String, Required - Nothing selected (Optional), Multiselect - Yes, Method - Pass parameter value, Value -  p_Productline (Same parameter), Property to pass - Default.
  Display prompt pages - based on the default prompt settings.....

When i run the report master list displayed. But when i drill through the product line it not shows the detail list. It only shows the master list.

Please any one help me to choose right way.

Thanks & Regards,
Chandrasekar.P

Title: Re: Create drill through in same page
Post by: CognosPaul on 16 Nov 2014 08:42:29 AM
By passing the parameter value you are passing nothing. Change that to data item value and try again.
Title: Re: Create drill through in same page
Post by: Chandrasekar on 17 Nov 2014 12:25:01 AM
Hi CognosPaul,

Thanks for your response. I passed parameter value, that name is p_Productline. I think, have a mistake in Boolean variable. My boolean expression is ParamDisplayValue(p_Productline) is null. When product line is selected detailed list not displayed.

Now i changed the expression ParamDisplayValue(p_Productline) is not null. Now it works. But this have one restriction. When it work means, Product line is (optional) nothing selected.

Can you tell any other to achieve this?

Thanks & Regards,
Chandrasekar.P
Title: Re: Create drill through in same page
Post by: mitali on 19 Nov 2014 05:55:57 AM
make your parameter p_Productline required.
Title: Re: Create drill through in same page
Post by: Chandrasekar on 19 Nov 2014 06:07:44 AM
Hi mitali,

Now i change prompt is required and make some changes in prompt. Add static choice is 0. 0 is default selection.
Variable Expression is ParamDisplayValue('p_productline') contains '0' is missing.

If run the report Master list executed, After drill through its not rendered detailed list. Where i am mistake. Please clear to me.

Thanks & Regards,
Chandrasekar.
Title: Re: Create drill through in same page
Post by: mitali on 19 Nov 2014 11:01:29 PM
have you passed parameter through which you are drilling through or it would be better if you can send screenshots.
Title: Re: Create drill through in same page
Post by: mitali on 19 Nov 2014 11:21:44 PM
you can use different report pages in same report and pass the condition if your parameter is equal to same data item of target report then display list1(inside the conditional block)else 0.
Title: Re: Create drill through in same page
Post by: CognosPaul on 23 Nov 2014 07:00:15 AM
You are building a drillthrough based on a list. The drillthrough definition needs to be set to data item value if you want to pass the value from the list.
Title: Re: Create drill through in same page
Post by: Chandrasekar on 24 Nov 2014 11:12:06 PM
Hi mitali & CognosPaul,

Sorry for delay response. Due to some reasons i am not able to open this issue.

Now I am change passing value is data item. But i have some issues. If list1  drill through condition is passed 2 data item like (Product line, Year) it rendered list3 & list4. If list1  drill through condition is passed 1 data item(Product line) it not rendered.
Likewise list2 as same issue.

For your reference attached my XML report. Please clear to me.

Thanks & Regards,
Chandrasekar.
Text only | Text with Images