Create drill through in same page

[Chandrasekar]

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

[CognosPaul]

By passing the parameter value you are passing nothing. Change that to data item value and try again.

[Chandrasekar]

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

[mitali]

make your parameter p_Productline required.

[Chandrasekar]

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.

[mitali]

have you passed parameter through which you are drilling through or it would be better if you can send screenshots.

[mitali]

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.

[CognosPaul]

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.

[Chandrasekar]

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.