Chart drill through when chart recorded for template

(3 posts) (2 voices)
  • Started by
  • Latest reply from


No tags yet.

  1., Member

    When I record using dbr.record and generate a chart I want to have a drill through on the chart columns. I cannot get this to work.

    The chart shows up perfectly but no click through.

    Here is my code:

    select 'dbr.record', 'begin', 'bi_content';

    select 'dbr.title', '';

    select 'dbr.hidecolumn', 'corporategroupdefid';

    SELECT 'dbr.chart', 'stackedbar', '', 420, 200;
    select 'dbr.chart.options','padding_right', -30;
    select 'dbr.chart.options','padding_left', -3;

    select 'dbr.url', '/pesttrend/PDF_report.php?reportname=sp_pt_118_single_group_risk_analysis&reporttype=onscreen', 'Drilldown','[riskscore]', 'p1=(corporategroupdefid)', 'p2=(param_drilldown)', 'new_window'

    w.performancetype AS '[performancetype]',
    WHEN w.performancetype = 'Group open actions' THEN k.groupopenactions
    WHEN w.performancetype = 'Stations not serviced in year' THEN k.efknotservicedinyear
    WHEN w.performancetype = 'Stations not active' THEN k.stationsnotactive
    WHEN w.performancetype = 'High risk stations' THEN k.highriskstations
    ) AS 'risk score[riskscore]',

    .... rest of SQL statement


    -- End the recording. The chart is now in the bi_content-variable
    select 'dbr.record', 'end';

    -- Use the template
    select 'dbr.template', '#bi_box';

    -- Pass other variables to the template
    'widest' as 'bi_width',
    'Group risk score' as 'bi_header1',
    'One unit for each risk item' as 'bi_header2',
    'big' as 'bi_dheight',
    null as 'bi_green',
    'no' as 'bi_show_green';

  2. myDBR Team, Key Master

    You do not need to specify the linked URL target with dealing with charts. myDBR places the link based on the chart type. You can remove the '[riskscore]'-parameter from dbr.url.

    myDBR Team

  3., Member

    Thank you that worked.


You must log in to post.