Auto slide report

[orbair]

Hi All,

My client wants a report with 3 lists, put on the screen and slide those lists. I was thinking to create 3 page and page down somehow automatic, or create an active report with iterator (lists are in deck), but I cannot find any automation for the iterator. I don't know js, and I cannot find anything on the internet. If could help me, really appreciate it.

Thank you

[bdbits]

So by autoslide, you mean you want a slideshow of three reports that continuously loops through them? Where will the report be viewed?

I guess if it was me, I might use one of these.

• If it is on a web page, you can loop through the reports with a little javascript and timer loop
• You could use PowerPoint and the Cognos office integration
• You might be able to do it with Active Reports, but honestly I am not the one to ask  :-)

If you want the web page with javascript, you will need the action URLs for each report. Then you set up a function that basically says "if I am on this URL, go to that URL" and reference that from a setInterval(). See http://www.w3schools.com/js/js_timing.asp.

[orbair]

HI bdbits,

Yes, I meant slideshow, they will put on a big screen in the office. I think I am gonna use PowerPoint. Can PowerPoint handle live data? I mean this report will refresh in every minute in cognos, that will be refreshed in PP silide too?

Thank you!

[CognosPaul]

It is possible with Active Reports, see here: http://cognospaul.com/2013/06/18/automatically-looping-through-charts-in-active-reports

[bdbits]

Live data, hmm... don't think there is a way to automatically refresh the data in the PowerPoint slide. Though you might be able to embed a macro in the PowerPoint deck to do the same thing as whatever clicking on refresh does.

I don't know if I would go down that route. I would probably just use a local install of IIS and a simple web page to show reports from the Cognos server. I know a business in town here that does just that, it works pretty well for them.