Hi,
I need to apply a filter to disable the rows in the output based on some condition.
I have written the code in the filter as shown below.
CASE [RISK_PARENT_NAME]
WHEN ([RISK_PARENT_NAME]='No Activity' and RI_NAME is not null and CI_NAME is not null)
THEN [RISK_PARENT_NAME]
ELSE
[RISK_PARENT_NAME]
END
Like i want to display the row when the process is "No_Activity" and RI_NAME is nt null and CI_NAME is nt null along with other records .
I m nt able to use this code in the filter. Hence i took a bew data item and wrote the code and then assigned the data item in the filter. Neither is working. Please help me with this regard.
IS there any different thing in report net? i am new to this. Kindly help.
Thank u.
Hi,
what do you want to show when the condition goes to ELSE?
regards
KSR
In the ELSE part i want to display the records along with the condition that i have given...
for eg,
The RISK_PARENT_NAME column contains data like,
No Activity,
order details,
customer euipment etc...
So when i run a report by selecting few parameters, i get the output as
RISK_PARENT_NAME A RI_NAME CI_NAME
No Activity
Customer euipement hjkkl kkkk llllll
etc ...
I want to eliminate only this first row .
Please let me know if i am nt clear.
Filters should contain comparisons that evaluate to a boolean result. The only records included would be those that evaluate to true for the condition.
If I understood your logic, then you want all records that are for something other than 'No Activity'. Records for 'No Activity' should only appear if either of the name fields have content. Something like below might be what you're after.
( [RISK_PARENT_NAME] <> 'No Activity' )
OR
( [RISK_PARENT_NAME] = 'No Activity' AND ( [RI_NAME] not null OR [CI_NAME] not null ) )