SSIS Build chart from table

Question

I've built a table in SSIS. I couldn't get the query to build the chart correctly. Can SSRS now build a chart based on that table? The Months and "opened/closed" are just typed in, not actual fields. 

The Table is like this....

January    Feb     March     April

Opened        45         34        34         45

Closed          67         21        54         89

Answer 1

Hi,

Can SSRS now build a chart based on that table?

Yes

Try this link for an example - http://sathyadb.blogspot.in/2013/06/ssrs-in-charts-how-to-display-all.html

---

sathya --------- Mark as answered if my post solved your problem and Vote as helpful if my post was useful.

Answer 2

There is no way to just highlight the table and say build chart?

Answer 3

Hello,

Based on your description, it seems that there are four columns in your table. If I understand correctly, you want to display the table data in the report as follows:
                 Type
Month     Opened    Closed
Jan            45          67
Feb            34          21
March         34         54
April           45          89

If so, you can try to unpivot the table  by creating  SSIS package.
Reference:http://msdn.microsoft.com/en-us/library/ms141723.aspx
http://www.sql-server-performance.com/2007/ssis-pivot-unpivot/

If I have any misunderstanding, please post the screen shot of the table and more information about your requirement.

Regards,
Fanny Liu

---

Fanny Liu
TechNet Community Support