Value Prompt issue

[skmahaboobjohny@gmail.com]

Hi All

In My report have Product line,Product Dis,Quantity,Amount_Sold are the Data items. i am using Value prompt on Product line.
Ex : in My Value prompt Displayed the list of Product lines
   
i.e   PL1
       PL2
       PL3
Like this.I was added one more Static Choice is "ALL PRoducts"

i.e   PL1
       PL2
       PL3
       ALL PRoducts

when i select "ALL Products" in Value Prompt it's displaying Empty Page.How Can do This.I am using Filter Condition i.e ?ParmVAlue? in ALL Products. But it's not working..can u Suggest me...


Regards
Jani

[MFGF]

Hi,

Your filter would need to be coded like this:

([Product Line] in ?ParmValue?) or ('ALL Products' in ?ParmValue?)

As long as you spell ALL Products exactly the same (including case) in your filter and your static choice, this should work.

Regards,

MF.

[skmahaboobjohny@gmail.com]

Hello MM

I was trying this filter also

([Product Line] in ?ParmValue?) or ('ALL Products' in ?ParmValue?)

but it's not validate.Can u give Suggestions.....


Regards
Jani

[CognosPaul]

is this a cube or a relational data source?

[skmahaboobjohny@gmail.com]

Hi
that is relational data source




Regards
jani

[bvk.cognoise]

HI,

follow these steps

>create report with required columns(for eg:year,revenue)
>then go to prompt page create a value prompt on YEAR Data item
>then select that value prompt in prompt page
>under properties >select static choice
>add use value as 'ALL PRODUcdTS'
>then go report page  > click on filter symoble
>there edit filter  like this
?ParmValue?='ALL PRODUcdTS' or DATAITEM NAME= ?ParmValue?
eg:?ParmValue?='ALL PRODUcdTS' or YEAR= ?ParmValue?
>then run the report


thanks
bvk

[MFGF]

Hello MM

I was trying this filter also

([Product Line] in ?ParmValue?) or ('ALL Products' in ?ParmValue?)

but it's not validate.Can u give Suggestions.....


Regards
Jani

Ok... You're going to have to give us a clue then. What error does the validation return? Did you use the relevant Product Line item in the expression (from either your query or the package)?

MF.