Line Point chart

hi,
How can i change the color property of the line in the line chart.
For bar charts and all i go to series style and change it.
but for line chart, default comes to green - and i would like to change it
to red.
thanksFor line charts, you need to change the series style border line color
(instead of the color property).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ramani" <Ramani@.discussions.microsoft.com> wrote in message
news:8A2BA0F6-A412-40EC-A316-B9D5F9D44889@.microsoft.com...
> hi,
> How can i change the color property of the line in the line chart.
> For bar charts and all i go to series style and change it.
> but for line chart, default comes to green - and i would like to change it
> to red.
> thanks
>|||Hi All,
I have a line a line chart where there are 2 lines.one of the line seems to
be hidden im not sure y' only one line is displayed at a time...
Can any1 let me know of my problem,
Thanks,
"Robert Bruckner [MSFT]" wrote:
> For line charts, you need to change the series style border line color
> (instead of the color property).
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Ramani" <Ramani@.discussions.microsoft.com> wrote in message
> news:8A2BA0F6-A412-40EC-A316-B9D5F9D44889@.microsoft.com...
> > hi,
> > How can i change the color property of the line in the line chart.
> > For bar charts and all i go to series style and change it.
> > but for line chart, default comes to green - and i would like to change it
> > to red.
> > thanks
> >
>
>

Line Column Charts

Is it possible to generate a line column chart in Reporting services.
It is possible in Excel. But I haven't found a way in reporting
services.Please check this previous posting (it also contains a sample RDL):
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"DavidR" <david.reller@.ato.gov.au> wrote in message
news:49eca18c.0409131955.7fe6de8e@.posting.google.com...
> Is it possible to generate a line column chart in Reporting services.
> It is possible in Excel. But I haven't found a way in reporting
> services.|||Thanks Robert
Next question is how does one add a secondary Y axis scale and title
like it is possible in Excel.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message news:<OwzDi8gmEHA.324@.TK2MSFTNGP11.phx.gbl>...
> Please check this previous posting (it also contains a sample RDL):
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "DavidR" <david.reller@.ato.gov.au> wrote in message
> news:49eca18c.0409131955.7fe6de8e@.posting.google.com...
> > Is it possible to generate a line column chart in Reporting services.
> > It is possible in Excel. But I haven't found a way in reporting
> > services.|||Secondary Y-axis is not natively supported in RS 2000, but is on the list
for inclusion in a future release. Some workarounds for RS 2000 are
discussed here:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=687c54df-a60c-4484-8d2b-3159cbc924d1&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"DavidR" <david.reller@.ato.gov.au> wrote in message
news:49eca18c.0409142149.7a9dc1d2@.posting.google.com...
> Thanks Robert
> Next question is how does one add a secondary Y axis scale and title
> like it is possible in Excel.
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:<OwzDi8gmEHA.324@.TK2MSFTNGP11.phx.gbl>...
> > Please check this previous posting (it also contains a sample RDL):
> >
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "DavidR" <david.reller@.ato.gov.au> wrote in message
> > news:49eca18c.0409131955.7fe6de8e@.posting.google.com...
> > > Is it possible to generate a line column chart in Reporting services.
> > > It is possible in Excel. But I haven't found a way in reporting
> > > services.

Line chart threshold

I have numerous reports generating line charts. I would like to have
one more line added to the graphs set to a static value to show what
the threshold would be. I have tried drawing a line on the chart and
this works in BIDS preview, but it does not appear when I publish the
report. Any suggestions on a better way to do this? I have also
tried adding a field with a static value to the dataset, but it draws
the line multiple times and shows multiple instances of the value in
the legend.On Mar 4, 2:03 am, Victag <miketagg...@.gmail.com> wrote:
> I have numerous reports generating line charts. I would like to have
> one more line added to the graphs set to a static value to show what
> the threshold would be. I have tried drawing a line on the chart and
> this works in BIDS preview, but it does not appear when I publish the
> report. Any suggestions on a better way to do this? I have also
> tried adding a field with a static value to the dataset, but it draws
> the line multiple times and shows multiple instances of the value in
> the legend.
Add another data value. add at the place where you can see the
original data you are seeing now.
This should work
Thanks
Raj Deep.A|||On Mar 5, 9:45=A0am, RajDeep <rajalap...@.gmail.com> wrote:
> On Mar 4, 2:03 am, Victag <miketagg...@.gmail.com> wrote:
> > I have numerous reports generating line charts. =A0I would like to have
> > one more line added to the graphs set to a static value to show what
> > the threshold would be. =A0I have tried drawing a line on the chart and
> > this works in BIDS preview, but it does not appear when I publish the
> > report. =A0Any suggestions on a better way to do this? =A0I have also
> > tried adding a field with a static value to the dataset, but it draws
> > the line multiple times and shows multiple instances of the value in
> > the legend.
> Add another data value. add at the place where you can see the
> original data you are seeing now.
> This should work
> Thanks
> Raj Deep.A
I tried adding a value to the dataset and putting that value in the
graph, but now I see more than one line in the graph for the value and
it shows multiple times in the legend.

Line Chart in RS - simple design question

I have a simply data file that I want to make a time-based line chart and I can't seem to get charts in RS to do it. The data file structure is as follows: (first line is column labels and each row is a case with three data points - one for each year)

school 2003 2004 2005

SchA 100 122 133

SchB 121 145 115

SchC 98 112 120

I can't seem to get the right series, category, and data fields to get a very simple line chart for each school (one trend line for each school connecting the three data points all one the same chart). It's trivial in Excel and using pivot tables, but RS charts is not structured the same way.?

The fields in the SQL result set returned are School, 2003, 2004, & 2005.

Any help for this seemingly simply problem would be appreciated. Thanks

Ed Sloat

your resultset has to look like this:

Year SchA SchB SchC

2003 100 121 98

2004 122 145 112

2005 133 115 120

SchA, SchB, SchC are your value fields
Year is your category field

this should work fine|||

Gerhard, Thanks for the reply. I did try this and it does work but it requires a fundemental restructuring of the underlying data. From your answer, I am guessing the RS charting assumes a single static (required) data structure for the charting features and does not allow for flexibility in the defining the data rerlationships,... which makes it much less functional than charting in Excel or in other statistical/data analysis software. Seem like it makes some pretty trival/common data display tasks much more difficult.

Thanks.

Ed

|||

OK, Select the line chart, then Select School and drop them under 'Drop Series fields here', Select years and drop them under 'Drop Categroy fields here' and finally Select the data fields and drop them 'Drop data fields here' areas.

Line Chart in RS - simple design question

I have a simply data file that I want to make a time-based line chart and I can't seem to get charts in RS to do it. The data file structure is as follows: (first line is column labels and each row is a case with three data points - one for each year)

school 2003 2004 2005

SchA 100 122 133

SchB 121 145 115

SchC 98 112 120

I can't seem to get the right series, category, and data fields to get a very simple line chart for each school (one trend line for each school connecting the three data points all one the same chart). It's trivial in Excel and using pivot tables, but RS charts is not structured the same way.?

The fields in the SQL result set returned are School, 2003, 2004, & 2005.

Any help for this seemingly simply problem would be appreciated. Thanks

Ed Sloat

your resultset has to look like this:

Year SchA SchB SchC

2003 100 121 98

2004 122 145 112

2005 133 115 120

SchA, SchB, SchC are your value fields
Year is your category field

this should work fine
|||

Gerhard, Thanks for the reply. I did try this and it does work but it requires a fundemental restructuring of the underlying data. From your answer, I am guessing the RS charting assumes a single static (required) data structure for the charting features and does not allow for flexibility in the defining the data rerlationships,... which makes it much less functional than charting in Excel or in other statistical/data analysis software. Seem like it makes some pretty trival/common data display tasks much more difficult.

Thanks.

Ed

|||

OK, Select the line chart, then Select School and drop them under 'Drop Series fields here', Select years and drop them under 'Drop Categroy fields here' and finally Select the data fields and drop them 'Drop data fields here' areas.