search

fuel9 / DisplayMonkey

Display Monkey digital signage solution
Other
127 stars 51 forks source link

SSRS Questions #93

Closed JimPowersDFL closed 5 years ago

JimPowersDFL commented 5 years ago

Hello,

I'm new to DisplayMonkey so bear with me. I'm a SQL Server DBA that has been tasked with digital signage. Our primary use will be semi-live updated (every five minutes) reports around the buildings. Each monitor will display a different report for that area of the building. My observations from my initial setup are:

  1. It appears that the report displayed is an image created from running the report. Is that a correct assumption? If so, I assume the "cache expiration" on the report frame deletes the image?

  2. Assuming #1 is correct, I have set the duration of the report frame to 300 seconds (five minutes). Since the cache will expire at four minutes, when the frame hits five minutes, it will re-generate the report to create a new image for cache?

  3. It is my understanding that a canvas can be displayed on multiple displays. However, I need each display to show something different. If I understand correctly, I need to create a new canvas/panels/frames for each display?

psined1 commented 5 years ago

Hi, 1) and 2) all correct.

Re 3) you have a choice here. You can create canvas for your first display, add panels and frames. Then you can clone your canvas along with panels/frames, attach them to other displays and only fiddle with frames that will vary between the displays. Alternatively, you can have one canvas shared between multiple displays. Displays, as well as frames, can be location-specific. That way you can easily control which location gets what.

Hope this makes sense.

JimPowersDFL commented 5 years ago

Thank you, After playing with it for a few weeks now, I have learned quite a bit. I'm actually quite amazed at what it can do and with a proof of concept complete, I have the green light to move forward. Since I was only working with one display for proof of concept, I hadn't looked at cloning anything but I do see the "copy " function which will be tremendously useful. We'll only have a couple of different configurations so this will streamline setting each one up. All I'll have to do is create the new SSRS report for each location and change it. Very pleased with what I see!

psined1 commented 5 years ago

Great, I'm glad you are liking DM! Good luck and Happy New Year!