Post reply

Auto change parameter?

  • June 15, 2017 at 8:20 pm

    #324100

    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

    #1947129

    hoangnguyennhh206 - Thursday, June 15, 2017 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.

    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