I want to know Reporter 3.9 can support MSSQL 2008 R2 64bit ?
Yes, its supported. Use "SQL Native Client driver" to create DSN (so you need to install SQL client package on Reporter server). I have successfully implemented this solution (sql server 2008 r2 64bit was on the remote host).
Also is reporter 3.9 supports Remote SQL database ( SQL 2008) on cluster??
I got a reply from hP that SQL 2008 on Remote database cluster is supported