Reports Module 4.5.2

I have a stored procedure I'm looking to call from a Reports Module query, then use the returned value in the remainder of the query:

DECLARE @myVar INT
EXECUTE @myVar = mySPROC_Get

SELECT ...

WHERE tblCol1 > @myVar

What I find is that EXECUTE runs and Reports Module renders only the value returned from the EXECUTE call; SELECT never executes.

Is there another way I should use EXECUTE in Reports Module?

The Reports Module only considers the first resultset returned by your query, in this case it appears that the EXECUTE is returning a resultset. I'm not a SQL guru, but making the whole thing one SPROC might help.

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer