How can select list name using query expression

[Chandrasekar]

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

[mitali]

when you have only one list,then why are you using condition on list name.

[Chandrasekar]

Hi mitali,

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

Thanks & Regards,
Chandrasekar.

[mitali]

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.

[Chandrasekar]

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.

[cognos810]

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

[Chandrasekar]

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.

[cognos810]

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

[Chandrasekar]

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.