dbr.report chart linking

(3 posts) (2 voices)
  • Started by ken@pesttrend.com
  • Latest reply from ken@pesttrend.com


No tags yet.

  1. ken@pesttrend.com, Member

    When I link from "report one" to "report two" and "report one" is not a chart(i.e table) the command dbr.report works fine. Here is and example call:

    SELECT 'dbr.report', 'sp_pt_32_visit_list_report', 'new_popup','[numberofvisitsinyear]', 'param_companyid=[companymemberid]';

    If report one is a chart and I want a drill through to another report then it will not work when I click on chart column. Here is and example call:

    SELECT 'dbr.chart', 'MScolumn', '';

    SELECT 'dbr.report', 'sp_pt_89_species_analysis_detail', 'new_popup','[totalyearspeciecount]', 'param_selectedcompanyid=(param_selectedcompanyid)';

    Is there anything obvious I'm missing ?

  2. myDBR Team, Key Master

    Leave out the ColumnReference ([numberofvisitsinyear]) for the dbr.report-call. myDBR knows it's a chart and places the link automatically in the correct position based on the chart type.

    myDBR Team

  3. ken@pesttrend.com, Member

    Thank you, that worked.


You must log in to post.