Please help me out in applying this filter for Query in Report studio:-
case when ?Local\Import?='Local' then [PAID LOGIC SCHEMA].[DIM_SUPPLIER_FOR_DM_PAID].[Country]='IND'
else [PAID LOGIC SCHEMA].[DIM_SUPPLIER_FOR_DM_PAID].[Country]<>'IND'
end
Thank You
Hey it worked.... ::)
if (?Local\Import?='Local') then
( [PAID LOGIC SCHEMA].[DIM_SUPPLIER_FOR_DM_PAID].[Country]='IND')
else ( [PAID LOGIC SCHEMA].[DIM_SUPPLIER_FOR_DM_PAID].[Country]<>'IND')