Welcome to the new CogKnowHow.com!


If you have trouble logging in, reset your password via the login window
by clicking the 'Forgot Password' link.

FM create detail filter with parameter which will be provided in Report Studio


#1

Dear All,

I am trying to create below detail filter on query subject in Framework manager:

[BUSINESS VIEW].[T_Status].[DISPLAY_DATE] in_range ?Date_Range?. I have marked the usage of this filter as ALWAYS.

The Date_Range is the parameter whose value will be provided while running the report i.e. through date range prompt. Please note Date_Range variable is assigned to data range prompt created on prompt page using report studio.

When I am trying to validate this Query subject with the filter, it gives an error :

XQE-QRY-0404 There are parameters or variables that require values. Also query subject is marked as broken.

  1. Any idea why I am getting this error
  2. Is it possible to create a filter with parameter in FM whose value will be provided during Report execution ?

Happy New Year.

Thanks
SK