Call JasperReports from URL

Author: Willie
Date: 2018/11/06

Jasperreport允許直接在URL輸入帳密來存取Report
下述範例

j_username代表login account id,
j_password代表login password
ItemCode代表該Report參數值
其他的前綴URL則先到該報表Copy Browser上網址列的URL


http://<URL>/jasperserver/flow.html?_flowId=viewReportFlow&_flowId=viewReportFlow&ParentFolderUri=%2FQT_REPORTS%2FGeneral&reportUnit=%2FQT_REPORTS%2FGeneral%2FJ1808001&standAlone=true&j_username=appuser&j_password=appuser999999&ItemCode=9901000100

上面的範例則是使用B1UP結合JASPERREPORT報表的方式。

[Reference]
https://community.jaspersoft.com/questions/532920/call-jasperreports-url

Jaserreport SQL Server connection

Author: Willie
Date: 2018-10-30
-----------------------

Download SQL JDBC Driver
https://www.microsoft.com/en-us/download/details.aspx?id=54671


Select to the Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver



Use`sqljdbc4.jar` file

Click Test ~ done!