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
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.
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
is this a cube or a relational data source?
Hi
that is relational data source
Regards
jani
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
Quote from: jani on 12 Jul 2011 11:54:26 PM
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.