[same Parameter in all subdatasets]

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

[same Parameter in all subdatasets]

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>

 

[java.lang.IllegalStateException: Cannot deactivate]

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.