stored procedures

[jeanjenkins]

 Hi,

I've written some stored procedures for iReports.  I now want to pass iReport parameters to those procedures.  Perhaps write a function I could use in a query, along with the iReport parameters.  Was wondering if anyone else had done this.  

 

Thanks in advance.

 

 

 

[kolaitis]

Something like that in iReport query :

 

(SELECT dbo.yourProcedure_Function (dataBaseFile.field, $P{iReport_Param1}))

as Name1

 

(select dbo.yourProcedure_Function ($P{iReport_Param1}, $P{iReport_Param2},

$P{iReport_Param3}, $P{iReport_Param4})) as Name2

 

AND

(SELECT dbo.yourProcedure_Function(dataBaseFile.field, $P{iReport_Param1},

$P{iReport_Param2})) = $P{iReport_Param3}

 

AND

dbo.yourProcedure_Function(dataBaseFile.field) = $P{iReport_Param4}

 

Good Luck....

 

[jeanjenkins]

 Hi, thanks.  Do you have an example of a function that executes a procedure that creates a temporary table, and returns the contents of that table?  Thanks in advance.  I'm using mysql.