Adding new button for a editable report

(2 posts) (2 voices)

Tags:

No tags yet.

  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.