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 17 Nov 2014 02:06:03 AM

Title: How can select list name using query expression
Post by: Chandrasekar on 17 Nov 2014 02:06:03 AM
Hi everyone,

Possible to select report list name? If possible how to do that?

My list name is 'List1'. I want to give a condition based on list name. Is it possible?

Thanks & Regards,
Chandrasekar.P
Title: Re: How can select list name using query expression
Post by: mitali on 19 Nov 2014 05:57:32 AM
when you have only one list,then why are you using condition on list name.
Title: Re: How can select list name using query expression
Post by: Chandrasekar on 19 Nov 2014 06:11:35 AM
Hi mitali,

I have 4 lists like List1, List2,List3, List4. Can you tell the expression.

Thanks & Regards,
Chandrasekar.
Title: Re: How can select list name using query expression
Post by: mitali on 19 Nov 2014 06:48:02 AM
create value prompt DisplayOption,add static choices list1,list 2,list3,list4

Use conditional block and create four string variable named list1,list 2,list,list 4.
Drag different list in different string variable using conditional block "current block" property.
In the expression of string variable type ParamDisplayValue('DisplayOption')='list1'


For any further help do contact.
Title: Re: How can select list name using query expression
Post by: Chandrasekar on 19 Nov 2014 07:29:02 AM
Hi Mitali,

This issue based on previous issue post(Drill through same report). I want to drill through the same report. I have 4 lists in a report. First two lists run based on prompt selections. 3rd list rendered when 1st list is drill through, 4th list rendered when 2nd list is drill through.

I am not able to do this. So i just ask possible to give the condition based on list names in variable expression. If you have any ideas regards/alter ideas please proceed.

Thanks & Regards,
Chandrasekar.

Title: Re: How can select list name using query expression
Post by: CognosAnalytics on 25 Nov 2014 07:16:13 PM
Hello Chandrasekar,
I had a similar requirement and this is how I would tackle it:
1) Create a hidden text box prompt anywhere on the page(Either set visible property to No or box type none to yes), assign a static choice of 1, and parameter name of "HOLDER" for example.
2) Next, create another text box prompt with name "LIST3RENDER" and assign a static choice of 0. Hide the text box prompt.
3) Create another text box prompt with name "LIST4RENDER" and assign a static choice of 0. Hide the text box prompt.
4)Create a render boolean variable for LIST3, with expression ParamValue("LIST3RENDER")=1. Apply the render variable to List3.
5)Create a render boolean variable for LIST4, with expression ParamValue("LIST4RENDER")=1. Apply the render variable to List4.
6)Open Drill through definition on List1 and Pass the parameter value of "HOLDER" to "LIST3REDNER". This will make LIST3RENDER as 1 and hence will render LIST3 as per the render variable.
7)Open Drill through definition on List2 and Pass the parameter value of "HOLDER" to "LIST4REDNER".This will make LIST4RENDER as 1 and hence will render LIST4 as per the render variable.

Let me know if it worked for you.

-Cognos810
Title: Re: How can select list name using query expression
Post by: Chandrasekar on 26 Nov 2014 01:34:02 AM
Hi Cognos810,

Thanks for your reply. I try to solve, but i have some issues. I think the issue is not in your ideas, its in my drill through condition.

List1 and List2 have different queries. List1 filtered by product line. List2 filtered by year. If i drill through list1 it filter both product line and year. Likewise list2.

I am attached my report xml. Please check it.

Thanks & Regards,
Chandrasekar.
Title: Re: How can select list name using query expression
Post by: CognosAnalytics on 26 Nov 2014 12:27:47 PM
Hello Chandrasekar,
Looked at your report spec. The drill through definitions needed some adjustments. Please look at the new definitions in the attached report spec.

-Cognos810
Title: Re: How can select list name using query expression
Post by: Chandrasekar on 26 Nov 2014 11:00:48 PM
Hi Cognos810,

Thanks for your effort. It works fine dude.

But it works only first time drill through any one of the list. If i drill through list1 it works, Continously now i drill through the list2 it will not work.

Any ideas?

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