I have successfully created a layout table report using a stored procedure (with passed parameters) as the source of data for the report. In the report editor, I am able to develop, test and run the report successfully.
I am using the report as an HTML report. I have used the "Generate Xbasic" to create the a5w code to place in my web page.
The xbasic/a5w output does contain the proper call to MySQL for the stored procedure and actually has some code to request the parameters in a dialog, but I want to be able to set the parameters at run time.
The issue I am having is: How do you pass the parameters to the report in the HTML/A5w page. I would like to use request variables for the source of the parameters.
Here is a snippet of the output from the "Generate Xbasic". It shows the mysql procedure call "=@CALL spActuals(:cashflowguid,:period)", but where would I put in the code to set the parameter values for ":cashflowguid" and ":period"?
NOTE: For source, I am using the trick in the other post that showed how to get around the named connection string issue....
***********************************************
This is the error I am getting when I run the report in the web browser:
I am using the report as an HTML report. I have used the "Generate Xbasic" to create the a5w code to place in my web page.
The xbasic/a5w output does contain the proper call to MySQL for the stored procedure and actually has some code to request the parameters in a dialog, but I want to be able to set the parameters at run time.
The issue I am having is: How do you pass the parameters to the report in the HTML/A5w page. I would like to use request variables for the source of the parameters.
Here is a snippet of the output from the "Generate Xbasic". It shows the mysql procedure call "=@CALL spActuals(:cashflowguid,:period)", but where would I put in the code to set the parameter values for ":cashflowguid" and ":period"?
NOTE: For source, I am using the trick in the other post that showed how to get around the named connection string issue....
***********************************************
<!--A5Report::Report
source=SQL:__cs__
select=@CALL spActuals(:cashflowguid,:period)-->
<!--SQLArguments
<Arguments<[1]<variablename="cashflowguid">
<prompt="cashflowguid">
<type="Character">
<style="TextBox">
<default_value="">
<helptext="">
<choices="">
<maximumvalue="">
<minimumvalue="">
>
<[2]<variablename="period">
<prompt="period">
<type="Character">
<style="TextBox">
<default_value="">
<helptext="">
<choices="">
<maximumvalue="">
<minimumvalue="">
>
>
<DialogTitle="Specify Argument Values">
<OKButtonLabel="&OK">
<CancelButtonLabel="&Cancel">
-->
source=SQL:__cs__
select=@CALL spActuals(:cashflowguid,:period)-->
<!--SQLArguments
<Arguments<[1]<variablename="cashflowguid">
<prompt="cashflowguid">
<type="Character">
<style="TextBox">
<default_value="">
<helptext="">
<choices="">
<maximumvalue="">
<minimumvalue="">
>
<[2]<variablename="period">
<prompt="period">
<type="Character">
<style="TextBox">
<default_value="">
<helptext="">
<choices="">
<maximumvalue="">
<minimumvalue="">
>
>
<DialogTitle="Specify Argument Values">
<OKButtonLabel="&OK">
<CancelButtonLabel="&Cancel">
-->
500 Internal Server Error
Script Error
Error:Script:" /cm/report_pl_sp.a5w" line:344
dim outhtml as c = rg.Generate()
An argument value was referenced in the SQL query, but no argument list was provided while opening connection
Current Connection Properties:
Database API = MySQL
Database Syntax = MySQL
Trace SQL = No
Database = cashmax
Port = 3306
Server = localhost
UserName = root
Script Error
Error:Script:" /cm/report_pl_sp.a5w" line:344
dim outhtml as c = rg.Generate()
An argument value was referenced in the SQL query, but no argument list was provided while opening connection
Current Connection Properties:
Database API = MySQL
Database Syntax = MySQL
Trace SQL = No
Database = cashmax
Port = 3306
Server = localhost
UserName = root
Comment