Hey Guys,
I am using the Free edition and I have created a Mydbr report which displays some output and then shows a button for viewing a linked report.
The issue I am facing is that on-clicking my button the browser opens a new popup window to show the report instead of showing it in same page. A former colleague at work used the free version earlier and it did not happen to him back then.
here's the code I used for the button.
select 'dbr.button', 'Click for full report', 'btn-primary-verifacto';
select 'dbr.report', 'sp_DBR_aging_report_details', 'clientdb=the_clientdb', '_location_name=the_location_name', '_portfolio_name=the_portfolio_name', '_status=the_status','linked_output[]';
SET @query := CONCAT("
SELECT
'", clientdb, "' AS the_clientdb,
'", _location_name, "' AS the_location_name,
'", _portfolio_name, "' AS the_portfolio_name,
'", _status, "' AS the_status
"
);
PREPARE stmt FROM @query;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
By the way, loading of linked report on same page works correctly on our premium version in development/production servers. So could you tell us if this a known issue in the community(free)version and if yes, how do we fix it ?
Your help will be much appreciated.