Unanswered: Problem on Dynamic SQL with MsSQL Server 2000 in Crystal Report(at VB.net)
Hi, I have a problem on using dynamic SQL in MsSQL Server 2000 to Crystal Report(which is in sp execute itself is no problem). The problem i facing as below:
create proc sp_Test
set @TmpStr = 'Select f1,f2 from table1 where f1 in (' + @Condition + ')'
execute sp_executesql @TmpStr
if this statement we run in store procedure by exec sp_test '111' --> Assume 111 is a condition value,
it is ok and can return value to me, but now if i try to use Crystal Report to call the sp (At Design mode of Crystal Report), it will return error
" unclose quotation marks before the character String ')' "