organisation chart / family tree

(11 posts) (2 voices)

Tags:

  1. Johan, Member

    Hi,
    I try to understand how organisation chart (and other network charts work).
    In the end of the code I see
    call sp_DBR_doc_Source('sp_DBR_org_ext').
    Where can I find the code in sp_DBR_doc_Source?

    Does anyone has an example of a family tree using Mydbr and Mysql database?

    Thanks for your help.
    Johan

    Posted 4 years ago #
  2. myDBR Team, Key Master

    Hi,
    you can find the documentation for the organization chart extension in myDBR documentation: http://mydbr.com/doc/?extensions.organizationchart.html.

    The sp_DBR_doc_Source is just a procedure which shows the "Show how this report is done"-button at the end of the report. Nothing to do with the organization chart.

    --
    myDBR Team

    Posted 4 years ago #
  3. Johan, Member

    ok thanks

    Posted 4 years ago #
  4. Johan, Member

    Hi,

    I've created my report
    select 'dbr.org.chart';

    select org_id id, org_parent_id parent_id, org_position position, org_naam name from reg_personeel.organogram where org_active = '1';
    but now I get this error

    organization_chart-extension should be marked to be used in the report.

    Any idea what's going wrong?
    Johan

    Posted 4 years ago #
  5. myDBR Team, Key Master

    Go to 'Edit' report parameter view and check the 'Organization chart' extension to be included for the report. This will load the needed libraries for the organization chart, which is implemented as an myDBR extension.

    --
    myDBR Team

    Posted 4 years ago #
  6. Johan, Member

    Ok that helps.
    Now the report view is to wide. How let it fit on my screen?
    Johan

    Posted 4 years ago #
  7. myDBR Team, Key Master

    If the organization chart is too wide, you have several options:

    1) Position the nodes differently (see demo).
    2) Use smaller font / node size in chart
    3) Zoom the page using CSS (zoom)

    --
    myDBR Team

    Posted 4 years ago #
  8. Johan, Member

    Hi,

    I've tried to use some html in my query but it doesn't work in the org.chart

    select org_id id, org_parent_id parent_id , org_position position,
    concat('<B>', org_naam, '</B>' , 'test') name from
    reg_personeel.organogram where org_active = '1' order by org_id;

    Is this a setting?
    Johan

    Posted 4 years ago #
  9. myDBR Team, Key Master

    Use <b> instead of <B>.

    Organization chart uses HTML5 Canvas and the <b> and <I> are converted from the data.

    --
    myDBR Team

    Posted 4 years ago #
  10. Johan, Member

    Hi,

    I'm still having problems with layout of my chart.

    I only see a part of the organisationchart, rest is missing. + I see more in firefox then in Chrome.
    Can I sent you some printscreens or url to my report?
    Johan

    Posted 4 years ago #
  11. myDBR Team, Key Master

    The best way of reporting an issue is to include both a screenshot and a report output when you add '&export=sql' to the report. This way we can easily reproduce the exact report. Use support email for the request.

    --
    myDBR Team

    Posted 4 years ago #

Reply

You must log in to post.