1. 

   astroshark, Member

   I am using a select list for a linking another report together

   SELECT 'dbr.report', 'sp_DBR_agent_performance_graphs', 'scope', 'inType=[scope]'; SELECT 'dbr.selectlist', 'Call Volume VS Service Level - Past 6 Months', '';

   SELECT 'Call Volume VS Service Level - Past 6 Months' AS '[scope]';

   How would I go about displaying "Call Volume VS Service Level - Past 6 Months" automatically without having to select another item and so that part of the report is not blank when the report loads?
2. 

   myDBR Team, Key Master

   You have the default selected value defined as a first paramter to the dbr.selectlist.

   Do you want that default linked report to be run automatically when the report loads the first time or what is your question? Do you have 'scope' DIV defined in your report as that is what you have defined as target for the linked report (named as same as the ColumnReference)?

   --
   myDBR Team
3. 

   astroshark, Member

   This is my full code loading into a template

   
   
   SELECT 	'dbr.record', 'begin', 'bi_header2';
   
   SELECT	'dbr.report', 'sp_DBR_agent_performance_graphs', 'scope', 'inType=[scope]';
   
   SELECT	'dbr.selectlist', 'Call Volume VS Service Level - Past 6 Months', '';
   
   SELECT 'Call Volume VS Service Level - Past 6 Months' AS '[scope]';
   
   -- End the recording. The chart is now in the bi_content-variable
   
   SELECT 	'dbr.record', 'end';
   
   SELECT 	'dbr.record', 'begin', 'bi_content';
   
   SELECT	'dbr.embed_object', 'scope';
   
   -- End the recording. The chart is now in the bi_content-variable
   
   SELECT 	'dbr.record', 'end';
   
   

   I am wanting the linked report to run automatically when the main report loads for the first time.
4. 

   myDBR Team, Key Master

   The linked reports are not automatically run. Either the user runs it or you can run it via JavaScript.

   To trigger the selectlist to run the attached linked report, you need to send the 'change' event to the select-element. In order to do that, add a CSS class to the select-element and use that in JS. The CSS class is the 4th parameter to the dbr.selectlist.

   SELECT  'dbr.selectlist', 'Call Volume VS Service Level - Past 6 Months', ''; null, 'myselect';

   Then you can trigger the change event via JS:

   select 'dbr.javascript', "$('.myselect').change();", 'onload';

   
   --
   myDBR Team
5. 

   astroshark, Member

   Awesome that worked I appreciate it!

Reply

You must log in to post.