Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm writing a console application that fetches data from database (SQL) and writes to an excel sheet. Now I want to add a chart in the workbook according to the datatable values. How can I create chart in the sheet before saving? How will I use dataset values to create chart?

Thank you.

share|improve this question
    
This looks more lika a programming question then a DBA question, you should ask on stackoverflow instead of dba.SE –  Daniel Serodio Aug 10 '12 at 18:05
    
I believe this question is in intersection between programming and business intelligence. BI questions are welcome here. These question is equally applicable to stackoverflow –  Atilla Ozgur Aug 10 '12 at 21:28
add comment

1 Answer 1

If you are using csv , you can not do this. But if you are willing to use other tools like Microsoft SQL Server Reporting Services or Crystal Reports you may do this.

If you can not install Reporting Services Server or do not want to, you can still use it for basic reporting purposes. Take a look at here,Microsoft Reporting without SQL Server Reporting Services.

Note that , I gave you examples for reporting services since it is easy to use out of box and in most cases free. But there are a lot of other tools exists which may be more suitable/powerful for your use case.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.