different datasource in subreport

[guenter.kuhnke]

I have this problem with Jasperstudio 6.2.0. I would like to use a subreport with different datasource than the main report. I use the connection string

java.sql.DriverManager.getConnection("jdbc:sqlserver://server-url:port;databaseName=dbname","user","pw"). I alwas get the error

No suitable driver found for jdbc:sqlserver://xxxxx:1433;databaseName=xxxxxxxxxxx.

I have already added the driver in the classpath of the Jaspersuite Preferences and although looked for similar discussing the problem using

a different datasource in a subreport; nothing i found and tried yet solved my problem.

Any useful hint?

 

Thanks