Share
ReportI am creating a report object that uses an existing query object. I like to add RequestFilterFields from some of the fields available in the query.
Is there any way?
Categories:
You’re offline. This is a read only version of the page.
I am creating a report object that uses an existing query object. I like to add RequestFilterFields from some of the fields available in the query.
Is there any way?
Hi, The RequestFilterFields property can only be applied to Data Items.
If you insert the Query fields as a variable into the Column, it cannot be done.
In this case, you can create a temporary table first, use this temporary table as DataItem, and insert the value of Query into this temporary table when Report runs. I think this will not be much less perfomance.
Hope this helps.
Thanks
ZHU
may be try to add variable as filter on request page if columns are not available in report data item and pass value a filter to query.
Regards,
Alok Kulshreshtha
Maybe you can share some code, so we can see how you have organized your report ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,564
Super User 2024 Season 2
#2
Martin Dráb
228,651
Most Valuable Professional
#3
nmaenpaa
101,148
All responses (
Answers (