I have recently upgraded from RS2000 to RS2005. The reports seem to have
converted without any errors. In the report designer, everything works fine.
When deploying to the server the reports don't update properly.
Details:
The reports have two components (a table and a chart) - both are based on
the same query. There are three parameters in a report. One is a dropdown
box that includes a list of products based on a subquery. The other two
parameters are textboxes that provide start and end months for the reporting
period. When changing either of the month parameters, the table and chart
updates with proper data. When changing the product (dropdown box), the
table information updates, but the chart does not (it still includes the
title and data from the previous update when a month was changed; or it
includes the results of the first query if a month was not changed).
Has anyone experienced anything like this? Is there a fix?Hello Piell,
I tested on my side and do not reproduce this issue.
Also, I did not find any related issue in our internal database.
I would like to know if this issue appeared on all reports?
If you apply SP1 on your SSRS 2005, does this issue persist?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Wei,
We have the same problem on all reports and we have even deleted the chart
and re-created it and get the same results. I will be checking with the
admins later today to find out if SP1 has been applied. If it hasn't, we
will have them update it.
Thanks.|||Wei,
We have installed SQL 2005 SP1 and still have the same problem. Would the
available hot fix help
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/rs2005-kb918222-x86-enu.exe|||We installed hot fix and charts still don't update when dropdown parameter
changes.|||Hello piell,
I would like to suggest you to check your IE security setting and try to
set the security level to low.
If this issue still persist, would you please send a sample report to me so
that I could try to reproduce this issue on my side.
To reach me, please remove the ONLINE in my email address.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
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.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
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.
Saturday, February 25, 2012
Charts displayed in tables
Is it possible to have a Chart control within a table. I am trying to create
a report which displays some information about a School and has a bar chart
to display the pupil age ranges for each school.Add a grouping to the table, where you group e.g. by Fields!SchoolName.Value
Then, enlarge the table group header and drop a chart in the table group
header (!). You can then design the chart.
At runtime, you will get one table group per school name with one chart per
table group header which should give you exactly what you want.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"MicroMoth" <stephen.adams@.forvus.co.uk> wrote in message
news:D562F265-AC31-4935-A217-628819F863C6@.microsoft.com...
> Is it possible to have a Chart control within a table. I am trying to
create
> a report which displays some information about a School and has a bar
chart
> to display the pupil age ranges for each school.|||It is possible to have a table where a row "expands" to reveal a table.
Add a second detail row to the table, and a second grouping with the same
grouping expreassion as the main table grouping. Place a rectangle in the
second detail row. The rectangle automatically takes up the whole row, and
you are now free to place your chart (plus any other controls) anywhere in
the rectangle. Set the initial visibility of the second grouping to False,
and toggle it according to one of the fields in the first detail row. Works a
treat.
"MicroMoth" wrote:
> Is it possible to have a Chart control within a table. I am trying to create
> a report which displays some information about a School and has a bar chart
> to display the pupil age ranges for each school.
a report which displays some information about a School and has a bar chart
to display the pupil age ranges for each school.Add a grouping to the table, where you group e.g. by Fields!SchoolName.Value
Then, enlarge the table group header and drop a chart in the table group
header (!). You can then design the chart.
At runtime, you will get one table group per school name with one chart per
table group header which should give you exactly what you want.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"MicroMoth" <stephen.adams@.forvus.co.uk> wrote in message
news:D562F265-AC31-4935-A217-628819F863C6@.microsoft.com...
> Is it possible to have a Chart control within a table. I am trying to
create
> a report which displays some information about a School and has a bar
chart
> to display the pupil age ranges for each school.|||It is possible to have a table where a row "expands" to reveal a table.
Add a second detail row to the table, and a second grouping with the same
grouping expreassion as the main table grouping. Place a rectangle in the
second detail row. The rectangle automatically takes up the whole row, and
you are now free to place your chart (plus any other controls) anywhere in
the rectangle. Set the initial visibility of the second grouping to False,
and toggle it according to one of the fields in the first detail row. Works a
treat.
"MicroMoth" wrote:
> Is it possible to have a Chart control within a table. I am trying to create
> a report which displays some information about a School and has a bar chart
> to display the pupil age ranges for each school.
Charts are not showing up when deploying
hi all,
I am using report services 2000, and my project works great in visual studio
2003 but when I deploy the solution my charts don't show up. has anyone gone
through this before?
thanksHi Netasp,
Thank you for your posting!
Based on my experience, this issue may caused by your machine name. If your
machine name contain underscore, it will cause this issue.
If this is your case, please follow these steps to resolve this issue:
1. Rename the machine to a name without an underscore
2. Change the UrlRoot element from the RSReportServer.config file to point
to the new name:
<UrlRoot>http://newname/ReportServer</UrlRoot>
Note the file is typically located at: C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config:
3. Change the ReportServerUrl element from the RSWebApplication.config file:
<ReportServerUrl>http://NewName/ReportServer</ReportServerUrl>
File location is usually: C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportManager\RSWebApplication.config
4. Restart the machine.
Please let me know if this will be helpful! Thank you for your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||hi Wei Lu
thank you for your reply,
I was able to get it by playing around with security settings.
thanks
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:mdqYgndtGHA.1992@.TK2MSFTNGXA01.phx.gbl...
> Hi Netasp,
> Thank you for your posting!
> Based on my experience, this issue may caused by your machine name. If
> your
> machine name contain underscore, it will cause this issue.
> If this is your case, please follow these steps to resolve this issue:
> 1. Rename the machine to a name without an underscore
> 2. Change the UrlRoot element from the RSReportServer.config file to point
> to the new name:
> <UrlRoot>http://newname/ReportServer</UrlRoot>
> Note the file is typically located at: C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config:
> 3. Change the ReportServerUrl element from the RSWebApplication.config
> file:
> <ReportServerUrl>http://NewName/ReportServer</ReportServerUrl>
> File location is usually: C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportManager\RSWebApplication.config
> 4. Restart the machine.
> Please let me know if this will be helpful! Thank you for your patience.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
I am using report services 2000, and my project works great in visual studio
2003 but when I deploy the solution my charts don't show up. has anyone gone
through this before?
thanksHi Netasp,
Thank you for your posting!
Based on my experience, this issue may caused by your machine name. If your
machine name contain underscore, it will cause this issue.
If this is your case, please follow these steps to resolve this issue:
1. Rename the machine to a name without an underscore
2. Change the UrlRoot element from the RSReportServer.config file to point
to the new name:
<UrlRoot>http://newname/ReportServer</UrlRoot>
Note the file is typically located at: C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config:
3. Change the ReportServerUrl element from the RSWebApplication.config file:
<ReportServerUrl>http://NewName/ReportServer</ReportServerUrl>
File location is usually: C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportManager\RSWebApplication.config
4. Restart the machine.
Please let me know if this will be helpful! Thank you for your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||hi Wei Lu
thank you for your reply,
I was able to get it by playing around with security settings.
thanks
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:mdqYgndtGHA.1992@.TK2MSFTNGXA01.phx.gbl...
> Hi Netasp,
> Thank you for your posting!
> Based on my experience, this issue may caused by your machine name. If
> your
> machine name contain underscore, it will cause this issue.
> If this is your case, please follow these steps to resolve this issue:
> 1. Rename the machine to a name without an underscore
> 2. Change the UrlRoot element from the RSReportServer.config file to point
> to the new name:
> <UrlRoot>http://newname/ReportServer</UrlRoot>
> Note the file is typically located at: C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config:
> 3. Change the ReportServerUrl element from the RSWebApplication.config
> file:
> <ReportServerUrl>http://NewName/ReportServer</ReportServerUrl>
> File location is usually: C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportManager\RSWebApplication.config
> 4. Restart the machine.
> Please let me know if this will be helpful! Thank you for your patience.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
Charts and Graphs Question
I have a chart that has dates list on the x axis in a horizontal fashion. I
would like to change them to be vertical. Can anyone tell me how todo this'
Thanks,Andy,
I don't think you can set it, it seems to be automatic. If the dates
don't fit horizontally, it turns them for you.
The only thing you can affect is the data labels inside the chart area.
Chris
Andy Jones wrote:
> I have a chart that has dates list on the x axis in a horizontal
> fashion. I would like to change them to be vertical. Can anyone tell
> me how todo this'
> Thanks,
would like to change them to be vertical. Can anyone tell me how todo this'
Thanks,Andy,
I don't think you can set it, it seems to be automatic. If the dates
don't fit horizontally, it turns them for you.
The only thing you can affect is the data labels inside the chart area.
Chris
Andy Jones wrote:
> I have a chart that has dates list on the x axis in a horizontal
> fashion. I would like to change them to be vertical. Can anyone tell
> me how todo this'
> Thanks,
Charts and colour control
Hello,
I wonder if it is possible to have better control over the colours than just
selecting the palette?
My problem is that I have several charts showing the same data series in
different time periods. But for some reason the same series get different
colours in the different charts. The report would look much more appealing
if the colours were consistent.
Many thanks in advance.
Best regards,
Vemund HagaHi Venmund,
Thanks for your post.
From your descriptions, I understood that you would like to set the colors
in the report manually when those series to be the same. Have I understood
you? Correct me if I was wrong.
Based on my scope, unfortunately, I am afraid SQL Server 2000 Reporting
Services only supports palette color selection. Additional functionality in
this area is still under consideration
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||"Vemund Haga" wrote:
> Hello,
> I wonder if it is possible to have better control over the colours than just
> selecting the palette?
You can manually set the colour of each series in the graph properties. See
http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.|||Hi Glenn
I'm having this same problem and after reading some other related posts I
came to the following conclusion:
Although one can write an expression to control the colors in the Fill
property of the Series Style but this expression will have to be based on the
fixed number of possible values in the Series Groups. The expression can end
with "Transparent" value if non of the conditions in the expression are
satisfied but that is about it.
Is this correct?
Thanks
Shawn
"Glenn F. Henriksen" wrote:
> "Vemund Haga" wrote:
> > Hello,
> > I wonder if it is possible to have better control over the colours than just
> > selecting the palette?
> You can manually set the colour of each series in the graph properties. See
> http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.|||"Shawn Kralj" wrote:
> Although one can write an expression to control the colors in the Fill
> property of the Series Style but this expression will have to be based on the
> fixed number of possible values in the Series Groups. The expression can end
> with "Transparent" value if non of the conditions in the expression are
> satisfied but that is about it.
> Is this correct?
I'm sorry, but I'm not quite understanding what you are trying to do here.
Why don't you explain what you want to obtain instead, the desired effect.
--
Glenn F. Henriksen
http://www.henriksen.no/|||Hi Venmund,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. Have you read
the blog Glenn provided? We appreciate your patience and look forward to
hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Glenn
I have a Series Group in my report based on Sales Category field values.
There are 5 sales categories, and if I want to assign custom color to chart
bars for each category my expression will have to include a logical test and
assignment of custom color for each category.
I did get it to work but I want to make sure I'm doing it in the most
efficient way. I assigned a number to each category in my query (from 1 to 5)
and I can now use a Choose method to assign colors easily.
My expression is as follows:
=choose(First(Fields!SalesCategoryCode.Value, "chart1_SeriesGroup1"),
"Navy", "White", "Blue", "Yellow", "Black")
Is this the best way of doing it?
Thanks
Shawn
"Glenn F. Henriksen" wrote:
> "Shawn Kralj" wrote:
> > Although one can write an expression to control the colors in the Fill
> > property of the Series Style but this expression will have to be based on the
> > fixed number of possible values in the Series Groups. The expression can end
> > with "Transparent" value if non of the conditions in the expression are
> > satisfied but that is about it.
> >
> > Is this correct?
> I'm sorry, but I'm not quite understanding what you are trying to do here.
> Why don't you explain what you want to obtain instead, the desired effect.
> --
> Glenn F. Henriksen
> http://www.henriksen.no/|||Hi Genn
I have a series group in the report. I customized the color of each bar,
and it looks exactly like what i need in VS.net. After I depolyed to the
report server, however, it ignored the customized color and used default
color instead. Is there any way to solve the problem'
Thanks a lot.
Sean
"Glenn F. Henriksen" wrote:
> "Vemund Haga" wrote:
> > Hello,
> > I wonder if it is possible to have better control over the colours than just
> > selecting the palette?
> You can manually set the colour of each series in the graph properties. See
> http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.|||Are you sure you have SP1 installed on the report server (not only on the
report designer machine)?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:2DB7DF0D-419D-424C-A924-B61786518442@.microsoft.com...
> Hi Genn
> I have a series group in the report. I customized the color of each bar,
> and it looks exactly like what i need in VS.net. After I depolyed to the
> report server, however, it ignored the customized color and used default
> color instead. Is there any way to solve the problem'
> Thanks a lot.
> Sean
> "Glenn F. Henriksen" wrote:
> > "Vemund Haga" wrote:
> > > Hello,
> > > I wonder if it is possible to have better control over the colours
than just
> > > selecting the palette?
> >
> > You can manually set the colour of each series in the graph properties.
See
> >
http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.
I wonder if it is possible to have better control over the colours than just
selecting the palette?
My problem is that I have several charts showing the same data series in
different time periods. But for some reason the same series get different
colours in the different charts. The report would look much more appealing
if the colours were consistent.
Many thanks in advance.
Best regards,
Vemund HagaHi Venmund,
Thanks for your post.
From your descriptions, I understood that you would like to set the colors
in the report manually when those series to be the same. Have I understood
you? Correct me if I was wrong.
Based on my scope, unfortunately, I am afraid SQL Server 2000 Reporting
Services only supports palette color selection. Additional functionality in
this area is still under consideration
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||"Vemund Haga" wrote:
> Hello,
> I wonder if it is possible to have better control over the colours than just
> selecting the palette?
You can manually set the colour of each series in the graph properties. See
http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.|||Hi Glenn
I'm having this same problem and after reading some other related posts I
came to the following conclusion:
Although one can write an expression to control the colors in the Fill
property of the Series Style but this expression will have to be based on the
fixed number of possible values in the Series Groups. The expression can end
with "Transparent" value if non of the conditions in the expression are
satisfied but that is about it.
Is this correct?
Thanks
Shawn
"Glenn F. Henriksen" wrote:
> "Vemund Haga" wrote:
> > Hello,
> > I wonder if it is possible to have better control over the colours than just
> > selecting the palette?
> You can manually set the colour of each series in the graph properties. See
> http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.|||"Shawn Kralj" wrote:
> Although one can write an expression to control the colors in the Fill
> property of the Series Style but this expression will have to be based on the
> fixed number of possible values in the Series Groups. The expression can end
> with "Transparent" value if non of the conditions in the expression are
> satisfied but that is about it.
> Is this correct?
I'm sorry, but I'm not quite understanding what you are trying to do here.
Why don't you explain what you want to obtain instead, the desired effect.
--
Glenn F. Henriksen
http://www.henriksen.no/|||Hi Venmund,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. Have you read
the blog Glenn provided? We appreciate your patience and look forward to
hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Glenn
I have a Series Group in my report based on Sales Category field values.
There are 5 sales categories, and if I want to assign custom color to chart
bars for each category my expression will have to include a logical test and
assignment of custom color for each category.
I did get it to work but I want to make sure I'm doing it in the most
efficient way. I assigned a number to each category in my query (from 1 to 5)
and I can now use a Choose method to assign colors easily.
My expression is as follows:
=choose(First(Fields!SalesCategoryCode.Value, "chart1_SeriesGroup1"),
"Navy", "White", "Blue", "Yellow", "Black")
Is this the best way of doing it?
Thanks
Shawn
"Glenn F. Henriksen" wrote:
> "Shawn Kralj" wrote:
> > Although one can write an expression to control the colors in the Fill
> > property of the Series Style but this expression will have to be based on the
> > fixed number of possible values in the Series Groups. The expression can end
> > with "Transparent" value if non of the conditions in the expression are
> > satisfied but that is about it.
> >
> > Is this correct?
> I'm sorry, but I'm not quite understanding what you are trying to do here.
> Why don't you explain what you want to obtain instead, the desired effect.
> --
> Glenn F. Henriksen
> http://www.henriksen.no/|||Hi Genn
I have a series group in the report. I customized the color of each bar,
and it looks exactly like what i need in VS.net. After I depolyed to the
report server, however, it ignored the customized color and used default
color instead. Is there any way to solve the problem'
Thanks a lot.
Sean
"Glenn F. Henriksen" wrote:
> "Vemund Haga" wrote:
> > Hello,
> > I wonder if it is possible to have better control over the colours than just
> > selecting the palette?
> You can manually set the colour of each series in the graph properties. See
> http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.|||Are you sure you have SP1 installed on the report server (not only on the
report designer machine)?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:2DB7DF0D-419D-424C-A924-B61786518442@.microsoft.com...
> Hi Genn
> I have a series group in the report. I customized the color of each bar,
> and it looks exactly like what i need in VS.net. After I depolyed to the
> report server, however, it ignored the customized color and used default
> color instead. Is there any way to solve the problem'
> Thanks a lot.
> Sean
> "Glenn F. Henriksen" wrote:
> > "Vemund Haga" wrote:
> > > Hello,
> > > I wonder if it is possible to have better control over the colours
than just
> > > selecting the palette?
> >
> > You can manually set the colour of each series in the graph properties.
See
> >
http://www.henriksen.no/Blog/PermaLink,guid,b2d2053e-8167-451d-8c5c-b79b8b0a043e.aspx for a step ny step explanation.
Charts & Graphics
Does anyone have a good recommendation for software that allows me to create
*very* attractive charts, gauges, graphs, etc.?
Thanks,
-wpOn Mar 21, 2:44 pm, "Wild Packet" <w...@.contoso.com> wrote:
> Does anyone have a good recommendation for software that allows me to create
> *very* attractive charts, gauges, graphs, etc.?
> Thanks,
> -wp
Obviously, SQL Server Reporting Services 2005, Crystal Reports XI and
Dundas (http://www.dundas.com/Products/Chart/NET/index.aspx?
Campaign=GoogleDCP&gclid=CIXsm9urh4sCFR3VgAodRy99Ew) have pretty
decent charting/graphing capabilities; however, for the top of the
line/cream-of-the-crop, I would suggest Adobe Flex:
http://examples.adobe.com/flex2/inproduct/sdk/dashboard/dashboard.html
- http://www.adobe.com/products/flex/ . Hope this is helpful.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks! I will givce those a try.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1174530873.250975.46390@.n76g2000hsh.googlegroups.com...
> On Mar 21, 2:44 pm, "Wild Packet" <w...@.contoso.com> wrote:
>> Does anyone have a good recommendation for software that allows me to
>> create
>> *very* attractive charts, gauges, graphs, etc.?
>> Thanks,
>> -wp
> Obviously, SQL Server Reporting Services 2005, Crystal Reports XI and
> Dundas (http://www.dundas.com/Products/Chart/NET/index.aspx?
> Campaign=GoogleDCP&gclid=CIXsm9urh4sCFR3VgAodRy99Ew) have pretty
> decent charting/graphing capabilities; however, for the top of the
> line/cream-of-the-crop, I would suggest Adobe Flex:
> http://examples.adobe.com/flex2/inproduct/sdk/dashboard/dashboard.html
> - http://www.adobe.com/products/flex/ . Hope this is helpful.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
*very* attractive charts, gauges, graphs, etc.?
Thanks,
-wpOn Mar 21, 2:44 pm, "Wild Packet" <w...@.contoso.com> wrote:
> Does anyone have a good recommendation for software that allows me to create
> *very* attractive charts, gauges, graphs, etc.?
> Thanks,
> -wp
Obviously, SQL Server Reporting Services 2005, Crystal Reports XI and
Dundas (http://www.dundas.com/Products/Chart/NET/index.aspx?
Campaign=GoogleDCP&gclid=CIXsm9urh4sCFR3VgAodRy99Ew) have pretty
decent charting/graphing capabilities; however, for the top of the
line/cream-of-the-crop, I would suggest Adobe Flex:
http://examples.adobe.com/flex2/inproduct/sdk/dashboard/dashboard.html
- http://www.adobe.com/products/flex/ . Hope this is helpful.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks! I will givce those a try.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1174530873.250975.46390@.n76g2000hsh.googlegroups.com...
> On Mar 21, 2:44 pm, "Wild Packet" <w...@.contoso.com> wrote:
>> Does anyone have a good recommendation for software that allows me to
>> create
>> *very* attractive charts, gauges, graphs, etc.?
>> Thanks,
>> -wp
> Obviously, SQL Server Reporting Services 2005, Crystal Reports XI and
> Dundas (http://www.dundas.com/Products/Chart/NET/index.aspx?
> Campaign=GoogleDCP&gclid=CIXsm9urh4sCFR3VgAodRy99Ew) have pretty
> decent charting/graphing capabilities; however, for the top of the
> line/cream-of-the-crop, I would suggest Adobe Flex:
> http://examples.adobe.com/flex2/inproduct/sdk/dashboard/dashboard.html
> - http://www.adobe.com/products/flex/ . Hope this is helpful.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Charts - width of columns
Is there a way to control the width of the columns that are produced when
using a column chart?Yes there is a way to control the width of columns and bars. The property is
called "PointWidth". However, the property is only supported on the report
server (and designer preview).
What you need to do is:
* open your RDL file in a text / xml-editor or in "code view" of designer
* search for the chart (<chart name="...">)
* add a PointWidth value between 0 and 100 (by default it is 55)
Example:
<Chart Name="Sales">
<PointWidth>30</PointWidth>
...
</Chart>
See also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsrdl/htm/rsp_ref_rdl_elements_fp_87lg.asp
Note: PointWidth is a constant value, so if you have an unknown number of
categories at runtime you might want to use two identical charts (one with
regular PointWidth, the other with a small PointWidth) and based on a
condition (number of categories) always hide one chart.
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"PD" <PD@.discussions.microsoft.com> wrote in message
news:5C4C2447-15F9-4A7B-B4BE-2823EE08D73D@.microsoft.com...
> Is there a way to control the width of the columns that are produced when
> using a column chart?
using a column chart?Yes there is a way to control the width of columns and bars. The property is
called "PointWidth". However, the property is only supported on the report
server (and designer preview).
What you need to do is:
* open your RDL file in a text / xml-editor or in "code view" of designer
* search for the chart (<chart name="...">)
* add a PointWidth value between 0 and 100 (by default it is 55)
Example:
<Chart Name="Sales">
<PointWidth>30</PointWidth>
...
</Chart>
See also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsrdl/htm/rsp_ref_rdl_elements_fp_87lg.asp
Note: PointWidth is a constant value, so if you have an unknown number of
categories at runtime you might want to use two identical charts (one with
regular PointWidth, the other with a small PointWidth) and based on a
condition (number of categories) always hide one chart.
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"PD" <PD@.discussions.microsoft.com> wrote in message
news:5C4C2447-15F9-4A7B-B4BE-2823EE08D73D@.microsoft.com...
> Is there a way to control the width of the columns that are produced when
> using a column chart?
Charts - too much data - possible to break up into 2 charts
If the user is reporting on a lot of information then the line chart/graph
in the report contains too much data and the X-Axis labels just look like
one big blob because all of the item labels are squeezed together too
tightly.
Has anyone found a way to say for example... If there are more than X number
of items on the X Axis in the chart then to split the chart into 2 charts.
The second chart would appear directly beneath the 1st chart. This way the
user would be able to telll what the data is they are looking at.
This seems to be a common problem in all charting situations and the
solution usually is just filtering on less data. I don't see why we have to
tell the user to filter on less data and run multiple reports. It seems
possible that en enterprise reporting application like RS should have this
capability... or... the capability to code it in the report.
Any ideas?There is no perfect solution for this. Some ideas:
* You could use filters and multiple charts and use conditional visibility
to hide unneeded charts
* Group the data and use drillthrough reports with charts showing the
details per group
* If you use a bar chart visualization instead of line chart, you could use
a table with groupings. In the group header you would add a chart. The more
data you have in the dataset, the more groups you get and the more chart
bars are drawn. A sample for this approach is copied to the bottom of this
posting.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"D Witherspoon" <dwitherspoon@.noway.org> wrote in message
news:elaCN4ivFHA.2008@.TK2MSFTNGP10.phx.gbl...
> If the user is reporting on a lot of information then the line chart/graph
> in the report contains too much data and the X-Axis labels just look like
> one big blob because all of the item labels are squeezed together too
> tightly.
> Has anyone found a way to say for example... If there are more than X
> number of items on the X Axis in the chart then to split the chart into 2
> charts. The second chart would appear directly beneath the 1st chart.
> This way the user would be able to telll what the data is they are looking
> at.
> This seems to be a common problem in all charting situations and the
> solution usually is just filtering on less data. I don't see why we have
> to tell the user to filter on less data and run multiple reports. It
> seems possible that en enterprise reporting application like RS should
> have this capability... or... the capability to code it in the report.
>
> Any ideas?
====
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table2">
<Height>0.75in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Product Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox4</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>0-200</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<DataSetName>Northwind</DataSetName>
<Top>0.125in</Top>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.5in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="ProductName_2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>ProductName_2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!ProductName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Chart Name="chart1">
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Legend>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>RightCenter</Position>
</Legend>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!UnitsInStock.Value)</Value>
</DataValue>
</DataValues>
<DataLabel />
<Marker />
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!UnitsOnOrder.Value)</Value>
</DataValue>
</DataValues>
<DataLabel />
<Marker />
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<CategoryAxis>
<Axis>
<Title />
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<Min>0</Min>
</Axis>
</CategoryAxis>
<DataSetName>Northwind</DataSetName>
<PointWidth>0</PointWidth>
<Type>Bar</Type>
<Title />
<SeriesGroupings>
<SeriesGrouping>
<StaticSeries>
<StaticMember>
<Label>Units In Stock</Label>
</StaticMember>
<StaticMember>
<Label>Units On Order</Label>
</StaticMember>
</StaticSeries>
</SeriesGrouping>
</SeriesGroupings>
<Subtype>Stacked</Subtype>
<PlotArea>
<Style>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<ValueAxis>
<Axis>
<Title />
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Max>200</Max>
<Margin>true</Margin>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
</Chart>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table2_Group1">
<GroupExpressions>
<GroupExpression>=Fields!ProductName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<TableColumns>
<TableColumn>
<Width>1.33333in</Width>
</TableColumn>
<TableColumn>
<Width>3.5in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>1.25in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>99dae70f-00e4-4971-a2f6-486f3896814a</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=(local);initial
catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>4.83333in</Width>
<DataSets>
<DataSet Name="Northwind">
<Fields>
<Field Name="ProductID">
<DataField>ProductID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ProductName">
<DataField>ProductName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="SupplierID">
<DataField>SupplierID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="CategoryID">
<DataField>CategoryID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="QuantityPerUnit">
<DataField>QuantityPerUnit</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="UnitPrice">
<DataField>UnitPrice</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
<Field Name="UnitsInStock">
<DataField>UnitsInStock</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="UnitsOnOrder">
<DataField>UnitsOnOrder</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="ReorderLevel">
<DataField>ReorderLevel</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="Discontinued">
<DataField>Discontinued</DataField>
<rd:TypeName>System.Boolean</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>select * from products</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<PageHeight>100in</PageHeight>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>9ecf615a-64ce-4ec1-98bf-05333c406eb6</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
in the report contains too much data and the X-Axis labels just look like
one big blob because all of the item labels are squeezed together too
tightly.
Has anyone found a way to say for example... If there are more than X number
of items on the X Axis in the chart then to split the chart into 2 charts.
The second chart would appear directly beneath the 1st chart. This way the
user would be able to telll what the data is they are looking at.
This seems to be a common problem in all charting situations and the
solution usually is just filtering on less data. I don't see why we have to
tell the user to filter on less data and run multiple reports. It seems
possible that en enterprise reporting application like RS should have this
capability... or... the capability to code it in the report.
Any ideas?There is no perfect solution for this. Some ideas:
* You could use filters and multiple charts and use conditional visibility
to hide unneeded charts
* Group the data and use drillthrough reports with charts showing the
details per group
* If you use a bar chart visualization instead of line chart, you could use
a table with groupings. In the group header you would add a chart. The more
data you have in the dataset, the more groups you get and the more chart
bars are drawn. A sample for this approach is copied to the bottom of this
posting.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"D Witherspoon" <dwitherspoon@.noway.org> wrote in message
news:elaCN4ivFHA.2008@.TK2MSFTNGP10.phx.gbl...
> If the user is reporting on a lot of information then the line chart/graph
> in the report contains too much data and the X-Axis labels just look like
> one big blob because all of the item labels are squeezed together too
> tightly.
> Has anyone found a way to say for example... If there are more than X
> number of items on the X Axis in the chart then to split the chart into 2
> charts. The second chart would appear directly beneath the 1st chart.
> This way the user would be able to telll what the data is they are looking
> at.
> This seems to be a common problem in all charting situations and the
> solution usually is just filtering on less data. I don't see why we have
> to tell the user to filter on less data and run multiple reports. It
> seems possible that en enterprise reporting application like RS should
> have this capability... or... the capability to code it in the report.
>
> Any ideas?
====
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table2">
<Height>0.75in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Product Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox4</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>0-200</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<DataSetName>Northwind</DataSetName>
<Top>0.125in</Top>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.5in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="ProductName_2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>ProductName_2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!ProductName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Chart Name="chart1">
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Legend>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>RightCenter</Position>
</Legend>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!UnitsInStock.Value)</Value>
</DataValue>
</DataValues>
<DataLabel />
<Marker />
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!UnitsOnOrder.Value)</Value>
</DataValue>
</DataValues>
<DataLabel />
<Marker />
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<CategoryAxis>
<Axis>
<Title />
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<Min>0</Min>
</Axis>
</CategoryAxis>
<DataSetName>Northwind</DataSetName>
<PointWidth>0</PointWidth>
<Type>Bar</Type>
<Title />
<SeriesGroupings>
<SeriesGrouping>
<StaticSeries>
<StaticMember>
<Label>Units In Stock</Label>
</StaticMember>
<StaticMember>
<Label>Units On Order</Label>
</StaticMember>
</StaticSeries>
</SeriesGrouping>
</SeriesGroupings>
<Subtype>Stacked</Subtype>
<PlotArea>
<Style>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<ValueAxis>
<Axis>
<Title />
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Max>200</Max>
<Margin>true</Margin>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
</Chart>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table2_Group1">
<GroupExpressions>
<GroupExpression>=Fields!ProductName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<TableColumns>
<TableColumn>
<Width>1.33333in</Width>
</TableColumn>
<TableColumn>
<Width>3.5in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>1.25in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>99dae70f-00e4-4971-a2f6-486f3896814a</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=(local);initial
catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>4.83333in</Width>
<DataSets>
<DataSet Name="Northwind">
<Fields>
<Field Name="ProductID">
<DataField>ProductID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ProductName">
<DataField>ProductName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="SupplierID">
<DataField>SupplierID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="CategoryID">
<DataField>CategoryID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="QuantityPerUnit">
<DataField>QuantityPerUnit</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="UnitPrice">
<DataField>UnitPrice</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
<Field Name="UnitsInStock">
<DataField>UnitsInStock</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="UnitsOnOrder">
<DataField>UnitsOnOrder</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="ReorderLevel">
<DataField>ReorderLevel</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="Discontinued">
<DataField>Discontinued</DataField>
<rd:TypeName>System.Boolean</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>select * from products</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<PageHeight>100in</PageHeight>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>9ecf615a-64ce-4ec1-98bf-05333c406eb6</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
Charts
In this release, the value fields for a chart must be aggregates. If you
don’t have the aggregate you need, you can create a custom field (name
it whatever you want) and wrap the base field in the SUM() aggregate
function, which should be a no-op in this case.Hi Bob,
Thanks a bunch! That did work!
don’t have the aggregate you need, you can create a custom field (name
it whatever you want) and wrap the base field in the SUM() aggregate
function, which should be a no-op in this case.Hi Bob,
Thanks a bunch! That did work!
Charts
Hi, I have a quick question about charts in SQL reporting services...
Is it possible to have a page through chart, meaning that an user can page through multiple pages of the same chart?
No, this is not built in to RS. You may be able to simulate this functionality using drill-throughs, where the user clicks on a link that opens the same report with a different set parameters that result in a new chart.For more information:
Working with Parameters in Reporting Services
Charts
Hi, I have a quick question about charts in SQL reporting services...
Is it possible to have a page through chart, meaning that an user can page through multiple pages of the same chart?
No, this is not built in to RS. You may be able to simulate this functionality using drill-throughs, where the user clicks on a link that opens the same report with a different set parameters that result in a new chart.For more information:
Working with Parameters in Reporting Services
charts
I've created a stacked bar chart using reporting services. I'm
building the chart from 20 records that include amounts, years, ect.
The problem is whenever there are two amounts that are the same the
chart only shows one of the amounts. I tried to find out if there was
a property that was hiding duplicates with no luck.
thanksYou need to create a group for the chart that will identify the unique
records.
Andy Potter
building the chart from 20 records that include amounts, years, ect.
The problem is whenever there are two amounts that are the same the
chart only shows one of the amounts. I tried to find out if there was
a property that was hiding duplicates with no luck.
thanksYou need to create a group for the chart that will identify the unique
records.
Andy Potter
Charts
Is it possible to have charting in SQL Server REporting services, where when
a mouse points to a point on the graph, it displays the value of the point?Sorry, this is not supported. The closest you can get is to either use data
point labels which are always visible, or use drillthrough actions on chart
datapoints.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"TerminatorIII" <TerminatorIII@.discussions.microsoft.com> wrote in message
news:6015BBDE-C7F5-4A04-8F3D-F65B417F932C@.microsoft.com...
> Is it possible to have charting in SQL Server REporting services, where
> when
> a mouse points to a point on the graph, it displays the value of the
> point?
a mouse points to a point on the graph, it displays the value of the point?Sorry, this is not supported. The closest you can get is to either use data
point labels which are always visible, or use drillthrough actions on chart
datapoints.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"TerminatorIII" <TerminatorIII@.discussions.microsoft.com> wrote in message
news:6015BBDE-C7F5-4A04-8F3D-F65B417F932C@.microsoft.com...
> Is it possible to have charting in SQL Server REporting services, where
> when
> a mouse points to a point on the graph, it displays the value of the
> point?
Charts
I have a Custom Dundas Charting library that I utilize normally. I'm having
troubles getting my chart object (and tried to return and image) to render
within my reports. I'm confident I have the custom assemblie referenced. I
don't want to use the chart field from the toolbox, I want to set it to what
my assemblie returns. Anyway to get around this? I'm aware of the custom
data extensions, although, I wanted to just have my existing assemblie which
returns charts do it instead. so all my reports that need graphs can just
reference the assemblie and graph that is needed. Anyway to accomplish this?
I'm getting data type reference errors etc.
ClintPlease try this:
* Add an image to your report
* Set the image type to Database
* Set the image mimetype to e.g. image/png
* For the image value use an expression like
=MyCustomAssembly.GenerateChart()
Note: your custom assembly call has to return the image as byte[].
Here is a code snippet which should convert the Dundas chart output into a
byte array:
public static byte[] GenerateChart()
{
// chart rendering code
...
// save chart image to byte[]
System.IO.MemoryStream renderedImage = new MemoryStream();
dundasChart.ImageType = ChartImageType.Png;
dundasChart.Save(renderedImage);
renderedImage.Position = 0;
return renderedImage.ToArray();
}
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Clint Jennings" <cjennings@.fusionAlliance.com> wrote in message
news:%237PwafckEHA.896@.TK2MSFTNGP12.phx.gbl...
> I have a Custom Dundas Charting library that I utilize normally. I'm
having
> troubles getting my chart object (and tried to return and image) to render
> within my reports. I'm confident I have the custom assemblie referenced.
I
> don't want to use the chart field from the toolbox, I want to set it to
what
> my assemblie returns. Anyway to get around this? I'm aware of the custom
> data extensions, although, I wanted to just have my existing assemblie
which
> returns charts do it instead. so all my reports that need graphs can just
> reference the assemblie and graph that is needed. Anyway to accomplish
this?
> I'm getting data type reference errors etc.
> Clint
>|||Thanks Robert. Created a public function in the library to return a byte
stream.
"Robert Bruckner [MSFT]" wrote:
> Please try this:
> * Add an image to your report
> * Set the image type to Database
> * Set the image mimetype to e.g. image/png
> * For the image value use an expression like
> =MyCustomAssembly.GenerateChart()
> Note: your custom assembly call has to return the image as byte[].
> Here is a code snippet which should convert the Dundas chart output into a
> byte array:
> public static byte[] GenerateChart()
> {
> // chart rendering code
> ...
> // save chart image to byte[]
> System.IO.MemoryStream renderedImage = new MemoryStream();
> dundasChart.ImageType = ChartImageType.Png;
> dundasChart.Save(renderedImage);
> renderedImage.Position = 0;
> return renderedImage.ToArray();
> }
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Clint Jennings" <cjennings@.fusionAlliance.com> wrote in message
> news:%237PwafckEHA.896@.TK2MSFTNGP12.phx.gbl...
> > I have a Custom Dundas Charting library that I utilize normally. I'm
> having
> > troubles getting my chart object (and tried to return and image) to render
> > within my reports. I'm confident I have the custom assemblie referenced.
> I
> > don't want to use the chart field from the toolbox, I want to set it to
> what
> > my assemblie returns. Anyway to get around this? I'm aware of the custom
> > data extensions, although, I wanted to just have my existing assemblie
> which
> > returns charts do it instead. so all my reports that need graphs can just
> > reference the assemblie and graph that is needed. Anyway to accomplish
> this?
> > I'm getting data type reference errors etc.
> >
> > Clint
> >
> >
>
>
troubles getting my chart object (and tried to return and image) to render
within my reports. I'm confident I have the custom assemblie referenced. I
don't want to use the chart field from the toolbox, I want to set it to what
my assemblie returns. Anyway to get around this? I'm aware of the custom
data extensions, although, I wanted to just have my existing assemblie which
returns charts do it instead. so all my reports that need graphs can just
reference the assemblie and graph that is needed. Anyway to accomplish this?
I'm getting data type reference errors etc.
ClintPlease try this:
* Add an image to your report
* Set the image type to Database
* Set the image mimetype to e.g. image/png
* For the image value use an expression like
=MyCustomAssembly.GenerateChart()
Note: your custom assembly call has to return the image as byte[].
Here is a code snippet which should convert the Dundas chart output into a
byte array:
public static byte[] GenerateChart()
{
// chart rendering code
...
// save chart image to byte[]
System.IO.MemoryStream renderedImage = new MemoryStream();
dundasChart.ImageType = ChartImageType.Png;
dundasChart.Save(renderedImage);
renderedImage.Position = 0;
return renderedImage.ToArray();
}
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Clint Jennings" <cjennings@.fusionAlliance.com> wrote in message
news:%237PwafckEHA.896@.TK2MSFTNGP12.phx.gbl...
> I have a Custom Dundas Charting library that I utilize normally. I'm
having
> troubles getting my chart object (and tried to return and image) to render
> within my reports. I'm confident I have the custom assemblie referenced.
I
> don't want to use the chart field from the toolbox, I want to set it to
what
> my assemblie returns. Anyway to get around this? I'm aware of the custom
> data extensions, although, I wanted to just have my existing assemblie
which
> returns charts do it instead. so all my reports that need graphs can just
> reference the assemblie and graph that is needed. Anyway to accomplish
this?
> I'm getting data type reference errors etc.
> Clint
>|||Thanks Robert. Created a public function in the library to return a byte
stream.
"Robert Bruckner [MSFT]" wrote:
> Please try this:
> * Add an image to your report
> * Set the image type to Database
> * Set the image mimetype to e.g. image/png
> * For the image value use an expression like
> =MyCustomAssembly.GenerateChart()
> Note: your custom assembly call has to return the image as byte[].
> Here is a code snippet which should convert the Dundas chart output into a
> byte array:
> public static byte[] GenerateChart()
> {
> // chart rendering code
> ...
> // save chart image to byte[]
> System.IO.MemoryStream renderedImage = new MemoryStream();
> dundasChart.ImageType = ChartImageType.Png;
> dundasChart.Save(renderedImage);
> renderedImage.Position = 0;
> return renderedImage.ToArray();
> }
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Clint Jennings" <cjennings@.fusionAlliance.com> wrote in message
> news:%237PwafckEHA.896@.TK2MSFTNGP12.phx.gbl...
> > I have a Custom Dundas Charting library that I utilize normally. I'm
> having
> > troubles getting my chart object (and tried to return and image) to render
> > within my reports. I'm confident I have the custom assemblie referenced.
> I
> > don't want to use the chart field from the toolbox, I want to set it to
> what
> > my assemblie returns. Anyway to get around this? I'm aware of the custom
> > data extensions, although, I wanted to just have my existing assemblie
> which
> > returns charts do it instead. so all my reports that need graphs can just
> > reference the assemblie and graph that is needed. Anyway to accomplish
> this?
> > I'm getting data type reference errors etc.
> >
> > Clint
> >
> >
>
>
Charting...jump to report
I have a chart with a number of categories, and a Jump To Report action
defined. The Jump to report is a table with details of the data.
I would like to set it up sothat the user can click on a category, and only
the details of that category are returned in the Jump To Report. Is there
any way of setting it up like this.
I have everything working, except I am getting all records in the detail
report, not only records from the selected category.
Thanks in advance
AndreYou will need to add a parameter on the detail report and provide the
current category id on the JumpToReport parameter page of the parent report.
Also, in the detail report you will need to have a parameterized query to
only retrieve the data based on the category id.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andre" <Andre@.discussions.microsoft.com> wrote in message
news:E49EB95A-156A-47A8-AE60-D898B8D43F93@.microsoft.com...
>I have a chart with a number of categories, and a Jump To Report action
> defined. The Jump to report is a table with details of the data.
> I would like to set it up sothat the user can click on a category, and
> only
> the details of that category are returned in the Jump To Report. Is there
> any way of setting it up like this.
> I have everything working, except I am getting all records in the detail
> report, not only records from the selected category.
> Thanks in advance
> Andre
defined. The Jump to report is a table with details of the data.
I would like to set it up sothat the user can click on a category, and only
the details of that category are returned in the Jump To Report. Is there
any way of setting it up like this.
I have everything working, except I am getting all records in the detail
report, not only records from the selected category.
Thanks in advance
AndreYou will need to add a parameter on the detail report and provide the
current category id on the JumpToReport parameter page of the parent report.
Also, in the detail report you will need to have a parameterized query to
only retrieve the data based on the category id.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andre" <Andre@.discussions.microsoft.com> wrote in message
news:E49EB95A-156A-47A8-AE60-D898B8D43F93@.microsoft.com...
>I have a chart with a number of categories, and a Jump To Report action
> defined. The Jump to report is a table with details of the data.
> I would like to set it up sothat the user can click on a category, and
> only
> the details of that category are returned in the Jump To Report. Is there
> any way of setting it up like this.
> I have everything working, except I am getting all records in the detail
> report, not only records from the selected category.
> Thanks in advance
> Andre
Charting...
I'll be quick and too the point...
1: I have a stacked area chart.
2: Percentages are the values being marked.
Issue:
I need to make the 100 mark (text and line) on the y-axis to be red.
I've tried writing an expression to get at the current "label" for the
mark. I keep getting the following error:
<<
The border color expression for the chart 'Sample' contains an
error: [BC30456] 'value' is not a member of
'ReportExprHostImpl.EH_Sample.EH_ValueAxis'.
>>
Here's what I have: '=iif(me.Value,"Black", "Red")'
I've also tried .Text and .Label.
Any help would be appreciated.I gave you incomplete code. Here is what I currently have.
Here's what I have: '=iif(me.Value <> "100","Black", "Red")'|||Sorry, the color of the axis is not an expression.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stu" <stumiller@.unforgettable.com> wrote in message
news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
>I gave you incomplete code. Here is what I currently have.
> Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
>|||Brian Welcker [MS] wrote:
> Sorry, the color of the axis is not an expression.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Stu" <stumiller@.unforgettable.com> wrote in message
> news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
> >I gave you incomplete code. Here is what I currently have.
> > Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
> >
Brian,
Thanks for responding...
So, just to make sure I understand what your saying... there is no way
to get the "value" or "text" of an axis and change the style of that
axis based upon that value?
The reason I "ask" it again this way is that I am able to change the
color of the line and text with this statement:
'=iif(InScope("100"),"Black", "Red")'
Ofcourse, "100" is not within the scope of the data and all the lines
turn "Red" but the point being, I can change the style in the
expression. I'm just asking is there a way to determine what axis your
on.
Thanks|||Yes, lines are data so you can set their color to an expression. Axis values
aren't data so expressions don't really make any sense (we can't iterate
through all possible values). We would have to add an 'Axis value color'
property to the data point.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stu" <stumiller@.unforgettable.com> wrote in message
news:1104349698.883859.301160@.c13g2000cwb.googlegroups.com...
> Brian Welcker [MS] wrote:
>> Sorry, the color of the axis is not an expression.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Stu" <stumiller@.unforgettable.com> wrote in message
>> news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
>> >I gave you incomplete code. Here is what I currently have.
>> > Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
>> >
> Brian,
> Thanks for responding...
> So, just to make sure I understand what your saying... there is no way
> to get the "value" or "text" of an axis and change the style of that
> axis based upon that value?
> The reason I "ask" it again this way is that I am able to change the
> color of the line and text with this statement:
> '=iif(InScope("100"),"Black", "Red")'
> Ofcourse, "100" is not within the scope of the data and all the lines
> turn "Red" but the point being, I can change the style in the
> expression. I'm just asking is there a way to determine what axis your
> on.
> Thanks
>
1: I have a stacked area chart.
2: Percentages are the values being marked.
Issue:
I need to make the 100 mark (text and line) on the y-axis to be red.
I've tried writing an expression to get at the current "label" for the
mark. I keep getting the following error:
<<
The border color expression for the chart 'Sample' contains an
error: [BC30456] 'value' is not a member of
'ReportExprHostImpl.EH_Sample.EH_ValueAxis'.
>>
Here's what I have: '=iif(me.Value,"Black", "Red")'
I've also tried .Text and .Label.
Any help would be appreciated.I gave you incomplete code. Here is what I currently have.
Here's what I have: '=iif(me.Value <> "100","Black", "Red")'|||Sorry, the color of the axis is not an expression.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stu" <stumiller@.unforgettable.com> wrote in message
news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
>I gave you incomplete code. Here is what I currently have.
> Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
>|||Brian Welcker [MS] wrote:
> Sorry, the color of the axis is not an expression.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Stu" <stumiller@.unforgettable.com> wrote in message
> news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
> >I gave you incomplete code. Here is what I currently have.
> > Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
> >
Brian,
Thanks for responding...
So, just to make sure I understand what your saying... there is no way
to get the "value" or "text" of an axis and change the style of that
axis based upon that value?
The reason I "ask" it again this way is that I am able to change the
color of the line and text with this statement:
'=iif(InScope("100"),"Black", "Red")'
Ofcourse, "100" is not within the scope of the data and all the lines
turn "Red" but the point being, I can change the style in the
expression. I'm just asking is there a way to determine what axis your
on.
Thanks|||Yes, lines are data so you can set their color to an expression. Axis values
aren't data so expressions don't really make any sense (we can't iterate
through all possible values). We would have to add an 'Axis value color'
property to the data point.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stu" <stumiller@.unforgettable.com> wrote in message
news:1104349698.883859.301160@.c13g2000cwb.googlegroups.com...
> Brian Welcker [MS] wrote:
>> Sorry, the color of the axis is not an expression.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Stu" <stumiller@.unforgettable.com> wrote in message
>> news:1104275769.160878.21860@.z14g2000cwz.googlegroups.com...
>> >I gave you incomplete code. Here is what I currently have.
>> > Here's what I have: '=iif(me.Value <> "100","Black", "Red")'
>> >
> Brian,
> Thanks for responding...
> So, just to make sure I understand what your saying... there is no way
> to get the "value" or "text" of an axis and change the style of that
> axis based upon that value?
> The reason I "ask" it again this way is that I am able to change the
> color of the line and text with this statement:
> '=iif(InScope("100"),"Black", "Red")'
> Ofcourse, "100" is not within the scope of the data and all the lines
> turn "Red" but the point being, I can change the style in the
> expression. I'm just asking is there a way to determine what axis your
> on.
> Thanks
>
Charting Trouble
Well, this is what is happening.
I am getting my data from a stored procedure, and for this particular chart
am need to use 4 different data fields, 'AverageFillRate',
'AverageFillRateTarget', 'Years', and 'Months'. The years need to correspond
to the averagefillrate, so for example, between 2004 and 2006 I will have 3
fill rates, but the averagefillratetarget is constant among all years.
This is the way the legend appears now:
-- 2004 Average Fill Rate
-- 2004 Average Fill Rate Target
-- 2005 Average Fill Rate
-- 2005 Average Fill Rate Target
-- 2006 Average Fill Rate
-- 2006 Average Fill Rate Target
I need it to be:
-- Average Fill Rate Target
-- 2004 Average Fill Rate
-- 2005 Average Fill Rate
-- 2006 Average Fill Rate
..... etc
Since the target is constant among all years, it does not need to correspond
to any year field, and should be a straight line across the chart. Then I
should have another three different lines on the chart corresponding to the
years selected. But I have 6 lines, because I am getting a target line for
each year as well, this is a mess.
Right now I have 'AverageFillRateTarget' and 'AverageFillRate' fields
dropped into the data field area, 'Months' dropped into the category field
area and 'Years' dropped into the series field area of the chart.
Any suggestions, and does this help any?
ThanksPlease check my response on your other thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=1ca451e6-5cc2-43fc-9fd9-bb51e1a3967d&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
news:5B978BF7-4D62-4D5C-9355-163AB6F7FCF3@.microsoft.com...
> Well, this is what is happening.
> I am getting my data from a stored procedure, and for this particular
chart
> am need to use 4 different data fields, 'AverageFillRate',
> 'AverageFillRateTarget', 'Years', and 'Months'. The years need to
correspond
> to the averagefillrate, so for example, between 2004 and 2006 I will have
3
> fill rates, but the averagefillratetarget is constant among all years.
> This is the way the legend appears now:
> -- 2004 Average Fill Rate
> -- 2004 Average Fill Rate Target
> -- 2005 Average Fill Rate
> -- 2005 Average Fill Rate Target
> -- 2006 Average Fill Rate
> -- 2006 Average Fill Rate Target
>
> I need it to be:
> -- Average Fill Rate Target
> -- 2004 Average Fill Rate
> -- 2005 Average Fill Rate
> -- 2006 Average Fill Rate
> ..... etc
>
> Since the target is constant among all years, it does not need to
correspond
> to any year field, and should be a straight line across the chart. Then I
> should have another three different lines on the chart corresponding to
the
> years selected. But I have 6 lines, because I am getting a target line for
> each year as well, this is a mess.
> Right now I have 'AverageFillRateTarget' and 'AverageFillRate' fields
> dropped into the data field area, 'Months' dropped into the category field
> area and 'Years' dropped into the series field area of the chart.
> Any suggestions, and does this help any?
> Thanks
I am getting my data from a stored procedure, and for this particular chart
am need to use 4 different data fields, 'AverageFillRate',
'AverageFillRateTarget', 'Years', and 'Months'. The years need to correspond
to the averagefillrate, so for example, between 2004 and 2006 I will have 3
fill rates, but the averagefillratetarget is constant among all years.
This is the way the legend appears now:
-- 2004 Average Fill Rate
-- 2004 Average Fill Rate Target
-- 2005 Average Fill Rate
-- 2005 Average Fill Rate Target
-- 2006 Average Fill Rate
-- 2006 Average Fill Rate Target
I need it to be:
-- Average Fill Rate Target
-- 2004 Average Fill Rate
-- 2005 Average Fill Rate
-- 2006 Average Fill Rate
..... etc
Since the target is constant among all years, it does not need to correspond
to any year field, and should be a straight line across the chart. Then I
should have another three different lines on the chart corresponding to the
years selected. But I have 6 lines, because I am getting a target line for
each year as well, this is a mess.
Right now I have 'AverageFillRateTarget' and 'AverageFillRate' fields
dropped into the data field area, 'Months' dropped into the category field
area and 'Years' dropped into the series field area of the chart.
Any suggestions, and does this help any?
ThanksPlease check my response on your other thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=1ca451e6-5cc2-43fc-9fd9-bb51e1a3967d&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
news:5B978BF7-4D62-4D5C-9355-163AB6F7FCF3@.microsoft.com...
> Well, this is what is happening.
> I am getting my data from a stored procedure, and for this particular
chart
> am need to use 4 different data fields, 'AverageFillRate',
> 'AverageFillRateTarget', 'Years', and 'Months'. The years need to
correspond
> to the averagefillrate, so for example, between 2004 and 2006 I will have
3
> fill rates, but the averagefillratetarget is constant among all years.
> This is the way the legend appears now:
> -- 2004 Average Fill Rate
> -- 2004 Average Fill Rate Target
> -- 2005 Average Fill Rate
> -- 2005 Average Fill Rate Target
> -- 2006 Average Fill Rate
> -- 2006 Average Fill Rate Target
>
> I need it to be:
> -- Average Fill Rate Target
> -- 2004 Average Fill Rate
> -- 2005 Average Fill Rate
> -- 2006 Average Fill Rate
> ..... etc
>
> Since the target is constant among all years, it does not need to
correspond
> to any year field, and should be a straight line across the chart. Then I
> should have another three different lines on the chart corresponding to
the
> years selected. But I have 6 lines, because I am getting a target line for
> each year as well, this is a mess.
> Right now I have 'AverageFillRateTarget' and 'AverageFillRate' fields
> dropped into the data field area, 'Months' dropped into the category field
> area and 'Years' dropped into the series field area of the chart.
> Any suggestions, and does this help any?
> Thanks
Charting table detail and sum
I have a bar chart that displays the detail of a table with locations along the x-axis and number of employees on the y-axis. Is there any way to have the sum of all of the locations show as the final bar in the chart? (which would be the footer in the table)
Any help would be most appreciated,
Thanks
One alternative way is to add a second chart which just shows the total number of employees.
-- Robert|||Just wondering if total chart bar are still not supported ? I need that also...
Charting table detail and sum
I have a bar chart that displays the detail of a table with locations along the x-axis and number of employees on the y-axis. Is there any way to have the sum of all of the locations show as the final bar in the chart? (which would be the footer in the table)
Any help would be most appreciated,
Thanks
One alternative way is to add a second chart which just shows the total number of employees.
-- Robert|||Just wondering if total chart bar are still not supported ? I need that also...
Charting simple value over time chart problems.
I am using Visual Studio Academic version 2002.
I have a simple table with dates and values that correspond to those dates and I would like to chart it using crystal reports. I have created a new report and pulled in the 2 columns from the table.
Now I am lost. When ever I try to do a chart it only gives me the option to continue if I select the "show value and select a field". Thats fine and dandy but when I select a field under any chart type or any chart option it always says "Count of <fieldname>" which is totally wrong.
I only want
for each x value show a y value. (basically like a stock ticker)
This is incredibly frustrating since this is the simplest graph type I can imagine and it just completely is not user friendly for it. Any help would be hugely appreciated.
Thank you.Btw, I downloaded the latest version of crystal reports and it does the same thing.
So obviously I just have no clue how to do this type of chart.
The "do not summarize" button is PERMA disabled, so no matter what field I select in the "Show Values" area, they are always Counted instead rather than just showing the value.
I am puting the date field in the "on Change of" column.
and the corresponding value in the "Show value(s)" column, but again in the show value(s) column it always Counts them rather than just displaying the value.
I tried inverting the selection with putting the value field in the "on change of" and the date field in the "show values" column with erradic results.
Can this type of simple graph even be created in crystal??|||Well now I know what the problem is. Called the company and they said that only the advanced developer version of crystal reports gives the functionality to not summarize the selected values with VS.net.
This is also the same case with the downloadable evaluation versions of their software.
Personally that makes me so annoyed I just won't recommend the product as our reporting solution. If I cannot even show my boss a working example of what types of charting and reports we will be getting with the product, there is no way I am going to even try to sell it to them because the software hasn't even sold me.|||After thinking about this, I came to the conclusion that the sales lady I spoke with must have been smoking crack.
I called Crystal again, went through an hour hugabaloo to get to a tech support guy to finally get the real answer.
The "don't summarize field" works with formulas. So that if you want to create a simple x, y graph, you must create a formula to show the value of the y field.
Don't worry you are not really creating a formula and changing the value at all, it is just the stupid interface they have for their 3rd party charting tool. So, you just have to jump through their hoops to get your work done. It is not intuative at all, but it works and luckily it is simple to do.
So
Task 1: create your report,
Task 2: before you add a chart to it, click on the solution explorer and select formula fields. Right click and select -> New
Task 3: Select the field you want to display as the y value from the database connection explorer and double click on it. This will move something like { <field name> } into the textbox at the bottom of the formula form. Leave it like that. Save and close the formula dialog box.
Task 4: Add a chart to your report.
-In the data fields (you should see your new formula field in the data field there with what ever name you named it when you saved it), select your x value (field) in the top list box that has the drop down that says "On Change of".
-Then select the formula field for the bottom list box that says "show value(s)". The don't summarize button now becomes upchecked if you needed it to be, and your chart should display something near correctly at this point.
There you go.|||I've got exactly the same problem. I tried your solution but that doesn't work.. the don't summarize button is still disabled.
I'm using Visual Studio .Net 2003
Do you have any idea why the charts' not working?|||for wwater:
Make sure that you select an item in the Show Values list box, otherwise the "Don't Summarize Values" option will be greyed out. Took me a while to cotton on to how that area works - not very untuitively, as it happens!
And of course "Don't Summarize Values" won't be enabled if the field you have selected is a "Sum of Group xxxx" type field, because you can't un-sum a summing operation.....:-))
Dave|||When I select the formula field (Y) in the Show Value's list box, the "Don't Summarize Values" option is still disabled..
The chart gives always a Y value of 1 for each X value, that is totaly wrong according to the table..|||might pay you to check Crystal Support site re evaluation precedence, because some formulae are evaluated on first poass thru report, and others are done on second pass, and depending what type of formula and where it is (detail vs group) can impact on this.
MOre info on actual formula, whether it's SUM, running total, etc etc, and where it's placed may help.
Dave|||might pay you to check Crystal Support site re evaluation precedence, because some formulae are evaluated on first poass thru report, and others are done on second pass, and depending what type of formula and where it is (detail vs group) can impact on this.
MOre info on actual formula, whether it's SUM, running total, etc etc, and where it's placed may help.
Dave
hey can u help me fix my project in vb.net...please lemme know if u can help ...i would b very thankful if u could help me...please reply soon...
thanks
shruti.|||I found out why charts didn't work. I did not found a direct solution, but i did found a way to work around the problem.
Instead of making a Blank Report, choose the Report Expert and insert the Chart. Then the chart works..
wil.
I have a simple table with dates and values that correspond to those dates and I would like to chart it using crystal reports. I have created a new report and pulled in the 2 columns from the table.
Now I am lost. When ever I try to do a chart it only gives me the option to continue if I select the "show value and select a field". Thats fine and dandy but when I select a field under any chart type or any chart option it always says "Count of <fieldname>" which is totally wrong.
I only want
for each x value show a y value. (basically like a stock ticker)
This is incredibly frustrating since this is the simplest graph type I can imagine and it just completely is not user friendly for it. Any help would be hugely appreciated.
Thank you.Btw, I downloaded the latest version of crystal reports and it does the same thing.
So obviously I just have no clue how to do this type of chart.
The "do not summarize" button is PERMA disabled, so no matter what field I select in the "Show Values" area, they are always Counted instead rather than just showing the value.
I am puting the date field in the "on Change of" column.
and the corresponding value in the "Show value(s)" column, but again in the show value(s) column it always Counts them rather than just displaying the value.
I tried inverting the selection with putting the value field in the "on change of" and the date field in the "show values" column with erradic results.
Can this type of simple graph even be created in crystal??|||Well now I know what the problem is. Called the company and they said that only the advanced developer version of crystal reports gives the functionality to not summarize the selected values with VS.net.
This is also the same case with the downloadable evaluation versions of their software.
Personally that makes me so annoyed I just won't recommend the product as our reporting solution. If I cannot even show my boss a working example of what types of charting and reports we will be getting with the product, there is no way I am going to even try to sell it to them because the software hasn't even sold me.|||After thinking about this, I came to the conclusion that the sales lady I spoke with must have been smoking crack.
I called Crystal again, went through an hour hugabaloo to get to a tech support guy to finally get the real answer.
The "don't summarize field" works with formulas. So that if you want to create a simple x, y graph, you must create a formula to show the value of the y field.
Don't worry you are not really creating a formula and changing the value at all, it is just the stupid interface they have for their 3rd party charting tool. So, you just have to jump through their hoops to get your work done. It is not intuative at all, but it works and luckily it is simple to do.
So
Task 1: create your report,
Task 2: before you add a chart to it, click on the solution explorer and select formula fields. Right click and select -> New
Task 3: Select the field you want to display as the y value from the database connection explorer and double click on it. This will move something like { <field name> } into the textbox at the bottom of the formula form. Leave it like that. Save and close the formula dialog box.
Task 4: Add a chart to your report.
-In the data fields (you should see your new formula field in the data field there with what ever name you named it when you saved it), select your x value (field) in the top list box that has the drop down that says "On Change of".
-Then select the formula field for the bottom list box that says "show value(s)". The don't summarize button now becomes upchecked if you needed it to be, and your chart should display something near correctly at this point.
There you go.|||I've got exactly the same problem. I tried your solution but that doesn't work.. the don't summarize button is still disabled.
I'm using Visual Studio .Net 2003
Do you have any idea why the charts' not working?|||for wwater:
Make sure that you select an item in the Show Values list box, otherwise the "Don't Summarize Values" option will be greyed out. Took me a while to cotton on to how that area works - not very untuitively, as it happens!
And of course "Don't Summarize Values" won't be enabled if the field you have selected is a "Sum of Group xxxx" type field, because you can't un-sum a summing operation.....:-))
Dave|||When I select the formula field (Y) in the Show Value's list box, the "Don't Summarize Values" option is still disabled..
The chart gives always a Y value of 1 for each X value, that is totaly wrong according to the table..|||might pay you to check Crystal Support site re evaluation precedence, because some formulae are evaluated on first poass thru report, and others are done on second pass, and depending what type of formula and where it is (detail vs group) can impact on this.
MOre info on actual formula, whether it's SUM, running total, etc etc, and where it's placed may help.
Dave|||might pay you to check Crystal Support site re evaluation precedence, because some formulae are evaluated on first poass thru report, and others are done on second pass, and depending what type of formula and where it is (detail vs group) can impact on this.
MOre info on actual formula, whether it's SUM, running total, etc etc, and where it's placed may help.
Dave
hey can u help me fix my project in vb.net...please lemme know if u can help ...i would b very thankful if u could help me...please reply soon...
thanks
shruti.|||I found out why charts didn't work. I did not found a direct solution, but i did found a way to work around the problem.
Instead of making a Blank Report, choose the Report Expert and insert the Chart. Then the chart works..
wil.
Charting question
I have a report where each page presents some data in tabular form, the
bottom row (numerically) representing a histogram; i.e., % of values falling
into the "bucket" corresponding to that column. Below this row I'd like to
have a bar chart that graphically displays this histogram with each bar
aligned with the column above. Although I've figured out how to constuct
the chart object there doesn't seem to be any way to actually get things to
line up properly.
The portion of the last row containing the data consists of 7 cells. There
are a couple of padding columns so the first data item is in column 3. What
I tried was to insert a row below (actually a footer row), then merge the 7
cells below the data along with the left adjacent pad cell. I included the
extra cell to allow space for the y axis labels.
So, I can get the chart to appear, but due to the formatting of the chart;
i.e., white space, things don't line up properly. I'm trying to duplicate
(as much as possible) a Crystal generated report in order to determine the
feasibility of using Reporting Services instead. I'm afraid this might be a
deal breaker -- so if anyone has any suggestions I'm anxious to hear back!
Thanks in advance for any help.
BillSo, anybody got any ideas on this one? I'd hoped to get some help before
this scrolls off the edge of the earth...
Bill
"Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
news:eDoS$jukEHA.1936@.TK2MSFTNGP12.phx.gbl...
>I have a report where each page presents some data in tabular form, the
> bottom row (numerically) representing a histogram; i.e., % of values
> falling
> into the "bucket" corresponding to that column. Below this row I'd like to
> have a bar chart that graphically displays this histogram with each bar
> aligned with the column above. Although I've figured out how to constuct
> the chart object there doesn't seem to be any way to actually get things
> to
> line up properly.
> The portion of the last row containing the data consists of 7 cells.
> There
> are a couple of padding columns so the first data item is in column 3.
> What
> I tried was to insert a row below (actually a footer row), then merge the
> 7
> cells below the data along with the left adjacent pad cell. I included the
> extra cell to allow space for the y axis labels.
> So, I can get the chart to appear, but due to the formatting of the chart;
> i.e., white space, things don't line up properly. I'm trying to duplicate
> (as much as possible) a Crystal generated report in order to determine the
> feasibility of using Reporting Services instead. I'm afraid this might be
> a
> deal breaker -- so if anyone has any suggestions I'm anxious to hear back!
> Thanks in advance for any help.
> Bill
>
bottom row (numerically) representing a histogram; i.e., % of values falling
into the "bucket" corresponding to that column. Below this row I'd like to
have a bar chart that graphically displays this histogram with each bar
aligned with the column above. Although I've figured out how to constuct
the chart object there doesn't seem to be any way to actually get things to
line up properly.
The portion of the last row containing the data consists of 7 cells. There
are a couple of padding columns so the first data item is in column 3. What
I tried was to insert a row below (actually a footer row), then merge the 7
cells below the data along with the left adjacent pad cell. I included the
extra cell to allow space for the y axis labels.
So, I can get the chart to appear, but due to the formatting of the chart;
i.e., white space, things don't line up properly. I'm trying to duplicate
(as much as possible) a Crystal generated report in order to determine the
feasibility of using Reporting Services instead. I'm afraid this might be a
deal breaker -- so if anyone has any suggestions I'm anxious to hear back!
Thanks in advance for any help.
BillSo, anybody got any ideas on this one? I'd hoped to get some help before
this scrolls off the edge of the earth...
Bill
"Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
news:eDoS$jukEHA.1936@.TK2MSFTNGP12.phx.gbl...
>I have a report where each page presents some data in tabular form, the
> bottom row (numerically) representing a histogram; i.e., % of values
> falling
> into the "bucket" corresponding to that column. Below this row I'd like to
> have a bar chart that graphically displays this histogram with each bar
> aligned with the column above. Although I've figured out how to constuct
> the chart object there doesn't seem to be any way to actually get things
> to
> line up properly.
> The portion of the last row containing the data consists of 7 cells.
> There
> are a couple of padding columns so the first data item is in column 3.
> What
> I tried was to insert a row below (actually a footer row), then merge the
> 7
> cells below the data along with the left adjacent pad cell. I included the
> extra cell to allow space for the y axis labels.
> So, I can get the chart to appear, but due to the formatting of the chart;
> i.e., white space, things don't line up properly. I'm trying to duplicate
> (as much as possible) a Crystal generated report in order to determine the
> feasibility of using Reporting Services instead. I'm afraid this might be
> a
> deal breaker -- so if anyone has any suggestions I'm anxious to hear back!
> Thanks in advance for any help.
> Bill
>
Charting problem
Hi all. I have plotted a chart based on the data obtained. However, is there a way to limit the number of bars to be displayed in the chart?
Lets say, I have data from Jan to Dec, i needed all the data because i need the accumulated figures from each month.
But, I do not wish to display in the bar chart for data from Jan to Dec.
There are section in the detail for hiding some data, but I dont know about chart.
Any comments are appreciated!Well, give us an example - what period do you wish to chart on, if it's not Jan-Dec??|||Lets say the data needed is from Jan to Dec, because I need to calculate the running total for the accumulated figures for other processing purposes.
Then for the chart, I would like to plot the data from Sept to Dec only. Is it possible?
The date field is used as a criteria for grouping.
Lets say, I have data from Jan to Dec, i needed all the data because i need the accumulated figures from each month.
But, I do not wish to display in the bar chart for data from Jan to Dec.
There are section in the detail for hiding some data, but I dont know about chart.
Any comments are appreciated!Well, give us an example - what period do you wish to chart on, if it's not Jan-Dec??|||Lets say the data needed is from Jan to Dec, because I need to calculate the running total for the accumulated figures for other processing purposes.
Then for the chart, I would like to plot the data from Sept to Dec only. Is it possible?
The date field is used as a criteria for grouping.
Charting Issue
1st... sorry about the duplicate post. Was posted under the wrong account.
I have run into a very strange situation and have been unable to locate
the cause of the problem. Running SQL Reporting Services 2000 and
pulling data from an Oracle db for this specific report.
The report is very simple. A bar chart with 2 data sets. One
represented as bars, the other represented as a line. Below the chart
is a table with the text representation of the data being used for the
chart.
On the chart, the data is displayed using the same y-axis scale.
For some reason when I run a report for a specific set of criteria I
get the correct data in the table, but the graph is messed up. The
2nd data point for my line has a value of 39.30 but the line on the
chart draws up to the 120 mark. The strange thing is that the marker
icon shows the value of 39.30.
My data looks something like this:
Bar Line
39.30 39.30
0 39.30
56.50 43.90
17.50 41.40
All of the points on the line show the correct value and are in the
right position except for the 2nd point. It shows the correct value
at the point, but the line shoots up to the 120 mark on the y-axis.
I have tried this running it both on the server and also in DebugLocal
mode on my development system.
I need to get this resolved ASAP for the executive management team.
Any help would be greatly appreciated.
Thanks!Mike
If you see the Value expression for line chart it must
SUM(Fields!ColumnName.Value).
I beleive becuase of the data some where it is summing the value.
--
Thanks & Rate the Postings.
-Ravi-
"Mike H." wrote:
> 1st... sorry about the duplicate post. Was posted under the wrong account.
> I have run into a very strange situation and have been unable to locate
> the cause of the problem. Running SQL Reporting Services 2000 and
> pulling data from an Oracle db for this specific report.
> The report is very simple. A bar chart with 2 data sets. One
> represented as bars, the other represented as a line. Below the chart
> is a table with the text representation of the data being used for the
> chart.
>
> On the chart, the data is displayed using the same y-axis scale.
>
> For some reason when I run a report for a specific set of criteria I
> get the correct data in the table, but the graph is messed up. The
> 2nd data point for my line has a value of 39.30 but the line on the
> chart draws up to the 120 mark. The strange thing is that the marker
> icon shows the value of 39.30.
>
> My data looks something like this:
>
> Bar Line
> 39.30 39.30
> 0 39.30
> 56.50 43.90
> 17.50 41.40
>
> All of the points on the line show the correct value and are in the
> right position except for the 2nd point. It shows the correct value
> at the point, but the line shoots up to the 120 mark on the y-axis.
>
> I have tried this running it both on the server and also in DebugLocal
> mode on my development system.
>
> I need to get this resolved ASAP for the executive management team.
> Any help would be greatly appreciated.
>
> Thanks!|||Thank you!
I have no idea why there was a SUM function in there. Everything looks
right now.
Thanks again!
"Ravi" wrote:
> Mike
> If you see the Value expression for line chart it must
> SUM(Fields!ColumnName.Value).
> I beleive becuase of the data some where it is summing the value.
> --
> Thanks & Rate the Postings.
> -Ravi-
>
> "Mike H." wrote:
> > 1st... sorry about the duplicate post. Was posted under the wrong account.
> >
> > I have run into a very strange situation and have been unable to locate
> > the cause of the problem. Running SQL Reporting Services 2000 and
> > pulling data from an Oracle db for this specific report.
> >
> > The report is very simple. A bar chart with 2 data sets. One
> > represented as bars, the other represented as a line. Below the chart
> > is a table with the text representation of the data being used for the
> > chart.
> >
> >
> > On the chart, the data is displayed using the same y-axis scale.
> >
> >
> > For some reason when I run a report for a specific set of criteria I
> > get the correct data in the table, but the graph is messed up. The
> > 2nd data point for my line has a value of 39.30 but the line on the
> > chart draws up to the 120 mark. The strange thing is that the marker
> > icon shows the value of 39.30.
> >
> >
> > My data looks something like this:
> >
> >
> > Bar Line
> > 39.30 39.30
> > 0 39.30
> > 56.50 43.90
> > 17.50 41.40
> >
> >
> > All of the points on the line show the correct value and are in the
> > right position except for the 2nd point. It shows the correct value
> > at the point, but the line shoots up to the 120 mark on the y-axis.
> >
> >
> > I have tried this running it both on the server and also in DebugLocal
> > mode on my development system.
> >
> >
> > I need to get this resolved ASAP for the executive management team.
> > Any help would be greatly appreciated.
> >
> >
> > Thanks!
I have run into a very strange situation and have been unable to locate
the cause of the problem. Running SQL Reporting Services 2000 and
pulling data from an Oracle db for this specific report.
The report is very simple. A bar chart with 2 data sets. One
represented as bars, the other represented as a line. Below the chart
is a table with the text representation of the data being used for the
chart.
On the chart, the data is displayed using the same y-axis scale.
For some reason when I run a report for a specific set of criteria I
get the correct data in the table, but the graph is messed up. The
2nd data point for my line has a value of 39.30 but the line on the
chart draws up to the 120 mark. The strange thing is that the marker
icon shows the value of 39.30.
My data looks something like this:
Bar Line
39.30 39.30
0 39.30
56.50 43.90
17.50 41.40
All of the points on the line show the correct value and are in the
right position except for the 2nd point. It shows the correct value
at the point, but the line shoots up to the 120 mark on the y-axis.
I have tried this running it both on the server and also in DebugLocal
mode on my development system.
I need to get this resolved ASAP for the executive management team.
Any help would be greatly appreciated.
Thanks!Mike
If you see the Value expression for line chart it must
SUM(Fields!ColumnName.Value).
I beleive becuase of the data some where it is summing the value.
--
Thanks & Rate the Postings.
-Ravi-
"Mike H." wrote:
> 1st... sorry about the duplicate post. Was posted under the wrong account.
> I have run into a very strange situation and have been unable to locate
> the cause of the problem. Running SQL Reporting Services 2000 and
> pulling data from an Oracle db for this specific report.
> The report is very simple. A bar chart with 2 data sets. One
> represented as bars, the other represented as a line. Below the chart
> is a table with the text representation of the data being used for the
> chart.
>
> On the chart, the data is displayed using the same y-axis scale.
>
> For some reason when I run a report for a specific set of criteria I
> get the correct data in the table, but the graph is messed up. The
> 2nd data point for my line has a value of 39.30 but the line on the
> chart draws up to the 120 mark. The strange thing is that the marker
> icon shows the value of 39.30.
>
> My data looks something like this:
>
> Bar Line
> 39.30 39.30
> 0 39.30
> 56.50 43.90
> 17.50 41.40
>
> All of the points on the line show the correct value and are in the
> right position except for the 2nd point. It shows the correct value
> at the point, but the line shoots up to the 120 mark on the y-axis.
>
> I have tried this running it both on the server and also in DebugLocal
> mode on my development system.
>
> I need to get this resolved ASAP for the executive management team.
> Any help would be greatly appreciated.
>
> Thanks!|||Thank you!
I have no idea why there was a SUM function in there. Everything looks
right now.
Thanks again!
"Ravi" wrote:
> Mike
> If you see the Value expression for line chart it must
> SUM(Fields!ColumnName.Value).
> I beleive becuase of the data some where it is summing the value.
> --
> Thanks & Rate the Postings.
> -Ravi-
>
> "Mike H." wrote:
> > 1st... sorry about the duplicate post. Was posted under the wrong account.
> >
> > I have run into a very strange situation and have been unable to locate
> > the cause of the problem. Running SQL Reporting Services 2000 and
> > pulling data from an Oracle db for this specific report.
> >
> > The report is very simple. A bar chart with 2 data sets. One
> > represented as bars, the other represented as a line. Below the chart
> > is a table with the text representation of the data being used for the
> > chart.
> >
> >
> > On the chart, the data is displayed using the same y-axis scale.
> >
> >
> > For some reason when I run a report for a specific set of criteria I
> > get the correct data in the table, but the graph is messed up. The
> > 2nd data point for my line has a value of 39.30 but the line on the
> > chart draws up to the 120 mark. The strange thing is that the marker
> > icon shows the value of 39.30.
> >
> >
> > My data looks something like this:
> >
> >
> > Bar Line
> > 39.30 39.30
> > 0 39.30
> > 56.50 43.90
> > 17.50 41.40
> >
> >
> > All of the points on the line show the correct value and are in the
> > right position except for the 2nd point. It shows the correct value
> > at the point, but the line shoots up to the 120 mark on the y-axis.
> >
> >
> > I have tried this running it both on the server and also in DebugLocal
> > mode on my development system.
> >
> >
> > I need to get this resolved ASAP for the executive management team.
> > Any help would be greatly appreciated.
> >
> >
> > Thanks!
Charting from two datasets
I have a chart that is displaying data from two datasets. Dataset #1 returns
a set of "all rows". Dataset #2 returns rows that are a subset of the
Dataset #1 with two status values - let's say "True" and "False". I wish to
display a stacked column chart with three segments - "True", "False" and
"Unknown", where unknown is the count of items from Dataset #1 that are not
represented in Dataset #2. How do I do this? What I have tried is a Series
group keyed to the status value from Dataset #2 (i.e. True, False). My data
value is labeled "Known" and is the count from Dataset #2. But when I add a
2nd data value (i.e. "Unknown") that is the count from Dataset #1, it
effectively multiplies the series to 4 values instead of the desired 3. In
other words, I want the chart to show series values of "Known True", "Known
False" and "Unknown", instead of "Known True", "Known False", "Unknown True",
"Unknown False".You would need to join the data in your query first. Create one chart from
two datasets is not supported.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"BootieDay" <BootieDay@.discussions.microsoft.com> wrote in message
news:0198843D-B474-48E6-9280-2D90038DD765@.microsoft.com...
>I have a chart that is displaying data from two datasets. Dataset #1
>returns
> a set of "all rows". Dataset #2 returns rows that are a subset of the
> Dataset #1 with two status values - let's say "True" and "False". I wish
> to
> display a stacked column chart with three segments - "True", "False" and
> "Unknown", where unknown is the count of items from Dataset #1 that are
> not
> represented in Dataset #2. How do I do this? What I have tried is a
> Series
> group keyed to the status value from Dataset #2 (i.e. True, False). My
> data
> value is labeled "Known" and is the count from Dataset #2. But when I add
> a
> 2nd data value (i.e. "Unknown") that is the count from Dataset #1, it
> effectively multiplies the series to 4 values instead of the desired 3.
> In
> other words, I want the chart to show series values of "Known True",
> "Known
> False" and "Unknown", instead of "Known True", "Known False", "Unknown
> True",
> "Unknown False".|||Thanks Robert. It is my understanding though that supporting an aggregate
from a 2nd dataset within a single data region IS supported, it does seem to
be working, just not giving me the series organization I want. Joining is
not an option as Dataset #1 is provided by an extension DLL and Dataset #2 is
SQL.
"Robert Bruckner [MSFT]" wrote:
> You would need to join the data in your query first. Create one chart from
> two datasets is not supported.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "BootieDay" <BootieDay@.discussions.microsoft.com> wrote in message
> news:0198843D-B474-48E6-9280-2D90038DD765@.microsoft.com...
> >I have a chart that is displaying data from two datasets. Dataset #1
> >returns
> > a set of "all rows". Dataset #2 returns rows that are a subset of the
> > Dataset #1 with two status values - let's say "True" and "False". I wish
> > to
> > display a stacked column chart with three segments - "True", "False" and
> > "Unknown", where unknown is the count of items from Dataset #1 that are
> > not
> > represented in Dataset #2. How do I do this? What I have tried is a
> > Series
> > group keyed to the status value from Dataset #2 (i.e. True, False). My
> > data
> > value is labeled "Known" and is the count from Dataset #2. But when I add
> > a
> > 2nd data value (i.e. "Unknown") that is the count from Dataset #1, it
> > effectively multiplies the series to 4 values instead of the desired 3.
> > In
> > other words, I want the chart to show series values of "Known True",
> > "Known
> > False" and "Unknown", instead of "Known True", "Known False", "Unknown
> > True",
> > "Unknown False".
>
>
a set of "all rows". Dataset #2 returns rows that are a subset of the
Dataset #1 with two status values - let's say "True" and "False". I wish to
display a stacked column chart with three segments - "True", "False" and
"Unknown", where unknown is the count of items from Dataset #1 that are not
represented in Dataset #2. How do I do this? What I have tried is a Series
group keyed to the status value from Dataset #2 (i.e. True, False). My data
value is labeled "Known" and is the count from Dataset #2. But when I add a
2nd data value (i.e. "Unknown") that is the count from Dataset #1, it
effectively multiplies the series to 4 values instead of the desired 3. In
other words, I want the chart to show series values of "Known True", "Known
False" and "Unknown", instead of "Known True", "Known False", "Unknown True",
"Unknown False".You would need to join the data in your query first. Create one chart from
two datasets is not supported.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"BootieDay" <BootieDay@.discussions.microsoft.com> wrote in message
news:0198843D-B474-48E6-9280-2D90038DD765@.microsoft.com...
>I have a chart that is displaying data from two datasets. Dataset #1
>returns
> a set of "all rows". Dataset #2 returns rows that are a subset of the
> Dataset #1 with two status values - let's say "True" and "False". I wish
> to
> display a stacked column chart with three segments - "True", "False" and
> "Unknown", where unknown is the count of items from Dataset #1 that are
> not
> represented in Dataset #2. How do I do this? What I have tried is a
> Series
> group keyed to the status value from Dataset #2 (i.e. True, False). My
> data
> value is labeled "Known" and is the count from Dataset #2. But when I add
> a
> 2nd data value (i.e. "Unknown") that is the count from Dataset #1, it
> effectively multiplies the series to 4 values instead of the desired 3.
> In
> other words, I want the chart to show series values of "Known True",
> "Known
> False" and "Unknown", instead of "Known True", "Known False", "Unknown
> True",
> "Unknown False".|||Thanks Robert. It is my understanding though that supporting an aggregate
from a 2nd dataset within a single data region IS supported, it does seem to
be working, just not giving me the series organization I want. Joining is
not an option as Dataset #1 is provided by an extension DLL and Dataset #2 is
SQL.
"Robert Bruckner [MSFT]" wrote:
> You would need to join the data in your query first. Create one chart from
> two datasets is not supported.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "BootieDay" <BootieDay@.discussions.microsoft.com> wrote in message
> news:0198843D-B474-48E6-9280-2D90038DD765@.microsoft.com...
> >I have a chart that is displaying data from two datasets. Dataset #1
> >returns
> > a set of "all rows". Dataset #2 returns rows that are a subset of the
> > Dataset #1 with two status values - let's say "True" and "False". I wish
> > to
> > display a stacked column chart with three segments - "True", "False" and
> > "Unknown", where unknown is the count of items from Dataset #1 that are
> > not
> > represented in Dataset #2. How do I do this? What I have tried is a
> > Series
> > group keyed to the status value from Dataset #2 (i.e. True, False). My
> > data
> > value is labeled "Known" and is the count from Dataset #2. But when I add
> > a
> > 2nd data value (i.e. "Unknown") that is the count from Dataset #1, it
> > effectively multiplies the series to 4 values instead of the desired 3.
> > In
> > other words, I want the chart to show series values of "Known True",
> > "Known
> > False" and "Unknown", instead of "Known True", "Known False", "Unknown
> > True",
> > "Unknown False".
>
>
Charting and the Document Map
Hi,
I have a report which contains 3 different charts. What I need to do is have
all 3 of the chart names in the Document and only 1 chart showing at a time.
The users can then click on a different chart name in the Document Map to
view a different chart.
Is this possible and any suggestions?
ThanksThe document map cannot be used to dynamically "show/hide" report items. It
can only be used to navigate through the report.
If the report only contains charts, you could add page breaks between the
charts and therefore have 3 pages and clicking in the document map would
just navigate the pages of the report. Not sure if that would work in your
situation.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
news:0C181E97-D056-495C-829D-94D78E73FFB6@.microsoft.com...
> Hi,
> I have a report which contains 3 different charts. What I need to do is
> have
> all 3 of the chart names in the Document and only 1 chart showing at a
> time.
> The users can then click on a different chart name in the Document Map to
> view a different chart.
> Is this possible and any suggestions?
> Thanks
I have a report which contains 3 different charts. What I need to do is have
all 3 of the chart names in the Document and only 1 chart showing at a time.
The users can then click on a different chart name in the Document Map to
view a different chart.
Is this possible and any suggestions?
ThanksThe document map cannot be used to dynamically "show/hide" report items. It
can only be used to navigate through the report.
If the report only contains charts, you could add page breaks between the
charts and therefore have 3 pages and clicking in the document map would
just navigate the pages of the report. Not sure if that would work in your
situation.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
news:0C181E97-D056-495C-829D-94D78E73FFB6@.microsoft.com...
> Hi,
> I have a report which contains 3 different charts. What I need to do is
> have
> all 3 of the chart names in the Document and only 1 chart showing at a
> time.
> The users can then click on a different chart name in the Document Map to
> view a different chart.
> Is this possible and any suggestions?
> Thanks
Chart: legend should not scale with the chart
The legend scales with the Chart. My client would the rectangles in the
legend to be perfect squares. Is this possible?
--
Callidus
Software DesignerYes, this is possible if you turn off the legend on the chart and use a
table instead to "draw" the legend for you. I will post a sample within the
next few days which shows how to do this.
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Callidus" <Callidus@.discussions.microsoft.com> wrote in message
news:AE04FCEE-6125-4392-A9D0-FBDB89655532@.microsoft.com...
> The legend scales with the Chart. My client would the rectangles in the
> legend to be perfect squares. Is this possible?
> --
> Callidus
> Software Designer|||The sample RDL is shown at the bottom of this posting. It will require some
careful study to see how it works.
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:e7Fdia%23VFHA.612@.TK2MSFTNGP12.phx.gbl...
> Yes, this is possible if you turn off the legend on the chart and use a
> table instead to "draw" the legend for you. I will post a sample within
> the next few days which shows how to do this.
>
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Callidus" <Callidus@.discussions.microsoft.com> wrote in message
> news:AE04FCEE-6125-4392-A9D0-FBDB89655532@.microsoft.com...
>> The legend scales with the Chart. My client would the rectangles in the
>> legend to be perfect squares. Is this possible?
>> --
>> Callidus
>> Software Designer
=========================
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Author>Robert M. Bruckner</Author>
<Body>
<ReportItems>
<Table Name="table1">
<Height>0.5in</Height>
<ZIndex>1</ZIndex>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Legend</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<DataSetName>DataSet1</DataSetName>
<Top>0.125in</Top>
<Width>2in</Width>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Rectangle Name="rectangle1">
<ZIndex>1</ZIndex>
<Style>
<BackgroundColor>=Code.GetColor(Fields!CategoryName.Value)</BackgroundColor>
</Style>
</Rectangle>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="CategoryName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>CategoryName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!CategoryName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table1_Group1">
<GroupExpressions>
<GroupExpression>=Fields!CategoryName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=Fields!CategoryName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
</TableGroup>
</TableGroups>
<Left>3.25in</Left>
<TableColumns>
<TableColumn>
<Width>0.25in</Width>
</TableColumn>
<TableColumn>
<Width>1.75in</Width>
</TableColumn>
</TableColumns>
</Table>
<Chart Name="chart1">
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Legend>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>BottomCenter</Position>
<Layout>Table</Layout>
</Legend>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!UnitsInStock.Value)</Value>
</DataValue>
</DataValues>
<DataLabel />
<Style>
<BackgroundColor>=Code.GetColor(Fields!CategoryName.Value)</BackgroundColor>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<CategoryAxis>
<Axis>
<Title />
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<Min>0</Min>
</Axis>
</CategoryAxis>
<DataSetName>DataSet1</DataSetName>
<PointWidth>0</PointWidth>
<Type>Bar</Type>
<Top>0.25in</Top>
<Title />
<Width>3in</Width>
<Height>2.5in</Height>
<SeriesGroupings>
<SeriesGrouping>
<DynamicSeries>
<Grouping Name="chart1_SeriesGroup1">
<GroupExpressions>
<GroupExpression>=Fields!CategoryName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=Fields!CategoryName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<Label>=Fields!CategoryName.Value</Label>
</DynamicSeries>
</SeriesGrouping>
</SeriesGroupings>
<Subtype>Plain</Subtype>
<PlotArea>
<Style>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<Left>0.125in</Left>
<ValueAxis>
<Axis>
<Title />
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Margin>true</Margin>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
</Chart>
</ReportItems>
<Style />
<Height>3.25in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>f646058b-4784-494d-a09d-27fde13a5679</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=(local);initial
catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Code> Private Shared colorPalette As String() = {"Green", "Blue",
"Red", "Orange", "Aqua", "Teal", "Gold", "RoyalBlue", "#A59D93", "#B8341B",
"#352F26", "#F1E7D6", "#E16C56", "#CFBA9B"}
Private Shared count As Integer = 0
Private Shared mapping As New System.Collections.Hashtable()
Public Function GetColor(ByVal groupingValue As String) As String
If mapping.ContainsKey(groupingValue) Then
Return mapping(groupingValue)
End If
Dim c As String = colorPalette(count Mod colorPalette.Length)
count = count + 1
mapping.Add(groupingValue, c)
Return c
End Function
</Code>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="ProductID">
<DataField>ProductID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ProductName">
<DataField>ProductName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="SupplierID">
<DataField>SupplierID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="CategoryID">
<DataField>CategoryID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="QuantityPerUnit">
<DataField>QuantityPerUnit</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="UnitPrice">
<DataField>UnitPrice</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
<Field Name="UnitsInStock">
<DataField>UnitsInStock</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="UnitsOnOrder">
<DataField>UnitsOnOrder</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="ReorderLevel">
<DataField>ReorderLevel</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="Discontinued">
<DataField>Discontinued</DataField>
<rd:TypeName>System.Boolean</rd:TypeName>
</Field>
<Field Name="CategoryName">
<DataField>CategoryName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Country">
<DataField>Country</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>SELECT Products.*, Categories.CategoryName,
Suppliers.Country
FROM Products INNER JOIN
Categories ON Products.CategoryID =Categories.CategoryID INNER JOIN
Suppliers ON Products.SupplierID =Suppliers.SupplierID</CommandText>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>e5564b0f-4fab-4cf7-9cef-bda726589920</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
legend to be perfect squares. Is this possible?
--
Callidus
Software DesignerYes, this is possible if you turn off the legend on the chart and use a
table instead to "draw" the legend for you. I will post a sample within the
next few days which shows how to do this.
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Callidus" <Callidus@.discussions.microsoft.com> wrote in message
news:AE04FCEE-6125-4392-A9D0-FBDB89655532@.microsoft.com...
> The legend scales with the Chart. My client would the rectangles in the
> legend to be perfect squares. Is this possible?
> --
> Callidus
> Software Designer|||The sample RDL is shown at the bottom of this posting. It will require some
careful study to see how it works.
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:e7Fdia%23VFHA.612@.TK2MSFTNGP12.phx.gbl...
> Yes, this is possible if you turn off the legend on the chart and use a
> table instead to "draw" the legend for you. I will post a sample within
> the next few days which shows how to do this.
>
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Callidus" <Callidus@.discussions.microsoft.com> wrote in message
> news:AE04FCEE-6125-4392-A9D0-FBDB89655532@.microsoft.com...
>> The legend scales with the Chart. My client would the rectangles in the
>> legend to be perfect squares. Is this possible?
>> --
>> Callidus
>> Software Designer
=========================
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Author>Robert M. Bruckner</Author>
<Body>
<ReportItems>
<Table Name="table1">
<Height>0.5in</Height>
<ZIndex>1</ZIndex>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Legend</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<DataSetName>DataSet1</DataSetName>
<Top>0.125in</Top>
<Width>2in</Width>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Rectangle Name="rectangle1">
<ZIndex>1</ZIndex>
<Style>
<BackgroundColor>=Code.GetColor(Fields!CategoryName.Value)</BackgroundColor>
</Style>
</Rectangle>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="CategoryName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>CategoryName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!CategoryName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table1_Group1">
<GroupExpressions>
<GroupExpression>=Fields!CategoryName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=Fields!CategoryName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
</TableGroup>
</TableGroups>
<Left>3.25in</Left>
<TableColumns>
<TableColumn>
<Width>0.25in</Width>
</TableColumn>
<TableColumn>
<Width>1.75in</Width>
</TableColumn>
</TableColumns>
</Table>
<Chart Name="chart1">
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Legend>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>BottomCenter</Position>
<Layout>Table</Layout>
</Legend>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!UnitsInStock.Value)</Value>
</DataValue>
</DataValues>
<DataLabel />
<Style>
<BackgroundColor>=Code.GetColor(Fields!CategoryName.Value)</BackgroundColor>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<CategoryAxis>
<Axis>
<Title />
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<Min>0</Min>
</Axis>
</CategoryAxis>
<DataSetName>DataSet1</DataSetName>
<PointWidth>0</PointWidth>
<Type>Bar</Type>
<Top>0.25in</Top>
<Title />
<Width>3in</Width>
<Height>2.5in</Height>
<SeriesGroupings>
<SeriesGrouping>
<DynamicSeries>
<Grouping Name="chart1_SeriesGroup1">
<GroupExpressions>
<GroupExpression>=Fields!CategoryName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=Fields!CategoryName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<Label>=Fields!CategoryName.Value</Label>
</DynamicSeries>
</SeriesGrouping>
</SeriesGroupings>
<Subtype>Plain</Subtype>
<PlotArea>
<Style>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<Left>0.125in</Left>
<ValueAxis>
<Axis>
<Title />
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Margin>true</Margin>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
</Chart>
</ReportItems>
<Style />
<Height>3.25in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>f646058b-4784-494d-a09d-27fde13a5679</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=(local);initial
catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Code> Private Shared colorPalette As String() = {"Green", "Blue",
"Red", "Orange", "Aqua", "Teal", "Gold", "RoyalBlue", "#A59D93", "#B8341B",
"#352F26", "#F1E7D6", "#E16C56", "#CFBA9B"}
Private Shared count As Integer = 0
Private Shared mapping As New System.Collections.Hashtable()
Public Function GetColor(ByVal groupingValue As String) As String
If mapping.ContainsKey(groupingValue) Then
Return mapping(groupingValue)
End If
Dim c As String = colorPalette(count Mod colorPalette.Length)
count = count + 1
mapping.Add(groupingValue, c)
Return c
End Function
</Code>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="ProductID">
<DataField>ProductID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ProductName">
<DataField>ProductName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="SupplierID">
<DataField>SupplierID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="CategoryID">
<DataField>CategoryID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="QuantityPerUnit">
<DataField>QuantityPerUnit</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="UnitPrice">
<DataField>UnitPrice</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
<Field Name="UnitsInStock">
<DataField>UnitsInStock</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="UnitsOnOrder">
<DataField>UnitsOnOrder</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="ReorderLevel">
<DataField>ReorderLevel</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="Discontinued">
<DataField>Discontinued</DataField>
<rd:TypeName>System.Boolean</rd:TypeName>
</Field>
<Field Name="CategoryName">
<DataField>CategoryName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Country">
<DataField>Country</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>SELECT Products.*, Categories.CategoryName,
Suppliers.Country
FROM Products INNER JOIN
Categories ON Products.CategoryID =Categories.CategoryID INNER JOIN
Suppliers ON Products.SupplierID =Suppliers.SupplierID</CommandText>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>e5564b0f-4fab-4cf7-9cef-bda726589920</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
Chart, how do I use format code for a label?
How do I refer to the actual value for the label inside my expression?
Say you have datetime data across the x-axis for the data. I get one row per
month in the dataset (every row is same date and time for each row/month). I
understand how I can format this, for instance "MMM" to get month name in
short format.
But if I want to do further or a bit more complex manipulation? In this
case, I want to show only first letter of the month. I fail to connect how
to put the actual data value inside my VB.NET expression (substring, left or
similar function in this case).
(I can retrieve the first letter of the month along with the data, as an
extra column, doing this in my stored procedure. If above is difficult, I'd
appreciate tips on how to refer to this column for the chart label. I.e., I
want to show some other column as the label, not the one used to derive the
actual value.)
TIA
Tibor Karaszi
SQL Server MVPExpressions for formatting labels are not directly supported in the current
release. You could do a bar chart and use an expression
(=Left(Format(Fields!OrderDate.Value, "MMM"), 1)) for the corresponding
category group. The sample report attached at the end of this post (which
runs against local Northwind database) demonstrates this.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
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:OEwX0qaiEHA.2848@.TK2MSFTNGP10.phx.gbl...
> How do I refer to the actual value for the label inside my expression?
> Say you have datetime data across the x-axis for the data. I get one row
per
> month in the dataset (every row is same date and time for each row/month).
I
> understand how I can format this, for instance "MMM" to get month name in
> short format.
> But if I want to do further or a bit more complex manipulation? In this
> case, I want to show only first letter of the month. I fail to connect how
> to put the actual data value inside my VB.NET expression (substring, left
or
> similar function in this case).
> (I can retrieve the first letter of the month along with the data, as an
> extra column, doing this in my stored procedure. If above is difficult,
I'd
> appreciate tips on how to refer to this column for the chart label. I.e.,
I
> want to show some other column as the label, not the one used to derive
the
> actual value.)
> TIA
> Tibor Karaszi
> SQL Server MVP
>
+++++++++++++ Sample report +++++++++++++
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Chart Name="chart1">
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Legend>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>RightCenter</Position>
</Legend>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!Freight.Value)</Value>
</DataValue>
</DataValues>
<DataLabel />
<Marker />
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<CategoryAxis>
<Axis>
<Title />
<Style>
<FontSize>8pt</FontSize>
</Style>
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Visible>true</Visible>
</Axis>
</CategoryAxis>
<DataSetName>Northwind</DataSetName>
<PointWidth>0</PointWidth>
<Type>Bar</Type>
<Title />
<Width>5.25in</Width>
<CategoryGroupings>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="chart1_CategoryGroup1">
<GroupExpressions>
<GroupExpression>=Fields!OrderDate.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Label>=Left(Format(Fields!OrderDate.Value, "MMM"), 1) & "
[" & Format(Fields!OrderDate.Value, "MMM yyyy") & "]"</Label>
</DynamicCategories>
</CategoryGrouping>
</CategoryGroupings>
<Subtype>Plain</Subtype>
<PlotArea>
<Style>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<ValueAxis>
<Axis>
<Title />
<Style>
<Format>c</Format>
<FontSize>8pt</FontSize>
</Style>
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Margin>true</Margin>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
</Chart>
</ReportItems>
<Style />
<Height>3in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>14b06457-afff-49a5-9624-2ecc74ef5643</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>initial catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>6.25in</Width>
<DataSets>
<DataSet Name="Northwind">
<Fields>
<Field Name="OrderDate">
<DataField>OrderDate</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="Freight">
<DataField>Freight</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>SELECT TOP 10 OrderDate, Freight
FROM Orders
ORDER BY ShipCity</CommandText>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>b8405333-c29c-4c57-8ba3-7915ae7bf5eb</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
Say you have datetime data across the x-axis for the data. I get one row per
month in the dataset (every row is same date and time for each row/month). I
understand how I can format this, for instance "MMM" to get month name in
short format.
But if I want to do further or a bit more complex manipulation? In this
case, I want to show only first letter of the month. I fail to connect how
to put the actual data value inside my VB.NET expression (substring, left or
similar function in this case).
(I can retrieve the first letter of the month along with the data, as an
extra column, doing this in my stored procedure. If above is difficult, I'd
appreciate tips on how to refer to this column for the chart label. I.e., I
want to show some other column as the label, not the one used to derive the
actual value.)
TIA
Tibor Karaszi
SQL Server MVPExpressions for formatting labels are not directly supported in the current
release. You could do a bar chart and use an expression
(=Left(Format(Fields!OrderDate.Value, "MMM"), 1)) for the corresponding
category group. The sample report attached at the end of this post (which
runs against local Northwind database) demonstrates this.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
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:OEwX0qaiEHA.2848@.TK2MSFTNGP10.phx.gbl...
> How do I refer to the actual value for the label inside my expression?
> Say you have datetime data across the x-axis for the data. I get one row
per
> month in the dataset (every row is same date and time for each row/month).
I
> understand how I can format this, for instance "MMM" to get month name in
> short format.
> But if I want to do further or a bit more complex manipulation? In this
> case, I want to show only first letter of the month. I fail to connect how
> to put the actual data value inside my VB.NET expression (substring, left
or
> similar function in this case).
> (I can retrieve the first letter of the month along with the data, as an
> extra column, doing this in my stored procedure. If above is difficult,
I'd
> appreciate tips on how to refer to this column for the chart label. I.e.,
I
> want to show some other column as the label, not the one used to derive
the
> actual value.)
> TIA
> Tibor Karaszi
> SQL Server MVP
>
+++++++++++++ Sample report +++++++++++++
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Chart Name="chart1">
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Legend>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>RightCenter</Position>
</Legend>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!Freight.Value)</Value>
</DataValue>
</DataValues>
<DataLabel />
<Marker />
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<CategoryAxis>
<Axis>
<Title />
<Style>
<FontSize>8pt</FontSize>
</Style>
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Visible>true</Visible>
</Axis>
</CategoryAxis>
<DataSetName>Northwind</DataSetName>
<PointWidth>0</PointWidth>
<Type>Bar</Type>
<Title />
<Width>5.25in</Width>
<CategoryGroupings>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="chart1_CategoryGroup1">
<GroupExpressions>
<GroupExpression>=Fields!OrderDate.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Label>=Left(Format(Fields!OrderDate.Value, "MMM"), 1) & "
[" & Format(Fields!OrderDate.Value, "MMM yyyy") & "]"</Label>
</DynamicCategories>
</CategoryGrouping>
</CategoryGroupings>
<Subtype>Plain</Subtype>
<PlotArea>
<Style>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<ValueAxis>
<Axis>
<Title />
<Style>
<Format>c</Format>
<FontSize>8pt</FontSize>
</Style>
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Margin>true</Margin>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
</Chart>
</ReportItems>
<Style />
<Height>3in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>14b06457-afff-49a5-9624-2ecc74ef5643</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>initial catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>6.25in</Width>
<DataSets>
<DataSet Name="Northwind">
<Fields>
<Field Name="OrderDate">
<DataField>OrderDate</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="Freight">
<DataField>Freight</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>SELECT TOP 10 OrderDate, Freight
FROM Orders
ORDER BY ShipCity</CommandText>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>b8405333-c29c-4c57-8ba3-7915ae7bf5eb</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
Chart Y-axis Values Problem
I created a chart using some calculated fields, the calculations are working
correctly (I manually checked the math), but the Y axis values are way off.
The highest field value generated was 18,544 but the scale on the chart was
showing 500,000 with the bar reaching nearly to the top. I could understand
if the scale was just off and the bar stopped at the correct position, but
not only is the scale off, the bar doesn't correctly represent the value
either. Because this report will be used for several customers I can't
manually set a limit for the Y-axis. I turned off the labels for the Y-axis
so that I can use the chart, but I would prefer being able to see the labels.
I have installed SP1. Any help would be appreciated.
JoeHi, you can convert the scale of your chart in a expression in the RDL; try
it.
John Bocachica
Colombia
"JHoward" <JHoward@.discussions.microsoft.com> wrote in message
news:78D0BEDF-A212-4B07-9641-9A1615E6168F@.microsoft.com...
>I created a chart using some calculated fields, the calculations are
>working
> correctly (I manually checked the math), but the Y axis values are way
> off.
> The highest field value generated was 18,544 but the scale on the chart
> was
> showing 500,000 with the bar reaching nearly to the top. I could
> understand
> if the scale was just off and the bar stopped at the correct position, but
> not only is the scale off, the bar doesn't correctly represent the value
> either. Because this report will be used for several customers I can't
> manually set a limit for the Y-axis. I turned off the labels for the
> Y-axis
> so that I can use the chart, but I would prefer being able to see the
> labels.
> I have installed SP1. Any help would be appreciated.
> Joe|||Note: expression-based min/max/intervals will only be available on RS2005.
Joe, can you post a simplified report which runs e.g. based on Northwind
data and reproduces the issue?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Bocachica (Colombia)" <jbocachica@.gmail.com> wrote in message
news:e%23FQGGl%23EHA.1084@.tk2msftngp13.phx.gbl...
> Hi, you can convert the scale of your chart in a expression in the RDL;
try
> it.
> John Bocachica
> Colombia
> "JHoward" <JHoward@.discussions.microsoft.com> wrote in message
> news:78D0BEDF-A212-4B07-9641-9A1615E6168F@.microsoft.com...
> >I created a chart using some calculated fields, the calculations are
> >working
> > correctly (I manually checked the math), but the Y axis values are way
> > off.
> > The highest field value generated was 18,544 but the scale on the chart
> > was
> > showing 500,000 with the bar reaching nearly to the top. I could
> > understand
> > if the scale was just off and the bar stopped at the correct position,
but
> > not only is the scale off, the bar doesn't correctly represent the value
> > either. Because this report will be used for several customers I can't
> > manually set a limit for the Y-axis. I turned off the labels for the
> > Y-axis
> > so that I can use the chart, but I would prefer being able to see the
> > labels.
> > I have installed SP1. Any help would be appreciated.
> >
> > Joe
>
correctly (I manually checked the math), but the Y axis values are way off.
The highest field value generated was 18,544 but the scale on the chart was
showing 500,000 with the bar reaching nearly to the top. I could understand
if the scale was just off and the bar stopped at the correct position, but
not only is the scale off, the bar doesn't correctly represent the value
either. Because this report will be used for several customers I can't
manually set a limit for the Y-axis. I turned off the labels for the Y-axis
so that I can use the chart, but I would prefer being able to see the labels.
I have installed SP1. Any help would be appreciated.
JoeHi, you can convert the scale of your chart in a expression in the RDL; try
it.
John Bocachica
Colombia
"JHoward" <JHoward@.discussions.microsoft.com> wrote in message
news:78D0BEDF-A212-4B07-9641-9A1615E6168F@.microsoft.com...
>I created a chart using some calculated fields, the calculations are
>working
> correctly (I manually checked the math), but the Y axis values are way
> off.
> The highest field value generated was 18,544 but the scale on the chart
> was
> showing 500,000 with the bar reaching nearly to the top. I could
> understand
> if the scale was just off and the bar stopped at the correct position, but
> not only is the scale off, the bar doesn't correctly represent the value
> either. Because this report will be used for several customers I can't
> manually set a limit for the Y-axis. I turned off the labels for the
> Y-axis
> so that I can use the chart, but I would prefer being able to see the
> labels.
> I have installed SP1. Any help would be appreciated.
> Joe|||Note: expression-based min/max/intervals will only be available on RS2005.
Joe, can you post a simplified report which runs e.g. based on Northwind
data and reproduces the issue?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Bocachica (Colombia)" <jbocachica@.gmail.com> wrote in message
news:e%23FQGGl%23EHA.1084@.tk2msftngp13.phx.gbl...
> Hi, you can convert the scale of your chart in a expression in the RDL;
try
> it.
> John Bocachica
> Colombia
> "JHoward" <JHoward@.discussions.microsoft.com> wrote in message
> news:78D0BEDF-A212-4B07-9641-9A1615E6168F@.microsoft.com...
> >I created a chart using some calculated fields, the calculations are
> >working
> > correctly (I manually checked the math), but the Y axis values are way
> > off.
> > The highest field value generated was 18,544 but the scale on the chart
> > was
> > showing 500,000 with the bar reaching nearly to the top. I could
> > understand
> > if the scale was just off and the bar stopped at the correct position,
but
> > not only is the scale off, the bar doesn't correctly represent the value
> > either. Because this report will be used for several customers I can't
> > manually set a limit for the Y-axis. I turned off the labels for the
> > Y-axis
> > so that I can use the chart, but I would prefer being able to see the
> > labels.
> > I have installed SP1. Any help would be appreciated.
> >
> > Joe
>
Subscribe to:
Posts (Atom)