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

Creating Multiple Charts

Hi,

With Report Builder, I created a basic chart using the chart Wizard..

I am wondering If I can create some 5 charts on a Single Page(Webpage), like a Mini Dashboard.

Can someone please guide me in this regard ?

Thanks in Advance for your help.

Regards,

Sundar

Dear Sundar,

Right Click your chart -> Properties -> Filter tab. You need to explore this tab to achieve what you want.

Here's a step by step article to do so.

HTH,

Suprotim Agarwal

|||

Thanks a lot Suprotim !

It gives exactly the information, I was looking for !!

Cheers,

Sundar

|||

Suprotim.

As per the Article, the author asks us to copy and paste the report , so that we get two Report side-by-side.

He doesnt mention how to copy the report !!!

Any idea how to do this ?

Thanks,

Sundar

|||

Dear Sundar,

Use the standard windows notion

Ctrl+C, Ctrl+V

If you have to display various charts, you will have to shorten the length/width of each and place them side by side. So select one, copy it and paste it besides the other.

HTH,

Suprotim Agarwal

|||

Suprotim,

Thanks again for your Reply.

I tried the windows Ctrl+C and Ctrl+V options.

Seems they are not working :-)

Btw, I am doing this in the 'Design Report' Tab.

Any reason why this is happening ?

Thanks a lot,

Sundar

Creating Multiple Charts

Hi,

With Report Builder, I created a basic chart using the chart Wizard..

I am wondering If I can create some 5 charts on a Single Page(Webpage), like a Mini Dashboard.

Can someone please guide me in this regard ?

Thanks in Advance for your help.

Regards,

Sundar

Dear Sundar,

Right Click your chart -> Properties -> Filter tab. You need to explore this tab to achieve what you want.

Here's a step by step article to do so.

HTH,

Suprotim Agarwal

|||

Thanks a lot Suprotim !

It gives exactly the information, I was looking for !!

Cheers,

Sundar

|||

Suprotim.

As per the Article, the author asks us to copy and paste the report , so that we get two Report side-by-side.

He doesnt mention how to copy the report !!!

Any idea how to do this ?

Thanks,

Sundar

|||

Dear Sundar,

Use the standard windows notion

Ctrl+C, Ctrl+V

If you have to display various charts, you will have to shorten the length/width of each and place them side by side. So select one, copy it and paste it besides the other.

HTH,

Suprotim Agarwal

|||

Suprotim,

Thanks again for your Reply.

I tried the windows Ctrl+C and Ctrl+V options.

Seems they are not working :-)

Btw, I am doing this in the 'Design Report' Tab.

Any reason why this is happening ?

Thanks a lot,

Sundar

Creating Multiple Charts

Hi,

With Report Builder, I created a basic chart using the chart Wizard..

I am wondering If I can create some 5 charts on a Single Page(Webpage), like a Mini Dashboard.

Can someone please guide me in this regard ?

Thanks in Advance for your help.

Regards,

Sundar

Dear Sundar,

Right Click your chart -> Properties -> Filter tab. You need to explore this tab to achieve what you want.

Here's a step by step article to do so.

HTH,

Suprotim Agarwal

|||

Thanks a lot Suprotim !

It gives exactly the information, I was looking for !!

Cheers,

Sundar

|||

Suprotim.

As per the Article, the author asks us to copy and paste the report , so that we get two Report side-by-side.

He doesnt mention how to copy the report !!!

Any idea how to do this ?

Thanks,

Sundar

|||

Dear Sundar,

Use the standard windows notion

Ctrl+C, Ctrl+V

If you have to display various charts, you will have to shorten the length/width of each and place them side by side. So select one, copy it and paste it besides the other.

HTH,

Suprotim Agarwal

|||

Suprotim,

Thanks again for your Reply.

I tried the windows Ctrl+C and Ctrl+V options.

Seems they are not working :-)

Btw, I am doing this in the 'Design Report' Tab.

Any reason why this is happening ?

Thanks a lot,

Sundar