Custom labels in charts

[Former Member]

Hello!

I'm using Crystal Reports for eclipse.

In one of my reports there is a chart, in which the data from database table is shown. The column in the database is called, say, NAMEOFACOLUMN.

I want that in the legend of the diagram, the column is displayed with spaces, i. e. "NAME OF A COLUMN", and not as NAMEOFACOLUMN.

How can I do that (except re-naming the database table or creating a view with this name) ?

Thanks in advance

Dmitri Pissarenko

[Former Member]

It will be a little tricky, however this may work for you.

I will use a bar chart as an example: There is an option to set the category title, which is the label for the bars. You can create a formula that formats the field name to the way you want it, and should be able to use that formula in the category title. In the properties window for the Category, you will see a Group By property; here you can select either a database field or a formula for your category.

The tricky part will be ensuring that when you do this you get the appropriate data in your graph after formatting the name.