Creatng Charts Using scripts in sql server 2005 express

Hi all,

I want to Create charts for database table entries in sql server 2005 express edition, by using the scripts only not through wizards...

Plz help me for the above topic

Thanks & Regards,
Srinivaswhat scripts are you refering to? TSQL?|||Hi,
I just want to prepare the charts with out using wizards..., by using some stored proceduers we can get the data from database and then create the charts with some code( script).., that scripts r in visual studio or any thing ,

give me some idea about that one (or) give me some links related to this topic..

thanking you very much..

regards,
Srinivas|||

Hi,

I really did not understand what you are talking about, but perhaps you are referencing the ReportViewer controls..http://msdn2.microsoft.com/en-us/library/ms251671.aspx

regards

|||

T-SQL only returns data, you will need to use some other program to generate the charts from the data. You could use the Reporting controls in VS but I believe the report designer for VS is only available in VS Pro and as a download for VWD Express. (The other Express products don't have report design as a feature.) You can also consider Report Server, which is part of SQL Express Advanced. You will additionally need the SQL Express Toolkit to get the report design projects as part of BIDS.

Office also provides charting capabilities in both Excel and Access. Just retrieve the data and create your chart. In Office 2003 I found Access to have slightly better charting capabilities because of the use of the Office Web Components, but Excel has better analytical tools if you want to manipulate the data prior to creating your charts.

There are also a number of third-party tools and controls that you should be able to find by searching the web.

Regards,
Mike Wachal