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 in a bar chart.

Does anyone know how to print a line on a bar chart....

Basically I have two series for the chart. The first series would appear as a bar chart. The second as a line.

ThanksIn the Report Designer, go to the Chart Properties dialog. Click on the Data tab, select the data point you want to make a line, click 'Edit..'. In the chart value dialog, click on the Appearance tab and select 'Plot Data as Line'.

Line Chart question

I have a line chart with three series group where it is possible that one
series will be missing data within the time range.
Currently the line is drawn from the last point to the next valid point. Is
it possible to have the report drawn with the line missing (or not drawn) for
that specific point for that specific series?
Thanks,
KevinHi
Set the border property in RS2005 to none , try something like this
=iif( Fields!<FieldName>.value=nothing or Fields!
<FieldName>.value='' , "None",
"Solid")
Cheers
Shai
On Dec 12, 4:08 am, Kevinst <Kevi...@.discussions.microsoft.com> wrote:
> I have a line chart with three series group where it is possible that one
> series will be missing data within the time range.
> Currently the line is drawn from the last point to the next valid point. Is
> it possible to have the report drawn with the line missing (or not drawn) for
> that specific point for that specific series?
> Thanks,
> Kevin|||Thanks for the info...
I changed the report to a x-y scatter and modified the sql query, but your
bit of code helped with another issue...
Thanks,
Kevin
"shaikat.das@.gmail.com" wrote:
> Hi
> Set the border property in RS2005 to none , try something like this
> =iif( Fields!<FieldName>.value=nothing or Fields!
> <FieldName>.value='' , "None",
> "Solid")
> Cheers
> Shai
> On Dec 12, 4:08 am, Kevinst <Kevi...@.discussions.microsoft.com> wrote:
> > I have a line chart with three series group where it is possible that one
> > series will be missing data within the time range.
> >
> > Currently the line is drawn from the last point to the next valid point. Is
> > it possible to have the report drawn with the line missing (or not drawn) for
> > that specific point for that specific series?
> >
> > Thanks,
> > Kevin
>

Line Chart Line Color

Is it possible to change line color in the line chart. I can change series
color in a bar chart, but cannot seem to change the color of the lines when
selecting a smooth line chart.
-ChrisThe relevant property in line charts is the border line color property.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Borgers" <ChrisBorgers@.discussions.microsoft.com> wrote in message
news:4852411A-7B54-4A8D-9E19-E3787F9D1656@.microsoft.com...
> Is it possible to change line color in the line chart. I can change
series
> color in a bar chart, but cannot seem to change the color of the lines
when
> selecting a smooth line chart.
> -Chris

Line Chart Color

Hello,

My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this? Or is the only differentiation the markers?

Michael

To put different colors for lines in line chart, Please select chart properties-goto Data-under values goto Edit-Apperance-goto Series Style...-select Border and Line-Color. give suitable color here. (and i think line and marker will have the same color.)|||

Merin,

I did see that option. But doing that changes the colors for ALL lines in my chart. I'd like my series to have different colors, if possible. Any ideas?

Michael

|||for each value u need to select colors. u may have different values inside data in chart properties , for each case u need to follow the same path and choose different color.it worked for me. i hope it will work for u also|||

Ugh, that sounds a lot messier than I thought, especially since my series are all dynamic. Can I reference the color pallete using an array? Or perhaps I'll wait to SRS 2008 with the Dundas charts.

Michael

|||What you mean by dynamic series?|||I mean I have multiple lines on the chart, one for each series value. All the lines are the same color.|||i am trying to do the same thing too.

i was able to for a 100% stacked column chart, using multiple data values, and still specify a color for each value in the stacked column chart (3 of them in my case).

however for my current line chart with only 1 data value, the default colors are automatic according to a color scheme, but i want to be able to define the colors. i was thinking of the following methods using coding under the chart properties -? data -? values (double click the value item) -? edit chart value -? appearance -? series style -? border and line -? color -? ?x

(refer to code snippet)

and the color will be hardcoded to the value string of the data. alternative you can put it as a database column. these are just my ideas. would be great if someone out there has a better solution ... always open to learn.

rev-boy

=IIf(
Fields!DATA_COLUMN.Value = "Type 1", "Green",
IIf
(
Fields!DATA_COLUMN.Value = "Type 2", "Red",
IIf
(
Fields!DATA_COLUMN.Value = "Type 3", "Brown", "Black"
)
)
)

Line Chart Color

Hello,

My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this? Or is the only differentiation the markers?

Michael

To put different colors for lines in line chart, Please select chart properties-goto Data-under values goto Edit-Apperance-goto Series Style...-select Border and Line-Color. give suitable color here. (and i think line and marker will have the same color.)|||

Merin,

I did see that option. But doing that changes the colors for ALL lines in my chart. I'd like my series to have different colors, if possible. Any ideas?

Michael

|||for each value u need to select colors. u may have different values inside data in chart properties , for each case u need to follow the same path and choose different color.it worked for me. i hope it will work for u also|||

Ugh, that sounds a lot messier than I thought, especially since my series are all dynamic. Can I reference the color pallete using an array? Or perhaps I'll wait to SRS 2008 with the Dundas charts.

Michael

|||What you mean by dynamic series?|||I mean I have multiple lines on the chart, one for each series value. All the lines are the same color.|||i am trying to do the same thing too.

i was able to for a 100% stacked column chart, using multiple data values, and still specify a color for each value in the stacked column chart (3 of them in my case).

however for my current line chart with only 1 data value, the default colors are automatic according to a color scheme, but i want to be able to define the colors. i was thinking of the following methods using coding under the chart properties -? data -? values (double click the value item) -? edit chart value -? appearance -? series style -? border and line -? color -? ?x

(refer to code snippet)

and the color will be hardcoded to the value string of the data. alternative you can put it as a database column. these are just my ideas. would be great if someone out there has a better solution ... always open to learn.

rev-boy

=IIf(
Fields!DATA_COLUMN.Value = "Type 1", "Green",
IIf
(
Fields!DATA_COLUMN.Value = "Type 2", "Red",
IIf
(
Fields!DATA_COLUMN.Value = "Type 3", "Brown", "Black"
)
)
)

Line Chart

I have created a line chart and the line for each series is very thick. Does anyone know if it is possible to set the width of these?
Thanks
DarrenGo to Chart Propertties Dialog -> Data tab -> Values -> Edit ->
Appearance -> Series Style -> Border and Fill tab and change the Width value
accordingly (this can also be an expression.)
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Darren" <Darren@.discussions.microsoft.com> wrote in message
news:F730A02E-B52E-4C99-B7C4-10F5C7BF4710@.microsoft.com...
> I have created a line chart and the line for each series is very thick.
Does anyone know if it is possible to set the width of these?
> Thanks
> Darren|||You will need SP1 installed on client and server to modify the thickness of
line charts:
In report designer, right click on the chart -> Chart Properties Dialog ->
Data tab -> Values -> Edit -> Edit Chart Value dialog -> Appearance tab ->
click Series Styles -> Style properties dialog -> select Width from dropdown
or use an expression like ="1pt"
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Darren" <Darren@.discussions.microsoft.com> wrote in message
news:F730A02E-B52E-4C99-B7C4-10F5C7BF4710@.microsoft.com...
> I have created a line chart and the line for each series is very thick.
Does anyone know if it is possible to set the width of these?
> Thanks
> Darren

Line Chart

I have a line chart where I am displaying values (x axis) for a 30 day period
(y axis) for 4 different regions (series). My problem is that when the chart
is displayed it is repeating a series value although that series does only
appear 30 times. If I change the series to only display 1 region the problem
still occurs. I think it may have something to do with zero values returned
in dataset ie
Day Region value
1 A 0
2 A 1.2
3 A 0
4 A 1.5
If I put a filter on to start at day 2 then I do not have the problem,
however I don't neccessarily know what day would be the first one without a
zero value.
I can return values only above zero but I'd prefer to plot that zero value
on the graph.Assuming you have RS 2000 SP2 installed, you can try the following:
Change the dataset (or use a calculated field or use an IIF expression in
the chart value expression), so that 0 is represented as NULL in the dataset
(or as VB: Nothing in the RDL expression). Then the "zero" value datapoints
will be interpreted as "empty" points, but on the other hand you should
still get the x-axis starting with 1.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Me and SRS" <Me and SRS@.discussions.microsoft.com> wrote in message
news:D087DFC5-1822-4685-819A-4D768FD80618@.microsoft.com...
>I have a line chart where I am displaying values (x axis) for a 30 day
>period
> (y axis) for 4 different regions (series). My problem is that when the
> chart
> is displayed it is repeating a series value although that series does only
> appear 30 times. If I change the series to only display 1 region the
> problem
> still occurs. I think it may have something to do with zero values
> returned
> in dataset ie
> Day Region value
> 1 A 0
> 2 A 1.2
> 3 A 0
> 4 A 1.5
> If I put a filter on to start at day 2 then I do not have the problem,
> however I don't neccessarily know what day would be the first one without
> a
> zero value.
> I can return values only above zero but I'd prefer to plot that zero value
> on the graph.|||Thanks for your help and to a degree this works, but I want to plot the zero
value when it shows even if it is the first value. For some regions I may
not get a reading till the 10th day so in the chart that line will now not
appear till half way thru the graph and depending on circumstances may end on
the 25th day. Originally I am plotting the zero values but just get
duplicates for the series.
We are using RS 2000 SP2.
Thanks
"Robert Bruckner [MSFT]" wrote:
> Assuming you have RS 2000 SP2 installed, you can try the following:
> Change the dataset (or use a calculated field or use an IIF expression in
> the chart value expression), so that 0 is represented as NULL in the dataset
> (or as VB: Nothing in the RDL expression). Then the "zero" value datapoints
> will be interpreted as "empty" points, but on the other hand you should
> still get the x-axis starting with 1.
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Me and SRS" <Me and SRS@.discussions.microsoft.com> wrote in message
> news:D087DFC5-1822-4685-819A-4D768FD80618@.microsoft.com...
> >I have a line chart where I am displaying values (x axis) for a 30 day
> >period
> > (y axis) for 4 different regions (series). My problem is that when the
> > chart
> > is displayed it is repeating a series value although that series does only
> > appear 30 times. If I change the series to only display 1 region the
> > problem
> > still occurs. I think it may have something to do with zero values
> > returned
> > in dataset ie
> > Day Region value
> > 1 A 0
> > 2 A 1.2
> > 3 A 0
> > 4 A 1.5
> > If I put a filter on to start at day 2 then I do not have the problem,
> > however I don't neccessarily know what day would be the first one without
> > a
> > zero value.
> > I can return values only above zero but I'd prefer to plot that zero value
> > on the graph.
>
>|||I seem to have fixed the problem. Even though dataset returned the correct
amount of records (4 * 30) I was still getting duplicate rows in the series.
Had to use the TRIM function on the series field in the chart and just like
that the duplicates disappeared.
Thanks for your help.
"Me and SRS" wrote:
> Thanks for your help and to a degree this works, but I want to plot the zero
> value when it shows even if it is the first value. For some regions I may
> not get a reading till the 10th day so in the chart that line will now not
> appear till half way thru the graph and depending on circumstances may end on
> the 25th day. Originally I am plotting the zero values but just get
> duplicates for the series.
> We are using RS 2000 SP2.
> Thanks
> "Robert Bruckner [MSFT]" wrote:
> > Assuming you have RS 2000 SP2 installed, you can try the following:
> >
> > Change the dataset (or use a calculated field or use an IIF expression in
> > the chart value expression), so that 0 is represented as NULL in the dataset
> > (or as VB: Nothing in the RDL expression). Then the "zero" value datapoints
> > will be interpreted as "empty" points, but on the other hand you should
> > still get the x-axis starting with 1.
> >
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Me and SRS" <Me and SRS@.discussions.microsoft.com> wrote in message
> > news:D087DFC5-1822-4685-819A-4D768FD80618@.microsoft.com...
> > >I have a line chart where I am displaying values (x axis) for a 30 day
> > >period
> > > (y axis) for 4 different regions (series). My problem is that when the
> > > chart
> > > is displayed it is repeating a series value although that series does only
> > > appear 30 times. If I change the series to only display 1 region the
> > > problem
> > > still occurs. I think it may have something to do with zero values
> > > returned
> > > in dataset ie
> > > Day Region value
> > > 1 A 0
> > > 2 A 1.2
> > > 3 A 0
> > > 4 A 1.5
> > > If I put a filter on to start at day 2 then I do not have the problem,
> > > however I don't neccessarily know what day would be the first one without
> > > a
> > > zero value.
> > > I can return values only above zero but I'd prefer to plot that zero value
> > > on the graph.
> >
> >
> >

Limited Remote Login db access

I have connected my desktop and laptop computer at home, on my desktop I have a series of db's under my default named instance <computername>/sqlexpress and I have created access logins using windows auth. When I connect to the desktop from the laptop using tcp:<computername>\sqlexpress\userid I can only see the system db's...I am trying to view adventure works, which I can see on the desktop fine using the same login...any ideas?

Thanks,

Rob

Do you have a domain controller and home network?

If not, then you must create use SQL logins -you cannot use Windows authentication without an Active Directory (domain controller).

|||

I don't even know what those things mean.

How would I go about doing this with SQL logins?

Rob

|||

I suggest you follow the steps under "To configure AdventureWorks to work with Web server controls" on the following page from the Books Online.

http://msdn2.microsoft.com/en-us/library/ms310325(vs.80).aspx

Hopefully this helps,

John

|||

So I read over the link provided...

I have completed the first part and added it to the server. I can access the database on my desktop machine, when I login from the laptop however (using the same windows login) I can't access to database...do I need to also add something to make it accessible remotely? I don't really understand what "configure AdventureWorks to work with Web server controls
" means..

Rob

|||

These resources might help.

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

|||

I have done this...as I stated before I can connect fine its just that I can't see anything other than system db's...I imagine I'm missing something stupid, like perhaps I didn't configure the login correctly?

Rob

|||

The login needs to be provided permission to access the databases.

Add the login to the appropriate database role.

|||

Ok first...I am running XP home on both the desktop and laptop...and the logins are windows auth.

if I want full access from the remote connection, where do I change the role of the login? is it in the login menu or the databases menu?

Rob

|||

Look back at the first response given to your problem.

Windows authentication will not work in your situation -you do not have a domain controller.

You will need to establish SQL Logins in each server, and assign permissions accordingly.

Look in Books Online about creating SQL Logins.

Limited Remote Login access

Hello all,

I'm very new to this so excuse my naiveity...I have connected my desktop and laptop computer at home, on my desktop I have a series of db's under my default named instance <computername>/sqlexpress and I have created access logins using windows auth. When I connect to the desktop from the laptop using tcp:<computername>\sqlexpress\userid I can only see the systemdb's...I am trying to view adventure works, just to see how this remote connection stuff works...any ideas?

Thanks,

Rob

See my response to your post in the 'Data Access' forum.