August 8, 2008 at 12:33 pm
Zipped, and Attached
August 8, 2008 at 6:12 pm
Great I'll take a look either over the weekend or on Monday morning.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 8, 2008 at 6:22 pm
It would be great if you also post your specific questions here. 🙂
SQL Server Database Administrator
August 8, 2008 at 8:41 pm
Can you also post your full create procedure statement? And, please try executing the procedure in a query window as:
Execute 'your procedure name here';
And post the results of the above?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 8, 2008 at 8:49 pm
Disregard my previous post - I see the problem you are having. Stored procedures are created and stored in the database - not in the report.
Open SSMS, connect to the database you are working with and open a New Query window. Once opened, copy the code from the data window in the report into the new query window and execute the code.
This should create a stored procedure on the database. BTW, change the create procedure statement to: CREATE PROCEDURE dbo.PercAvg AS ... This will create the procedure in the 'dbo' schema.
If you get an error trying to create the procedure, post the error here and we can help you get the procedure created. The procedure may already be created under a different schema - which you should delete (the other schema will be the one that matches the user you are logging in with for the report).
Once you have the procedure created, test the procedure in another query window by executing the command:
Execute dbo.PercAvg;
Once you have this worked out and you see the results are correct - you can then modify the report to use the stored procedure. In the database window - removed everything and replace it with: dbo.PercAvg and make sure the type is selected as Stored Procedure. At this point - you should be able to test the dataset by running it, and if it returns data - test the report.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 11, 2008 at 7:58 am
Jeffery,
That seemed to get everything working just fine. No problems getting the SProc created, ran just fine, and it works in the report as well.
Until I break something else, I think we can consider this one closed.
Lenny, Jack, Antonio, and Jeffery - A special thank you to each of you. I certainly would have never gotten through this one without you guys.
August 11, 2008 at 10:54 am
I am happy that you are now able to move forward. Glad we could help.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 11, 2008 at 12:09 pm
Since you had figured it out I didn't take a look.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 8 posts - 31 through 37 (of 37 total)
You must be logged in to reply to this topic. Login to reply