Hello, I'm new to creating reports and need some help setting up a data adapter to talk to my JasperReports Server in AWS.
I can connect to the server using Studio and everything shows up fine. I tried creating a JR adapter, but not sure how to point it at the server, domain, etc. Halp!
Is the error from Jaspersoft Studio or from JasperReports Server?
>net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: tibcosoftware.jdbc.sqlserver.SQLServerDriver
The error is just saying you're missing a jar file. I strongly recommend not using Tibco software's jdbc driver but instead use jdbc driver from Microsoft.
You'll need to specify the jar file in the "Driver Classpath" tab in Jaspersoft Studio and upload the jar file when creating Datasource in JasperReports Server.
Update, I was able to add the data source from the server, but when creating a new report studio hangs on getting data from the data source. Am I missing a driver?
Error text when testing connection: