Changing name of columns in a chart

[Guest]

I'm creating a chart in a report that will show 'Available Time', 'Running
Time', and 'Downtime'. These are all taken from a query. How do I change
the name of these columns to 'Available Time', etc. Just now they are called
'SumOfDaily', 'SumOfSumOfRunning Time (Mins)', and 'SumOfSumOfDowntime(Min)'.


Thanks for the help

Tommy

 

[Rob Parker]

Hi Tommy,

Assuming that your current chart is using the query's field names as its
labels, the simplest solution is to change the name by supplying an alias in
the query. You can do this either by entering the required text in the
Caption field of the properties dialog when the appropriate field is
selected, or by entering an alias in the Field cell in the query grid,
followed by a colon, before the current field expession. So, eg. (assuming
that your query is a totals query) to change the first name you quoted,
enter:
Available Timeaily
in the field cell in the query design grid for the cell which contains the
Daily field with the Totals row set to Sum.

If you use both the caption property and the alias in the query grid, the
caption property will over-ride the query grid alias.

HTH,

Rob

 

[Guest]

The names are coming up ok in the query table by changing the caption in
properties and by the other method. They are still not being sisplayed
correctly in the report. They are coming up 'SumOfAvailable Time',
'SumOfRunning Time', and 'SumOfDowntime'. It's just the 'SumOf' bit I need
to get rid off. is there any way of doing this in the report itself?

 

[Rob Parker]

It works for me, so I'm at a loss what else to suggest. Does your revised
query (with the aliased name) have the same name as previously? If not, did
you change the Row Source for the chart object in your report to the new
query? Note: the chart's Row Source will not automatically change if you
change the Record Source of the report itself. Also note that the changes
may not show in design view of the chart, but will show when the report
(chart) is opened normally.

HTH,

Rob

 

[Guest]

Tommy,
If you can't figure this out, come back with the SQL view of your Row Source
of the chart.