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.
| 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 |
|
|
|
|
|
|
Creating Charts Using stored Procedures