Dynamic labels in chart.

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.

ThanksThe 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|||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

Dynamic labels for X and Y-axis in a chart

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.
ThanksThe 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.
"PV" <PV@.discussions.microsoft.com> wrote in message
news:15141351-1BB5-45D4-8364-B132948612D8@.microsoft.com...
> 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.
> Thanks|||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
"Robert Bruckner [MSFT]" wrote:
> 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.
> "PV" <PV@.discussions.microsoft.com> wrote in message
> news:15141351-1BB5-45D4-8364-B132948612D8@.microsoft.com...
> > 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.
> >
> > Thanks
>
>|||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.
"PV" <PV@.discussions.microsoft.com> wrote in message
news:7C67DBA0-DD8B-4403-B49B-11B16A51D80B@.microsoft.com...
> 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
> "Robert Bruckner [MSFT]" wrote:
>> 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.
>> "PV" <PV@.discussions.microsoft.com> wrote in message
>> news:15141351-1BB5-45D4-8364-B132948612D8@.microsoft.com...
>> > 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.
>> >
>> > Thanks
>>

dynamic columns in matrix

hi all,

i m using ssrs 2005. i want to generate a report which displays data according to the dataset returned.Now this dataset can return any number of columns.

does matrix use helps out in this case..

if anyone can really explain me on it or can even point to certain articles in this regard,that wudd be wonderful

thanks a ton...

hi all
m quite new to reporting services so may b it sounds easy for u champs but still ur replies wudd b appreciated..

thanks a ton ...

|||Hi,hilander:
Try to do this.
1. Convert your RDL files in RLDC files (see this topic at VS2005 help).
2. Configure your ReportViewer to a LocalReport mode. This will allow you to
link yourdataset to a report at runtime by using ReportViewer.LocalReport methods or at disign level too.

Hopefully I help you.

|||

Hi,hilander:
We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

Dynamic Columns

Can I create columns dynamically? In other words, progammatically determine the columns to display based on what is returned by the dataset. I know that it is easy to just drag/drop items from my dataset but is there a way to do this programmatically.

You can define a table with all the possible columns, then decide whether to show the column based on the the value of the IsMissing property on Field. http://msdn2.microsoft.com/en-us/library/ms157274(SQL.90).aspx

The other alternative is to generate rdl dynamically based on the dataset.