Hi

this is an urgent query i want to use store procedure to make some calculation and then want to draw a graoh by returned value.
i am using sql server report services and i want to know how we create store procedure in this and how we execute and how can i get data which i can send to graph.
please explain step by step

thanks
shivani

Hi there,

If you want to use a stored procedure, first create that procedure in SQL Server.
Next, open your report and switch to the Data tab. Click the button with the three ellipses (Edit Selected DataSet), choose StoredProcedure from the Command type drop-down and click OK.
The toolbar of the Data tab changes and displays a drop-down with all your procedures. Choose your procedure from the drop-down.

From this point on, things are pretty much the same as with a direct SQL statement.

Hope this helps,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Pretty by KoRn (Track 8 from the album: Follow The Leader) What's This?

Hi Hovik,

Did you miss the original topic of this post (Microsoft SQL Server Reporting Services, Microsoft's Reporting solution), or is there something about RS that I don't know (which is quite possible as I do not know much about it ;) )....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Suck it Up by Hed Planet Earth (Track 1 from the album: Blackout ) What's This?

Opps! I guess I post it to wronge Topic!
Sorry Imar & shivani16

Always:),
Hovik Melkomian.