Creating Charts Using stored Procedures

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

Creating Charts Using stored Procedures

Author

Topic

srinivasparimi
Starting Member

3 Posts

Posted - 2006-07-21 : 06:10:55

Hi all,

I want to create charts(pie/bar) using stored procedures for the table record values in sql server 2005 express edition.

plz help me for the above topic

Thanks & Regards,
Srinivas

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-21 : 06:13:20

The stored procedure will just return the data you will need another product to draw the chart from that data.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

srinivasparimi
Starting Member

3 Posts

Posted - 2006-07-24 : 01:45:40

Hi,

thank you for ur reply.. tell me that which type of products are there to create charts after getting the values from database..

Can i use Visual Studio .Net?

Thanks & Regards,
Srinivas

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2006-07-24 : 02:39:02

http://www.google.com/search?ie=UTF-8&oe=UTF-8&sourceid=deskbar&q=.net+charts

Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson

lobsterZoom
Starting Member

9 Posts

Posted - 2007-04-23 : 06:59:05

(Spam removed.)

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-23 : 06:59:43

SPAM SPAM SPAM

Peter Larsson
Helsingborg, Sweden

mikewa
Microsoft SQL Server Product Team

84 Posts

Posted - 2007-04-23 : 12:11:54

Different products suit different needs depending on what you want to do with the charts.

- If you just want to do some analysis, import the data in to Excel and do the anaylsis there. (You could then take the chart from Excel and paste it into a PowerPoint presentation, etc.)
- If you want to have "live reports" you could use Reporting Services, which you can get in SQL Express with Advanced Services, this required that your computer be running IIS.
- If you want to embed your reports in your application, VS offers reporting controls starting with VS Pro. (Might be in Standard as well, I'm not sure.) Note: There are report designer controls available for VWD Express if you're doing web development.
- You could take a look at Crystal Reports as well.
- You can write reports in Access using linked tables to SQL Server.
- There are a number of third party reporting tools and controls that I'm sure you could fine using a Microsoft Live search.

Regards,
Mike Wachal
SQL Express

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources