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
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
3. 

   Johan, Member

   ok thanks
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
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
6. 

   Johan, Member

   Ok that helps.
   Now the report view is to wide. How let it fit on my screen?
   Johan
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
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
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
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
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

Reply

You must log in to post.