请帮助我通过PHP代码将报告参数传递给"Reportica报告"。
这是我尝试过的方法:
PHP代码:
require_once('../reportico/reportico.php');
$q = new reportico();
$q->initial_project = "loansys";
$q->initial_project_password = "k013";
$q->initial_report = "loansys.xml";
$q->initial_output_format = "HTML";
$q->embedded_report = true;
$q->allow_debug = true;
$q->forward_url_get_parameters = "";
$q->external_param1 = 1;
$q->execute($q->get_execute_mode(), true);
报表查询:
SELECT l_number,due_number,due_date,amount,capital,interest
FROM loan_due
WHERE l_number = {external_param1}
错误信息:
错误:连接中的错误 (1064):SQL 语法有错误;请查看与您的 MySQL 服务器版本对应的手册,了解在"})"附近使用的正确语法在 3 号线
我的脚本:
require_once('../reportico/reportico.php');
$q = new reportico();
$q->initial_project = "xxxx";
$q->initial_project_password = "xxxx";
$q->initial_report = "xxxx.xml";
$q->initial_execute_mode = "MENU";
$q->access_mode = "SInGLEPROJECT";
$q->embedded_report = true;
$q->user_parameters["lnumber"] = $_POST['cmblnumber'];
$q->execute();
我的报告查询:
select
l_number, due_number, due_date, amount, capital, interest
from
loan_due
where
l_number = "{USER_PARAM,lnumber}"
limit
0, 30