I have a stored procedure called 'spD_DefectsByStateAndSeverity' which is defined as follows:

CREATE PROCEDURE [dbo].[spD_DefectsByStateAndSeverity]
(
    @ProjectID int = NULL
)
AS
SELECT * FROM Defects

 When I try to create a custom report and enter the following SQL Command:

spD_DefectsByStateAndSeverity @ProjectID = 437

I get an error saying:

"The SQL statement you entered is invalid."

 I don't understand how this could be invalid.  Any help would be great thanks in advance.
 

I have copied the same exact stored procedure from this forum post and tested it on my end. The application did not seem to generate any errors when attempting to create a new custom report. Can you please give me the exact reproduction steps on this issue? Where do you exactly see this error message? Are you running the latest OnTime 2007 version 7.1.2?

Thank you, 

Hello nguiffrida,

I know this might sound basic, but has this stored procedure been created in the correct database?

If so, make sure you've granted 'execute' permissions to public for that stored procedure.

Let me know if setting the execute permission to public resolved the issue.

I'm not an SQL expert, but it doesn't look like you're requiring use of the variable that you've declared. Try:

...
AS
SELECT * FROM Defects
WHERE [Defects].[ProjectID]=@ProjectID