Crystal Report not accepting parameters

[TudorSmith]

Hi All

I have a Stored Procedure sourcing an SQL 2000 database. The SQL Query analyser runs the SP fine (including any parameters I pass in). the paramters are:

@Year INT,
@Period INT,
@GroupOG VarChar(50)
@Analyser VarChar(25)

Now, when I bind my Crystal Report (v 9.0) to this stored procedure, it runs fine as long as the @GroupOH parameter has no spaces i.e. 'Broxbourne' or 'Electricians' But when I pass in a parameter with a space i.e. 'Cheif QS' or 'Commercial Director' I get error messages stating: "Not Supported - Cannot obtain error message form server"

now this is pointing to the Stored procedure being wrong, but it runs fine in SQL Query analyser...so it can't be wrong.

do you think my report cannot handle the spaces? If so, how can I convince the report to accept them with spaces?

So long winded...I hope I've explained myself

Tudor

birklea ~©¿©~ <><
Dim objJedi as Jedi.Knight
Set objJedi[skyWalker].Aniken = FatherOf(useThe.Force(objJedi[skyWalker].luke))

 

[synapsevampire]

Sounds buggy to me.

Perhaps the service pack will help:

http://support.businessobjects.com/fix/hot/si75/default.asp

-k