1. 

   jcushman, Member

   Hi,

   Currently, we are casting a report to a TV in our work area, which shows progress for the day and refreshes every 3 minutes. We're using chromecast and it works great.

   My Question: Is it possible to "loop" two or more reports? I'd like it to work like this:

   Report 1 shows on the screen. After x minutes, the pages refreshes and shows Report 2. After x minutes, the page refreshes and shows report 1....back to 2....back to 1....etc.

   Any help would be great. Thank you.
2. 

   myDBR Team, Key Master

   Sure, one way of doing it would be to use separate report which refeshes itself and calls the new report on each turn. You can store the called report to a separate table.

   create procedure sp_DBR_chromecast()
   
   begin
   
   declare v_cc_id int;
   
   select id into v_cc_id
   
   from chromecast_report;
   
   if (v_cc_id>3) then
   
     set v_cc_id = 1;
   
   else
   
     set v_cc_id = v_cc_id + 1;
   
   end if;
   
   update chromecast_report
   
   set id = v_cc_id;
   
   case v_cc_id
   
     when 1 then call sp_ chromecast_report_1();
   
     when 2 then call sp_ chromecast_report_2();
   
     when 3 then call sp_ chromecast_report_3();
   
   end case;
   
   select 'dbr.refresh', 180;
   
   end

Reply

You must log in to post.