1. 

   jasmondluk, Member

   Can I based on different logged in user to show different information in the main-screen notification? Says, I can query the database to get relevant information based on the username and shows the corresponding information there? Thanks
2. 

   myDBR Team, Key Master

   The latest build supports this. To do it, you use the embed_url call with 'notification' as third paramerer and append &embed=3 to the report call:

   <script>
   
   embed_url("http://yoursever/report.php?r=123&h=f9e26e7c499041aeeef56fa7908f3eb38ac2b276&i=1&embed=3", false, 'notification');
   
   </script>

   The report code can contain full report with inLogin automatic parameter. With just text, you can use:

   CREATE PROCEDURE `sp_DBR_notifiction`(
   
   inLogin varchar(50)
   
   )
   
   BEGIN
   
   select 'dbr.title', '';
   
   select 'dbr.text', concat('Message for ',inLogin);
   
   END

   --
   myDBR Team
3. 

   jasmondluk, Member

   Where do I call this sp_DBR_notifiction?
4. 

   myDBR Team, Key Master

   The latest build makes this even easier. You can just place the report name into the Main-screen notification field. Make sure the report in question is marked as Public so all users have access to it.

   --
   myDBR Team

Reply

You must log in to post.