1. Can we implement two date ranges in a single report for analytical purposes? For example, one date range could load one specific tabular data set, while the other date range loads a different data set for comparison.
Sure. Add two pairs of dates as parameter and use one for the tabular data set and the other for the different data set.
2. Is it possible to export or print chart data in the same way we do for tabular data?
Charts are exported in non-text formats (Excel and PDF). Make sure to use image-based charts (ChartDirector). If you use Chart.js charts by default, you can use the following option::
if (inExportFormat in ('xlsx', 'pdf')) then
select 'dbr.chart.options', 'imagechart', 1;
end if;
, where inExportFormat
is an automatic parameter (varchar(4)).
--
myDBR Team