I want to produce a combination Column / Line chart for sales and budgets by amount/month
Sales figures should be displayed as lines with a separate line for each year.
Budgets should be displayed as columns. I will only be displaying budgets for the current year.
Is it possible to do this within Reporting Services - if so what chart type do I use
Hello Experts,
Problem here. Trying to display database column information in a chart. Basically I have a dbase query that pulls different percentiles on transaction. So when I run the query, a number appears in the data for columns called 95th percentile, 97th percentile and 99th percentile.
Now I know how to filter the data in reports by a parameter, however I do not know how to show columns by a parameter. Specicially in a chart situation. So if I choose 95th Percentile in a parameter dropdown box, I want to see the chart for the 95th percentile column in the database, likewise with the other columns.
I am not sure how to show/hide these via a parameter when charting. Anyone have any ideas?
Has anyone heard as to whether Microsoft plans on updating the charting engine for Reporting Services? Right now I find the charting capability rather limited and would like to see richer charting capability. Is this a case where it is better to not wait for this feature as it will be way off into the future before this happens, or better charting features just are not in the scope of Microsoft's plans for Reporting Services. If either case is true then the best solution would be to purchase the full capabilities of Dundas Chart for Reporting Services.
View 1 Replies View RelatedI would like to create a bar chart and at the same time display some text after each bar.
I guess I could just create some textboxes on the chart, but I have a parameter that the user can change to specify the numbers of bars (therefore the number of textboxes, and the location of the textboxes are variables)
Is there anyway that I could do this in reporting services?
Thanks,
Steven
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)
View 3 Replies View RelatedCan SSRS be configured to use any third party .NET charting components or only ones that have been specifically designed for SSRS? I have seen a couple of third party charting software (Dundas, etc.) and while they are nice, they sell at a real premium and there are not many vendors offering SSRS charting. I was hoping for a bit better value and more of a selection to choose from.
R
I have a table which contains data regarding calls to the Help Desk, I want to chart this using a simple line chart in SSRS 2005 with the chart displaying the number of cases opened by the help desk each hour for the last 24 hours. Although our Help Desk provides 24/7 support, there are periods of an hour in which no calls are received. The issue I'm having is I want the chart to still display these hour periods of time even though there are no records created in the time span. I want the x-axis to display every hour for the last 24 hours.
Anyone have any suggestion on how I can accomplish this? The only idea I've come up with is creating a new table containing a list of every hour in a day and referencing this to build the x-axis...but it seems as though it should be easier than that?
Thanks in advance for any input or assistance.
Does anyone know if you can do polar charting with Reporting Services? I have a need to report the polar coordinates of an element and show the polar chart of the data elements. If I can't do polar charting with Reporting Services, does anyone know of a third party product that I can utilize?
Thanks
KM