all groups > sql server reporting services > june 2005 >
You're in the

sql server reporting services

group:

Dynamic labels for X and Y-axis in a chart


Dynamic labels for X and Y-axis in a chart PV
6/6/2005 3:52:06 PM
sql server reporting services:
Hi
Is there a way in which I can set the labels for the X and Y axes for a
chart programatically? The values for the labels are returned from the
database...

I already have a stored proc which acts as the source for the chart. I might
have the labels retrieved as a seperate query from the DB.

Re: Dynamic labels for X and Y-axis in a chart Robert Bruckner [MSFT]
6/6/2005 9:14:48 PM
The Y-axis labels are determined by the chart control and are numeric
values. You can set the format code property to get special numeric
formatting and locale settings.

The X-axis has two modes: numeric ("timescale or numeric values" checkbox)
and non-numeric (default). In the non-numeric mode, the labels are
determined by the category grouping value expression or the category
grouping label expression (if explicitly specified).

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Dynamic labels for X and Y-axis in a chart PV
6/7/2005 10:49:31 AM
Thanks....

Can we also display the Titles for the X and Y-axes from the database? I
have one query that generates the data for the report...

I was wondering if I could set the Titles for these axes from a seperate
query from the Database.

Thanks
Kannan

[quoted text, click to view]
Re: Dynamic labels for X and Y-axis in a chart Robert Bruckner [MSFT]
6/8/2005 9:22:21 PM
The x-axis title and y-axis title can be expressions. By using aggregate
functions, you can reference fields from other datasets, e.g.
=First(Fields!XAxisDescription.Value, "OtherDataset")

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

AddThis Social Bookmark Button