Announcements
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 ?
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156