Exception when using formulas referencing fields from a table with an alias. The field name not known

I am using CRJavaHelper to display report on web but it’s not accessing alias of table.

I believe settablelocation is breaking the link so i need to use replaceconnection method instead

Can any help me with demo replaceconnection method code instead of my below current code.

try {

        String reportName = “test.rpt”;

        ReportClientDocument clientDoc = (ReportClientDocument) session.getAttribute(reportName);

        if (clientDoc == null) {

            // Report can be opened from the relative location specified in the CRConfig.xml, or the report location

            // tag can be removed to open the reports as Java resources or using an absolute path

            // (absolute path not recommended for Web applications).

            clientDoc = new ReportClientDocument();

            clientDoc.setReportAppServer(ReportClientDocument.inprocConnectionString);

            // Open report

            clientDoc.open(reportName, OpenReportOptions._openAsReadOnly);

            // ****** BEGIN SET RUNTIME DATABASE CREDENTIALS ****************

            {

                String connectStr = PropertyLoader.getProperty(“DBURL”);

                String JNDIName = PropertyLoader.getProperty(“DB_POOL_NAME”);

                String driverName = PropertyLoader.getProperty(“DBDRIVER”);

                String userName = PropertyLoader.getProperty(“DBUSER”);    // TODO: Fill in database user

                String password = PropertyLoader.getProperty(“DBPASSWD”);    // TODO: Fill in valid password

                // Switch all tables on the main report and sub reports

                CRJavaHelper.changeDataSource(clientDoc, userName, password, connectStr, driverName, JNDIName);

                // logon to database

                CRJavaHelper.logonDataSource(clientDoc, userName, password);

            }

Thanks in Advance.

Vish