Need help to fix this problem...
I am using IWR 7. I create a type in prompt to ask for user's input and the prompt value will be used in the filter. eg. Customer_Name as the prompt. I set the default value as 'All'. If the user leaves the default value as it is ('All'), all customers will be retrieved. Otherwise only the customer name in the prompt value will be retrieved.
In the report, I created a calculated field as Cust_Prompt and its value is (If (?Customer_Name? <> 'All') Then (?Customer_Name?) else(' ')). In the filter, I put in (Customer_Name in (Cust_Prompt)). The result of this filter is: It only returns data when the user actually input something besides 'All' in the prompt but no data returns when the prompt value is 'All'.
Anyone has a get-around to fix it when the prompt value is 'All'.
Any help is highly appreciated.
Thanks & regards.
I am using IWR 7. I create a type in prompt to ask for user's input and the prompt value will be used in the filter. eg. Customer_Name as the prompt. I set the default value as 'All'. If the user leaves the default value as it is ('All'), all customers will be retrieved. Otherwise only the customer name in the prompt value will be retrieved.
In the report, I created a calculated field as Cust_Prompt and its value is (If (?Customer_Name? <> 'All') Then (?Customer_Name?) else(' ')). In the filter, I put in (Customer_Name in (Cust_Prompt)). The result of this filter is: It only returns data when the user actually input something besides 'All' in the prompt but no data returns when the prompt value is 'All'.
Anyone has a get-around to fix it when the prompt value is 'All'.
Any help is highly appreciated.
Thanks & regards.
![[bigcheeks]](/data/assets/smilies/bigcheeks.gif "[bigcheeks] [bigcheeks]")