FIlter error in FM mngr

[krishdw85]

Hi Team,
I created below filter in report studio an it is working fine.... so i tried below calculation to apply in FM rather than in RS since i have to use it in many queries. In FM i tried with #prompt but i see some error in FM with dotted red color.... Can some one check & suggest me. Thanks in adv. Please see attachment for more.

Report Studio:

(([Presentation Layer].[MI_CIAO_MASTER_FACT].[CASE_CREAT_DT] >= TO_DATE(?Start Date (MM/DD/YYYY)?, 'MM/DD/YYYY') AND
               TRUNC([Presentation Layer].[MI_CIAO_MASTER_FACT].[CASE_CREAT_DT]) <= TO_DATE(?End Date (MM/DD/YYYY)?, 'MM/DD/YYYY')) OR
               (Decode(Trim([Presentation Layer].[MI_INTRN_STATUS].[INTRN_STA_CDE]),'PWS_110002','Rejected','PWS_110001','Withdrawn','PWS_110003',
          'Cancelled',[Presentation Layer].[MI_INTRN_STATUS].[INTRN_STA_GRP])= 'Active' OR
               ([Presentation Layer].[MI_CIAO_MASTER_FACT].[CUR_STEP_ACTL_START_DT]>=
               TO_DATE(?Start Date (MM/DD/YYYY)?, 'MM/DD/YYYY') AND
               TRUNC([Presentation Layer].[MI_CIAO_MASTER_FACT].[CUR_STEP_ACTL_START_DT]) <=
               TO_DATE(?End Date (MM/DD/YYYY)?, 'MM/DD/YYYY'))))
       

FM Filter Calculation: (Error one)

(
(  [Presentation Layer].[MI_CIAO_MASTER_FACT].[CASE_CREAT_DT]  >= #prompt('&Start_Date','MM/DD/YYYY','String') #
AND
(TRUNC ([Presentation Layer].[MI_CIAO_MASTER_FACT].[CASE_CREAT_DT]) <= #prompt('&End_Date','MM/DD/YYYY','String'  ) # )
OR
([Presentation Layer].[MI_INTRN_STATUS].[New_Intrn_Sta_Grp]  = 'Active' OR
   
([Presentation Layer].[MI_CIAO_MASTER_FACT].[CUR_STEP_ACTL_START_DT] >= #prompt('&Start_Date', 'MM/DD/YYYY','String') #
AND
TRUNC([Presentation Layer].[MI_CIAO_MASTER_FACT].[CUR_STEP_ACTL_START_DT])  <=  #prompt('&End_Date', 'MM/DD/YYYY','String') #)))

[bus_pass_man]

Is there anything displaying in the tips?

Try each element of your filter expression in isolation and see what happens. Build up the expression bit by bit.   

There might be a problem in that you're passing strings from those prompts and the expression editor is expecting that they get indicated by the single quotes.   You might need to incorporate the sq macro function into those prompts.

[krishdw85]

Thanks to the group... i fixed like this way.....

([Presentation Layer].[MI_CIAO_MASTER_FACT].[CASE_CREAT_DT] >= TO_DATE ( #prompt('Start Date (MM/DD/YYYY)','String') # ,'MM/DD/YYYY')
AND
trunc([Presentation Layer].[MI_CIAO_MASTER_FACT].[CASE_CREAT_DT])   <= TO_DATE ( #prompt('End Date (MM/DD/YYYY)','String') #,'MM/DD/YYYY')
OR
([Presentation Layer].[MI_INTRN_STATUS].[New_Intrn_Sta_Grp]  = 'Active' OR
([Presentation Layer].[MI_CIAO_MASTER_FACT].[CUR_STEP_ACTL_START_DT] >= TO_DATE ( #prompt('Start Date (MM/DD/YYYY)','String') # ,'MM/DD/YYYY')
AND
trunc([Presentation Layer].[MI_CIAO_MASTER_FACT].[CUR_STEP_ACTL_START_DT])   <= TO_DATE ( #prompt('End Date (MM/DD/YYYY)','String') #,'MM/DD/YYYY'))))