I've very sorry if I'm missing something obvious, but I can't seem to find any specific examples in your docs or on the web of the actual syntax needed to specify the chart tooltip label.
The documentation says:
tooltip, '[ColumnReference] [ColumnReference]' - Define the mouse tooltip content with the ability to refer to data columns
Which sounds fine, but when I try this, the report produces an error saying unknown column in field list or if I use a number reference, the number itself is just shown, not the column data.
An example of what I am trying (I want the tooltip to display col2 data - if I do not change the tooltip, it displays 'col3 /n col1'):
select 'dbr.chart', 'Percentbar';
select 'dbr.chart.options', 'imagechart';
select 'dbr.chart.options', 'hide', 'all';
select 'dbr.chart.options', 'tooltip', 2; /* alternatives also tried here were 'col2','2',col2 */
As always, your advice/help is much appreciated.
Many thanks and kind regards,