October 28, 2010 at 7:58 am
Hey everyone,
I'm new to the SSRS Charts function. I'm trying to create a Bubble Chart from a report. I have the data coming in from a SQL table fine. I encounter 2 problems. When I try to populate the report, it looks as though a report from only one store is populating. On the chart I have x & y values, but on the Bubble Chart only one bubble populates and it states I have 1 series of data. Am I doing something wrong? Is there something in the Report Parameters that I need to specify?
These are my columns: Store,Quantity,Price. Store(Region1),Quantity(Region1),Price(Region1). I'm trying to display stores from different regions and their sales on one chart. How can I do this?
Hope you guys can help me out.
Thanks
November 1, 2010 at 7:29 am
Hi,
If you are using SSRS 2005 then edit values field in Data tab of chart properties as follows.
x =Fields!Store.Value
Y =Fields!Region.Value
Size = Fields!Sales.Value (If u want sum u can display accordinly)
When you drag the store column in X value or y value the default would value would be sum(field!Store.value). That is whay its not showing all the stores in your chart.
Hope this should help.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply