Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

sandippk

Programmer
Jan 1, 2016
1
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top