Forum Discussion
Query parameter not updating
I am currently using a parameter list in one of my reports. This parameter list is generated from a table I have in SQL Server. The issue I am having is that when I refresh my report this paramet...
Hi BenDenham,
Have you turn on the "include the report refresh" option? if you not, these data doesn't refresh when you use refresh button at report view.(they will refresh when you choose this query and use refresh preview button at query editor)
Regards,
Xiaoxin Sheng
I do have "include the report refresh" enabled. The list is successfully being updated when I press the refresh button, but the parameter that uses this list (I have set Suggested Values to Query) is not being updated.
Hi BenDenham,
Perhaps you can try to turn on the below feature to enable the parallel loading, then modify the query sort index to let the parameter list update before the custom function:
Regards,
Xiaoxin Sheng