Hello.
This issue stems from my report concept. I am trying to create a main report that houses minimal information. I then have a sub report that pulls in some related information from other db tables.
I am trying to add another subreport that uses a separate datasource from the other two reports. I have searched online and found a solution that I thought would work, and I still think that it would work, if not running into this issue :
java.sql.DriverManager.getConnection("jdbc:sqlserver://Host\Name;dbName","username","password")
Now - Before anyone answers saying that I should not have the //Host\Name portion - I know this... This is my problem...
When the DBA's in my organization named this, they added that backslash ( \ ) into the hostname. I cannot get around this if I want to connect.
I was able to create a Data Adapter using this, but cannot create an expression using the same. Kicks out the following : Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\)
Is there a workaround, or another method that will be equally successful? The report runs, and the first subreport shows its data, but second subreport shows nothing, no matter what I do (because it is not getting data from the correct data source)
Any Ideas?
4 Answers:
Thank you for your comment, that just produced a different error - which leads me to believe that the first error was not the issue in the first place... :
com.microsoft.sqlserver.jdbc.SQLServerConnection cannot be cast to net.sf.jasperreports.engine.JRDataSource