Charts using SSRS

Friends,

I have a requirement in Bar charts using SSRS...Assume that I have 3 Products Quantity and the representation will look like following

A - 10

B- 20

C-15

Though it is easy to develop this as a bar chart...The requirement is that a Product Perfomace should be represented using Images in the chart area...Instead of showing that A has 10 quantitites in a single bar, a general product image should be coming in the place of 10 and same with the case of B and C.. I have used smiley icons here for clarity

The look of the chart should be like following

|

|__

|__|

|

|__

|__|

|

|_

|_|

|_

Please let me know if there is a way to customize this bar chart using SSRS Charts...Thanks in Advance

There is a custom chart displaying in the above format, but does not have image associated to the data lable.

have anyone come across charts of this type, like the one mentioned in this thread

Charts on multiple pages?

Hi All,

I am using SQL Reportig Services 2005 for displaying reports in Bar Graph charts. The problem is that the width of each bar in chart is not fixed and changes based on volume of data. If number of rows retrieved by dataset connection are many, then the graph appears too cramped and is not readable.

Is there any way, programmatically or at design time, that we can change the width of chart based on number of rows retrieved in the dataset?

Any help or reference will be highly appreciated.

Thanks in Advance !!!

Assuming all the data you are showing as bars are really detail rows rather than grouped data, you could consider the following approach:

Add a (detail) group to the list with the following grouping expression:

=Int((RowNumber(Nothing)-1)/20)

As a result you would get 20 detail rows per (repeating) list instance. Then just put the chart inside the list. Those chart instances will never "see" more than 20 detail rows at once.

-- Robert

|||

Thanks Robert !!!

The solution given by you works fine. But I did not get what you mean by 'data you are showing as bars are really detail rows rather than grouped data'.

Is there any limitation to the approach that you have given?

Thanks for reply once again !!!

Charts for Reporting Services

I'm having problem with Charts
any good website or books i can read up on
just can't anything good on charts
I need to use 2 pie chart and 1 bar chart but i can't get it to work like i wanted to

I'm not sure what Series and Category is used and how to stack the fields in the Charts

For a standard bar chart, the Category is what goes on the X axis (i.e. might be the month, or product, or whatever). Using the Series will group the bars, a typical grouping might be by year.

These three links (especially the last one) may be of some assistance:

http://msdn2.microsoft.com/en-us/library/ms156306.aspx

http://msdn2.microsoft.com/en-us/library/ms155847.aspx

http://msdn2.microsoft.com/en-us/library/aa964128.aspx

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.

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

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

Sorry, "subtotals" are not directly supported in charts. But I'm not sure if you would really get the desired effect with a subtotal in charts. Since the individual employee groups share the same Y-axis as the total number of employees, you would most likely get many small bars and one long bar showing the total number of employees.
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

Sorry, "subtotals" are not directly supported in charts. But I'm not sure if you would really get the desired effect with a subtotal in charts. Since the individual employee groups share the same Y-axis as the total number of employees, you would most likely get many small bars and one long bar showing the total number of employees.
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...

chart Y-Axis dynamic maximum

Hello,
I got a bar chart, it shows percentages up to...yes 100%.
Usually, their is a series which are 20-30%, but once in a while
I get one value which is 100%.
If I leave the maximum unset...the bar chart resizes so that the area
show differences better for 20-30% series, however if a single 100%
value comes then the upper limit of the Y-Axis goes above 100%.
If I set the maximum then obviously the series of 20-30% look all
small...
Any ideas for putting in some expression into the maximum?
Thanks,
MattUnfortunately you cannot use expressions for the max and min (I too wanted
this). This feature will be available in RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"yurps" <yurps@.yahoo.co.uk> wrote in message
news:1116341493.581592.139110@.f14g2000cwb.googlegroups.com...
> Hello,
> I got a bar chart, it shows percentages up to...yes 100%.
> Usually, their is a series which are 20-30%, but once in a while
> I get one value which is 100%.
> If I leave the maximum unset...the bar chart resizes so that the area
> show differences better for 20-30% series, however if a single 100%
> value comes then the upper limit of the Y-Axis goes above 100%.
> If I set the maximum then obviously the series of 20-30% look all
> small...
> Any ideas for putting in some expression into the maximum?
> Thanks,
> Matt
>

Chart URL Action? Easy question ... I hope!

I am trying to create a chart action to do a URL drill into bar chart. But I
can not figure out how to get the name of the clicked bar.
Example: If the diagram below were a chart, when I click on the "two" bar, I
want to create the url: http://www.bonzo.com/foo.aspx&PICKEDBAR=Two
One == Two ==== Three ========
Is it possible to do this?Your Jump to navigate action you can use the RS global collections. Assuming
that One, Two, etc. are category groups, you can use Fields!<your database
field>.Value
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"billd" <billd@.discussions.microsoft.com> wrote in message
news:43521AC0-1DE9-4980-B579-16F0DF651586@.microsoft.com...
> I am trying to create a chart action to do a URL drill into bar chart. But
I
> can not figure out how to get the name of the clicked bar.
> Example: If the diagram below were a chart, when I click on the "two" bar,
I
> want to create the url: http://www.bonzo.com/foo.aspx&PICKEDBAR=Two
> One ==> Two ====> Three ========> Is it possible to do this?|||Thanks ... excactly the answer I needed.
You are the MVP.
"Teo Lachev [MVP]" wrote:
> Your Jump to navigate action you can use the RS global collections. Assuming
> that One, Two, etc. are category groups, you can use Fields!<your database
> field>.Value
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "billd" <billd@.discussions.microsoft.com> wrote in message
> news:43521AC0-1DE9-4980-B579-16F0DF651586@.microsoft.com...
> > I am trying to create a chart action to do a URL drill into bar chart. But
> I
> > can not figure out how to get the name of the clicked bar.
> >
> > Example: If the diagram below were a chart, when I click on the "two" bar,
> I
> > want to create the url: http://www.bonzo.com/foo.aspx&PICKEDBAR=Two
> >
> > One ==> > Two ====> > Three ========> >
> > Is it possible to do this?
>
>

Chart Series Total

I have a chart on one of my reports that has two series as a stracked bar
chart, and displays two point labels on each bar for the series value. What
I'd like to do is show the series value as a percentage relative to the total
bar value. The real problem here is I don't know how to get programmatically
get at the value shown in the point label, since this value calculated by
reporting services and not in my query (i.e. my query returns the total for
each bar, and SRS breaks it down into the two series values).
Any help would be appreciated.I haven't done many charts but can't you reference the label by
ReportItems!LabelName.Value.....I don't know if this is what you are looking
for.
"blabore" wrote:
> I have a chart on one of my reports that has two series as a stracked bar
> chart, and displays two point labels on each bar for the series value. What
> I'd like to do is show the series value as a percentage relative to the total
> bar value. The real problem here is I don't know how to get programmatically
> get at the value shown in the point label, since this value calculated by
> reporting services and not in my query (i.e. my query returns the total for
> each bar, and SRS breaks it down into the two series values).
> Any help would be appreciated.

chart series

Is it possible to chart one data series as a line and another as a bar on the
same graph. Other tools allow this and I have been asked to do it - I dont
see how it is possible since you define the graph as either line or bar to
begin with.Yes, you can do that. Create your column chart. Then go to the chart
properties dialog. In the dialog go to the Data tab and edit the properties
of your trend data series. The "Edit chart value" dialog should pop up. In
this dialog go to the Appearance tab and select "Plot data as line".
You can also check the following KB article:
http://support.microsoft.com/kb/842422
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:EAE49F79-5B1D-4E42-850B-6C08671546CA@.microsoft.com...
> Is it possible to chart one data series as a line and another as a bar on
> the
> same graph. Other tools allow this and I have been asked to do it - I
> dont
> see how it is possible since you define the graph as either line or bar to
> begin with.

Chart Problem

My y axis of bar chart does not show values when there is more data in table. Is there any way out .please help me
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.Right click on the chart control and go to chart
properties , then go to Y Axis tab and remove all values
under scale.
Hope this helps.
>--Original Message--
>My y axis of bar chart does not show values when there is
more data in table. Is there any way out .please help me
>--
>Posted using Wimdows.net NntpNews Component -
>Post Made from http://www.SqlJunkies.com/newsgroups Our
newsgroup engine supports Post Alerts, Ratings, and
Searching.
>.
>

Chart legend has too much data - how to only show 1 legend

I have created a hybrid bar chart / with line. Basically uses the bars to
show sales for each geographic region. A single line is plotted showing the
sales goal to be reached. The x axis is "Region" The y axis value 1 is total
sales $. I added y value 2 to show the sales goal $ and the legend
automatically got populated with series labels. I only want the x axis
labels to be in the legend.
How can I fix this?NP,
This is not a direct answer to your question, but I got tired of the report
legend and what seemed the lack of configuration and used a nice trick from
the Technical Article: Get More Out of SQL Server Reporting Services Charts
(http://msdn2.microsoft.com/en-us/library/aa964128.aspx) to create my own
legend. The document is excellent, five stars.
If you use the Custom Chart Color Palettes and Legends section from the doc
you will see what I mean. You are able to create your own legend and use what
you want and remove what you don't.
Hope this helps.
Reeves
"NP" wrote:
> I have created a hybrid bar chart / with line. Basically uses the bars to
> show sales for each geographic region. A single line is plotted showing the
> sales goal to be reached. The x axis is "Region" The y axis value 1 is total
> sales $. I added y value 2 to show the sales goal $ and the legend
> automatically got populated with series labels. I only want the x axis
> labels to be in the legend.
> How can I fix this?

Chart Labels at an angle?

Hi,

I have created a report with bar chart but the labels are too long and often go into next line. Is there any way to specify text orientation for labels of a bar chart? I would like to show the chart labels at an angle. Is it possible?

Any help will be appreciated!

This depends on which labels you are referring to. If you are referring to data point labels, then yes, it is possible to specifiy an angle. However, if you are referring to the labels on one of the axes, then no, it is not possible at this time to specify an angle. These labels are positioned automatically. The ability to manually set the angle for axis labels is a potential new feature for the next version of Reporting Services.

To Set the Angle for Data Point Labels:
In the Report Designer, there is a section on the Chart Value properties dialog that allows you to specify an angle for data point labels. This is located on the Point Labels tab of this dialog, which can be reached by creating or editing a Chart Value on the Data tab of the Chart properties dialog.

Chart Grouping Label Formatting

Is there a way to adjust the orientation of the grouping labels (x-axis) of a bar chart in a report.So instead of displaying the grouping label text horizontally I want to display the text vertically?Is there any way to access the chart object and code this in the report from properties ->code tab? Any suggestions?

From the "Axis Label Formatting Q&A" section of the following whitepaper: http://msdn.microsoft.com/library/en-us/dnsql90/html/MoreSSRSCharts.asp?frame=true#moressrscharts_topic3

Question (X-axis): How does automatic x-axis label positioning work?

Answer: Currently, built-in Reporting Services charts only allow automatic positioning in order to avoid overlapping the x-axis labels. The label direction (horizontal/vertical) of the axis labels depends on the label string sizes and the available space. X-axis labels are either shown horizontally in one line, horizontally in multiple lines with line breaks, or vertically. Showing x-axis labels at an angle, or explicit manual control over individual x-axis label positions is currently not supported.

Note There are several third-party chart add-ins that enable more control over axis labels. These add-ins can be installed on top of Reporting Services 2005.

Chart formatting and non breaking spaces

Hi all,

I'm having a problem and I cannot seem to find how to fix this anywhere on the web.

I have a stacked bar chart with my data labels showing down the x axis. My client wants me to put a bit of white space between the label and the actual chart. So I tried adding spaces to my data label but of course RS thinks they don't exist since they are not non breaking spaces.

How can I do the following in my chart label

=Fields!Myfield.Value & " "

As you can see I want to add a couple of spaces to my data label. I can't use &nbsp;, all the ampersands get confused. I tried & char(32) but RS doesn't like char(n). I tried ChrW(160) [I saw this in the web somewhere] but this didn't work either.

Is there anything I can do?

thanks in advance, I'm at my wits end (again)

Annabel

Try Chr(160).|||thanks but this made no difference....We have told the client we can't add spaces between the label and the axis, they are ok with it.

Chart formatting and non breaking spaces

Hi all,

I'm having a problem and I cannot seem to find how to fix this anywhere on the web.

I have a stacked bar chart with my data labels showing down the x axis. My client wants me to put a bit of white space between the label and the actual chart. So I tried adding spaces to my data label but of course RS thinks they don't exist since they are not non breaking spaces.

How can I do the following in my chart label

=Fields!Myfield.Value & " "

As you can see I want to add a couple of spaces to my data label. I can't use &nbsp;, all the ampersands get confused. I tried & char(32) but RS doesn't like char(n). I tried ChrW(160) [I saw this in the web somewhere] but this didn't work either.

Is there anything I can do?

thanks in advance, I'm at my wits end (again)

Annabel

Try Chr(160).|||thanks but this made no difference....We have told the client we can't add spaces between the label and the axis, they are ok with it.

Chart formatting and non breaking spaces

Hi all,

I'm having a problem and I cannot seem to find how to fix this anywhere on the web.

I have a stacked bar chart with my data labels showing down the x axis. My client wants me to put a bit of white space between the label and the actual chart. So I tried adding spaces to my data label but of course RS thinks they don't exist since they are not non breaking spaces.

How can I do the following in my chart label

=Fields!Myfield.Value & " "

As you can see I want to add a couple of spaces to my data label. I can't use &nbsp;, all the ampersands get confused. I tried & char(32) but RS doesn't like char(n). I tried ChrW(160) [I saw this in the web somewhere] but this didn't work either.

Is there anything I can do?

thanks in advance, I'm at my wits end (again)

Annabel

Try Chr(160).|||thanks but this made no difference....We have told the client we can't add spaces between the label and the axis, they are ok with it.

Chart Drill Through?

Is it possible to build a report that displays a chart and if a particular
bar or slice of the chart is clicked we can present the details for the data
associated with the Bar or SLice of the chart?Yes it can be done. After creating the charts go to the properties and then
data tab and then values and then edit individual values you can see the
"action" there you can give the link or jump to report.
Amarnath
"Steven H" wrote:
> Is it possible to build a report that displays a chart and if a particular
> bar or slice of the chart is clicked we can present the details for the data
> associated with the Bar or SLice of the chart?
>
>

Chart does not display when Toolbar=False

I have a basic bar chart that runs fine on a local 32 bit server both within an IFRAME and within the reports manager. However, on another server that is brand new and clean install of SQL Server 2005 (64 bit) that same chart will run fine within reports manager but not through a direct link (whether in an IFRAME or not).

I narrowed the problem down to the parameter Toolbar=False. If I leave off that parameter, the report runs fine but includes the header. If I set the parameter to True, it also displays fine with a direct link. I can also specify Parameters=False and that works fine. However, no matter what I try, setting Toolbar=False returns a report (showing text in textboxes) but the chart itself returns as an image placeholder with the little red x.

Obviously, I do not want the user to see the toolbar within the application. I tried looking at the logs and event viewer for clues and found nothing.

Can someone please help?

Well it appears I have run across a bug: http://support.microsoft.com/?kbid=921405

Why would Microsoft not release this hotfix without having to call them if it is a known problem when not in anonymous mode and should have been included in the latest hotfix post-SP1 rollup release?

Does anyone know where I might can simply get this hotfix?