查询中的Pentaho Report Designer错误
技术问答
259 人阅读
|
0 人回复
|
2023-09-12
|
|
我在尝试Pentaho Report Designer创建我的第一份报告。我创建了一个JDBC添加数据源和查询：
$ F$ i4 L$ K: e. U+ `SELECT a.* FROM (SELECT Sum(loan_receivable_detail.interest) AS interest, loan_account_opening_id FROM loan_receivable_detail GROUP BY loan_account_opening_id) AS a但是，当我保存查询时，它改为：' [+ W: v& ?2 C5 L8 D& s2 Z) z
SELECT a.*, sum(loan_receivable_detail.interest) AS interest, loan_account_opening_id AS interestFROM `loan_receivable_detail`GROUP BY loan_account_opening_id, as, a我的查询中是否有任何问题导致这样的变化？该语法在其他查询分析器中非常有效。
& U. E! J/ ^6 H0 ~! o 1 I) {8 K0 J$ O2 f! a; A
解决方案: |
|
|
|
|
|
|
|
|
|
