June 15, 2017 at 8:20 pm
Hi all, I have a question that:
In my report, the parameter has about 15 values. And I want to set after 5 minutes, the parameter auto change to the next value and the report auto refresh after the parameter changed. One more thing is if the parameter run out 15 values, it will begin again to value 1. Is there possible to make it?
Thanks.
June 16, 2017 at 10:32 am
hoangnguyennhh206 - Thursday, June 15, 2017 8:20 PMHi all, I have a question that:
In my report, the parameter has about 15 values. And I want to set after 5 minutes, the parameter auto change to the next value and the report auto refresh after the parameter changed. One more thing is if the parameter run out 15 values, it will begin again to value 1. Is there possible to make it?
Thanks.
Take a look at a data driven subscription; it seems like you could do something with this. Maybe put your 15 parameter values in a table, and every 4 minutes rerun the query so if the minute in an hour is 0-3, use the first parm, 4-7 used the second parm, ect. Just an idea.
Good luck,
Rob
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply