PDA

View Full Version : Bar chart with selected columns



Pepe
9-Jul-2020, 05:53 AM
Hi,


We've got a report with multiple columns.


We need to have a bar chart with values from only two of those columns


Is that possible? How?

More on https://support.dataaccess.com/Forums/showthread.php?65860-Chhose-columan-for-a-graph


TIA

Pepe

Bob Cergol
10-Jul-2020, 04:41 PM
Hi Pepe,

Did the information found in the other forum thread you referenced here not work for you?

Here's a snippet from the released docs that repeats that information:

Build 6.4.46
You can set specific colorcodes on the charts using @chartcolor:colorcode in the grouping text. The @chartcolor:colorcode will not show on the list.
Use @chartcolor:hide to hide a total from being used in a chart.

To be clear you caption the column to include the mentioned string. It will suppress that total from the chart, and the string will also be stripped out of the actual title displayed in the report grid.

For example: Total_Cost@chartcolor:hide will be captioned Total_Cost in the report grid, and that total will be excluded from the chart.

Bob

Pepe
14-Jul-2020, 08:49 AM
Thanks Bob.

More than colors or aesthetics the idea was to be able to represent the charts only with determined columns specified at programming time.

Salu2

Pepe

Bob Cergol
14-Jul-2020, 08:53 AM
Right, and you noticed that the "color" specified was "hide" which will hide that total from the chart.
Bob

Pepe
14-Jul-2020, 08:55 AM
Uuups. I missed that!

Sorry I will try it out