MSSQL 2005 Stored Procedure and xaction

[forum2reg]

I have no luck making reports with resultset generated from a MSSQL 2005 Stored Procedure

Also passing parameters from Xaction to the stored procedure doesn't work also.

Reports with normal SQL query do work with no problem, so the db connection is setup properly

Do the experts here have any idea? or I miss something ? or Any Example for me to follow to build such report ?

Million thanks

[pstoellberger]

how do you call the stored procedure?
exec spoc_name?
i think the only chance to get the result-set is, if you are able to do a select * from proc_name
im not sure if this works with stored procedures... probably you need a table scalar function (if thats the right name) that calls the stored procedure

-paul