Geek Answers Handbook

SSRS How to rotate reports in a slide show?

I was instructed to create a dashboard that will be displayed on TV monitors. This panel has 5 different diagrams that need to be displayed in a slide show - in other words, one diagram at a time, in turn for a time interval.

I used the solution posted here with visibility property =IIf(Second(Now()) >= 48 AND Second(Now()) <= 60, False, True), etc. with automatic update of the report with an interval of 12 seconds.

However, my manager came back to me with feedback that there was too little interval for 12 seconds and that he would like to see each report 20 seconds before he was turned to the next.

Does anyone have any ideas on how to make this possible?

Many thanks.

+4
source share
1 answer

You want to go from a 60 second cycle to a 100 second cycle.

Based on your existing code, you can use something like:

=IIf(DateDiff(DateInterval.Second, Today(), Now()) Mod 100 >= 80
    AND DateDiff(DateInterval.Second, Today(), Now()) Mod 100 <= 99
  , False
  , True)

You get a 100-second cycle by taking the number of seconds since the beginning of the day of the Modulo 100. Then you can break it into buckets of twenty in your expression, and not into buckets of 12.

+2
source

More articles:


All Articles