CA Service Management

Good day...

Has anyone created new custom SDM reports in Jaspersoft Studio 6.3 that will work in Jaspersoft 6.2.

We are having issues with applying filters...like date filters multiselect on groups and categories.

Does anyone have more documentation in this regard or can help us in the right direction?

ANY help will be appreciated.

Thank you

Ronel

Hi Ronel,

Have you opened up the OOTB that get delivered and see how input controls are implemented within those reports?    If so and you are still having issues can you provide more details on exactly what your problems are so we can try to help?

Regards,

Steve

Hi Steve

Yes we have opened the input controls and copied it exactly as they used it and still not working.

We are using the OOTB multi select request area input control on our report (p_requestarea), create the parameter in our report and also added it to the where clause as per the OOTB reports.

Please see below an example of what was done

SELECT cr.ref_num,

                cr.summary,

                cr.open_date,

    cr.group_name,

                cr.request_area_symbol

FROM cr

WHERE cr.request_area_symbol IS NOT NULL AND cr.type = 'R' AND ( cr.request_area_symbol in $P! or '*' in $P! )

com.jaspersoft.jasperserver.api.JSException: Error filling report

Arguments:

                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1294)

                at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:210)

                at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:134)

                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:922)

                at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:164)

                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:878)

                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1774)

                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1118)

                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1047)

                at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:944)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

                at java.lang.Thread.run(Thread.java:745)

Caused by: net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query:

SELECT cr.ref_num,

                cr.summary,

                cr.open_date,

    cr.group_name,

                cr.request_area_symbol

FROM cr

WHERE cr.request_area_symbol IS NOT NULL AND cr.type = 'R' AND ( cr.request_area_symbol in  or '*' in  )

                at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:486)

                at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:295)

                at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)

                at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:113)

                at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)

                at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)

                at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437)

                at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:526)

                at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)

                ... 10 more

Caused by: java.sql.SQLException: [OpenAccess SDK JDBC Driver][OpenAccess SDK SQL Engine]syntax error, unexpected '*', expecting '(' at request_area_symbol *

                at com.ddtek.openaccess.ssp.Diagnostic.toSQLException(Unknown Source)

                at com.ddtek.openaccess.ssp.Chain.cnvDiagnostics(Unknown Source)

                at com.ddtek.openaccess.ssp.Chain.decodeDiagnostic(Unknown Source)

                at com.ddtek.openaccess.ssp.Chain.decodeBody(Unknown Source)

                at com.ddtek.openaccess.ssp.Chain.decode(Unknown Source)

                at com.ddtek.openaccess.ssp.Chain.send(Unknown Source)

                at com.ddtek.openaccess.ctxt.stmt.StatementContext.associate(Unknown Source)

                at com.ddtek.jdbc.openaccess.OpenAccessImplStatement.prepare(Unknown Source)

                at com.ddtek.jdbc.oabase.BaseImplStatement.prepare(Unknown Source)

                at com.ddtek.jdbc.oabase.BasePreparedStatement.prepareSQL(Unknown Source)

                at com.ddtek.jdbc.oabase.BaseStatement.preProcessSQL(Unknown Source)

                at com.ddtek.jdbc.oabase.BasePreparedStatement.

Could you solve this issue?

Regards,

JOHN