Showing posts with label quantity. Show all posts
Showing posts with label quantity. Show all posts

Wednesday, March 7, 2012

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

Sunday, February 19, 2012

Chart Axes Labels

I need to dynamically name the axes of a chart as the data plotted can be changed - Sliced. Ie. Sales dollars, Quantity, Profit etc.
The dataset that is used to plot the graph does not contain the measure description (it's a generic name - MeasureModifier). There is a second data set that contains all the descriptions that the report can be sliced on.
I have a text box that displays the description of the measure and I tried referencing the value as an expression from the Y axes title expression box. - =ReportItems!Parameter1_1.value
However it returns "Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope."
Does anybody know of any other way I can referrence values outside the dataset that the object is derived from?
Cheers
KevinI can actually reference a regular textbox value for the y axes label.
What I can't do - from the Y axes label or even from another text box is reference a value from a textbox that is inside a list box. The list box has a filter that only returns one row from the data set and the textbox displays the field from the dataset. I need to reference that value for the Y axes title but keep getting the error below when I use ReportItems!...
Any ideas how to overcome this?
Thanks
Kevin
"Kevin Wilson" wrote:
> I need to dynamically name the axes of a chart as the data plotted can be changed - Sliced. Ie. Sales dollars, Quantity, Profit etc.
> The dataset that is used to plot the graph does not contain the measure description (it's a generic name - MeasureModifier). There is a second data set that contains all the descriptions that the report can be sliced on.
> I have a text box that displays the description of the measure and I tried referencing the value as an expression from the Y axes title expression box. - =ReportItems!Parameter1_1.value
> However it returns "Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope."
> Does anybody know of any other way I can referrence values outside the dataset that the object is derived from?
> Cheers
> Kevin
>