1. 

   ken@pesttrend.com, 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'

   SELECT
   k.groupname,
   w.performancetype AS '[performancetype]',
   (SELECT
   CASE
   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
   END
   ) AS 'risk score[riskscore]',
   k.corporategroupdefid

   FROM(
   .... 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
   select
   '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. 

   ken@pesttrend.com, Member

   Thank you that worked.

Reply

You must log in to post.