Link to another report on point labels in Pie Chart

Hello. I am new to SQL Server Reporting Services. The short explanation of what I want to do: In a pie chart, I have turned on point labels. I want each of the point labels to be a link. When you click on the link, you are taken to another report (in table format) that is more information about the data in that wedge of the pie.
If that is unclear, maybe it will help if I explain what I'm trying to do. The pie chart is a chart showing the status of developer issues in an issue tracking database. (Open, In-Progress, Awaiting Verification, Closed, Rejected, etc.) Each wedge of the pie has a point label that shows the number of issues that fall into the category (8 issues opened, 12 issues IP, etc.) When I click on the label that shows the number, I want to be taken to a table that shows what the issues in that category are.
Is this possible with SQL Server Reporting Services? Thanks in advance.Yes. Check out Chart Properties Dialog -> Values -> Edit -> Edit Chart Value
dialog box -> Action tab. You can choose Jump To Report option here and
specify the target report. You can also pass parameters to the target report
from this location.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Justin30519" <Justin30519@.discussions.microsoft.com> wrote in message
news:BC5B49B6-2B72-4D9C-A4B0-0CA3356E8114@.microsoft.com...
> Hello. I am new to SQL Server Reporting Services. The short explanation of
what I want to do: In a pie chart, I have turned on point labels. I want
each of the point labels to be a link. When you click on the link, you are
taken to another report (in table format) that is more information about the
data in that wedge of the pie.
> If that is unclear, maybe it will help if I explain what I'm trying to do.
The pie chart is a chart showing the status of developer issues in an issue
tracking database. (Open, In-Progress, Awaiting Verification, Closed,
Rejected, etc.) Each wedge of the pie has a point label that shows the
number of issues that fall into the category (8 issues opened, 12 issues IP,
etc.) When I click on the label that shows the number, I want to be taken to
a table that shows what the issues in that category are.
> Is this possible with SQL Server Reporting Services? Thanks in advance.|||Thank you very much for your reply. It was very helpful. My report works now.
Justin

Line/Point Chart

I am trying to create a simple chart that displays just the data points and
"hide" the line. Scatter chart does not appear to be the right choice for
this. Is there a way to create a line chart and then hide the line so that
only the data points themselves are visible?
JHIn RS 2000 SP1 or later, you can just set the border line width property on
the value to a value of 0.5 pt or lower.
In RS 2005, you can set the border line style to "None".
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"halej51" <halej51@.discussions.microsoft.com> wrote in message
news:5A79CABA-6B4E-4579-9610-B06BF3136F71@.microsoft.com...
>I am trying to create a simple chart that displays just the data points and
> "hide" the line. Scatter chart does not appear to be the right choice for
> this. Is there a way to create a line chart and then hide the line so that
> only the data points themselves are visible?
> JH|||Have you tried setting the line color to the same as the background color?
--
Alphonse Giambrone
Email: a-giam at customdatasolutions dot us
"halej51" <halej51@.discussions.microsoft.com> wrote in message
news:5A79CABA-6B4E-4579-9610-B06BF3136F71@.microsoft.com...
>I am trying to create a simple chart that displays just the data points and
> "hide" the line. Scatter chart does not appear to be the right choice for
> this. Is there a way to create a line chart and then hide the line so that
> only the data points themselves are visible?
> JH

Line weight in line chart

Hi
Is it possible to change the weight of a line in a line chart?
There seems to be the option to change just about everything else but not
the weight of the actual data line itself?
Thanks
PeteYou will need RS 2000 SP1 installed:
http://www.microsoft.com/downloads/details.aspx?FamilyId=580FEBF7-2972-40E7-BCCF-6CD90AC2F464&displaylang=en
Then in report designer layout view: right-click the chart, select
properties, go to the data tab,
press the edit button for the desired value, go to the appearance tab and
there you can set the width of a line.
You may also be interested in this related posting:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=58c440ba-4ab8-4474-9d23-559823ef6171&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"P" <P@.discussions.microsoft.com> wrote in message
news:C4529EAC-FDCD-4BE7-A770-40567BC23518@.microsoft.com...
> Hi
> Is it possible to change the weight of a line in a line chart?
> There seems to be the option to change just about everything else but not
> the weight of the actual data line itself?
>
> Thanks
> Pete

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 area chart

Hello,
I've been searching for an option to add a line to an area chart, but so far
I haven't found a way to do this. Could someone tell me how to do this, if
it's possible.
Thanks in advance,
HKI've had to deal with the opposite, that of removing a heavy blue line that
had been put there because of the report style I chose. I figured out that
the line was actually a border property, and the only way to get rid of it
was to set the border to White. A (None) option would have been preferrable.
"HK" <HK@.discussions.microsoft.com> wrote in message
news:B6B3793E-84FD-4555-A784-99DDD7636761@.microsoft.com...
> Hello,
> I've been searching for an option to add a line to an area chart, but so
> far
> I haven't found a way to do this. Could someone tell me how to do this, if
> it's possible.
> Thanks in advance,
> HK|||Thanks for your reply, but actually I meant a graph with an area and a
trendline. So instead of adding a line to a bar graph, I would like to add a
line to an area graph.
"Bev Kaufman" wrote:
> I've had to deal with the opposite, that of removing a heavy blue line that
> had been put there because of the report style I chose. I figured out that
> the line was actually a border property, and the only way to get rid of it
> was to set the border to White. A (None) option would have been preferrable.
>
> "HK" <HK@.discussions.microsoft.com> wrote in message
> news:B6B3793E-84FD-4555-A784-99DDD7636761@.microsoft.com...
> > Hello,
> >
> > I've been searching for an option to add a line to an area chart, but so
> > far
> > I haven't found a way to do this. Could someone tell me how to do this, if
> > it's possible.
> >
> > Thanks in advance,
> >
> > HK
>
>

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 graph on bar chart

Does anyone know if it is possible to create a graph where a line is on top
of a bar chart?
I'm using reporting services 2000, cheers
bobThis is not possible unless you have a 3rd party program such as Dundas
"bobfoc" <Greg.conn@.nospam.nospam> wrote in message
news:uB8GP9Q6FHA.2092@.TK2MSFTNGP12.phx.gbl...
> Does anyone know if it is possible to create a graph where a line is on
> top of a bar chart?
> I'm using reporting services 2000, cheers
> bob
>|||Hi Bob,
Can you be more specific? Do you need to create stacked values or
duplicate values bar - line charts?
You can download and try Nevron Chart for .NET from:
http://www.nevron.com
The evaluation is fully featured and you will be able to create
spectacular charts.
Regards,
Christo Bahchevanov
Nevron - Visualize Your Success|||And this works with reporting services yes?
Greg
"Christo Bahchevanov" <christo@.nevron.com> wrote in message
news:1133452933.814425.96550@.g14g2000cwa.googlegroups.com...
> Hi Bob,
> Can you be more specific? Do you need to create stacked values or
> duplicate values bar - line charts?
> You can download and try Nevron Chart for .NET from:
> http://www.nevron.com
> The evaluation is fully featured and you will be able to create
> spectacular charts.
> Regards,
> Christo Bahchevanov
> Nevron - Visualize Your Success
>|||Hi Greg,
Nevron Chart can be used as part of any program that want to generate
dynamic, data driven charts.
Feel free to download the free evaluation from http://www.nevron.com
Regards,
Christo Bahchevanov
Nevron - Visualize Your Success

Line graph - line width

How do I set the line width (weight) of lines with a line chart. Lines
always seem several pixels wide.
Also, when selecting "Numeric or time-scale values" on the X-axis of a line
chart the labels appear vertically in the Chart Properties dialog box but
appear horizontally when the report is generated. I have RS sp1 installed.
How do I fix this problem?Answer to your first problem:
Layout view: right-click the chart, select properties, go to the data tab,
press the edit button for the desired value, go to the appearance tab and
there you can set the width of a line.
They've put it away quite well :)
"Stephen Strong" <StephenStrong@.discussions.microsoft.com> wrote in message
news:B7EB33C9-E210-4F18-9E08-AC588746DC7F@.microsoft.com...
> How do I set the line width (weight) of lines with a line chart. Lines
> always seem several pixels wide.
> Also, when selecting "Numeric or time-scale values" on the X-axis of a
> line
> chart the labels appear vertically in the Chart Properties dialog box but
> appear horizontally when the report is generated. I have RS sp1 installed.
> How do I fix this problem?|||Thanks! I've noticed that setting the line weight to 0.75 pixels produces
sharp lines. Less than 0.75 and the line doesn't appear.
"Pieter van Maasdam" wrote:
> Answer to your first problem:
> Layout view: right-click the chart, select properties, go to the data tab,
> press the edit button for the desired value, go to the appearance tab and
> there you can set the width of a line.
> They've put it away quite well :)
> "Stephen Strong" <StephenStrong@.discussions.microsoft.com> wrote in message
> news:B7EB33C9-E210-4F18-9E08-AC588746DC7F@.microsoft.com...
> > How do I set the line width (weight) of lines with a line chart. Lines
> > always seem several pixels wide.
> >
> > Also, when selecting "Numeric or time-scale values" on the X-axis of a
> > line
> > chart the labels appear vertically in the Chart Properties dialog box but
> > appear horizontally when the report is generated. I have RS sp1 installed.
> > How do I fix this problem?
>
>|||This is a limitation of the chart control in RS 2000 which only allows
integer values for line width. This will change in RS 2005. For pixel-based
output format (like TIFF) you won't notice to much difference, but in vector
graphics formats (like EMF) you will see differences especially when zooming
or at high resolutions (e.g. printing).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Strong" <StephenStrong@.discussions.microsoft.com> wrote in message
news:80991847-4967-4F14-840E-20F72C0DE53B@.microsoft.com...
> Thanks! I've noticed that setting the line weight to 0.75 pixels produces
> sharp lines. Less than 0.75 and the line doesn't appear.
> "Pieter van Maasdam" wrote:
> > Answer to your first problem:
> >
> > Layout view: right-click the chart, select properties, go to the data
tab,
> > press the edit button for the desired value, go to the appearance tab
and
> > there you can set the width of a line.
> >
> > They've put it away quite well :)
> >
> > "Stephen Strong" <StephenStrong@.discussions.microsoft.com> wrote in
message
> > news:B7EB33C9-E210-4F18-9E08-AC588746DC7F@.microsoft.com...
> > > How do I set the line width (weight) of lines with a line chart.
Lines
> > > always seem several pixels wide.
> > >
> > > Also, when selecting "Numeric or time-scale values" on the X-axis of a
> > > line
> > > chart the labels appear vertically in the Chart Properties dialog box
but
> > > appear horizontally when the report is generated. I have RS sp1
installed.
> > > How do I fix this problem?
> >
> >
> >
>

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, line goes to 0 when data missing

In a line chart, where data is missing, the line goes from the preceding or
next point to zero. This can result in displaying incorrect information to
the user. Example:
Display sales over past two years. We have not measured sales last year
until May. And for this year, we have only measured up to September. For the
missing months, there are no rows in the dataset. I.e., time span in dataset
(number of rows) is May 2003 to September 2004, one row per month.
However, last year line starts February with value of 0. This is false
information. We did not have 0 sales in Feb 2003. We don't know how much
sales we had.
Also, current year sales end at Oct 2004 with value of 0. This is also false
information.
Can the diagram be configured to it just terminate the line "midair" when
input data is missing?
TIA
Tibor Karaszi
SQL Server MVPWe have identified this issue in the chart control recently and provided a
hotfix. Please feel free to contact CSS/PSS and refer them to KB 883675.
http://support.microsoft.com/default.aspx?scid=kb;en-us;883675
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Ox44SSiqEHA.2340@.TK2MSFTNGP11.phx.gbl...
> In a line chart, where data is missing, the line goes from the preceding
or
> next point to zero. This can result in displaying incorrect information to
> the user. Example:
> Display sales over past two years. We have not measured sales last year
> until May. And for this year, we have only measured up to September. For
the
> missing months, there are no rows in the dataset. I.e., time span in
dataset
> (number of rows) is May 2003 to September 2004, one row per month.
> However, last year line starts February with value of 0. This is false
> information. We did not have 0 sales in Feb 2003. We don't know how much
> sales we had.
> Also, current year sales end at Oct 2004 with value of 0. This is also
false
> information.
> Can the diagram be configured to it just terminate the line "midair" when
> input data is missing?
> TIA
> Tibor Karaszi
> SQL Server MVP
>|||Does this apply to missing rows as well?
The KB refers to rows with NULL for the value. My case is that I have no row
for certain points, and I don't want the prior or next point to make up a
point with a value of 0.
FYI:
I have an expression for the Style of the line, so that current year is
solid, past year is dotted:
=Iif( Fields!year_offset.Value = 0, "Solid", "Dotted")
I also have an expression for Color of the line. Since I have bunch of
diagrams I pick up the color from a text box (so I can change color in one
place):
=ReportItems!gcsSelected.Value
Thanks!
Tibor
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:u$GIP9iqEHA.1988@.TK2MSFTNGP09.phx.gbl...
> We have identified this issue in the chart control recently and provided a
> hotfix. Please feel free to contact CSS/PSS and refer them to KB 883675.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;883675
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:Ox44SSiqEHA.2340@.TK2MSFTNGP11.phx.gbl...
> > In a line chart, where data is missing, the line goes from the preceding
> or
> > next point to zero. This can result in displaying incorrect information
to
> > the user. Example:
> >
> > Display sales over past two years. We have not measured sales last year
> > until May. And for this year, we have only measured up to September. For
> the
> > missing months, there are no rows in the dataset. I.e., time span in
> dataset
> > (number of rows) is May 2003 to September 2004, one row per month.
> >
> > However, last year line starts February with value of 0. This is false
> > information. We did not have 0 sales in Feb 2003. We don't know how much
> > sales we had.
> > Also, current year sales end at Oct 2004 with value of 0. This is also
> false
> > information.
> >
> > Can the diagram be configured to it just terminate the line "midair"
when
> > input data is missing?
> >
> > TIA
> > Tibor Karaszi
> > SQL Server MVP
> >
> >
>|||> Does this apply to missing rows as well?
Just FYI for some future reader. The answer is "yes".
I created a repro at home and on a machine with a fix, the endpoints did not "go to zero".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
news:OsL4esrqEHA.3744@.TK2MSFTNGP10.phx.gbl...
> Does this apply to missing rows as well?
> The KB refers to rows with NULL for the value. My case is that I have no row
> for certain points, and I don't want the prior or next point to make up a
> point with a value of 0.
>
>
> FYI:
> I have an expression for the Style of the line, so that current year is
> solid, past year is dotted:
> =Iif( Fields!year_offset.Value = 0, "Solid", "Dotted")
> I also have an expression for Color of the line. Since I have bunch of
> diagrams I pick up the color from a text box (so I can change color in one
> place):
> =ReportItems!gcsSelected.Value
> Thanks!
> Tibor
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:u$GIP9iqEHA.1988@.TK2MSFTNGP09.phx.gbl...
>> We have identified this issue in the chart control recently and provided a
>> hotfix. Please feel free to contact CSS/PSS and refer them to KB 883675.
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;883675
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
>> message news:Ox44SSiqEHA.2340@.TK2MSFTNGP11.phx.gbl...
>> > In a line chart, where data is missing, the line goes from the preceding
>> or
>> > next point to zero. This can result in displaying incorrect information
> to
>> > the user. Example:
>> >
>> > Display sales over past two years. We have not measured sales last year
>> > until May. And for this year, we have only measured up to September. For
>> the
>> > missing months, there are no rows in the dataset. I.e., time span in
>> dataset
>> > (number of rows) is May 2003 to September 2004, one row per month.
>> >
>> > However, last year line starts February with value of 0. This is false
>> > information. We did not have 0 sales in Feb 2003. We don't know how much
>> > sales we had.
>> > Also, current year sales end at Oct 2004 with value of 0. This is also
>> false
>> > information.
>> >
>> > Can the diagram be configured to it just terminate the line "midair"
> when
>> > input data is missing?
>> >
>> > TIA
>> > Tibor Karaszi
>> > SQL Server MVP
>> >
>> >
>>
>

Line Chart X-Axis has too many point

Hi All,
I have a Chart line report that works great except when there are too many
data points. The x-axis labels then get too cramped and become unreadable.
I saw from another post that to fix this, you right mouse click on the chart
object, select properties, select "X Axis" tab, set "Major tick mark" to
"None" and "Minor tick mark" to "None". So I have "Major tick mark" set to
"None" and "Minor tick mark" set to "None" and also set on my "X Axis" tab
is: Checkbox "Show labels" is "Checked" and "Scale Minimum" = 0 (nothing
else is specified). However, this is not solving the problem (i.e. the
x-axis labels are still cramped together and unreadable).
I called Dundas Software and their tech support department said they cannot
provide technical support to me since I am using the Chart control packaged
with SQL Reporting Svsc 2005.
Can anyone offer any advice on how I can solve this?
Thanks in advance.Hello,
Since SQL Server 2005 has not been publicly released yet, we do not support
SQL Server 2005 in the newsgroup. For any SQL Server 2005 and related
issues, you could post here
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
cid=us
Thank you for your patience and cooperation.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Sorry, typo...I am on SQL Reporting Svcs 2000.
"Anthony LaMark" <anthony@.eXcSoftware.com> wrote in message
news:%23xWn$y%23tFHA.3252@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I have a Chart line report that works great except when there are too many
> data points. The x-axis labels then get too cramped and become
> unreadable. I saw from another post that to fix this, you right mouse
> click on the chart object, select properties, select "X Axis" tab, set
> "Major tick mark" to "None" and "Minor tick mark" to "None". So I have
> "Major tick mark" set to "None" and "Minor tick mark" set to "None" and
> also set on my "X Axis" tab is: Checkbox "Show labels" is "Checked" and
> "Scale Minimum" = 0 (nothing else is specified). However, this is not
> solving the problem (i.e. the x-axis labels are still cramped together and
> unreadable).
> I called Dundas Software and their tech support department said they
> cannot provide technical support to me since I am using the Chart control
> packaged with SQL Reporting Svsc 2005.
> Can anyone offer any advice on how I can solve this?
> Thanks in advance.
>|||Hello,
Please reproduce this issue with the sample AdventureWorks2000 database,
then post here the detailed steps to reproduce the issue. Send the report
to me so I can check the issue on my side. My email address is
v-sguo@.microsoft.com. After checking it I will let you know the results.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||It sounds like your are NOT using a timescale/numeric x-axis. You can solve
the issue with too many labels on the x-axis by setting the x-axis MINOR
interval value to e.g. 5 (i.e. one label per 5 categories / data samples).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Anthony LaMark" <anthony@.eXcSoftware.com> wrote in message
news:eTarYvGuFHA.3500@.TK2MSFTNGP09.phx.gbl...
> Sorry, typo...I am on SQL Reporting Svcs 2000.
> "Anthony LaMark" <anthony@.eXcSoftware.com> wrote in message
> news:%23xWn$y%23tFHA.3252@.TK2MSFTNGP10.phx.gbl...
>> Hi All,
>> I have a Chart line report that works great except when there are too
>> many data points. The x-axis labels then get too cramped and become
>> unreadable. I saw from another post that to fix this, you right mouse
>> click on the chart object, select properties, select "X Axis" tab, set
>> "Major tick mark" to "None" and "Minor tick mark" to "None". So I have
>> "Major tick mark" set to "None" and "Minor tick mark" set to "None" and
>> also set on my "X Axis" tab is: Checkbox "Show labels" is "Checked" and
>> "Scale Minimum" = 0 (nothing else is specified). However, this is not
>> solving the problem (i.e. the x-axis labels are still cramped together
>> and unreadable).
>> I called Dundas Software and their tech support department said they
>> cannot provide technical support to me since I am using the Chart control
>> packaged with SQL Reporting Svsc 2005.
>> Can anyone offer any advice on how I can solve this?
>> Thanks in advance.
>

Line Chart with a "Single Category Group"

Hi Folks
I have a line chart showing some data vs time. The chart is okay when
we have multiple periods (say Q1 2006 and Q2 2006). However, the chart
is empty when only period (the category group) is being displayed.
This leaves me with two questions...,
1. is this because line charts are supposed to show trends over
multiple category groups and thus are Not applicable for a single
category group?
2. is there a fix for this?
Any help would be greatly appreciated :)
Thnx a ton.Oops..., I meant the chart is empty when only a single period (say only
Q1 2006) is selected (i.e. is to be displayed).
> I have a line chart showing some data vs time. The chart is okay when
> we have multiple periods (say Q1 2006 and Q2 2006). However, the chart
> is empty when only period (the category group) is being displayed.|||Allright, the problem has been solved :D
Turns out I need to edit the data field, and enable the "Show Markers"
checkbox :)
Profundus wrote:
> Hi Folks
> I have a line chart showing some data vs time. The chart is okay when
> we have multiple periods (say Q1 2006 and Q2 2006). However, the chart
> is empty when only period (the category group) is being displayed.
> This leaves me with two questions...,
> 1. is this because line charts are supposed to show trends over
> multiple category groups and thus are Not applicable for a single
> category group?
> 2. is there a fix for this?
> Any help would be greatly appreciated :)
> Thnx a ton.

Line Chart used in Subreport ...

Hi,
I am using a Main report page which has different subreports and depending
on some data selection, I will show different sub reports.
But when I am using a line diagram in a sub report, this report will show
all the time. The same visible expression works fine on a sub report, which
has
only data values on.
Thanks for any help
RichardHi,
I found a solution by my self.
I just modify the database selection (via code) in that way, that the query
will not find data for this graph.
If anybody knows a better way, feel free to let me know .
Ritchie
"Ritchie" wrote:
> Hi,
> I am using a Main report page which has different subreports and depending
> on some data selection, I will show different sub reports.
> But when I am using a line diagram in a sub report, this report will show
> all the time. The same visible expression works fine on a sub report, which
> has
> only data values on.
> Thanks for any help
> Richard

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

Line Chart Help

Unfortunately this isn't as easy as it sounds. I am trying to build a chart just like the one in the attachment (I made it in Excel to show what I want). It's a simple line chart that reflects a trend of data over a period of time. However, there may be multiple entries on one day (such as the 24th in the example), but a single entry on another day.

Crystal wants to summarize the data and present ONE value for ONE day even if there are multiple entries in a day. How can I make it stop doing this? Are there any 3rd party vendors that have additional charts that can be installed?

Check out the attachments:
Chart.jpg - Excel Chart
cry_chart.jpg - Crystal Chart (notice 2 values for 7/23, but Crystal only shows 1 on the chart)

FYIIm running 8.5 because thats the only version my app will support.

I'd appreciate any help!Actually, CR not just shows you 1 value for 7/23/07 on the chart, it returns you sum of those 2 values for that date:

HGB ..... 10.3 .... 7/23/07
HGB ..... 7.9 ..... 7/23/07

If your Date field containes only date, I don't think you can get CR to show your values separately. But if this is a date_time field just formatted as date you can do next:
Open your Chart Expert ->Data. In the 'On change of' section, highlight your date_time field, then click the 'Order' button. I believe you have 'for each day' selected for the 'The section will be printed'.
Set it 'for each second' then you will get your desired result.|||That's what I meant when I said that Crystal sumarizes the data for one day and only shows one value.

Cool man. I'll try that and see if it works. I appreciate it!|||This worked! Thanks for the help.

Line Chart Empty

I have a dataset that can be viewed as columns chart. But when I change to
line chart, the data is shown only partly, or not shown at all.
I noticed that if I have one set of data that covers the full lenght of
x-axis, and another set of data that covers only the right side of x-axis,
then what you will see will be the start of the line representing the first
set, then it stops completely and another line starts representing the second
set.
Anybody knows why it happends and how to fix it?
D>Are you using the RTM version of RS 2000, and SP1 or SP2 is not installed?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"uiwork" <uiwork@.discussions.microsoft.com> wrote in message
news:004E3B42-5CBE-4590-BC7D-28D15B266131@.microsoft.com...
>I have a dataset that can be viewed as columns chart. But when I change to
> line chart, the data is shown only partly, or not shown at all.
> I noticed that if I have one set of data that covers the full lenght of
> x-axis, and another set of data that covers only the right side of x-axis,
> then what you will see will be the start of the line representing the
> first
> set, then it stops completely and another line starts representing the
> second
> set.
> Anybody knows why it happends and how to fix it?
> D>|||It is RS 2000, and I have only SP1 installed. Is it a problem?
"Robert Bruckner [MSFT]" wrote:
> Are you using the RTM version of RS 2000, and SP1 or SP2 is not installed?
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "uiwork" <uiwork@.discussions.microsoft.com> wrote in message
> news:004E3B42-5CBE-4590-BC7D-28D15B266131@.microsoft.com...
> >I have a dataset that can be viewed as columns chart. But when I change to
> > line chart, the data is shown only partly, or not shown at all.
> > I noticed that if I have one set of data that covers the full lenght of
> > x-axis, and another set of data that covers only the right side of x-axis,
> > then what you will see will be the start of the line representing the
> > first
> > set, then it stops completely and another line starts representing the
> > second
> > set.
> > Anybody knows why it happends and how to fix it?
> > D>
>
>|||Yes, you are running into a known issue with line charts using multiple data
series and the datapoints having interleaved category (x-axis) values. The
fix is available in RS 2000 SP2.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"uiwork" <uiwork@.discussions.microsoft.com> wrote in message
news:991368D7-2E58-4566-AB34-68027D9FC856@.microsoft.com...
> It is RS 2000, and I have only SP1 installed. Is it a problem?
> "Robert Bruckner [MSFT]" wrote:
>> Are you using the RTM version of RS 2000, and SP1 or SP2 is not
>> installed?
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "uiwork" <uiwork@.discussions.microsoft.com> wrote in message
>> news:004E3B42-5CBE-4590-BC7D-28D15B266131@.microsoft.com...
>> >I have a dataset that can be viewed as columns chart. But when I change
>> >to
>> > line chart, the data is shown only partly, or not shown at all.
>> > I noticed that if I have one set of data that covers the full lenght of
>> > x-axis, and another set of data that covers only the right side of
>> > x-axis,
>> > then what you will see will be the start of the line representing the
>> > first
>> > set, then it stops completely and another line starts representing the
>> > second
>> > set.
>> > Anybody knows why it happends and how to fix it?
>> > D>
>>