I created a report with a table in it from a query that I am pulling from SQL. The table has 16 columns the first column is the month the other 15 columns are data that needs to be displayed for each month. There are 12 rows representing each month of the year. What I would like to do is separate the data into a bar chart for each column for the year. So for example the y axis would have the value and the x axis would have a bar for each month for that column. I would create 15 bar charts one for each column of data. Thanks.
Create new params of Dataset type and use the default value expression to coerce the data from the SQL Data Source into the structure you need for bar charts? That is how I would do it… I think. Good Luck!