1. 

   chadwickhung, Member

   I'm trying to follow the document to create an editable report by adding a button for new record. But don't why the button doesn't show up. I'm using premium version, below is the code. Please help.
   Thanks

   
   
   DROP PROCEDURE IF EXISTS sp_DBR_leave_record
   
   $$
   
   CREATE PROCEDURE `sp_DBR_leave_record`(staff_id int)
   
   BEGIN
   
   select 'dbr.hidecolumns', 'leave_id';
   
   select `staff_id`, `leave_type`, `date`, `date_type`, `backup_plan`, `Approved`,
   
   `leave_id` 'leave_id'
   
   from dreamhigh_hr.leave_record;
   
   select 'dbr.button', 'New leave';
   
   select 'dbr.report', 'sp_DBR_leave_record_new', 'newleave[]';
   
   select 'dummy result set for the button';
   
   END
   
   $$
2. 

   myDBR Team, Key Master

   The code is ok.

   Just make sure you have added the sp_DBR_leave_record_new-procedure as a report and that you have been granted access to the report. Otherwise myDBR will treat you as another user which do not have right to add records and does not show the button.

   --
   myDBR Team

Reply

You must log in to post.