Error with Subreport Expression

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?