Filter in report Net

[sg24]

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.

[ksr]

Hi,

what do you want to show when the condition goes to ELSE?

regards
KSR

[sg24]

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.

[Lynn]

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.

Code Select Expand


( [RISK_PARENT_NAME] <> 'No Activity' )
OR
( [RISK_PARENT_NAME] = 'No Activity' AND ( [RI_NAME] not null OR [CI_NAME] not null ) )