drummer54 Posted July 3, 2014 Share Posted July 3, 2014 Can someone explain to me how to create a stacked bar chart that looks like the attached TIFF file (created with SQL Server Reporting Services) using a dataset like that shown in the attached Excel spreadsheet?In the event that it's not clear, each bar shows the percent of the total represented by the number of items that are late, missing or compliant. There is one bar per category.I'm using JasperSoft Studio 5.6.final.Thanks. Link to comment Share on other sites More sharing options...
H Mendoza Posted July 3, 2014 Share Posted July 3, 2014 Using Chart, Charts Pro or HTML5? All three are available from the Palette, and good starting point is to drag one of the chart types into the Summary band. You'll need at least a Category and a Measure configured. You may want to read the user documentation; there's a good section in there on Charts. Link to comment Share on other sites More sharing options...
drummer54 Posted July 3, 2014 Author Share Posted July 3, 2014 I'm using whatever chart control is included with JSS 5.6 and selecting stacked bar chart as the chart type. I don't see anywhere to add a Measure. The only really extensive chart examples I've located in the documentation and elsewhere on the web are for a pie chart, and I haven't been able to translate that into the kind of bar chart I require. I get all kinds of weird results no matter how I set up. I'm wondering if the series data all needs to be on the same row of data? Link to comment Share on other sites More sharing options...
rajesh.sirsikar Posted July 10, 2014 Share Posted July 10, 2014 Hi drummer54,With the dataset provided by you in teh excel sheet, you can not achieve 100% stacked Bar as you would need rows level data per category, whereas your dataset has column level data per category.So I have modified the dataset and have created 100% stacked bar chart. (Attached the dataset xls and the screenshot of the Chart.Thanks,Rajesh Swww.rajeshsirsikar.com Link to comment Share on other sites More sharing options...
drummer54 Posted July 10, 2014 Author Share Posted July 10, 2014 Thanks. I suspected it was the data, but as it's being generated by a stored procedure for a current production report in SQL Server Reporting Services I'm not at liberty to modify it. I may just pull the SQL out of the stored procedure to embed in the JS report as a temporary solution. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now