java.lang.ClassCastException

[camnott]

Caused by: java.lang.ClassCastException: com.microsoft.sqlserver.jdbc.SQLServerConnection cannot be cast to net.sf.jasperreports.engine.JRDataSource

I am trying to create a connection to a data source for my subreport - here is parameter expression :

(Blocked out company information for this)

<parameter name="subreport_datasource" class="java.sql.Connection" isForPrompting="false">        <defaultValueExpression><![CDATA[java.sql.DriverManager.getConnection("jdbc:sqlserver://Host;databaseName","user","pword")]]></defaultValueExpression>    </parameter>[/code]

 

[mlopez_1]

The parameter is well.

Perhaps the problem is where you use it.

Mariano

[Friendly User]

Here you try to pass a connection as the data source parameter. Try to pass it as reports connection expression.

[camnott]

Thank you "Friendly User" - This was the issue. It is now working the way that I need it to.