metricmine

never mind, I figured out the fix. should not have been set to report execution.

Hi, I did this, and it works great. BUT if I have 3 datasets all of which reference the same main parameter, the report now prompts for the report parameter three times, highly undesirable. code fragment below, I see the prompt for CLIENTAPPNAME three times. <dataset> <datasetRun subDataset="dataset3"> <datasetParameter name="parameter1"> <datasetParameterExpression><![CDATA[$P{CLIENTAPPNAME}]]> </datasetParameterExpression> </datasetParameter> </datasetRun> </dataset>

Code:Hi, I'm getting this error against Vertica (per screenshot). I am using Vertica as the source (JDBC). I do not see this in context.xml or jasperserver.xml therefore the earlier suggested fixes do not help me. Also tried to append "&autoReconnect=true" on a lark - just in case this mysql-specific syntax worked for vertica but it didn't. Any advice would be appreciated. Details in screenshots attached.