path: root/ecomp-sdk/epsdk-analytics/src/main/java/org/onap/portalsdk/analytics/model/base/ReportWrapper.java

/*
 * ============LICENSE_START==========================================
 * ONAP Portal SDK
 * ===================================================================
 * Copyright © 2017 AT&T Intellectual Property. All rights reserved.
 * ===================================================================
 *
 * Unless otherwise specified, all software contained herein is licensed
 * under the Apache License, Version 2.0 (the "License");
 * you may not use this software except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *             http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 * Unless otherwise specified, all documentation contained herein is licensed
 * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
 * you may not use this documentation except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *             https://creativecommons.org/licenses/by/4.0/
 *
 * Unless required by applicable law or agreed to in writing, documentation
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 * ============LICENSE_END============================================
 *
 *
 */
package org.onap.portalsdk.analytics.model.base;

import java.io.Serializable;
import java.io.StringWriter;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Collections;
import java.util.GregorianCalendar;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import java.util.Set;
import java.util.StringTokenizer;
import java.util.TreeSet;
import java.util.Vector;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import javax.servlet.http.HttpServletRequest;
import javax.xml.bind.JAXBContext;
import javax.xml.bind.JAXBException;
import javax.xml.bind.Marshaller;
import javax.xml.bind.Unmarshaller;
import javax.xml.datatype.DatatypeConfigurationException;
import javax.xml.datatype.DatatypeFactory;
import javax.xml.transform.stream.StreamResult;

import org.onap.portalsdk.analytics.error.RaptorException;
import org.onap.portalsdk.analytics.error.RaptorRuntimeException;
import org.onap.portalsdk.analytics.error.UserDefinedException;
import org.onap.portalsdk.analytics.model.DataCache;
import org.onap.portalsdk.analytics.model.ReportLoader;
import org.onap.portalsdk.analytics.model.definition.TableSource;
import org.onap.portalsdk.analytics.model.runtime.FormField;
import org.onap.portalsdk.analytics.model.runtime.ReportParamValues;
import org.onap.portalsdk.analytics.model.runtime.ReportRuntime;
import org.onap.portalsdk.analytics.system.AppUtils;
import org.onap.portalsdk.analytics.system.ConnectionUtils;
import org.onap.portalsdk.analytics.system.DbUtils;
import org.onap.portalsdk.analytics.system.Globals;
import org.onap.portalsdk.analytics.util.AppConstants;
import org.onap.portalsdk.analytics.util.CachingUtils;
import org.onap.portalsdk.analytics.util.DataSet;
import org.onap.portalsdk.analytics.util.RemDbInfo;
import org.onap.portalsdk.analytics.util.SQLCorrector;
import org.onap.portalsdk.analytics.util.Utils;
import org.onap.portalsdk.analytics.xmlobj.ChartAdditionalOptions;
import org.onap.portalsdk.analytics.xmlobj.ChartDrillFormfield;
import org.onap.portalsdk.analytics.xmlobj.ChartDrillOptions;
import org.onap.portalsdk.analytics.xmlobj.ColFilterList;
import org.onap.portalsdk.analytics.xmlobj.ColFilterType;
import org.onap.portalsdk.analytics.xmlobj.CustomReportType;
import org.onap.portalsdk.analytics.xmlobj.DashboardEditorList;
import org.onap.portalsdk.analytics.xmlobj.DashboardReports;
import org.onap.portalsdk.analytics.xmlobj.DashboardReportsNew;
import org.onap.portalsdk.analytics.xmlobj.DataColumnList;
import org.onap.portalsdk.analytics.xmlobj.DataColumnType;
import org.onap.portalsdk.analytics.xmlobj.DataSourceList;
import org.onap.portalsdk.analytics.xmlobj.DataSourceType;
import org.onap.portalsdk.analytics.xmlobj.DataminingOptions;
import org.onap.portalsdk.analytics.xmlobj.FormFieldList;
import org.onap.portalsdk.analytics.xmlobj.FormFieldType;
import org.onap.portalsdk.analytics.xmlobj.FormatList;
import org.onap.portalsdk.analytics.xmlobj.FormatType;
import org.onap.portalsdk.analytics.xmlobj.JavascriptItemType;
import org.onap.portalsdk.analytics.xmlobj.JavascriptList;
import org.onap.portalsdk.analytics.xmlobj.Marker;
import org.onap.portalsdk.analytics.xmlobj.ObjectFactory;
import org.onap.portalsdk.analytics.xmlobj.PDFAdditionalOptions;
import org.onap.portalsdk.analytics.xmlobj.PredefinedValueList;
import org.onap.portalsdk.analytics.xmlobj.ReportMap;
import org.onap.portalsdk.analytics.xmlobj.Reports;
import org.onap.portalsdk.analytics.xmlobj.SemaphoreList;
import org.onap.portalsdk.analytics.xmlobj.SemaphoreType;
import org.onap.portalsdk.core.logging.logic.EELFLoggerDelegate;
import org.onap.portalsdk.core.util.SecurityCodecUtil;
import org.owasp.esapi.ESAPI;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

/**<HR/>
 * This class is part of <B><I>RAPTOR (Rapid Application Programming Tool for OLAP Reporting)</I></B><BR/>
 * <HR/>
 *
 * --------------------------------------------------------------------------------------------------<BR/>
 * <B>ReportWrapper.java</B> - This is the base class for the RAPTOR. This involves in creating,<BR/>
 * modifying, running RAPTOR reports.<BR/>
 * --------------------------------------------------------------------------------------------------<BR/>
 *
 *
 * <U>Change Log</U><BR/><BR/>
 *
 * 31-Aug-2009 : Version 8.5.1 (Sundar);<UL><LI> All the elements in the meta xml is copied to the target reports. </LI></UL>
 * 18-Aug-2009 : Version 8.5.1 (Sundar);<UL><LI> request Object is passed to prevent caching user/roles - Datamining/Hosting. </LI></UL>
 * 27-Jul-2009 : Version 8.4 (Sundar); <UL><LI> verifySQLBasedReportAccess method checks for Admin user instead of super user. </LI></UL>
 * 09-Jul-2009 : Version 8.4 (Sundar); <UL><LI> Bug due to parsing and removing formfields from "and" is bulletproofed to the right "and" to which the formfield is associated. </LI></UL>
 * 08-Jul-2009 : Version 8.4 (Sundar); <UL><LI> Bug due to parsing and removing formfields when there is no parameter for Daytona specific database is resolved. </LI></UL>
 * 29-Jun-2009 : Version 8.4 (Sundar); <UL><LI> isLastSeriesALineChart() and setLastSeriesALineChart(String value) method have been added for the Bar Chart enhancements. </LI></UL>
 * 23-Jun-2009 : Version 8.4 (Sundar); <UL><LI> check for cr.getChartAdditionalOptions() for null value is added.</LI></UL>
 * 22-Jun-2009 : Version 8.4 (Sundar); <UL><LI> Wrapper functions to call JAXB were added. These Wrapper
 * functions are related to the Pareto chart, Time Difference Chart, Multiple Pie Chart and generic Chart Options.</LI></UL>
 *
 */

@Component
public class ReportWrapper extends org.onap.portalsdk.analytics.RaptorObject implements Serializable{

    private static final EELFLoggerDelegate logger = EELFLoggerDelegate.getLogger(ReportWrapper.class);

	protected static RemDbInfo remDbInfo;

	@SuppressWarnings("static-access")
	@Autowired
    public void setRemDbInfo(RemDbInfo remDbInfo) {
		this.remDbInfo = remDbInfo;
	}

    protected CustomReportType cr = null;

    protected Vector allColumns = null;

    protected Vector allVisibleColumns = null;

    protected Vector allFilters = null;

    protected String generatedSQL = null;

    protected String generatedChartSQL = null;

	protected String wholeSQL = null;


    protected String reportID = null;

    protected String menuID = "";

    protected boolean menuApproved = false;

    protected String reportDefType = "";

    protected ReportSecurity reportSecurity = null;

    protected String reportSQLWithRowNum = null;

    protected String reportSQLOnlyFirstPart = null;

    public ReportWrapper() {
        super();
    }
	
    private ReportWrapper(CustomReportType cr, String reportID, ReportSecurity reportSecurity) {
        super();

        if (reportID == null)
            reportID = "-1";

        this.cr = cr;
        this.reportID = reportID;

        this.reportSecurity = reportSecurity;
	}

    public ReportWrapper(ReportWrapper rw) {
		this(rw.getCustomReport(), 
                rw.getReportID(), rw.reportSecurity);

        this.menuID = rw.getMenuID();
        this.menuApproved = rw.isMenuApproved();

        this.reportDefType = rw.getReportDefType();
	}
    public ReportWrapper(CustomReportType cr, String reportID, String ownerID, String createID,
            String createDate, String updateID, String updateDate, String menuID,
            boolean menuApproved) throws RaptorException {
        this(cr, reportID, null);

        if (ownerID == null && !"-1".equals(reportID)) {
            try {

                String rSql = Globals.getReportWrapperFormat();
                rSql = rSql.replace("[Globals.getTimeFormat()]", Globals.getTimeFormat());
                rSql = rSql.replace("[reportID]", reportID);

                DataSet ds = DbUtils
                        .executeQuery(rSql);

                ownerID = ds.getString(0, 0);
                createID = ds.getString(0, 1);
                createDate = ds.getString(0, 2);
                updateID = ds.getString(0, 3);
                updateDate = ds.getString(0, 4);
                menuID = nvl(ds.getString(0, 5));
                menuApproved = nvl(ds.getString(0, 6)).equals("Y");
            } catch (Exception e) {
                String eMsg = "ReportWrapper.ReportWrapper: Unable to load report record details. Exception: ";
                logger.error(EELFLoggerDelegate.debugLogger, ("[EXCEPTION ENCOUNTERED IN RAPTOR] " + eMsg), e);
                throw new RaptorRuntimeException(eMsg);
            }
        }
        this.menuID = nvl(menuID);
        this.menuApproved = menuApproved;

        if (!"-1".equals(reportID)) {
            updateReportDefType();
        }

        reportSecurity = new ReportSecurity(reportID, ownerID, createID, createDate, updateID,
                updateDate, cr.isPublic());
    } // ReportWrapper

    public CustomReportType getCustomReport() {
        return cr;
    }

    public String getReportID() {
        return reportID;
    }

    public String getMenuID() {
        return menuID;
    }

    public boolean checkMenuIDSelected(String chkMenuID) {
        return ("|" + menuID + "|").indexOf("|" + chkMenuID + "|") >= 0;
    }

    public boolean isMenuApproved() {
        return menuApproved;
    }

    public String getReportDefType() {
        return reportDefType;
    }

    public void setMenuID(String menuID) {
        this.menuID = menuID;
    }

    public void setMenuApproved(boolean menuApproved) {
        this.menuApproved = menuApproved;
    }

    public void setReportDefType(String reportDefType) {
        this.reportDefType = reportDefType;
    }

    public void updateReportDefType() {
        this.reportDefType = (nvl(cr.getReportSQL()).length() > 0)
                ? ((cr.getDataminingOptions() != null && nvl(cr.getDataminingOptions().getClassifier()).length() > 0)
                        ? AppConstants.RD_SQL_BASED_DATAMIN
                        : AppConstants.RD_SQL_BASED)
                : AppConstants.RD_VISUAL;
    }

    public String getJavascriptElement() {
        return cr.getJavascriptElement();
    }

    public int getPageSize() {
        return cr.getPageSize() == null ? 50 : cr.getPageSize();
    }

    public int getMaxRowsInExcelDownload() {
        return cr.getMaxRowsInExcelDownload() == null ? 500 : cr.getMaxRowsInExcelDownload();
    }

    public boolean isDisplayFolderTree() {
        return cr.isDisplayFolderTree() != null ? cr.isDisplayFolderTree().booleanValue() : false;
    }

    public boolean isHideFormFieldAfterRun() {
        return cr.isHideFormFieldAfterRun() != null ? cr.isHideFormFieldAfterRun().booleanValue() : false;
    }

    public void setHideFormFieldAfterRun(boolean hideFormFieldAfterRun) {
        cr.setHideFormFieldAfterRun(hideFormFieldAfterRun);
    }

    public boolean isReportInNewWindow() {
        return cr.isReportInNewWindow() != null ? cr.isReportInNewWindow().booleanValue() : false;
    }

    public String getReportType() {
        return cr.getReportType();
    }

    public String getReportName() {
        return cr.getReportName();
    }

    public String getDBInfo() {
        return cr.getDbInfo();
    }

    public String getDBType() {
        return cr.getDbType();
    }

    public boolean isDrillDownURLInPopupPresent() {
        return cr.isDrillURLInPoPUpPresent() != null ? cr.isDrillURLInPoPUpPresent().booleanValue() : false;
    }

    public void setDrillDownURLInPopupPresent(boolean value) {
        cr.setDrillURLInPoPUpPresent(value);
    }

    public String getReportDescr() {
        return cr.getReportDescr();
    }

    public String getChartType() {
        return cr.getChartType();
    }

    public boolean displayChartTitle() {
        return cr.isShowChartTitle();
    }

    public void setShowChartTitle(boolean showTitle) {
        cr.setShowChartTitle(showTitle);
    }

    public String getChartTypeFixed() {
        return cr.getChartTypeFixed();
    }

    public boolean isChartTypeFixed() {
        return nvl(cr.getChartTypeFixed()).length() > 0 ? "Y".equals(cr.getChartTypeFixed())
                : (!Globals.getAllowRuntimeChartSel());
    }

    public String getChartLeftAxisLabel() {
        return cr.getChartLeftAxisLabel();
    }

    public String getChartRightAxisLabel() {
        return cr.getChartRightAxisLabel();
    }

    public String getChartWidth() {
        return cr.getChartWidth();
    }

    public int getChartWidthAsInt() {
        return getIntValue(cr.getChartWidth(), Globals.getDefaultChartWidth());
    }

    public String getChartHeight() {
        return cr.getChartHeight() == null ? "500" : cr.getChartHeight();
    }


    public boolean displayPieOrderinRunPage() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getChartMultiplePieOrder() : "";
        if (nvl(s).indexOf("|") != -1) {
            s = s.substring(s.indexOf("|") + 1);
            return getFlagInBoolean(s);
        } else
            return false;
    }

    public boolean isMultiplePieOrderByRow() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getChartMultiplePieOrder() : "";
        if (nvl(s).indexOf("|") != -1)
            s = s.substring(0, s.indexOf("|"));
        return (nvl(s).length() > 0) ? ("row".equals(s) ? true : false) : true;
    }

    public boolean isMultiplePieOrderByColumn() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getChartMultiplePieOrder() : "";
        if (nvl(s).indexOf("|") != -1)
            s = s.substring(0, s.indexOf("|"));
        return (nvl(s).length() > 0) && ("column".equals(s)) ? true : false;
    }

    public boolean displayPieLabelDisplayinRunPage() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getChartMultiplePieLabelDisplay()
                : "";
        if (nvl(s).indexOf("|") != -1) {
            s = s.substring(s.indexOf("|") + 1);
            return getFlagInBoolean(s);
        } else
            return false;
    }

    public String getMultiplePieLabelDisplay() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getChartMultiplePieLabelDisplay()
                : "";
        if (nvl(s).indexOf("|") != -1)
            s = s.substring(0, s.indexOf("|"));
        return s;
    }

    public boolean displayChartDisplayinRunPage() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getChartDisplay() : "";
        if (nvl(s).indexOf("|") != -1) {
            s = s.substring(s.indexOf("|") + 1);
            return getFlagInBoolean(s);
        } else
            return false;
    }

    public boolean isChartDisplayIn3D() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getChartDisplay() : "";
        if (nvl(s).length() <= 0)
            return true;
        if (nvl(s).indexOf("|") != -1)
            s = s.substring(0, s.indexOf("|"));
        return (nvl(s).length() > 0) && ("3D".equals(s)) ? true : false;
    }

    public boolean displayChartOrientationInRunPage() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getChartOrientation() : "";
        if (nvl(s).indexOf("|") != -1) {
            s = s.substring(s.indexOf("|") + 1);
            return getFlagInBoolean(s);
        } else
            return false;

    }

    public String getLinearRegression() {
        String s = "";
        s = nvl((cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getLinearRegression() : "Y");
        return s;
    }

    public void setLinearRegression(String linear) {
        cr.getChartAdditionalOptions().setLinearRegression(linear);
    }

    public String getLinearRegressionColor() {
        return (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getLinearRegressionColor()
                : "";
    }

    public String getCustomizedRegressionPoint() {
        return (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getMaxRegression() : "";
    }

    public void setCustomizedRegressionPoint(String d) {
        cr.getChartAdditionalOptions().setMaxRegression(d);
    }

    public void setLinearRegressionColor(String color) {
        cr.getChartAdditionalOptions().setLinearRegressionColor(color);
    }

    public String getExponentialRegressionColor() {
        return (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getExponentialRegressionColor()
                : "";
    }

    public void setExponentialRegressionColor(String color) {
        cr.getChartAdditionalOptions().setExponentialRegressionColor(color);
    }

    public void setRangeAxisUpperLimit(String d) {
        if (cr.getChartAdditionalOptions() != null)
            cr.getChartAdditionalOptions().setRangeAxisUpperLimit(d);
    }

    public void setRangeAxisLowerLimit(String d) {
        if (cr.getChartAdditionalOptions() != null)
            cr.getChartAdditionalOptions().setRangeAxisLowerLimit(d);
    }

    public String getRangeAxisUpperLimit() {
        return (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getRangeAxisUpperLimit() : "";
    }

    public String getRangeAxisLowerLimit() {
        return (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getRangeAxisLowerLimit() : "";
    }

    public boolean isChartAnimate() {
        return (cr.getChartAdditionalOptions() != null)
                ? (cr.getChartAdditionalOptions().isAnimate() != null ? cr.getChartAdditionalOptions().isAnimate()
                        : false)
                : false;
    }

    public boolean isAnimateAnimatedChart() {
        return (cr.getChartAdditionalOptions() != null)
                ? (cr.getChartAdditionalOptions().isAnimateAnimatedChart() != null
                        ? cr.getChartAdditionalOptions().isAnimateAnimatedChart()
                        : false)
                : true;
    }

    public void setAnimateAnimatedChart(boolean animate) {
        cr.getChartAdditionalOptions().setAnimateAnimatedChart(animate);
    }

    public void setChartStacked(boolean stacked) {
        cr.getChartAdditionalOptions().setStacked(stacked);
    }

    public boolean isChartStacked() {
        return (cr.getChartAdditionalOptions() != null)
                ? (cr.getChartAdditionalOptions().isStacked() != null ? cr.getChartAdditionalOptions().isStacked()
                        : true)
                : false;
    }

    public void setBarControls(boolean barControls) {
        cr.getChartAdditionalOptions().setBarControls(barControls);
    }

    public boolean displayBarControls() {
        return (cr.getChartAdditionalOptions() != null) ? (cr.getChartAdditionalOptions().isBarControls() != null
                ? cr.getChartAdditionalOptions().isBarControls()
                : false) : false;
    }

    public void setXAxisDateType(boolean dateType) {
        cr.getChartAdditionalOptions().setXAxisDateType(dateType);
    }

    public boolean isXAxisDateType() {
        return (cr.getChartAdditionalOptions() != null) ? (cr.getChartAdditionalOptions().isXAxisDateType() != null
                ? cr.getChartAdditionalOptions().isXAxisDateType()
                : false) : false;
    }

    public void setLessXaxisTickers(boolean lessTickers) {
        cr.getChartAdditionalOptions().setLessXaxisTickers(lessTickers);
    }

    public boolean isLessXaxisTickers() {
        return (cr.getChartAdditionalOptions() != null) ? (cr.getChartAdditionalOptions().isLessXaxisTickers() != null
                ? cr.getChartAdditionalOptions().isLessXaxisTickers()
                : false) : false;
    }

    public void setTimeAxis(boolean timeAxis) {
        cr.getChartAdditionalOptions().setTimeAxis(timeAxis);
    }

    public boolean isTimeAxis() {
        return (cr.getChartAdditionalOptions() != null)
                ? (cr.getChartAdditionalOptions().isTimeAxis() != null ? cr.getChartAdditionalOptions().isTimeAxis()
                        : true)
                : true;
    }

    public void setLogScale(boolean logScale) {
        cr.getChartAdditionalOptions().setLogScale(logScale);
    }

    public boolean isLogScale() {
        return (cr.getChartAdditionalOptions() != null)
                ? (cr.getChartAdditionalOptions().isLogScale() != null ? cr.getChartAdditionalOptions().isLogScale()
                        : false)
                : false;
    }

    public void setMultiSeries(boolean multiSeries) {
        cr.getChartAdditionalOptions().setMultiSeries(multiSeries);
        cr.setChartMultiSeries(multiSeries ? "Y" : "N");
    }

    public boolean isMultiSeries() {
        if ("Y".equals(AppUtils.nvl(cr.getChartMultiSeries())))
            cr.getChartAdditionalOptions().setMultiSeries(true);
        return (cr.getChartAdditionalOptions() != null) ? (cr.getChartAdditionalOptions().isMultiSeries() != null
                ? cr.getChartAdditionalOptions().isMultiSeries()
                : false) : false;
    }

    public void setTimeSeriesRender(String timeSeriesRenderer) {
        cr.getChartAdditionalOptions().setTimeSeriesRender(timeSeriesRenderer);
    }

    public String getTimeSeriesRender() {
        return (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getTimeSeriesRender() : "line";
    }

    public void setShowXAxisLabel(boolean showXaxisLabel) {
        cr.getChartAdditionalOptions().setShowXAxisLabel(showXaxisLabel);
    }

    public boolean isShowXaxisLabel() {
        return (cr.getChartAdditionalOptions() != null) ? (cr.getChartAdditionalOptions().isShowXAxisLabel() != null
                ? cr.getChartAdditionalOptions().isShowXAxisLabel()
                : false) : false;
    }

    public void setAddXAxisTickers(boolean addXAxisTickers) {
        cr.getChartAdditionalOptions().setAddXAxisTickers(addXAxisTickers);
    }

    public boolean isAddXAxisTickers() {
        return (cr.getChartAdditionalOptions() != null) ? (cr.getChartAdditionalOptions().isAddXAxisTickers() != null
                ? cr.getChartAdditionalOptions().isAddXAxisTickers()
                : false) : true;
    }

    public void setZoomIn(Integer zoomIn) {
        cr.getChartAdditionalOptions().setZoomIn(zoomIn);
    }

    public Integer getZoomIn() {
        return (cr.getChartAdditionalOptions() != null)
                ? (cr.getChartAdditionalOptions().getZoomIn() != null ? cr.getChartAdditionalOptions().getZoomIn()
                        : new Integer("25"))
                : new Integer("25");
    }

    public void setTimeAxisType(String timeAxisType) {
        cr.getChartAdditionalOptions().setTimeAxisType(timeAxisType);
    }

    public String getTimeAxisType() {
        return (cr.getChartAdditionalOptions() != null) ? (cr.getChartAdditionalOptions().getTimeAxisType() != null
                ? cr.getChartAdditionalOptions().getTimeAxisType()
                : "hourly") : "hourly";
    }

    public void setTopMargin(Integer topMargin) {
        cr.getChartAdditionalOptions().setTopMargin(topMargin);
    }

    public Integer getTopMargin() {
        return (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getTopMargin()
                : new Integer("30");
    }

    public void setBottomMargin(Integer bottomMargin) {
        cr.getChartAdditionalOptions().setBottomMargin(bottomMargin);
    }

    public Integer getBottomMargin() {
        return (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getBottomMargin()
                : new Integer("50");
    }

    public void setRightMargin(Integer rightMargin) {
        cr.getChartAdditionalOptions().setRightMargin(rightMargin);
    }

    public Integer getRightMargin() {
        return (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getRightMargin()
                : new Integer("60");
    }

    public void setLeftMargin(Integer leftMargin) {
        cr.getChartAdditionalOptions().setLeftMargin(leftMargin);
    }

    public Integer getLeftMargin() {
        return (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getLeftMargin()
                : new Integer("100");
    }

    public boolean isVerticalOrientation() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getChartOrientation() : "";
        if (nvl(s).length() <= 0)
            return true;
        if (nvl(s).indexOf("|") != -1)
            s = s.substring(0, s.indexOf("|"));
        return (nvl(s).length() > 0) && ("vertical".equals(s)) ? true : false;
    }

    public boolean isHorizontalOrientation() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getChartOrientation() : "";
        if (nvl(s).indexOf("|") != -1)
            s = s.substring(0, s.indexOf("|"));
        return (nvl(s).length() > 0) && ("horizontal".equals(s)) ? true : false;
    }

    public boolean displaySecondaryChartRendererInRunPage() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getSecondaryChartRenderer() : "";
        if (nvl(s).indexOf("|") != -1) {
            s = s.substring(s.indexOf("|") + 1);
            return getFlagInBoolean(s);
        } else
            return false;

    }

    public String getSecondaryChartRenderer() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getSecondaryChartRenderer() : "";
        if (nvl(s).indexOf("|") != -1)
            s = s.substring(0, s.indexOf("|"));
        return s;
    }

    public String getOverlayItemValueOnStackBar() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getOverlayItemValueOnStackBar()
                : "N";
        return s;
    }

    public boolean displayIntervalInputInRunPage() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getIntervalFromdate() : "";
        if (nvl(s).indexOf("|") != -1) {
            s = s.substring(s.indexOf("|") + 1);
            return getFlagInBoolean(s);
        } else
            return false;
    }

    public boolean showLegendDisplayOptionsInRunPage() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getHidechartLegend() : "";
        if (nvl(s).indexOf("|") != -1) {
            s = s.substring(s.indexOf("|") + 1);
            return getFlagInBoolean(s);
        } else
            return false;
    }

    public String getIntervalFromdate() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getIntervalFromdate() : "";
        if (nvl(s).indexOf("|") != -1)
            s = s.substring(0, s.indexOf("|"));
        return nvl(s, "");
    }

    public String getIntervalTodate() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getIntervalTodate() : "";
        if (nvl(s).indexOf("|") != -1)
            s = s.substring(0, s.indexOf("|"));
        return nvl(s, "");
    }

    public String getIntervalLabel() {
        return cr.getChartAdditionalOptions() != null ? nvl(cr.getChartAdditionalOptions().getIntervalLabel()) : "";
    }

    public String getLegendPosition() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getLegendPosition() : "";
        return nvl(s, "bottom");
    }

    public String getLegendLabelAngle() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getLabelAngle() : "";
        return nvl(s, "UP90");
    }

    public String getMaxLabelsInDomainAxis() {
        String s = "";
        s = (cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getMaxLabelsInDomainAxis() : "";
        return nvl(s, "99");
    }

    public boolean isLastSeriesALineChart() {
        String s = "";
        s = nvl((cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getLastSeriesALineChart()
                : "");
        return s.equals("Y");
    }

    public boolean isLastSeriesABarChart() {
        String s = "";
        s = nvl((cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getLastSeriesABarChart()
                : "");
        return s.equals("Y");
    }

    public void setChartLegendDisplay(String value) {
        cr.getChartAdditionalOptions().setHidechartLegend(value);
    }

    public boolean hideChartLegend() {
        String s = "";
        s = nvl((cr.getChartAdditionalOptions() != null) ? cr.getChartAdditionalOptions().getHidechartLegend() : "N");
        if (nvl(s).length() <= 0)
            s = "N";
        if (nvl(s).indexOf("|") != -1)
            s = s.substring(0, s.indexOf("|"));
        return s.equals("Y");
    }

    public void setChartToolTips(String value) {
        cr.getChartAdditionalOptions().setHideToolTips(value);
    }

    public void setDomainAxisValuesAsString(String value) {
        cr.getChartAdditionalOptions().setKeepDomainAxisValueAsString(value);
    }

    public boolean hideChartToolTips() {
        boolean s = true;
        s = (cr.getChartAdditionalOptions() != null)
                ? (cr.getChartAdditionalOptions().getHideToolTips() != null
                        ? ("Y".equals(cr.getChartAdditionalOptions().getHideToolTips()) ? true : false)
                        : (Globals.hideToolTipsGlobally() ? true : false))
                : (Globals.hideToolTipsGlobally() ? true : false);
        return s;
    }

    public boolean keepDomainAxisValueInChartAsString() {
        boolean s = true;
        s = (cr.getChartAdditionalOptions() != null)
                ? (cr.getChartAdditionalOptions().getKeepDomainAxisValueAsString() != null
                        ? ("Y".equals(cr.getChartAdditionalOptions().getKeepDomainAxisValueAsString()) ? true : false)
                        : false)
                : false;
        return s;
    }

    public int getChartHeightAsInt() {
        return getIntValue(cr.getChartHeight(), Globals.getDefaultChartHeight());
    }

    public boolean isPublic() {
        return cr.isPublic();
    }

    public boolean isDashboardType() throws RaptorException {
        return cr.isDashboardType() != null ? cr.isDashboardType().booleanValue() : false;
    }


    public String getReportSQL() {
        return cr.getReportSQL();
    }

    public String getReportTitle() {
        return cr.getReportTitle();
    }

    public String getReportSubTitle() {
        return cr.getReportSubTitle();
    }

    public String getReportHeader() {
        return cr.getReportHeader();
    }

    public String getReportFooter() {
        return cr.getReportFooter();
    }

    public String getNumDashCols() {
        return cr.getNumDashCols();
    }

    public int getNumDashColsAsInt() {
        return getIntValue(cr.getNumDashCols(), 1);
    }

    public String getNumFormCols() {
        return cr.getNumFormCols();
    }

    public int getNumFormColsAsInt() {
        return getIntValue(cr.getNumFormCols(), 5);
    }

    public String getDisplayOptions() {
        return cr.getDisplayOptions();
    }



    public int getJumpTo() {
        return cr.getJumpTo() == null ? 1 : cr.getJumpTo();
    }

    public void setJumpTo(int value) {
        cr.setJumpTo(value);
    }

    public int getSearchPageSize() {
        return cr.getSearchPageSize() == null ? 20 : cr.getSearchPageSize();
    }

    public void setSearchPageSize(int value) {
        cr.setSearchPageSize(value);
    }

    public boolean isToggleLayout() {
        if (cr.isToggleLayout() != null)
            return cr.isToggleLayout();

        else
            return Globals.displayRuntimeOptionsAsDefault();

    }

    public void setToggleLayout(boolean value) {
        cr.setToggleLayout(value);
    }

    public boolean isShowPageSize() {
        if (cr.isShowPageSize() != null)
            return cr.isShowPageSize();

        else
            return Globals.displayRuntimeOptionsAsDefault();

    }

    public void setShowPageSize(boolean value) {
        cr.setShowPageSize(value);
    }

    public boolean isShowNavPos() {
        if (cr.isShowNavPos() != null)
            return cr.isShowNavPos();

        else
            return Globals.displayRuntimeOptionsAsDefault();

    }

    public void setShowNavPos(boolean value) {
        cr.setShowNavPos(value);
    }

    public boolean isShowGotoOption() {
        if (cr.isShowGotoOption() != null)
            return cr.isShowGotoOption();

        else
            return Globals.displayRuntimeOptionsAsDefault();

    }

    public void setShowGotoOption(boolean value) {
        cr.setShowGotoOption(value);
    }

    public boolean isPageNav() {

        if (cr.isPageNav() != null)
            return cr.isPageNav();

        else
            return Globals.displayRuntimeOptionsAsDefault();

    }

    public void setPageNav(boolean value) {
        cr.setPageNav(value);
    }

    public String getNavPosition() {
        if (cr.getNavPosition() != null)
            return cr.getNavPosition();

        else
            return "top";
		
    }

    public void setNavPosition(String value) {
        cr.setNavPosition(value);
    }

    public String getDashboardEditor() {
        return getDashBoardReportsNew().getDashboardEditor();
    }

    public void setDashboardEditor(String value) {
        getDashBoardReportsNew().setDashboardEditor(value);
    }

    public DashboardEditorList getDashboardEditorList() {
        return getDashBoardReportsNew().getDashboardEditorList();
    }

    public void setDashboardEditorList(DashboardEditorList value) {
        getDashBoardReportsNew().setDashboardEditorList(value);
    }

    public PDFAdditionalOptions getPDFAdditionalOptions() {
        try {
            if (cr.getPdfAdditionalOptions() == null)
                addPDFAdditionalOptions(new ObjectFactory());
        } catch (RaptorException ex) {
            logger.error(EELFLoggerDelegate.debugLogger, "Exception occured in getPDFAdditionalOptions ", ex);
        }
        return cr.getPdfAdditionalOptions();
    }

    public String getPDFFont() {
        return getPDFAdditionalOptions().getPDFFont() != null ? getPDFAdditionalOptions().getPDFFont()
                : Globals.getDataFontFamily();
    }

    public void setPDFFont(String value) {
        getPDFAdditionalOptions().setPDFFont(value);
    }

    public int getPDFFontSize() {
        return getPDFAdditionalOptions().getPDFFontSize() == null ? 9 : getPDFAdditionalOptions().getPDFFontSize();
    }

    public void setPDFFontSize(int value) {
        getPDFAdditionalOptions().setPDFFontSize(value);
    }

    public String getPDFOrientation() {
        return getPDFAdditionalOptions().getPDFOrientation() != null ? "portrait" : "landscape";
    }

    public void setPDFOrientation(String value) {
        getPDFAdditionalOptions().setPDFOrientation(value);
    }

    public String getPDFLogo1() {
        return getPDFAdditionalOptions().getPDFLogo1();
    }

    public void setPDFLogo1(String value) {
        getPDFAdditionalOptions().setPDFLogo1(value);
    }

    public String getPDFLogo2() {
        return getPDFAdditionalOptions().getPDFLogo2();
    }

    public void setPDFLogo2(String value) {
        getPDFAdditionalOptions().setPDFLogo2(value);
    }

    public int getPDFLogo1Size() {
        return getPDFAdditionalOptions().getPDFLogo1Size() == null ? 0 : getPDFAdditionalOptions().getPDFLogo1Size();
    }

    public void setPDFLogo1Size(int value) {
        getPDFAdditionalOptions().setPDFLogo1Size(value);
    }

    public int getPDFLogo2Size() {
        return getPDFAdditionalOptions().getPDFLogo2Size() == null ? 0 : getPDFAdditionalOptions().getPDFLogo2Size();
    }

    public void setPDFLogo2Size(int value) {
        getPDFAdditionalOptions().setPDFLogo2Size(value);
    }

    public boolean isPDFCoverPage() {

        if (getPDFAdditionalOptions().isPDFCoverPage() != null)
            return getPDFAdditionalOptions().isPDFCoverPage();

        else
            return true;

    }

    public void setPDFCoverPage(boolean value) {
        getPDFAdditionalOptions().setPDFCoverPage(value);
    }

    public String getPDFFooter1() {
        return getPDFAdditionalOptions().getPDFFooter1();
    }

    public void setPDFFooter1(String value) {
        getPDFAdditionalOptions().setPDFFooter1(value);
    }

    public String getPDFFooter2() {
        return getPDFAdditionalOptions().getPDFFooter2();
    }

    public void setPDFFooter2(String value) {
        getPDFAdditionalOptions().setPDFFooter2(value);
    }


    public String getDataContainerHeight() {
        return cr.getDataContainerHeight();
    }

    public String getDataContainerWidth() {
        return cr.getDataContainerWidth();
    }

    public boolean isAllowSchedule() {
        String allowSchedule = getAllowSchedule();
        return (allowSchedule != null) ? allowSchedule.startsWith("Y") : false;
    }

    public String getAllowSchedule() {
        return cr.getAllowSchedule();
    }



    public boolean isMultiGroupColumn() {
        String multiGroupColumn = getMultiGroupColumn();
        return (multiGroupColumn != null) ? multiGroupColumn.startsWith("Y") : false;
    }

    public String getMultiGroupColumn() {
        return cr.getMultiGroupColumn();
    }

    public void setMultiGroupColumn(String value) {
        cr.setMultiGroupColumn(value);
    }

    private int getColumnGroupLevel(String colId) throws RaptorException {
        DataColumnType dc = getColumnById(colId);
        return (dc == null) ? 0 : dc.getLevel();
	} 

    public int getMaxGroupLevel() {
        List reportCols = getAllColumns();
        int maxLevel = 0;
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (dc.getLevel() != null) {
                if (maxLevel < dc.getLevel())
                    maxLevel = dc.getLevel();
            }
		} 
        return maxLevel;
	}

    private int getColumnGroupStart(String colId) throws RaptorException {
        DataColumnType dc = getColumnById(colId);
        return (dc == null) ? 0 : dc.getStart();
	}

    private int getColumnGroupColSpan(String colId) throws RaptorException {
        DataColumnType dc = getColumnById(colId);
        return (dc == null) ? 0 : dc.getColspan();
	}

    public void setTopDown(String value) {
        cr.setTopDown(value);
    }

    public boolean isTopDown() {
        String topDown = getTopDownOption();
        return (topDown != null) ? topDown.startsWith("Y") : false;
    }

    public String getTopDownOption() {
        return cr.getTopDown();
    }

    public void setSizedByContent(String value) {
        cr.setSizedByContent(value);
    }

    public boolean isSizedByContent() {
        String sizedByContent = getSizedByContentOption();
        return (sizedByContent != null) ? sizedByContent.startsWith("Y") : false;
    }

    public String getSizedByContentOption() {
        return cr.getSizedByContent();
    }

    public String getDashboardOptions() {
        return cr.getDashboardOptions();
    }

    public boolean isDashboardOptionHideChart() {
        return nvl(getDashboardOptions()).length() > 0 && (getDashboardOptions().charAt(0) == 'Y');
    }

    public boolean isDashboardOptionHideData() {
        return nvl(getDashboardOptions()).length() > 0 && (getDashboardOptions().charAt(1) == 'Y');
    }

    public boolean isDashboardOptionHideBtns() {
        return nvl(getDashboardOptions()).length() > 0 && (getDashboardOptions().charAt(2) == 'Y');
    }

    public boolean isDisplayOptionHideForm() {
        return nvl(getDisplayOptions()).length() > 0 && (getDisplayOptions().charAt(0) == 'Y');
    }

    public boolean isDisplayOptionHideChart() {
        return nvl(getDisplayOptions()).length() > 1 && (getDisplayOptions().charAt(1) == 'Y');
    }

    public boolean isDisplayOptionHideData() {
        return nvl(getDisplayOptions()).length() > 2 && (getDisplayOptions().charAt(2) == 'Y');
    }

    public boolean isDisplayOptionHideBtns() {
        return nvl(getDisplayOptions()).length() > 3 && (getDisplayOptions().charAt(3) == 'Y');
    }

    public boolean isDisplayOptionHideMap() {
        return nvl(getDisplayOptions()).length() > 4 && (getDisplayOptions().charAt(4) == 'Y');
    }

    public boolean isDisplayOptionHideExcelIcons() {
        return nvl(getDisplayOptions()).length() > 5 && (getDisplayOptions().charAt(5) == 'Y');
    }

    public boolean isDisplayOptionHidePDFIcons() {
        return nvl(getDisplayOptions()).length() > 6 && (getDisplayOptions().charAt(6) == 'Y');
    }

    public String getComment() {
        return cr.getComment();
    }

    public DataSourceList getDataSourceList() {
        return cr.getDataSourceList();
    }

    public ChartAdditionalOptions getChartAdditionalOptions() {
        return cr.getChartAdditionalOptions();
    }

    public ChartDrillOptions getChartDrillOptions() {
        return cr.getChartDrillOptions();
    }

    public DataminingOptions getDataminingOptions() {
        return cr.getDataminingOptions();
    }

    public DashboardReports getDashBoardReports() {
        return cr.getDashBoardReports();
    }

    public DashboardReportsNew getDashBoardReportsNew() {
        try {
            if (cr.getDashBoardReportsNew() == null)
                addDashboardReportsNew(new ObjectFactory());
        } catch (RaptorException ex) {
            logger.error(EELFLoggerDelegate.debugLogger, "Exception occured in getDashBoardReportsNew ", ex);
        }
        return cr.getDashBoardReportsNew();
    }

    public String getDashboardLayoutHTML() {
        return cr.getDashboardLayoutHTML();
    }

	public String getDashboardLayoutJSON() {
		return cr.getDashboardLayoutJSON();
	}
	
    public FormFieldList getFormFieldList() {
        return cr.getFormFieldList();
    }

    public JavascriptList getJavascriptList() {
        return cr.getJavascriptList();
    }

    public SemaphoreList getSemaphoreList() {
        return cr.getSemaphoreList();
    }

    public void setPageSize(int value) {
        cr.setPageSize(value);
    }

    public void setAllowSchedule(String value) {
        cr.setAllowSchedule(value);
    }

    public void setMaxRowsInExcelDownload(int value) {
        cr.setMaxRowsInExcelDownload(value);
    }

    public void setReportInNewWindow(boolean value) {
        cr.setReportInNewWindow(value);
    }

    public void setDisplayFolderTree(boolean value) {
        cr.setDisplayFolderTree(value);
    }

    public void setReportType(String value) {
        cr.setReportType(value);
    }

    public void setReportName(String value) {
        cr.setReportName(value);
    }

    public void setDBInfo(String value) {
            cr.setDbInfo(value);
    }

    public void setDBType(String value) {
            cr.setDbType(value);
    }

    public void setReportDescr(String value) {
        cr.setReportDescr(value);
    }

    public void setChartType(String value) {
        cr.setChartType(value);
    }

    public void setChartMultiplePieOrder(String value) {
        cr.getChartAdditionalOptions().setChartMultiplePieOrder(value);
    }

    public void setChartMultiplePieLabelDisplay(String value) {
        cr.getChartAdditionalOptions().setChartMultiplePieLabelDisplay(value);
    }

    public void setChartOrientation(String value) {
        cr.getChartAdditionalOptions().setChartOrientation(value);
    }

    public void setSecondaryChartRenderer(String value) {
        cr.getChartAdditionalOptions().setSecondaryChartRenderer(value);
    }

    public void setOverlayItemValueOnStackBar(String value) {
        cr.getChartAdditionalOptions().setOverlayItemValueOnStackBar(value);
    }

    public void setIntervalFromdate(String value) {
        cr.getChartAdditionalOptions().setIntervalFromdate(value);
    }

    public void setIntervalLabel(String value) {
        cr.getChartAdditionalOptions().setIntervalLabel(value);
    }

    public void setIntervalTodate(String value) {
        cr.getChartAdditionalOptions().setIntervalTodate(value);
    }

    public void setLegendPosition(String value) {
        cr.getChartAdditionalOptions().setLegendPosition(value);
    }

    public void setLegendLabelAngle(String value) {
        cr.getChartAdditionalOptions().setLabelAngle(value);
    }

    public void setMaxLabelsInDomainAxis(String value) {
        if (nvl(value).length() <= 0)
            value = "99";
        cr.getChartAdditionalOptions().setMaxLabelsInDomainAxis(value);
    }

    public void setLastSeriesALineChart(String value) {
        cr.getChartAdditionalOptions().setLastSeriesALineChart(value);
    }

    public void setLastSeriesABarChart(String value) {
        cr.getChartAdditionalOptions().setLastSeriesABarChart(value);
    }

    public void setChartDisplay(String value) {
        cr.getChartAdditionalOptions().setChartDisplay(value);
    }

    public void setChartAnimate(boolean animate) {
        if (cr.getChartAdditionalOptions() != null)
            cr.getChartAdditionalOptions().setAnimate(animate);
        else {
            try {
                if (getChartAdditionalOptions() == null)
                    addChartAdditionalOptions(new ObjectFactory());
            } catch (RaptorException ex) {
                logger.error(EELFLoggerDelegate.debugLogger, "Exception occured in setChartAnimate ", ex);
            }
            if (cr.getChartAdditionalOptions() != null)
                cr.getChartAdditionalOptions().setAnimate(animate);

        }

    }

    public void addChartAdditionalOptions(ObjectFactory objFactory) throws RaptorException {
        ChartAdditionalOptions chartOptions = objFactory.createChartAdditionalOptions();
        cr.setChartAdditionalOptions(chartOptions);
    }

    public void addDashboardReportsNew(ObjectFactory objFactory) throws RaptorException {
        DashboardReportsNew dashboardReports = objFactory.createDashboardReportsNew();
        cr.setDashBoardReportsNew(dashboardReports);
    }

    public void addPDFAdditionalOptions(ObjectFactory objFactory) throws RaptorException {
        PDFAdditionalOptions pdfOptions = objFactory.createPDFAdditionalOptions();
        cr.setPdfAdditionalOptions(pdfOptions);
    }

    public void setChartTypeFixed(String value) {
        cr.setChartTypeFixed(value);
    }

    public void setChartLeftAxisLabel(String value) {
        cr.setChartLeftAxisLabel(value);
    }

    public void setChartRightAxisLabel(String value) {
        cr.setChartRightAxisLabel(value);
    }

    public void setChartWidth(String value) {
        cr.setChartWidth(value);
    }

    public void setChartHeight(String value) {
        cr.setChartHeight(value);
    }

    public void setChartMultiSeries(String value) {
        cr.setChartMultiSeries(value);
    }

    public void setPublic(boolean value) {
        cr.setPublic(value);
        if (reportSecurity != null)
            reportSecurity.setPublic(value);
    }

    public void setReportSQL(String value) {
        cr.setReportSQL(value);
    }

    public void setReportTitle(String value) {
        cr.setReportTitle(value);
    }

    public void setReportSubTitle(String value) {
        cr.setReportSubTitle(value);
    }

    public void setReportHeader(String value) {
        cr.setReportHeader(value);
    }

    public void setReportFooter(String value) {
        cr.setReportFooter(value);
    }

    public void setNumFormCols(String value) {
        cr.setNumFormCols(value);
    }

    public void setNumDashCols(String value) {
        cr.setNumDashCols(value);
    }

    public void setDisplayOptions(String value) {
        cr.setDisplayOptions(value);
    }

    public void setDataContainerHeight(String value) {
        cr.setDataContainerHeight(value);
    }

    public void setDataContainerWidth(String value) {
        cr.setDataContainerWidth(value);
    }

    public void setDashboardOptions(String value) {
        cr.setDashboardOptions(value);
    }

    public void setComment(String value) {
        cr.setComment(value);
    }

    public void setDashboardType(boolean dashboardType) {
        cr.setDashboardType(dashboardType);
    }

    public void setDashboardLayoutHTML(String html) {
        cr.setDashboardLayoutHTML(html);
    }

    public void setDataSourceList(DataSourceList value) {
        cr.setDataSourceList(value);
    }

    public void setFormFieldList(FormFieldList value) {
        cr.setFormFieldList(value);
    }

    public void setDashBoardReports(DashboardReports value) {
        cr.setDashBoardReports(value);
    }

    public void setSemaphoreList(SemaphoreList value) {
        cr.setSemaphoreList(value);
    }

    public void setJavascriptList(JavascriptList value) {
        cr.setJavascriptList(value);
    }

    public void setJavascriptElement(String javascriptElement) {
        cr.setJavascriptElement(javascriptElement);
    }

    public void checkUserReadAccess(HttpServletRequest request) throws RaptorException {
        reportSecurity.checkUserReadAccess(request, null);
    }

    public void checkUserReadAccess(HttpServletRequest request, String userID) throws RaptorException {
        reportSecurity.checkUserReadAccess(request, userID);
    }

    public void checkUserWriteAccess(HttpServletRequest request) throws RaptorException {
        reportSecurity.checkUserWriteAccess(request);
        verifySQLBasedReportAccess(request);
    }

    public String getOwnerID() {
        return reportSecurity.getOwnerID();
    }

    public String getCreateID() {
        return reportSecurity.getCreateID();
    }

    public String getCreateDate() {
        return reportSecurity.getCreateDate();
    }

    public String getUpdateID() {
        return reportSecurity.getUpdateID();
    }

    public String getUpdateDate() {
        return reportSecurity.getUpdateDate();
    }

    public ReportSecurity getReportSecurity() {
        return reportSecurity;
    }

    /**** Report Maps - Start ****/
    public ReportMap getReportMap() {
        return cr.getReportMap();
    }

    public void setReportMap(ReportMap reportMap) {
        cr.setReportMap(reportMap);
    }

    /**** Report Maps - End ****/

    /**** Report Chart Drilldown - Start ****/
    public ChartDrillOptions getReportChartDrillOptions() {
        return cr.getChartDrillOptions();
    }

    public void setReportChartDrillOptions(ChartDrillOptions chartDrillOptions) {
        cr.setChartDrillOptions(chartDrillOptions);
    }



    public String getFormHelpText() {
        String formHelpText = nvl(getComment());

        if (formHelpText.indexOf('|') >= 0)
            formHelpText = formHelpText.substring(formHelpText.lastIndexOf('|') + 1);

        return formHelpText;
	} 

    public void setFormHelpText(String formHelpText) {
        String comment = nvl(getComment());

        if (comment.indexOf('|') >= 0)
            comment = comment.substring(0, comment.lastIndexOf('|'));
        if (comment.length() > 0)
            comment += '|';

        setComment(comment + formHelpText);
	}

    public boolean isRuntimeColSortDisabled() {
        String comment = nvl(getComment());

        if (comment.indexOf('|') < 0)
            return false;

        return "Y".equals(comment.substring(0, comment.indexOf('|')));
	} 
    public void setRuntimeColSortDisabled(boolean value) {
        String comment = nvl(getComment());

        if (comment.indexOf('|') >= 0)
            comment = comment.substring(comment.indexOf('|') + 1);

        setComment((value ? "Y" : "N") + "|" + comment);
	}

    /**
     * *************************************************************************************************
     */

    protected void verifySQLBasedReportAccess(HttpServletRequest request) throws RaptorException {
        String userID = AppUtils.getUserID(request);
        if (getReportDefType().equals(AppConstants.RD_SQL_BASED)
                && (!Globals.getAllowSQLBasedReports()) && (!AppUtils.isAdminUser(request)))
            throw new org.onap.portalsdk.analytics.error.UserAccessException(reportID, "[" + userID + "] "
                    + AppUtils.getUserName(request), AppConstants.UA_WRITE);
	} 

    /**
     * *************************************************************************************************
     */

    private String getColumnNameById(String colId) throws RaptorException {
        DataColumnType dc = getColumnById(colId);
        return (dc == null) ? "NULL" : dc.getColName();
	} 
    private boolean isViewAction(String value) throws RaptorException {
        try {
            Vector viewActions = org.onap.portalsdk.analytics.model.DataCache.getDataViewActions();

            for (int i = 0; i < viewActions.size(); i++)
                if (value.equals(AppUtils.getBaseActionURL() + ((String) viewActions.get(i))))
                    return true;
        } catch (Exception e) {
            logger.error(EELFLoggerDelegate.debugLogger, "Exception occured in isViewAction ", e);
            throw new RaptorRuntimeException("ReportWrapper.isViewAction Exception: "
                    + e.getMessage());
        }

        return false;
	}

    public String getSelectExpr(DataColumnType dct) {
        return getSelectExpr(dct, dct.getColName() /* colName */);
	} 



    private String getSelectExpr(DataColumnType dct, String colName) {
        String colType = dct.getColType();
        if (colType.equals(AppConstants.CT_NUMBER)) {
            return colName;
        } else if (colType.equals(AppConstants.CT_CHAR)
                || ((nvl(dct.getColFormat()).length() == 0) && (!colType
                        .equals(AppConstants.CT_DATE))))
            return colName;

        else
            return "TO_CHAR(" + colName + ", '"
                    + nvl(dct.getColFormat(), AppConstants.DEFAULT_DATE_FORMAT) + "')";
	} 
	


    public DataSourceType getTableById(String tableId) {
        for (Iterator iter = getDataSourceList().getDataSource().iterator(); iter.hasNext();) {
            DataSourceType ds = (DataSourceType) iter.next();
            if (ds.getTableId().equals(tableId))
                return ds;
		}
        return null;
	} 

    public DataSourceType getTableByDBName(String tableName) {
        for (Iterator iter = getDataSourceList().getDataSource().iterator(); iter.hasNext();) {
            DataSourceType ds = (DataSourceType) iter.next();
            if (ds.getTableName().equals(tableName))
                return ds;
		} 

        return null;
	}

    public DataSourceType getColumnTableById(String colId) {
        return getTableById(getColumnById(colId).getTableId());
	}

    public DataColumnType getColumnById(String colId) {
        List reportCols = getAllColumns();
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (dc.getColId().equalsIgnoreCase(colId)) {
                return dc;
            }
		} 

        return null;
	} 

    public DataColumnType getChartLegendColumn() {
        List reportCols = getAllColumns();
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (nvl(dc.getColOnChart()).equals(AppConstants.GC_LEGEND))
                return dc;
		} 
        return null;
	} 

    public List getChartValueColumnsList(int filter, HashMap formValues) { /*
                                                                            * filter; all=0;create without new chart =1;
                                                                            * createNewChart=2
                                                                            */
        List reportCols = getAllColumns();

        ArrayList chartValueCols = new ArrayList();
        int flag = 0;
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            flag = 0;
            DataColumnType dc = (DataColumnType) iter.next();
            flag = getDependsOnFormFieldFlag(dc, formValues);

            if ((dc.getChartSeq() != null && dc.getChartSeq() > 0) && flag == 0) {
                if (!AppUtils.nvl(dc.getColOnChart()).equals(AppConstants.GC_LEGEND)) {
                    if (nvl(dc.getChartGroup()).length() <= 0) {
                        if (filter == 2
                                && (dc.isCreateInNewChart() != null && dc.isCreateInNewChart().booleanValue())) {
                            chartValueCols.add(dc);
                        } else if (filter == 1
                                && (dc.isCreateInNewChart() == null || !dc.isCreateInNewChart().booleanValue())) {
                            chartValueCols.add(dc);
                        } else if (filter == 0)
                            chartValueCols.add(dc);
                    } else
                        chartValueCols.add(dc);
                }
            }

		} 
        Collections.sort(chartValueCols, new ChartSeqComparator());
        return chartValueCols;
    } 

    /** Check whether chart has series (Category) columns **/
    public boolean hasSeriesColumn() {
        List reportCols = getAllColumns();

        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (dc.isChartSeries() != null && dc.isChartSeries().booleanValue())
                return true;
		} 
        return false;
	}

    public List getChartDisplayNamesList(int filter, HashMap formValues) { 
        List reportCols = getAllColumns();
        ArrayList chartValueColNames = new ArrayList();
        int flag = 0;
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            flag = 0;
            DataColumnType dc = (DataColumnType) iter.next();
            // if(filter == 2 || filter == 1) {
            flag = getDependsOnFormFieldFlag(dc, formValues);

            if ((dc.getChartSeq() != null && dc.getChartSeq() > 0) && flag == 0) {
                if (nvl(dc.getChartGroup()).length() <= 0) {
                    if (filter == 2 && (dc.isCreateInNewChart() != null && dc.isCreateInNewChart().booleanValue())) {
                        chartValueColNames.add(dc.getDisplayName());
                    } else if (filter == 1
                            && (dc.isCreateInNewChart() == null || !dc.isCreateInNewChart().booleanValue())) {
                        chartValueColNames.add(dc.getDisplayName());
                    } else if (filter == 0)
                        chartValueColNames.add(dc.getDisplayName());
                } else if (filter == 0)
                    chartValueColNames.add(dc.getDisplayName());
            }


        }
        return chartValueColNames;
	} 

    public List getChartColumnColorsList(int filter, HashMap formValues) { 
        List reportCols = getAllColumns();
        ArrayList chartValueColColors = new ArrayList();
        int flag = 0;
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            flag = 0;
            DataColumnType dc = (DataColumnType) iter.next();
            flag = getDependsOnFormFieldFlag(dc, formValues);

            if ((dc.getChartSeq() != null && dc.getChartSeq() > 0) && flag == 0) {
                if (nvl(dc.getChartGroup()).length() <= 0) {
                    if (filter == 2 && (dc.isCreateInNewChart() != null && dc.isCreateInNewChart().booleanValue())) {
                        chartValueColColors.add(dc.getChartColor());
                    } else if (filter == 1
                            && (dc.isCreateInNewChart() == null || !dc.isCreateInNewChart().booleanValue())) {
                        chartValueColColors.add(dc.getChartColor());
                    } else if (filter == 0)
                        chartValueColColors.add(dc.getChartColor());
                } else if (filter == 0)
                    chartValueColColors.add(dc.getChartColor());
            }
        }
        return chartValueColColors;
	} 

    public List getChartValueColumnAxisList(int filter, HashMap formValues) { 
        List reportCols = getAllColumns();
        ArrayList chartValueColAxis = new ArrayList();
        int flag = 0;
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            flag = 0;
            DataColumnType dc = (DataColumnType) iter.next();
            flag = getDependsOnFormFieldFlag(dc, formValues);

            if ((dc.getChartSeq() != null && dc.getChartSeq() > 0) && flag == 0) {
                if (nvl(dc.getChartGroup()).length() <= 0) {
                    if (filter == 2 && (dc.isCreateInNewChart() != null && dc.isCreateInNewChart().booleanValue())) {
                        chartValueColAxis.add(nvl(dc.getColOnChart(), "0"));
                    } else if (filter == 1
                            && (dc.isCreateInNewChart() == null || !dc.isCreateInNewChart().booleanValue())) {
                        chartValueColAxis.add(nvl(dc.getColOnChart(), "0"));
                    } else if (filter == 0)
                        chartValueColAxis.add(nvl(dc.getColOnChart(), "0"));
                } else if (filter == 0)
                    chartValueColAxis.add(nvl(dc.getColOnChart(), "0"));
            }
        }
        return chartValueColAxis;
	}


    public List getChartValueNewChartList() {
        ArrayList chartValueNewChartAxis = new ArrayList();
        for (Iterator iter = getChartValueColumnsList(2, null).iterator(); iter.hasNext();)
            chartValueNewChartAxis.add(new Boolean(((DataColumnType) iter.next()).isCreateInNewChart()));
        return chartValueNewChartAxis;
	}

    public List getAllChartGroups() {
        ArrayList chartGroups = new ArrayList();
        String chartGroupName = "";
        List reportCols = getAllColumns();
        Set groupSet = new TreeSet();
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (dc.getChartSeq() != null && dc.getChartSeq() > 0) {
                chartGroupName = dc.getChartGroup();
                if (nvl(chartGroupName).length() > 0)
                    groupSet.add(chartGroupName);
            }
        }
        List l = new ArrayList(groupSet);
        return l;
	} 

    public HashMap getAllChartYAxis(ReportParamValues reportParamValues) {
        String chartYAxis = "";
        List reportCols = getAllColumns();
        HashMap hashMap = new HashMap();
        FormFieldList formFieldList = getFormFieldList();
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (dc.getChartSeq() != null && dc.getChartSeq() > 0) {
                chartYAxis = dc.getYAxis();
                if (formFieldList != null && reportParamValues != null) {
                    for (Iterator iter1 = getFormFieldList().getFormField().iterator(); iter1.hasNext();) {
                        FormFieldType fft = (FormFieldType) iter1.next();
                        String fieldDisplay = getFormFieldDisplayName(fft);
                        String fieldId = "";
                        if (fft != null)
                            fieldId = fft.getFieldId();
                        if (fft != null && !fft.getFieldType().equals(FormField.FFT_BLANK)
                                && !fft.getFieldType().equals(FormField.FFT_LIST_MULTI)
                                && !fft.getFieldType().equals(FormField.FFT_TEXTAREA)) {
                            String paramValue = Utils.oracleSafe(nvl(reportParamValues.getParamValue(fieldId)));
                            chartYAxis = Utils.replaceInString(chartYAxis, fieldDisplay, nvl(
                                    paramValue, ""));
                        }
                    }
                }
                if (nvl(dc.getChartGroup()).length() > 0)
                    hashMap.put(dc.getChartGroup(), chartYAxis);
            }
        }
        return hashMap;
	}

    public List getChartGroupColumnAxisList(String chartGroupName, HashMap formValues) { /*
                                                                                          * filter; all=0;create without
                                                                                          * new chart =1;
                                                                                          * createNewChart=2
                                                                                          */
        List reportCols = getAllColumns();
        ArrayList chartGroupColAxis = new ArrayList();
        String chartGroup = chartGroupName.substring(0, chartGroupName.lastIndexOf("|"));
        int flag = 0;
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            flag = getDependsOnFormFieldFlag(dc, formValues);

            if ((dc.getChartSeq() != null && dc.getChartSeq() > 0) && flag == 0) {
                if (nvl(dc.getChartGroup()).indexOf("|") > 0
                        && (nvl(dc.getChartGroup().substring(0, dc.getChartGroup().lastIndexOf("|")))
                                .equals(chartGroup))) {
                    chartGroupColAxis.add(dc);
                }
            }
        }
        Collections.sort(chartGroupColAxis, new ChartSeqComparator());
        return chartGroupColAxis;
	} 

    public List getChartGroupValueColumnAxisList(String chartGroupName, HashMap formValues) {
        List reportCols = getAllColumns();
        String index = chartGroupName.substring(chartGroupName.lastIndexOf("|") + 1);
        String chartGroup = chartGroupName.substring(0, chartGroupName.lastIndexOf("|"));
        ArrayList chartGroupValueColAxis = new ArrayList();
        int flag = 0;

        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            flag = 0;
            DataColumnType dc = (DataColumnType) iter.next();
            flag = getDependsOnFormFieldFlag(dc, formValues);

            if ((dc.getChartSeq() != null && dc.getChartSeq() > 0) && flag == 0) {
                if (nvl(dc.getChartGroup()).indexOf("|") > 0
                        && (nvl(dc.getChartGroup().substring(0, dc.getChartGroup().lastIndexOf("|")))
                                .equals(chartGroup))) {
                    chartGroupValueColAxis.add(dc);
                }
            }
        }
        return chartGroupValueColAxis;
	} 

    public List getChartGroupDisplayNamesList(String chartGroupName, HashMap formValues) {
        List reportCols = getAllColumns();
        ArrayList chartGroupValueColNames = new ArrayList();
        String chartGroup = chartGroupName.substring(0, chartGroupName.lastIndexOf("|"));
        int flag = 0;

        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            flag = 0;
            DataColumnType dc = (DataColumnType) iter.next();
            flag = getDependsOnFormFieldFlag(dc, formValues);

            if ((dc.getChartSeq() != null && dc.getChartSeq() > 0) && flag == 0) {
                if (nvl(dc.getChartGroup()).indexOf("|") > 0
                        && (nvl(dc.getChartGroup().substring(0, dc.getChartGroup().lastIndexOf("|")))
                                .equals(chartGroup))) {
                    chartGroupValueColNames.add(dc.getDisplayName());
                }
            }
        }
        return chartGroupValueColNames;
	} 


    public List getChartGroupColumnColorsList(String chartGroupName, HashMap formValues) {
        List reportCols = getAllColumns();
        ArrayList chartValueColColors = new ArrayList();
        String chartGroup = chartGroupName.substring(0, chartGroupName.lastIndexOf("|"));
        int flag = 0;
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            flag = 0;
            DataColumnType dc = (DataColumnType) iter.next();
            flag = getDependsOnFormFieldFlag(dc, formValues);

            if ((dc.getChartSeq() != null && dc.getChartSeq() > 0) && flag == 0) {
                if (nvl(dc.getChartGroup()).indexOf("|") > 0
                        && (nvl(dc.getChartGroup().substring(0, dc.getChartGroup().lastIndexOf("|")))
                                .equals(chartGroup))) {
                    chartValueColColors.add(dc.getChartColor());
                }
            }
        }
        return chartValueColColors;
	}

    public List getCrossTabRowColumns() {
        List reportCols = getAllColumns();
        Vector v = new Vector(reportCols.size());

        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (nvl(dc.getCrossTabValue()).equals(AppConstants.CV_ROW))
                v.add(dc);
		} 

        return v;
	} 

    public List getCrossTabColColumns() {
        List reportCols = getAllColumns();
        Vector v = new Vector(reportCols.size());

        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (nvl(dc.getCrossTabValue()).equals(AppConstants.CV_COLUMN))
                v.add(dc);
		} 

        return v;
	} 

    public String getCrossTabDisplayTotal(String rowColPos) {
        DataColumnType dct = getCrossTabValueColumn();
        if (dct == null)
            return "";

        String displayTotal = nvl(dct.getDisplayTotal());
        if (displayTotal.indexOf('|') >= 0) {
            String displayColTotal = displayTotal.substring(0, displayTotal.indexOf('|'));
            String displayRowTotal = displayTotal.substring(displayTotal.indexOf('|') + 1);

            if (rowColPos.equals(AppConstants.CV_COLUMN))
                displayTotal = displayColTotal;
            else if (rowColPos.equals(AppConstants.CV_ROW))
                displayTotal = displayRowTotal;
            else if (displayColTotal.equals(displayRowTotal))
                displayTotal = displayColTotal;
		}

        return displayTotal;
	} 

    public DataColumnType getCrossTabValueColumn() {
        List reportCols = getAllColumns();
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (nvl(dc.getCrossTabValue()).equals(AppConstants.CV_VALUE))
                return dc;
		} 

        return null;
	} 

	public int getCrossTabValueColumnIndex() { 
        List reportCols = getAllColumns();

        int idx = 0;
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (nvl(dc.getCrossTabValue()).equals(AppConstants.CV_VALUE))
                break;
            if (dc.isVisible())
                idx++;
		} 

        return idx;
	} 

    public ColFilterType getFilterById(String colId, int filterIndex) {
        DataColumnType dc = getColumnById(colId);
        try {
            return dc.getColFilterList().getColFilter().get(filterIndex);
        } catch (Exception e) {
            logger.error(EELFLoggerDelegate.debugLogger, "Exception occured in getFilterById ", e);
            return null;
        }
	}

    public boolean needFormInput() {
        List reportCols = getAllColumns();
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dct = (DataColumnType) iter.next();

            if (dct.getColFilterList() != null) {
                List fList = dct.getColFilterList().getColFilter();
                for (Iterator iterF = fList.iterator(); iterF.hasNext();) {
                    ColFilterType cft = (ColFilterType) iterF.next();

                    if (nvl(cft.getArgType()).equals(AppConstants.AT_FORM))
                        return true;
				}
			} 
		} 

        return false;
	}

    public int getNumSortColumns() {
        int numSortCols = 0;
        for (Iterator iter = getAllColumns().iterator(); iter.hasNext();) {
            DataColumnType dct = (DataColumnType) iter.next();
            if (dct.getOrderBySeq() != null && dct.getOrderBySeq() > 0)
                numSortCols++;
		} 

        return numSortCols;
	} 

    public SemaphoreType getSemaphoreById(String semaphoreId) {
        if (getSemaphoreList() != null && semaphoreId != null)
            for (Iterator iter = getSemaphoreList().getSemaphore().iterator(); iter.hasNext();) {
                SemaphoreType sem = (SemaphoreType) iter.next();
                if (sem.getSemaphoreId().equals(semaphoreId))
                    return sem;
			}

        return null;
	} 

    public void deleteSemaphore(SemaphoreType semaphore) {
        if (getSemaphoreList() != null) {
            if (getSemaphoreList().getSemaphore() != null)
                getSemaphoreList().getSemaphore().remove((SemaphoreType) semaphore);
        }
	} 

    public void setSemaphore(SemaphoreType sem) {
        if (getSemaphoreList() != null) {
            getSemaphoreList().getSemaphore().add(sem);
        }

	} 

    public static FormatType getSemaphoreFormatById(SemaphoreType semaphore, String formatId) {
        if (semaphore != null)
            for (Iterator iter = semaphore.getFormatList().getFormat().iterator(); iter
                    .hasNext();) {
                FormatType fmt = (FormatType) iter.next();
                if (fmt.getFormatId().equals(formatId))
                    return fmt;
			} 

        return null;
	} 

    public FormFieldType getFormFieldById(String fieldId) {
        if (getFormFieldList() != null && fieldId != null)
            for (Iterator iter = getFormFieldList().getFormField().iterator(); iter.hasNext();) {
                FormFieldType fft = (FormFieldType) iter.next();
                if (fft.getFieldId().equals(fieldId))
                    return fft;
			} 

        return null;
	} 

    public FormFieldType getFormFieldByDisplayValue(String fieldDisplay) {
        if (getFormFieldList() != null && fieldDisplay != null)
            for (Iterator iter = getFormFieldList().getFormField().iterator(); iter.hasNext();) {
                FormFieldType fft = (FormFieldType) iter.next();
                if (fieldDisplay.equals(getFormFieldDisplayName(fft)))
                    return fft;
			} 

        return null;
	}
    public String getFormFieldDisplayName(FormFieldType fft) {
        return "[" + fft.getFieldName() + "]";
	}


    public void resetCache(boolean sqlOnly) {
        generatedSQL = null;
        if (!sqlOnly) {
            allColumns = null;
            allFilters = null;
        }
	} 

    public String getOuterJoinType(DataSourceType curTable) {
        String refDefinition = nvl(curTable.getRefDefinition());
        int outerJoinIdx = refDefinition.indexOf(" (+)");
        if (outerJoinIdx < 0)
            return "";

        int equalSignIdx = refDefinition.indexOf("=");
        if (refDefinition.indexOf(curTable.getTableId()) < equalSignIdx)
            return (outerJoinIdx < equalSignIdx) ? AppConstants.OJ_CURRENT
                    : AppConstants.OJ_JOINED;
        else
            return (outerJoinIdx < equalSignIdx) ? AppConstants.OJ_JOINED
                    : AppConstants.OJ_CURRENT;
	} 

    public String getFormFieldName(ColFilterType filter) {
        FormFieldType fft = null;
        if (filter.getArgType().equals(AppConstants.AT_FORM))
            fft = getFormFieldByDisplayValue(filter.getArgValue());

        return (fft != null) ? fft.getFieldId()
                : filter.getColId() + "_f"
                        + filter.getFilterSeq();
	} 

    public String getFormFieldDisplayName(DataColumnType column, ColFilterType filter) {
        FormFieldType fft = null;
        if (filter.getArgType().equals(AppConstants.AT_FORM))
            fft = getFormFieldByDisplayValue(filter.getArgValue());

        return (fft != null) ? fft.getFieldName()
                : column.getDisplayName() + "&nbsp;"
                        + filter.getExpression();
	}

    public Calendar getFormFieldRangeStart(ColFilterType filter) {
        FormFieldType fft = null;
        if (filter.getArgType().equals(AppConstants.AT_FORM))
            fft = getFormFieldByDisplayValue(filter.getArgValue());

        return (fft != null) ? fft.getRangeStartDate().toGregorianCalendar() : null;
	} 

    public Calendar getFormFieldRangeEnd(ColFilterType filter) {
        FormFieldType fft = null;
        if (filter.getArgType().equals(AppConstants.AT_FORM))
            fft = getFormFieldByDisplayValue(filter.getArgValue());
        return (fft != null) ? fft.getRangeEndDate().toGregorianCalendar() : null;
	} 

    public String getFormFieldRangeStartSQL(ColFilterType filter) {
        FormFieldType fft = null;
        if (filter.getArgType().equals(AppConstants.AT_FORM))
            fft = getFormFieldByDisplayValue(filter.getArgValue());

        return (fft != null) ? fft.getRangeStartDateSQL() : null;
	} 

    public String getFormFieldRangeEndSQL(ColFilterType filter) {
        FormFieldType fft = null;
        if (filter.getArgType().equals(AppConstants.AT_FORM))
            fft = getFormFieldByDisplayValue(filter.getArgValue());
        return (fft != null) ? fft.getRangeEndDateSQL() : null;
	}

    public String getUniqueTableId(String tableName) {
        String tableIdPrefix = tableName.startsWith("MSA_") ? tableName.substring(4, 6)
                : tableName.substring(0, 2);
        String tableId = "";

        int tableIdN = getDataSourceList().getDataSource().size() + 1;
        do {
            tableId = tableIdPrefix.toLowerCase() + (tableIdN++);
        } while (getTableById(tableId) != null);

        return tableId;
	} 

    protected void deleteDataSourceType(String tableId) {
        List dsList = getDataSourceList().getDataSource();
        for (Iterator iter = dsList.iterator(); iter.hasNext();) {
            DataSourceType dst = (DataSourceType) iter.next();
            if (dst.getTableId().equals(tableId))
                iter.remove();
            else if (nvl(dst.getRefTableId()).equals(tableId)) {
                dst.setRefTableId(null);
                dst.setRefDefinition(null);
            }
		} 

        resetCache(false);
	}

    public static void adjustColumnType(DataColumnType dct) {
        dct.setColType(dct.getDbColType());

        if (dct.isCalculated())
            if (dct.getColName().startsWith("SUM(") || dct.getColName().startsWith("COUNT(")
                    || dct.getColName().startsWith("AVG(")
                    || dct.getColName().startsWith("STDDEV(")
                    || dct.getColName().startsWith("VARIANCE("))
                dct.setColType(AppConstants.CT_NUMBER);
            else if (dct.getColName().startsWith("DECODE(") || dct.getColName().startsWith("coalesce("))
                dct.setColType(AppConstants.CT_CHAR);
	} 
    public static boolean getColumnNoParseDateFlag(DataColumnType dct) {
        return (nvls(dct.getComment()).indexOf(AppConstants.CF_NO_PARSE_DATE) >= 0);
	}

    public static void setColumnNoParseDateFlag(DataColumnType dct, boolean noParseDateFlag) {
        dct.setComment(noParseDateFlag ? AppConstants.CF_NO_PARSE_DATE : null);
	} 


    public static String getSQLBasedFFTColTableName(String fftColId) {
        return fftColId.substring(0, fftColId.indexOf('.'));
	} 

    public static String getSQLBasedFFTColColumnName(String fftColId) {
        fftColId = (fftColId.indexOf('|') < 0) ? fftColId
                : fftColId.substring(0, fftColId
                        .indexOf('|'));
        return fftColId.substring(fftColId.indexOf('.') + 1);
	} 
    public static String getSQLBasedFFTColDisplayFormat(String fftColId) {
        return (fftColId.indexOf('|') < 0) ? ""
                : fftColId
                        .substring(fftColId.indexOf('|') + 1);
	} 


    public List<DataColumnType> getAllColumns() {
        if (cr == null)
            throw new NullPointerException("CustomReport not initialized");

        if (allColumns == null) {
            allColumns = new Vector();

            List dsList = getDataSourceList().getDataSource();
            for (Iterator iter = dsList.iterator(); iter.hasNext();) {
                DataSourceType ds = (DataSourceType) iter.next();
                List dcList = ds.getDataColumnList().getDataColumn();
                for (Iterator iterC = dcList.iterator(); iterC.hasNext();) {
                    DataColumnType dc = (DataColumnType) iterC.next();

                    allColumns.add(dc);
				} 
			} 

            Collections.sort(allColumns, new OrderSeqComparator());
		} 

        return allColumns;
	}

    public List getOnlyVisibleColumns() {
        if (cr == null)
            throw new NullPointerException("CustomReport not initialized");

        if (allVisibleColumns == null) {
            allVisibleColumns = new Vector();

            List dsList = getDataSourceList().getDataSource();
            for (Iterator iter = dsList.iterator(); iter.hasNext();) {
                DataSourceType ds = (DataSourceType) iter.next();
                List dcList = ds.getDataColumnList().getDataColumn();
                for (Iterator iterC = dcList.iterator(); iterC.hasNext();) {
                    DataColumnType dc = (DataColumnType) iterC.next();
                    if (dc.isVisible())
                        allVisibleColumns.add(dc);
				} 
			} 

            Collections.sort(allVisibleColumns, new OrderSeqComparator());
		} 

        return allVisibleColumns;
	} 
    public int getVisibleColumnCount() {
        if (cr == null)
            throw new NullPointerException("CustomReport not initialized");
        int colCount = 0;
        List dsList = getDataSourceList().getDataSource();
        for (Iterator iter = dsList.iterator(); iter.hasNext();) {
            DataSourceType ds = (DataSourceType) iter.next();
            List dcList = ds.getDataColumnList().getDataColumn();
            for (Iterator iterC = dcList.iterator(); iterC.hasNext();) {
                DataColumnType dc = (DataColumnType) iterC.next();
                if (dc.isVisible())
                    colCount++;
				} 
			} 

        return colCount;
    }

    public List getAllFilters() {
        if (cr == null)
            throw new NullPointerException("CustomReport not initialized");

        allFilters = new Vector();

        List reportCols = getAllColumns();
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dct = (DataColumnType) iter.next();

            if (dct.getColFilterList() != null) {
                List colFilters = dct.getColFilterList().getColFilter();

                for (Iterator iterF = colFilters.iterator(); iterF.hasNext();) {
                    ColFilterType cft = (ColFilterType) iterF.next();

                    allFilters.add(cft);
				} 
			} 
		} 
        return allFilters;
	}

    private String formatValue(String value, DataColumnType dc, boolean useDefaultDateFormat) throws RaptorException {
        return formatValue(value, dc, useDefaultDateFormat, getColumnTableById(dc.getColId()), null);
	}

    private String formatValue(String value, DataColumnType dc, boolean useDefaultDateFormat,
            DataSourceType ds, FormFieldType fft) throws RaptorException {
        String fmtValue = null;

        if (nvl(value).length() == 0)
            fmtValue = "";
        else if (value.equals(AppConstants.FILTER_MAX_VALUE)
                || value.equals(AppConstants.FILTER_MIN_VALUE))
            fmtValue = "(SELECT "
                    + (value.equals(AppConstants.FILTER_MAX_VALUE) ? "MAX" : "MIN") + "("
                    + dc.getColName() + ") FROM " + ds.getTableName() + ")";
        else if (dc.getColType().equals(AppConstants.CT_NUMBER)) {
            try {
                double vD = Double.parseDouble(value);
                fmtValue = value;
            } catch (NumberFormatException ex) {
                throw new UserDefinedException(
                        "Expected number, Given String for the form field \"" + fft.getFieldName() + "\"");
            }
        } else if (dc.getColType().equals(AppConstants.CT_DATE)) {
            if (fft != null && (fft.getValidationType().equals(FormField.VT_TIMESTAMP_HR)
                    || fft.getValidationType().equals(FormField.VT_TIMESTAMP_MIN)
                    || fft.getValidationType().equals(FormField.VT_TIMESTAMP_SEC))) {
                fmtValue = "TO_DATE('"
                        + value
                        + "', '"
                        + (useDefaultDateFormat ? AppConstants.DEFAULT_DATE_FORMAT
                                : nvl(dc
							.getColFormat(), AppConstants.DEFAULT_DATE_FORMAT));
                fmtValue = fmtValue + " HH24";
                if (fft.getValidationType().equals(FormField.VT_TIMESTAMP_MIN)
                        || fft.getValidationType().equals(FormField.VT_TIMESTAMP_SEC))
                    fmtValue = fmtValue + ":MI";
                if (fft.getValidationType().equals(FormField.VT_TIMESTAMP_SEC))
                    fmtValue = fmtValue + " HH24:MI:SS";
            } else {
                fmtValue = "TO_DATE('"
                        + value
                        + "', '"
                        + (useDefaultDateFormat ? AppConstants.DEFAULT_DATE_FORMAT
                                : nvl(dc
                                        .getColFormat(), AppConstants.DEFAULT_DATE_FORMAT))
                        + "')";
                if (Globals.getMonthFormatUseLastDay())
                    if (!useDefaultDateFormat)
                        if ("MM/YYYY".equals(nvl(dc.getColFormat(), AppConstants.DEFAULT_DATE_FORMAT))
                                || "MONTH, YYYY"
                                        .equals(nvl(dc.getColFormat(), AppConstants.DEFAULT_DATE_FORMAT)))
                            fmtValue = "ADD_MONTHS(" + fmtValue + ", 1)-1";
            }
        } else {
            fmtValue = value;
            if (!fmtValue.startsWith("'"))
                fmtValue = "'" + fmtValue + "'";
        }

        return fmtValue;
	}

    private String formatListValue(String listValue, DataColumnType dc,
            boolean useDefaultDateFormat, boolean useOnlyPipeDelimiter) throws RaptorException {
        return formatListValue("", listValue, dc, useDefaultDateFormat, useOnlyPipeDelimiter,
                getColumnTableById(dc.getColId()), null);
	} 

    public String formatListValue(String fieldDisplay, String listValue, DataColumnType dc,
            boolean useDefaultDateFormat, boolean useOnlyPipeDelimiter, DataSourceType ds,
            String listBaseSQL) throws RaptorException {
        StringBuffer fmtValue = new StringBuffer("");
        StringTokenizer st = new StringTokenizer(listValue, useOnlyPipeDelimiter ? "|"
                : ",\n\r\f");

        while (st.hasMoreTokens()) {
            if (fmtValue.length() > 0)
                fmtValue.append(", ");

            if (dc == null) {
                String value = st.nextToken().trim();
                if (value.startsWith("'"))
                    fmtValue.append(value);
                else
                    fmtValue.append("'" + value + "'");
            } else
                fmtValue.append(formatValue(st.nextToken().trim(), dc, useDefaultDateFormat,
                        ds, null));

		}

        if (fmtValue.length() == 0) {
            if (nvl(fieldDisplay).length() > 0) {
                fmtValue.append("");
            } else {
                fmtValue.append("(");
                fmtValue.append(nvl(listBaseSQL, "NULL"));
                fmtValue.append(")");
            }
        } else if (fmtValue.charAt(0) != '(') {
            fmtValue.insert(0, '(');
            fmtValue.append(')');
        }

        return fmtValue.toString();
	} 

    private String getColumnSelectStr(DataColumnType dc, ReportParamValues paramValues) {
        String colName = dc.isCalculated() ? dc.getColName()
                : ((nvl(dc.getTableId()).length() > 0) ? (dc.getTableId() + "." + dc
                        .getColName()) : dc.getColName());
        String paramValue = null;
        if (dc.isCalculated())
            if (getFormFieldList() != null)
                for (Iterator iter2 = getFormFieldList().getFormField().iterator(); iter2
                        .hasNext();) {
                    FormFieldType fft = (FormFieldType) iter2.next();
                    String fieldId = fft.getFieldId();
                    String fieldDisplay = getFormFieldDisplayName(fft);
                    if (!paramValues.isParameterMultiValue(fieldId)) {
                        paramValue = paramValues.getParamValue(fieldId);
                        if (paramValue != null && paramValue.length() > 0) {
                            colName = Utils.replaceInString(colName, fieldDisplay, Utils
                                    .oracleSafe(nvl(paramValue, "NULL")));
                        } else {
                            colName = Utils.replaceInString(colName, "'" + fieldDisplay + "'", nvl(
                                    paramValue, "NULL"));
                            colName = Utils.replaceInString(colName, fieldDisplay, nvl(
                                    paramValue, "NULL"));
                        }
                    }
				}

        return colName;
	} 

    private void addExtraIdSelect(StringBuffer selectExtraIdCl, String drillDownParams,
            boolean includeSelectExpr) {
		drillDownParams = drillDownParams.substring(10, drillDownParams.length() - 1); 

        selectExtraIdCl.append(", ");
        if (includeSelectExpr) {
            selectExtraIdCl.append(drillDownParams);
            selectExtraIdCl.append(" ");
        } // if
		selectExtraIdCl.append(drillDownParams.replace('.', '_')); 
	} 

    private void addExtraDateSelect(StringBuffer selectExtraDateCl, String drillDownParams,
            ReportParamValues paramValues, boolean includeSelectExpr) {
        String colId = "";
        while (drillDownParams.indexOf('[') >= 0) {
            int startIdx = drillDownParams.indexOf('[');
            int endIdx = drillDownParams.indexOf(']');

            if (startIdx <= endIdx) {
				colId = drillDownParams.substring(startIdx + 1, endIdx); 
            } else {
                drillDownParams = drillDownParams.substring(endIdx + 1);
                continue;
            }
																		

            DataColumnType column = getColumnById(colId);
            if (column != null)
                if (column.getColType().equals(AppConstants.CT_DATE))
                    if (!nvl(column.getColFormat(), AppConstants.DEFAULT_DATE_FORMAT).equals(
                            AppConstants.DEFAULT_DATE_FORMAT))
                        if (selectExtraDateCl.toString().indexOf(
                                " " + colId + AppConstants.DD_COL_EXTENSION) < 0) {
                            selectExtraDateCl.append(", ");
                            if (includeSelectExpr) {
                                selectExtraDateCl.append("TO_CHAR("
                                        + getColumnSelectStr(column, paramValues) + ", '"
                                        + AppConstants.DEFAULT_DATE_FORMAT + "')");
                                selectExtraDateCl.append(" ");
							} 
							selectExtraDateCl.append(colId + AppConstants.DD_COL_EXTENSION);
						} 

            drillDownParams = drillDownParams.substring(endIdx + 1);
		} 
	} 


    public String generateSQL(String userId, HttpServletRequest request) throws RaptorException {
        return generateSQL(new ReportParamValues(), userId, request);
	} 
    public String generateSQL(ReportParamValues paramValues, String userId, HttpServletRequest request)
            throws RaptorException {
        return generateSQL(paramValues, null, AppConstants.SO_ASC, userId, request);
	} 

    public String generateSQL(ReportParamValues paramValues, String overrideSortByColId,
            String overrideSortByAscDesc, String userId, HttpServletRequest request) throws RaptorException {
        if (cr == null)
            throw new NullPointerException("CustomReport not initialized");
        if (nvl(getWholeSQL()).length() > 0)
            return getWholeSQL();
        if (paramValues.size() > 0)
            resetCache(true);
          
        if (generatedSQL == null) {
            if (getReportDefType().equals(AppConstants.RD_SQL_BASED)
                    || getReportDefType().equals(AppConstants.RD_SQL_BASED_DATAMIN)) {
                generatedSQL = generateSQLSQLBased(paramValues, overrideSortByColId,
                        overrideSortByAscDesc, userId, request);
                generatedChartSQL = generateSQLSQLBased(paramValues, null,
                        AppConstants.SO_ASC, userId, request);
            } else if (getReportDefType().equals(AppConstants.RD_VISUAL)
                    && !getReportType().equals(AppConstants.RT_CROSSTAB)) {
                generatedSQL = generateSQLVisual(paramValues, overrideSortByColId,
                        overrideSortByAscDesc, userId, request);
                generatedChartSQL = generateSQLVisual(paramValues, null,
                        AppConstants.SO_ASC, userId, request);
            } else {
                generatedSQL = generateSQLCrossTabVisual(paramValues, overrideSortByColId,
                        overrideSortByAscDesc, userId, request);
            }

            generatedSQL = replaceNewLine(generatedSQL, "" + '\n', " " + '\n' + " ");
            if (nvl(generatedChartSQL).trim().length() > 0)
                generatedChartSQL = replaceNewLine(generatedChartSQL, "" + '\n', " " + '\n' + " ");
		} 

        return generatedSQL;
	} 

    public String generateSQLSQLBased(ReportParamValues paramValues,
            String overrideSortByColId, String overrideSortByAscDesc, String userId, HttpServletRequest request)
            throws RaptorException {
        String sql = getReportSQL();
        DataSet ds = null;
        String[] reqParameters = Globals.getRequestParams().split(",");
        String[] sessionParameters = Globals.getSessionParams().split(",");
        String[] scheduleSessionParameters = Globals.getSessionParamsForScheduling().split(",");
        javax.servlet.http.HttpSession session = request.getSession();
        String dbType = "";
        String dbInfo = getDBInfo();
        int fieldCount = 0;
        Pattern re1 = null;
        Matcher matcher = null;
        int index = 0;
        int posFormField = 0;
        int posAnd = 0;
        if (!isNull(dbInfo) && (!dbInfo.equals(AppConstants.DB_LOCAL))) {
            try {
                dbType = remDbInfo.getDBType(dbInfo);
            } catch (Exception ex) {
                throw new RaptorException(ex);
            }
        }

        sql = sql + " ";
        sql = Pattern.compile("(^[\r\n]*|([\\s]))[Ss][Ee][Ll][Ee][Cc][Tt]([\r\n]*|[\\s]*)", Pattern.DOTALL).matcher(sql)
                .replaceAll(" SELECT ");
        sql = Pattern.compile("(^[\r\n]*|([\\s]))[Ww][Hh][Ee][Rr][Ee]([\r\n]*|[\\s]*)", Pattern.DOTALL).matcher(sql)
                .replaceAll(" WHERE ");
        sql = Pattern.compile("(^[\r\n]*|([\\s]))[Ww][Hh][Ee][Nn]([\r\n]*|[\\s]*)", Pattern.DOTALL).matcher(sql)
                .replaceAll(" WHEN ");
        sql = Pattern.compile("(^[\r\n]*|([\\s]))[Aa][Nn][Dd]([\r\n]*|[\\s]*)", Pattern.DOTALL).matcher(sql)
                .replaceAll(" AND ");

        if (getFormFieldList() != null) {
            for (Iterator iter = getFormFieldList().getFormField().iterator(); iter.hasNext();) {

                FormFieldType fft = (FormFieldType) iter.next();
                String fieldId = fft.getFieldId();
                String fieldDisplay = getFormFieldDisplayName(fft);
                if (!fft.getFieldType().equals(FormField.FFT_BLANK)) {
                    if (paramValues.isParameterMultiValue(fieldId)) {
                        String replaceValue = formatListValue(fieldDisplay, Utils
                                .oracleSafe(nvl(paramValues.getParamValue(fieldId))), null, false,
                                true, null, paramValues.getParamBaseSQL(fieldId));
                        if (replaceValue.length() > 0) {
                            sql = Utils.replaceInString(sql, fieldDisplay, replaceValue);
                        } else {
                            fieldCount++;
                            if (fieldCount == 1) {
                            }
                            while (sql.indexOf(fieldDisplay) > 0) {
                                re1 = Pattern.compile(
                                        "(^[\r\n]|[\\s])AND(.*?[^\r\n]*)" + "\\[" + fft.getFieldName() + "\\](.*?)\\s",
                                        Pattern.DOTALL);
                                posFormField = sql.indexOf(fieldDisplay);
                                int posSelectField = sql.lastIndexOf("SELECT ", posFormField);
                                int andField = 0;
                                int whereField = 0;
								int	whenField = 0;
                                andField = sql.lastIndexOf(" AND ", posFormField);
                                whereField = sql.indexOf(" WHERE", posSelectField);
                                whenField = sql.indexOf(" WHEN", posSelectField);

                                if (posFormField > whereField)
                                    andField = sql.lastIndexOf(" AND ", posFormField);
                                if (posFormField > andField && (andField > whereField || andField > whenField))
                                    posAnd = andField;
                                else
                                    posAnd = 0;
                                matcher = re1.matcher(sql);

                                if (posAnd > 0 && matcher.find(posAnd - 1)) {
           						
                                    matcher = re1.matcher(sql);
                                    index = sql != null ? sql.lastIndexOf("[" + fft.getFieldName() + "]") : -1;

                                    if (andField > 0)
                                        index = andField;
                                    else
                                        index = whereField;
                                    if (index >= 0 && matcher.find(index - 1)) {
                                        sql = sql.replace(matcher.group(), " ");
                                    }
                                } else {

                                    re1 = Pattern.compile(
                                            "(^[\r\n]|[\\s])WHERE(.*?[^\r\n]*)\\[" + fft.getFieldName() + "\\](.*?)\\s",
                                            Pattern.DOTALL);
                                    matcher = re1.matcher(sql);
                                    if (whereField != -1) {
                                        if (matcher.find(whereField - 1)) {
                                            matcher = re1.matcher(sql);
                                            index = sql != null ? sql.lastIndexOf("[" + fft.getFieldName() + "]") : -1;
                                            if (index >= 0 && matcher.find(index - 30)) {
                                                sql = sql.replace(matcher.group(), " WHERE 1=1 ");
                                            }
                                        } 
                                    } else {
                                        sql = Utils.replaceInString(sql, fieldDisplay, replaceValue);
                                    }

                                }
                            }
                        }

                    } else {
                        String paramValue = "";
                        if (paramValues.isParameterTextAreaValueAndModified(fieldId)) {
                            String value = "";
                            value = nvl(paramValues
                                    .getParamValue(fieldId));
                            paramValue = value;
                        } else
                            paramValue = Utils.oracleSafe(nvl(paramValues
                                    .getParamValue(fieldId)));

                        if (paramValue != null && paramValue.length() > 0) {
                            if (paramValue.toLowerCase().trim().startsWith("select ")) {
                                paramValue = Utils.replaceInString(paramValue, "[LOGGED_USERID]", userId);
                                paramValue = Utils.replaceInString(paramValue, "[USERID]", userId);
                                paramValue = Utils.replaceInString(paramValue, "[USER_ID]", userId);

                                paramValue = Utils.replaceInString(paramValue, "''", "'");
                                ds = ConnectionUtils.getDataSet(paramValue, dbInfo);
                                if (ds.getRowCount() > 0)
                                    paramValue = ds.getString(0, 0);
                            }
                            if (fft != null && (fft.getValidationType() != null
                                    && (fft.getValidationType().equals(FormField.VT_TIMESTAMP_HR)
                                            || fft.getValidationType().equals(FormField.VT_TIMESTAMP_MIN)
                                            || fft.getValidationType().equals(FormField.VT_TIMESTAMP_SEC)
                                            || fft.getValidationType().equals(FormField.VT_DATE)))) {
                                if (fft.getValidationType().equals(FormField.VT_TIMESTAMP_HR)) {
                                    sql = Utils.replaceInString(sql, fieldDisplay, nvl(
                                            paramValue)
                                            + ((nvl(paramValues
                                                    .getParamValue(fieldId + "_Hr")).length() > 0)
                                                            ? " " + addZero(Utils.oracleSafe(nvl(paramValues
                                                                    .getParamValue(fieldId + "_Hr"))))
                                                            : ""));
                                } else if (fft.getValidationType().equals(FormField.VT_TIMESTAMP_MIN)) {
			                            sql = Utils.replaceInString(sql, fieldDisplay, nvl(
                                            paramValue)
                                            + ((nvl(paramValues
                                                    .getParamValue(fieldId + "_Hr")).length() > 0)
                                                            ? " " + addZero(Utils.oracleSafe(nvl(paramValues
                                                                    .getParamValue(fieldId + "_Hr"))))
                                                            : "")
                                            + ((nvl(paramValues
                                                    .getParamValue(fieldId + "_Min")).length() > 0)
                                                            ? ":" + addZero(Utils.oracleSafe(nvl(paramValues
                                                                    .getParamValue(fieldId + "_Min"))))
                                                            : ""));
                                } else if (fft.getValidationType().equals(FormField.VT_TIMESTAMP_SEC)) {
                                    sql = Utils.replaceInString(sql, fieldDisplay, nvl(
                                            paramValue)
                                            + ((nvl(paramValues
                                                    .getParamValue(fieldId + "_Hr")).length() > 0)
                                                            ? " " + addZero(Utils.oracleSafe(nvl(paramValues
                                                                    .getParamValue(fieldId + "_Hr"))))
                                                            : "")
                                            + ((nvl(paramValues
                                                    .getParamValue(fieldId + "_Min")).length() > 0)
                                                            ? ":" + addZero(Utils.oracleSafe(nvl(paramValues
                                                                    .getParamValue(fieldId + "_Min"))))
                                                            : "")
                                            + ((nvl(paramValues
                                                    .getParamValue(fieldId + "_Sec")).length() > 0)
                                                            ? ":" + addZero(Utils.oracleSafe(nvl(paramValues
                                                                    .getParamValue(fieldId + "_Sec"))))
                                                            : ""));
                                } else {
                                    sql = Utils.replaceInString(sql, fieldDisplay, nvl(
                                            paramValue, "NULL"));
                                }

                            } else {
                                if (paramValue != null && paramValue.length() > 0) {
                                    if (sql.indexOf("'" + fieldDisplay + "'") != -1
                                            || sql.indexOf("'" + fieldDisplay) != -1
                                            || sql.indexOf(fieldDisplay + "'") != -1
                                            || sql.indexOf("'%" + fieldDisplay + "%'") != -1
                                            || sql.indexOf("'%" + fieldDisplay) != -1
                                            || sql.indexOf(fieldDisplay + "%'") != -1
                                            || sql.indexOf("'_" + fieldDisplay + "_'") != -1
                                            || sql.indexOf("'_" + fieldDisplay) != -1
                                            || sql.indexOf(fieldDisplay + "_'") != -1
                                            || sql.indexOf("'%_" + fieldDisplay + "_%'") != -1
                                            || sql.indexOf("^" + fieldDisplay + "^") != -1
                                            || sql.indexOf("'%_" + fieldDisplay) != -1
                                            || sql.indexOf(fieldDisplay + "_%'") != -1) {
                                        sql = Utils.replaceInString(sql, fieldDisplay, nvl(
                                                paramValue, "NULL"));
                                    } else {
                                        if (sql.indexOf(fieldDisplay) != -1) {
                                            if (nvl(paramValue).length() > 0) {
                                                try {
                                                    double vD = Double.parseDouble(paramValue);
                                                    sql = Utils.replaceInString(sql, fieldDisplay, nvl(
                                                            paramValue, "NULL"));

                                                } catch (NumberFormatException ex) {
                                                    if (sql.trim().toUpperCase()
                                                            .startsWith("SELECT")) {
                                                        sql = Utils.replaceInString(sql, fieldDisplay, nvl(
                                                                paramValue, "NULL"));
                                                    } else
                                                        throw new UserDefinedException(
                                                                "Expected number, Given String for the form field \""
                                                                        + fieldDisplay + "\"");
                                                }
                                              
                                            } else
                                                sql = Utils.replaceInString(sql, fieldDisplay, nvl(
                                                        paramValue, "NULL"));

                                        }
                                    }
                                } else {
                                    if ("DAYTONA".equals(dbType) && sql.trim().toUpperCase().startsWith("SELECT")) {
                                        sql = sql + " ";
                                        re1 = Pattern.compile("(^[\r\n]|[\\s]|[^0-9a-zA-Z])AND(.*?[^\r\n]*)" + "\\["
                                                + fft.getFieldName() + "\\](.*?)\\s", Pattern.DOTALL);
                                        posFormField = sql.indexOf(fieldDisplay);
                                        posAnd = sql.lastIndexOf(" AND ", posFormField);
                                        if (posAnd < 0)
                                            posAnd = 0;
                                        else if (posAnd > 2)
                                            posAnd = posAnd - 2;
                                        matcher = re1.matcher(sql);
                                        if (matcher.find(posAnd)) {
                                            sql = sql.replace(matcher.group(), "");
                                        }
                                    } else {
                                        sql = Utils.replaceInString(sql, "'" + fieldDisplay + "'", nvl(
                                                paramValue, "NULL"));
                                        sql = Utils.replaceInString(sql, fieldDisplay, nvl(
                                                paramValue, "NULL"));
                                    }
                                }
                            }

                        }

                        if ("DAYTONA".equals(dbType) && sql.trim().toUpperCase().startsWith("SELECT")) {
                            sql = sql + " ";
                            re1 = Pattern.compile("(^[\r\n]|[\\s]|[^0-9a-zA-Z])AND(.*?[^\r\n]*)" + "\\["
                                    + fft.getFieldName() + "\\](.*?)\\s", Pattern.DOTALL); // +[\'\\)|\'|\\s]
                            posFormField = sql.indexOf(fieldDisplay);
                            posAnd = sql.lastIndexOf(" AND ", posFormField);
                            if (posAnd < 0)
                                posAnd = 0;
                            else if (posAnd > 2)
                                posAnd = posAnd - 2;
                            matcher = re1.matcher(sql);
                            if (matcher.find(posAnd)) {
                                sql = sql.replace(matcher.group(), " ");
                            }
                        } else {
                            if (fft.isGroupFormField() != null && fft.isGroupFormField().booleanValue()) {
                                sql = Pattern.compile("[[\\s*][,]]\\[" + fft.getFieldName() + "\\](.*?)[,]",
                                        Pattern.MULTILINE).matcher(sql).replaceAll(" ");
                                sql = Pattern
                                        .compile("(,.+?)[\\s*]\\[" + fft.getFieldName() + "\\][\\s]", Pattern.MULTILINE)
                                        .matcher(sql).replaceAll(" ");
           				} else {
                                sql = Utils.replaceInString(sql, "'" + fieldDisplay + "'", nvl(
                                        paramValue, "NULL"));
                                sql = Utils.replaceInString(sql, fieldDisplay, nvl(
                                        paramValue, "NULL"));
                            }
                        }

				} 
				}
			} 
            if (request != null) {
                for (int i = 0; i < reqParameters.length; i++) {
                    if (!reqParameters[i].startsWith("ff")) {
                        if (nvl(request.getParameter(reqParameters[i].toUpperCase())).length() > 0)
                            sql = Utils.replaceInString(sql, "[" + reqParameters[i].toUpperCase() + "]",
                                    ESAPI.encoder().encodeForSQL(SecurityCodecUtil.getCodec(),
                                            request.getParameter(reqParameters[i].toUpperCase())));
                    } else
                        sql = Utils.replaceInString(sql, "[" + reqParameters[i].toUpperCase() + "]", ESAPI.encoder()
                                .encodeForSQL(SecurityCodecUtil.getCodec(), request.getParameter(reqParameters[i])));
                }

                for (int i = 0; i < scheduleSessionParameters.length; i++) {
                    if (nvl(request.getParameter(scheduleSessionParameters[i])).trim().length() > 0)
                        sql = Utils.replaceInString(sql, "[" + scheduleSessionParameters[i].toUpperCase() + "]",
                                ESAPI.encoder().encodeForSQL(SecurityCodecUtil.getCodec(),
                                        request.getParameter(scheduleSessionParameters[i])));
                }
            }
            if (session != null) {
                for (int i = 0; i < sessionParameters.length; i++) {
                    sql = Utils.replaceInString(sql, "[" + sessionParameters[i].toUpperCase() + "]",
                            (String) session.getAttribute(sessionParameters[i]));
                    
                }
            }
        } else {
            sql = Utils.replaceInString(sql, "[LOGGED_USERID]", userId);
            sql = Utils.replaceInString(sql, "[USERID]", userId);
            sql = Utils.replaceInString(sql, "[USER_ID]", userId);
            if (request != null) {
                for (int i = 0; i < reqParameters.length; i++) {
                    sql = Utils.replaceInString(sql, "[" + reqParameters[i].toUpperCase() + "]", ESAPI.encoder()
                            .encodeForSQL(SecurityCodecUtil.getCodec(), request.getParameter(reqParameters[i])));
                }
            }
            if (session != null) {
                for (int i = 0; i < sessionParameters.length; i++) {
                    sql = Utils.replaceInString(sql, "[" + sessionParameters[i].toUpperCase() + "]",
                            (String) session.getAttribute(sessionParameters[i]));
                }
            }
        }
        sql = Utils.replaceInString(sql, "[LOGGED_USERID]",
                ESAPI.encoder().encodeForSQL(SecurityCodecUtil.getCodec(), userId));
        sql = Utils.replaceInString(sql, "[USERID]",
                ESAPI.encoder().encodeForSQL(SecurityCodecUtil.getCodec(), userId));
        sql = Utils.replaceInString(sql, "[USER_ID]",
                ESAPI.encoder().encodeForSQL(SecurityCodecUtil.getCodec(), userId));

        int closeBracketPos = 0;
        if (nvl(overrideSortByColId).length() > 0) {
            if (sql.lastIndexOf(")") != -1)
                closeBracketPos = sql.lastIndexOf(")");
            int idxOrderBy = (closeBracketPos > 0) ? sql.toUpperCase().indexOf("ORDER BY", closeBracketPos)
                    : sql.toUpperCase().lastIndexOf("ORDER BY");
            DataColumnType dct = getColumnById(overrideSortByColId + "_sort");
            if (dct != null && dct.getColName().length() > 0) {
                overrideSortByColId = overrideSortByColId + "_sort";
            }
            if (idxOrderBy < 0)
                sql += " ORDER BY " + overrideSortByColId + " " + overrideSortByAscDesc;
            else {
                int braketCount = 0;
                int idxOrderByClauseEnd = 0;
                for (idxOrderByClauseEnd = idxOrderBy; idxOrderByClauseEnd < sql.length(); idxOrderByClauseEnd++) {
                    char ch = sql.charAt(idxOrderByClauseEnd);

                    if (ch == '(')
                        braketCount++;
                    else if (ch == ')') {
                        if (braketCount == 0)
                            break;
                        braketCount--;
                    }
				}

                sql = sql.substring(0, idxOrderBy) + " ORDER BY " + overrideSortByColId + " "
                        + overrideSortByAscDesc + sql.substring(idxOrderByClauseEnd);
			}
		} 
        sql = Pattern.compile("([\n][\\s]*)", Pattern.DOTALL).matcher(sql).replaceAll(" ");
        return sql;
	} 

    public String generateSQLVisual(ReportParamValues paramValues, String overrideSortByColId,
            String overrideSortByAscDesc, String userId, HttpServletRequest request) throws RaptorException {
        StringBuffer selectCl = new StringBuffer();
        StringBuffer fromCl = new StringBuffer();
        StringBuffer whereCl = new StringBuffer();
        StringBuffer groupByCl = new StringBuffer();
        StringBuffer havingCl = new StringBuffer();
        StringBuffer orderByCl = new StringBuffer();
        StringBuffer selectExtraIdCl = new StringBuffer();
        StringBuffer selectExtraDateCl = new StringBuffer();

        int whereClBracketCount = 0;
        int havingClBracketCount = 0;
        int whereClCarryoverBrackets = 0;
        int havingClCarryoverBrackets = 0;

        List dsList = getDataSourceList().getDataSource();
        for (Iterator iter = dsList.iterator(); iter.hasNext();) {
            DataSourceType ds = (DataSourceType) iter.next();

            if (fromCl.length() > 0)
                fromCl.append(", ");
            fromCl.append(ds.getTableName());
            fromCl.append(" ");
            fromCl.append(ds.getTableId());

            if (nvl(ds.getRefTableId()).length() > 0) {
                if (whereCl.length() > 0)
                    whereCl.append(" AND ");
                whereCl.append(ds.getRefDefinition());
			}
            TableSource tableSource = null;
            String dBInfo = this.cr.getDbInfo();
            Vector userRoles = AppUtils.getUserRoles(request);
            tableSource = DataCache.getTableSource(ds.getTableName(), dBInfo, userRoles, userId, request);
            if (userId != null && (!AppUtils.isSuperUser(request))
                    && (!AppUtils.isAdminUser(request)) && tableSource != null
                    && nvl(tableSource.getFilterSql()).length() > 0) {
                if (whereCl.length() > 0)
                    whereCl.append(" AND ");
                whereCl.append(Utils.replaceInString(Utils.replaceInString(tableSource
                        .getFilterSql(), "[" + ds.getTableName() + "]", ds.getTableId()),
                        "[USER_ID]", userId));
			}
		}

        List reportCols = getAllColumns();

        boolean isGroupStmt = false;
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (dc.isGroupBreak()) {
                isGroupStmt = true;
                break;
			} 
		}


        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            String colName = getColumnSelectStr(dc, paramValues);

            if (selectCl.length() > 0)
                selectCl.append(", ");
            selectCl.append(getSelectExpr(dc, colName));
            selectCl.append(" ");
            selectCl.append(dc.getColId());
            if (nvl(dc.getDrillDownURL()).length() > 0)
                if (isViewAction(dc.getDrillDownURL()))
                    addExtraIdSelect(selectExtraIdCl, nvl(dc.getDrillDownParams()), true);
                else
                    addExtraDateSelect(selectExtraDateCl, nvl(dc.getDrillDownParams()),
                            paramValues, true);
            if (dc.isGroupBreak()) {
                if (groupByCl.length() > 0)
                    groupByCl.append(", ");
                groupByCl.append(colName);
			} 
            boolean isHavingCl = isGroupStmt && (!dc.isGroupBreak());
            StringBuffer filterCl = isHavingCl ? havingCl : whereCl;

            if (dc.getColFilterList() != null) {
                int fNo = 0;
                List fList = dc.getColFilterList().getColFilter();
                for (Iterator iterF = fList.iterator(); iterF.hasNext(); fNo++) {
                    ColFilterType cf = (ColFilterType) iterF.next();

                    StringBuffer curFilter = new StringBuffer();
                    if (filterCl.length() > 0)
                        curFilter.append(" " + cf.getJoinCondition() + " ");
                    if ((isHavingCl ? havingClCarryoverBrackets : whereClCarryoverBrackets) > 0)
                        for (int b = 0; b < (isHavingCl ? havingClCarryoverBrackets
                                : whereClCarryoverBrackets); b++)
                            filterCl.append('(');
                    curFilter.append(nvl(cf.getOpenBrackets()));
                    curFilter.append(colName + " ");
                    curFilter.append(cf.getExpression() + " ");

                    boolean applyFilter = true;
                    if ((nvl(cf.getArgValue()).length() > 0)
                            || (nvl(cf.getArgType()).equals(AppConstants.AT_FORM)))
                        if (nvl(cf.getArgType()).equals(AppConstants.AT_FORMULA))
                            curFilter.append(cf.getArgValue());
                        else if (nvl(cf.getArgType()).equals(AppConstants.AT_VALUE))
                            curFilter.append(formatValue(cf.getArgValue(), dc, false));
                        else if (nvl(cf.getArgType()).equals(AppConstants.AT_LIST))
                            curFilter.append(formatListValue(cf.getArgValue(), dc, false,
                                    false));
                        else if (nvl(cf.getArgType()).equals(AppConstants.AT_COLUMN))
                            curFilter.append(getColumnNameById(cf.getArgValue()));
                        else if (nvl(cf.getArgType()).equals(AppConstants.AT_FORM)) {
                            String fieldName = getFormFieldName(cf);
                            String fieldValue = Utils.oracleSafe(paramValues
                                    .getParamValue(fieldName));
                            boolean isMultiValue = paramValues
                                    .isParameterMultiValue(fieldName);
                            boolean usePipeDelimiterOnly = false;

                            FormFieldType fft = getFormFieldByDisplayValue(cf.getArgValue());
                            if (fft == null)
                                fieldValue = nvl(fieldValue, Utils
                                        .oracleSafe(cf.getArgValue()));
                            else
                                usePipeDelimiterOnly = fft.getFieldType().equals(
                                        FormField.FFT_CHECK_BOX)
                                        || fft.getFieldType().equals(FormField.FFT_LIST_MULTI);
                            if (fft != null) {
                                String fieldId = fft.getFieldId();
                                if (fft.getValidationType().equals(FormField.VT_TIMESTAMP_HR)
                                        || fft.getValidationType().equals(FormField.VT_TIMESTAMP_MIN)
                                        || fft.getValidationType().equals(FormField.VT_TIMESTAMP_SEC)) {
                                    fieldValue = nvl(
                                            fieldValue + " " + addZero(Utils.oracleSafe(nvl(paramValues
                                                    .getParamValue(fieldId + "_Hr")))));
                                    if (fft.getValidationType().equals(FormField.VT_TIMESTAMP_MIN)
                                            || fft.getValidationType().equals(FormField.VT_TIMESTAMP_SEC)) {
                                        fieldValue = fieldValue + (nvl(paramValues
                                                .getParamValue(fieldId + "_Min")).length() > 0
                                                        ? ":" + addZero(Utils.oracleSafe(nvl(paramValues
                                                                .getParamValue(fieldId + "_Min"))))
                                                        : "");
                                    }
                                    if (fft.getValidationType().equals(FormField.VT_TIMESTAMP_SEC)) {
                                        fieldValue = fieldValue + (nvl(paramValues
                                                .getParamValue(fieldId + "_Sec")).length() > 0
                                                        ? ":" + addZero(Utils.oracleSafe(nvl(paramValues
                                                                .getParamValue(fieldId + "_Sec"))))
                                                        : "");
                                    }
                                }
                            }

                            // End
                            if (nvl(fieldValue).length() == 0) {
                                // Does not append filter with missing form
                                // field argument
                                applyFilter = false;
                            } else if (isMultiValue || "IN".equals(nvl(cf.getExpression()))
                                    || "NOT IN".equals(nvl(cf.getExpression()))) {
                                curFilter.append(formatListValue(fieldValue, dc, true,
                                        usePipeDelimiterOnly));
                            } else {
                                curFilter.append(formatValue(fieldValue, dc, true, getColumnTableById(dc.getColId()), fft));
                            }
                        } // else
                    curFilter.append(nvl(cf.getCloseBrackets()));

                    if (applyFilter) {
                        filterCl.append(curFilter.toString());

                        if (isHavingCl) {
                            havingClBracketCount += (nvl(cf.getOpenBrackets()).length() - nvl(
                                    cf.getCloseBrackets()).length());
                            havingClCarryoverBrackets = 0;
                        } else {
                            whereClBracketCount += (nvl(cf.getOpenBrackets()).length() - nvl(
                                    cf.getCloseBrackets()).length());
                            whereClCarryoverBrackets = 0;
                        }
                    } else if (nvl(cf.getOpenBrackets()).length() != nvl(cf.getCloseBrackets())
                            .length())
                        if (nvl(cf.getOpenBrackets()).length() > nvl(cf.getCloseBrackets())
                                .length()) {
                            if (isHavingCl)
                                havingClCarryoverBrackets += (nvl(cf.getOpenBrackets())
                                        .length() - nvl(cf.getCloseBrackets()).length());
                            else
                                whereClCarryoverBrackets += (nvl(cf.getOpenBrackets())
                                        .length() - nvl(cf.getCloseBrackets()).length());

                            if (isHavingCl)
                                havingClBracketCount += (nvl(cf.getOpenBrackets()).length() - nvl(
                                        cf.getCloseBrackets()).length());
                            else
                                whereClBracketCount += (nvl(cf.getOpenBrackets()).length() - nvl(
                                        cf.getCloseBrackets()).length());
                        } else {
						
                            if (filterCl.length() > 0) {
                                for (int b = 0; b < nvl(cf.getCloseBrackets()).length()
                                        - nvl(cf.getOpenBrackets()).length(); b++)
                                    filterCl.append(')');

                                if (isHavingCl)
                                    havingClBracketCount += (nvl(cf.getOpenBrackets())
                                            .length() - nvl(cf.getCloseBrackets()).length());
                                else
                                    whereClBracketCount += (nvl(cf.getOpenBrackets()).length() - nvl(
                                            cf.getCloseBrackets()).length());
							} 
						} 
				} 
			} 
		}

        DataColumnType overrideSortByCol = null;
        if (overrideSortByColId != null)
            overrideSortByCol = getColumnById(overrideSortByColId);

        if (overrideSortByCol != null) {
            orderByCl.append(getColumnSelectStr(overrideSortByCol, paramValues));
            orderByCl.append(" ");
            orderByCl.append(nvl(overrideSortByAscDesc, AppConstants.SO_ASC));
        } else if (getReportType().equals(AppConstants.RT_CROSSTAB)) {

        } else {
            Collections.sort(reportCols, new OrderBySeqComparator());
            for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
                DataColumnType dc = (DataColumnType) iter.next();

                if (dc.getOrderBySeq() > 0) {
                    if (orderByCl.length() > 0)
                        orderByCl.append(", ");
                    orderByCl.append(getColumnSelectStr(dc, paramValues));
                    orderByCl.append(" ");
                    orderByCl.append(dc.getOrderByAscDesc());
				} 
			} 
            Collections.sort(reportCols, new OrderSeqComparator());
		} 

        StringBuffer sql = new StringBuffer();
        sql.append(Globals.getGenerateSqlVisualSelect());
        sql.append((selectCl.length() == 0) ? Globals.getGenerateSqlVisualCount() : selectCl.toString());
        if (groupByCl.length() == 0)
            sql.append(selectExtraIdCl.toString());
        sql.append(selectExtraDateCl.toString());
        sql.append((fromCl.length() == 0) ? Globals.getGenerateSqlVisualDual() : "FROM " + fromCl.toString());
        if (whereCl.length() > 0) {
            if (whereClBracketCount > 0) {
                for (int b = 0; b < whereClBracketCount; b++)
                    whereCl.append(')');
            } else if (whereClBracketCount < 0) {
                for (int b = 0; b < Math.abs(whereClBracketCount); b++)
                    whereCl.insert(0, '(');
			}

            sql.append(" WHERE ");
            sql.append(whereCl.toString());
		}
        if (groupByCl.length() > 0) {
            sql.append(" GROUP BY ");
            sql.append(groupByCl.toString());

            if (havingCl.length() > 0) {
                if (havingClBracketCount > 0) {
                    for (int b = 0; b < havingClBracketCount; b++)
                        havingCl.append(')');
                } else if (havingClBracketCount < 0) {
                    for (int b = 0; b < Math.abs(havingClBracketCount); b++)
                        havingCl.insert(0, '(');
				}

                sql.append(" HAVING ");
                sql.append(havingCl.toString());
            }
        }
        if (orderByCl.length() > 0) {
            sql.append(" ORDER BY ");
            sql.append(orderByCl.toString());
        }
        return sql.toString();
	} 

    public String generateSQLCrossTabVisual(ReportParamValues paramValues, String overrideSortByColId,
            String overrideSortByAscDesc, String userId, HttpServletRequest request) throws RaptorException {
        StringBuffer selectCl = new StringBuffer();
        StringBuffer fromCl = new StringBuffer();
        StringBuffer whereCl = new StringBuffer();
        StringBuffer groupByCl = new StringBuffer();
        StringBuffer havingCl = new StringBuffer();
        StringBuffer orderByCl = new StringBuffer();
        StringBuffer selectExtraIdCl = new StringBuffer();
        StringBuffer selectExtraDateCl = new StringBuffer();

        int whereClBracketCount = 0;
        int havingClBracketCount = 0;
        int whereClCarryoverBrackets = 0;
        int havingClCarryoverBrackets = 0;

        List dsList = getDataSourceList().getDataSource();
        for (Iterator iter = dsList.iterator(); iter.hasNext();) {
            DataSourceType ds = (DataSourceType) iter.next();

            if (fromCl.length() > 0)
                fromCl.append(", ");
            fromCl.append(ds.getTableName());
            fromCl.append(" ");
            fromCl.append(ds.getTableId());

            if (nvl(ds.getRefTableId()).length() > 0) {
                if (whereCl.length() > 0)
                    whereCl.append(" AND ");
                whereCl.append(ds.getRefDefinition());
            } 
            TableSource tableSource = null;
            String dBInfo = this.cr.getDbInfo();
            Vector userRoles = AppUtils.getUserRoles(request);
            tableSource = DataCache.getTableSource(ds.getTableName(), dBInfo, userRoles, userId, request);
            if (userId != null && (!AppUtils.isSuperUser(request))
                    && (!AppUtils.isAdminUser(request)) && tableSource != null
                    && nvl(tableSource.getFilterSql()).length() > 0) {
                if (whereCl.length() > 0)
                    whereCl.append(" AND ");
                whereCl.append(Utils.replaceInString(Utils.replaceInString(tableSource
                        .getFilterSql(), "[" + ds.getTableName() + "]", ds.getTableId()),
                        "[USER_ID]", userId));
            }
        } 

        List reportCols = getAllColumns();

        boolean isGroupStmt = false;
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (dc.isGroupBreak()) {
                isGroupStmt = true;
                break;
            } 
        } 

        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            String colName = getColumnSelectStr(dc, paramValues);

            
            if (dc.isVisible()) {
                if (selectCl.length() > 0)
                    selectCl.append(", ");
                selectCl.append(getSelectExpr(dc, colName));
                selectCl.append(" ");
                selectCl.append(dc.getColId());
             } 


            if (nvl(dc.getDrillDownURL()).length() > 0)
                if (isViewAction(dc.getDrillDownURL()))
                    addExtraIdSelect(selectExtraIdCl, nvl(dc.getDrillDownParams()), true);
                else
                    addExtraDateSelect(selectExtraDateCl, nvl(dc.getDrillDownParams()),
                            paramValues, true);

            if (dc.isGroupBreak()) {
                if (groupByCl.length() > 0)
                    groupByCl.append(", ");
                groupByCl.append(colName);
            } 
            boolean isHavingCl = isGroupStmt && dc.isVisible() && (!dc.isGroupBreak());
            StringBuffer filterCl =
                    isGroupStmt ? (dc.isVisible() ? (dc.isGroupBreak() ? whereCl : havingCl) : whereCl) : whereCl;
            if (dc.getColFilterList() != null) {
                int fNo = 0;
                List fList = dc.getColFilterList().getColFilter();
                for (Iterator iterF = fList.iterator(); iterF.hasNext(); fNo++) {
                    ColFilterType cf = (ColFilterType) iterF.next();

                    StringBuffer curFilter = new StringBuffer();
                    if (filterCl.length() > 0)
                        curFilter.append(" " + cf.getJoinCondition() + " ");
                    if ((isHavingCl ? havingClCarryoverBrackets : whereClCarryoverBrackets) > 0)
                        for (int b = 0; b < (isHavingCl ? havingClCarryoverBrackets
                                : whereClCarryoverBrackets); b++)
                            filterCl.append('(');
                    curFilter.append(nvl(cf.getOpenBrackets()));
                    curFilter.append(colName + " ");
                    curFilter.append(cf.getExpression() + " ");

                    boolean applyFilter = true;
                    if ((nvl(cf.getArgValue()).length() > 0)
                            || (nvl(cf.getArgType()).equals(AppConstants.AT_FORM)))
                        if (nvl(cf.getArgType()).equals(AppConstants.AT_FORMULA))
                            curFilter.append(cf.getArgValue());
                        else if (nvl(cf.getArgType()).equals(AppConstants.AT_VALUE))
                            curFilter.append(formatValue(cf.getArgValue(), dc, false));
                        else if (nvl(cf.getArgType()).equals(AppConstants.AT_LIST))
                            curFilter.append(formatListValue(cf.getArgValue(), dc, false,
                                    false));
                        else if (nvl(cf.getArgType()).equals(AppConstants.AT_COLUMN))
                            curFilter.append(getColumnNameById(cf.getArgValue()));
                        else if (nvl(cf.getArgType()).equals(AppConstants.AT_FORM)) {
                            String fieldName = getFormFieldName(cf);
                            String fieldValue = Utils.oracleSafe(paramValues
                                    .getParamValue(fieldName));
                            boolean isMultiValue = paramValues
                                    .isParameterMultiValue(fieldName);
                            boolean usePipeDelimiterOnly = false;

                            FormFieldType fft = getFormFieldByDisplayValue(cf.getArgValue());
                            if (fft == null)
                                fieldValue = nvl(fieldValue, Utils
                                        .oracleSafe(cf.getArgValue()));
                            else
                                usePipeDelimiterOnly = fft.getFieldType().equals(
                                        FormField.FFT_CHECK_BOX)
                                        || fft.getFieldType().equals(FormField.FFT_LIST_MULTI);

                            if (nvl(fieldValue).length() == 0)
                                applyFilter = false;
                            else if (isMultiValue || "IN".equals(nvl(cf.getExpression()))
                                    || "NOT IN".equals(nvl(cf.getExpression())))
                                curFilter.append(formatListValue(fieldValue, dc, true,
                                        usePipeDelimiterOnly));
                            else
                                curFilter.append(formatValue(fieldValue, dc, true));
                        } 
                    curFilter.append(nvl(cf.getCloseBrackets()));

                    if (applyFilter) {
                        filterCl.append(curFilter.toString());

                        if (isHavingCl) {
                            havingClBracketCount += (nvl(cf.getOpenBrackets()).length() - nvl(
                                    cf.getCloseBrackets()).length());
                            havingClCarryoverBrackets = 0;
                        } else {
                            whereClBracketCount += (nvl(cf.getOpenBrackets()).length() - nvl(
                                    cf.getCloseBrackets()).length());
                            whereClCarryoverBrackets = 0;
                        }
                    } else if (nvl(cf.getOpenBrackets()).length() != nvl(cf.getCloseBrackets())
                            .length())
                        if (nvl(cf.getOpenBrackets()).length() > nvl(cf.getCloseBrackets())
                                .length()) {
                            if (isHavingCl)
                                havingClCarryoverBrackets += (nvl(cf.getOpenBrackets())
                                        .length() - nvl(cf.getCloseBrackets()).length());
                            else
                                whereClCarryoverBrackets += (nvl(cf.getOpenBrackets())
                                        .length() - nvl(cf.getCloseBrackets()).length());

                            if (isHavingCl)
                                havingClBracketCount += (nvl(cf.getOpenBrackets()).length() - nvl(
                                        cf.getCloseBrackets()).length());
                            else
                                whereClBracketCount += (nvl(cf.getOpenBrackets()).length() - nvl(
                                        cf.getCloseBrackets()).length());
                        } else {
                            if (filterCl.length() > 0) {
                                for (int b = 0; b < nvl(cf.getCloseBrackets()).length()
                                        - nvl(cf.getOpenBrackets()).length(); b++)
                                    filterCl.append(')');

                                if (isHavingCl)
                                    havingClBracketCount += (nvl(cf.getOpenBrackets())
                                            .length() - nvl(cf.getCloseBrackets()).length());
                                else
                                    whereClBracketCount += (nvl(cf.getOpenBrackets()).length() - nvl(
                                            cf.getCloseBrackets()).length());
                            } 
                        } 
                }
            } 
        } 

        DataColumnType overrideSortByCol = null;
        if (overrideSortByColId != null)
            overrideSortByCol = getColumnById(overrideSortByColId);

        if (overrideSortByCol != null) {
            orderByCl.append(getColumnSelectStr(overrideSortByCol, paramValues));
            orderByCl.append(" ");
            orderByCl.append(nvl(overrideSortByAscDesc, AppConstants.SO_ASC));
        } else if (getReportType().equals(AppConstants.RT_CROSSTAB)) {
        } else {
            Collections.sort(reportCols, new OrderBySeqComparator());
            for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
                DataColumnType dc = (DataColumnType) iter.next();

                if (dc.getOrderBySeq() > 0) {
                    if (orderByCl.length() > 0)
                        orderByCl.append(", ");
                    orderByCl.append(getColumnSelectStr(dc, paramValues));
                    orderByCl.append(" ");
                    orderByCl.append(dc.getOrderByAscDesc());
                } 
            } 
            Collections.sort(reportCols, new OrderSeqComparator());
        } 


        StringBuffer sql = new StringBuffer();
        sql.append(Globals.getGenerateSqlVisualSelect());
        sql.append((selectCl.length() == 0) ? Globals.getGenerateSqlVisualCount() : selectCl.toString());
        if (groupByCl.length() == 0)
            sql.append(selectExtraIdCl.toString());
        sql.append(selectExtraDateCl.toString());
        sql.append((fromCl.length() == 0) ? Globals.getGenerateSqlVisualDual() : "FROM " + fromCl.toString());
        if (whereCl.length() > 0) {
            if (whereClBracketCount > 0) {
                for (int b = 0; b < whereClBracketCount; b++)
                    whereCl.append(')');
            } else if (whereClBracketCount < 0) {
                for (int b = 0; b < Math.abs(whereClBracketCount); b++)
                    whereCl.insert(0, '(');
            } 

            sql.append(" WHERE ");
            sql.append(whereCl.toString());
        } 
        if (groupByCl.length() > 0) {
            sql.append(" GROUP BY ");
            sql.append(groupByCl.toString());

            if (havingCl.length() > 0) {
                if (havingClBracketCount > 0) {
                    for (int b = 0; b < havingClBracketCount; b++)
                        havingCl.append(')');
                } else if (havingClBracketCount < 0) {
                    for (int b = 0; b < Math.abs(havingClBracketCount); b++)
                        havingCl.insert(0, '(');
                } 
                sql.append(" HAVING ");
                sql.append(havingCl.toString());
            }
        }
        if (orderByCl.length() > 0) {
            sql.append(" ORDER BY ");
            sql.append(orderByCl.toString());
        }

        logger.debug(EELFLoggerDelegate.debugLogger, "Created SQL statement: {}", sql);

        return sql.toString();
    } 

    public String generatePagedSQL(int pageNo, String userId, HttpServletRequest request,
            boolean getColumnNamesFromReportSQL, ReportParamValues paramValues) throws RaptorException {
        int counter = 0;
        if (!Globals.isMySQL())
            counter = 1;
        return generateSubsetSQL(pageNo * getPageSize() + counter, ((pageNo + 1) * getPageSize())
                + ((pageNo == 0) ? 1 : 0), userId, request, getColumnNamesFromReportSQL, paramValues);
	} 

    public String generateSubsetSQL(int startRow, int endRow, String userId, HttpServletRequest request,
            boolean getColumnNamesFromReportSQL, ReportParamValues paramValues) throws RaptorException {
        String dbInfo = getDBInfo();
        String dbType = "";
		String partSql = "";
		String reportSQL = getWholeSQL();
		if (!CachingUtils.isReportSqlExists(request.getSession().getId()+reportSQL)) {
        if (!isNull(dbInfo) && (!dbInfo.equals(AppConstants.DB_LOCAL))) {
            try {
                dbType = remDbInfo.getDBType(dbInfo);
            } catch (Exception ex) {
                throw new RaptorException(ex);
            }
        }
        List reportCols = getAllColumns();
        String wholeSQL_OrderBy = getWholeSQL();
        reportSQL = reportSQL.replace(";", "");
        setWholeSQL(reportSQL);
        if (nvl(reportSQL).length() > 0)
            reportSQL = generateSQL(userId, request);
        if (nvl(reportSQL).toUpperCase().indexOf("ORDER BY ") < 0) {
            StringBuffer sortBy = null;

            if (nvl(reportSQL).toUpperCase().indexOf("GROUP BY ") < 0)
                if (getDataSourceList().getDataSource().size() > 0) {
						DataSourceType dst = (DataSourceType) getDataSourceList().getDataSource().get(0);
                    String tId = dst.getTableId();
                    String tPK = dst.getTablePK();
                    if (nvl(tPK).length() > 0) {
                        sortBy = new StringBuffer();
                        StringTokenizer st = new StringTokenizer(tPK, ", ");
                        while (st.hasMoreTokens()) {
                            if (sortBy.length() > 0)
                                sortBy.append(",");
                            sortBy.append(tId);
                            sortBy.append(".");
                            sortBy.append(st.nextToken());
                    }
						}
					} 
            if (nvl(reportSQL).trim().toUpperCase().startsWith("SELECT")) {

            }
        }
        StringBuffer colNames = new StringBuffer();
        StringBuffer colExtraIdNames = new StringBuffer();
        StringBuffer colExtraDateNames = new StringBuffer();

        if (getColumnNamesFromReportSQL) {
				String getColumnDef = "SELECT * FROM ( "+reportSQL+ ") derivedtable WHERE 1 > 2 ";
				DataSet ds = ConnectionUtils.getDataSet(getColumnDef, dbInfo);
            List reportCols1 = getAllColumns();
            reportCols = new Vector();
            outer: for (Iterator iter = reportCols1.iterator(); iter.hasNext();) {
                DataColumnType dct = (DataColumnType) iter.next();
                for (int k = 0; k < ds.getColumnCount(); k++) {
                    if (dct.getColId().toUpperCase().trim().equals(ds.getColumnName(k).trim())) {
                        reportCols.add(dct);
                        continue outer;
                    }
                }
            }

            if (getFormFieldList() != null) {
                String paramValue = "";
                for (Iterator iter = getFormFieldList().getFormField().iterator(); iter.hasNext();) {
                    FormFieldType fft = (FormFieldType) iter.next();
                    if (fft.isGroupFormField() != null && fft.isGroupFormField().booleanValue()) {
                        paramValue = Utils.oracleSafe(nvl(paramValues
                                .getParamValue(fft.getFieldId())));
                        outer: for (Iterator iter1 = reportCols1.iterator(); iter1.hasNext();) {
                            DataColumnType dct = (DataColumnType) iter1.next();
                            if (("[" + fft.getFieldName() + "]").equals(dct.getColName().trim())) {
                                dct.setDisplayName(paramValue);
                                continue outer;
                            }
                        }

                    }
                }
            }

        }

        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (colNames.length() > 0)
                colNames.append(", ");
            colNames.append(dc.getColId());
            if (nvl(dc.getDrillDownURL()).length() > 0)
                if (isViewAction(dc.getDrillDownURL()))
                    addExtraIdSelect(colExtraIdNames, nvl(dc.getDrillDownParams()), false);
                else
						addExtraDateSelect(colExtraDateNames, nvl(dc.getDrillDownParams()), null, false);
			}

        if (reportSQL.toUpperCase().indexOf("GROUP BY ") < 0)
            colNames.append(colExtraIdNames.toString());

        if ("DAYTONA".equals(dbType) && reportSQL.trim().toUpperCase().startsWith("SELECT")) {
            if (endRow == -1)
					endRow = (getMaxRowsInExcelDownload() > 0) ? getMaxRowsInExcelDownload()
							: Globals.getDownloadLimit();
            reportSQL = reportSQL + " LIMIT TO " + (startRow == 0 ? startRow + 1 : startRow) + "->" + endRow;
            return reportSQL;
        } else if ("DAYTONA".equals(dbType)) {
            return reportSQL;
        }


        String rSQL = Globals.getGenerateSubsetSql();
        rSQL = rSQL.replace("[colNames.toString()]", colNames.toString());
        rSQL = rSQL.replace("[reportSQL]", reportSQL);

        reportSQL = rSQL;

        reportSQLOnlyFirstPart = Globals.getReportSqlOnlyFirstPart();
        reportSQLOnlyFirstPart = reportSQLOnlyFirstPart.replace("[colNames.toString()]", colNames.toString());

        reportSQLWithRowNum = reportSQL;

        String parta = Globals.getReportSqlOnlySecondPartA();
        String partb = Globals.getReportSqlOnlySecondPartB();

        if (!AppUtils.isNotEmpty(getDBType())) {
            setDBType(Globals.getDBType());
        }

        int closeBracketPos = 0;
        if (wholeSQL_OrderBy.lastIndexOf(")") != -1)
            closeBracketPos = wholeSQL_OrderBy.lastIndexOf(")");
        int idxOrderBy = (closeBracketPos > 0) ? wholeSQL_OrderBy.toUpperCase().indexOf("ORDER BY", closeBracketPos)
                : wholeSQL_OrderBy.toUpperCase().lastIndexOf("ORDER BY");
        String orderbyclause = "";
        if (idxOrderBy < 0) {
            orderbyclause = " ORDER BY 1 ";
            partSql += " " + orderbyclause + " ";
        } else {
            orderbyclause = wholeSQL_OrderBy.substring(idxOrderBy);
            partSql += " " + orderbyclause + " ";
        }

			CachingUtils.putPageSql(request.getSession().getId()+getWholeSQL(), partSql);
			CachingUtils.putReportSql(request.getSession().getId()+getWholeSQL(), reportSQL);
		}else {
			if (!AppUtils.isNotEmpty(getDBType())) {
				setDBType(Globals.getDBType());
			}
		}
		if(startRow >= 0 && CachingUtils.isReportSqlExists(request.getSession().getId()+getWholeSQL()) ) {
			partSql = CachingUtils.getPageSql(request.getSession().getId()+getWholeSQL());
			reportSQL = CachingUtils.getReportSql(request.getSession().getId()+getWholeSQL());
			}
		
        if (getDBType().equals(AppConstants.MYSQL)) {
            partSql = partSql + " LIMIT " + String.valueOf(startRow) + " , " + String.valueOf(endRow);
        } else if (getDBType().equals(AppConstants.ORACLE)) {
            partSql = "where rnum >= " + String.valueOf(startRow) + " and rnum <= "
                    + ( Integer.parseInt(String.valueOf(endRow)));
        } else if (getDBType().equals(AppConstants.POSTGRESQL)) {
            partSql = partSql + " LIMIT " + String.valueOf(endRow) + " , " + String.valueOf(startRow);
        }

         
        reportSQL += partSql;

        return reportSQL;

	} 

    public String generateChartSQL(ReportParamValues paramValues, String userId, HttpServletRequest request)
            throws RaptorException {
        List reportCols = getAllColumns();
        List chartValueCols = getChartValueColumnsList(AppConstants.CHART_ALL_COLUMNS, null); 
        String reportSQL = generateSQL(userId, request);
        logger.debug(EELFLoggerDelegate.debugLogger, ("SQL " + reportSQL));
        String legendCol = "1 a";
        StringBuffer groupCol = new StringBuffer();
        StringBuffer seriesCol = new StringBuffer();
        StringBuffer valueCols = new StringBuffer();

        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            String colName = getColumnSelectStr(dc, paramValues);
            if (nvl(dc.getColOnChart()).equals(AppConstants.GC_LEGEND))
                legendCol = getSelectExpr(dc, colName) + " " + dc.getColId();
            if ((!nvl(dc.getColOnChart()).equals(AppConstants.GC_LEGEND))
                    && (dc.getChartSeq() == null || dc.getChartSeq() <= 0) && dc.isGroupBreak()) {
                groupCol.append(", ");
                groupCol.append(colName + " " + dc.getColId());
            }
		} 
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (dc.isChartSeries() != null && dc.isChartSeries().booleanValue()) {
                seriesCol.append(", " + getSelectExpr(dc, getColumnSelectStr(dc, paramValues)) + " " + dc.getColId());
            }
        }


        for (Iterator iter = chartValueCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            String colName = getColumnSelectStr(dc, paramValues);
            seriesCol.append("," + formatChartColumn(colName) + " " + dc.getColId());
		} 

        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            String colName = getColumnSelectStr(dc, paramValues);
            if (colName.equals(AppConstants.RI_CHART_TOTAL_COL))
                seriesCol.append(", " + AppConstants.RI_CHART_TOTAL_COL + " " + AppConstants.RI_CHART_TOTAL_COL);
            if (colName.equals(AppConstants.RI_CHART_COLOR))
                seriesCol.append(", " + AppConstants.RI_CHART_COLOR + " " + AppConstants.RI_CHART_COLOR);
            if (colName.equals(AppConstants.RI_CHART_MARKER_START))
                seriesCol.append(", " + AppConstants.RI_CHART_MARKER_START + " " + AppConstants.RI_CHART_MARKER_START);
            if (colName.equals(AppConstants.RI_CHART_MARKER_END))
                seriesCol.append(", " + AppConstants.RI_CHART_MARKER_END + " " + AppConstants.RI_CHART_MARKER_END);
            if (colName.equals(AppConstants.RI_CHART_MARKER_TEXT_LEFT))
                seriesCol.append(
                        ", " + AppConstants.RI_CHART_MARKER_TEXT_LEFT + " " + AppConstants.RI_CHART_MARKER_TEXT_LEFT);
            if (colName.equals(AppConstants.RI_CHART_MARKER_TEXT_RIGHT))
                seriesCol.append(
                        ", " + AppConstants.RI_CHART_MARKER_TEXT_RIGHT + " " + AppConstants.RI_CHART_MARKER_TEXT_RIGHT);
            if (colName.equals(AppConstants.RI_ANOMALY_TEXT))
                seriesCol.append(", " + AppConstants.RI_ANOMALY_TEXT + " " + AppConstants.RI_ANOMALY_TEXT);
        }


        String final_sql = "";
        reportSQL = Utils.replaceInString(reportSQL, " from ", " FROM ");
        reportSQL = Utils.replaceInString(reportSQL, " select ", " SELECT ");
        reportSQL = Utils.replaceInString(reportSQL, " union ", " UNION ");
        int pos = 0;
        int pos_first_select = 0;
        int pos_dup_select = 0;
        int pos_prev_select = 0;
        int pos_last_select = 0;
        if (reportSQL.indexOf("FROM", pos) != -1) {
            pos = reportSQL.indexOf("FROM", pos);
            pos_dup_select = reportSQL.lastIndexOf("SELECT", pos);
            pos_first_select = reportSQL.indexOf("SELECT");
            logger.debug(EELFLoggerDelegate.debugLogger, ("pos_select " + pos_first_select + " " + pos_dup_select));
            if (pos_dup_select > pos_first_select) {
                logger.debug(EELFLoggerDelegate.debugLogger, ("********pos_dup_select ********" + pos_dup_select));
                pos_prev_select = pos_first_select;
                pos_last_select = pos_dup_select;
                while (pos_last_select > pos_prev_select) {
                    logger.debug(EELFLoggerDelegate.debugLogger,
                            ("pos_last , pos_prev " + pos_last_select + " " + pos_prev_select));
                    pos = reportSQL.indexOf("FROM", pos + 2);
                    pos_prev_select = pos_last_select;
                    pos_last_select = reportSQL.lastIndexOf("SELECT", pos);
                    logger.debug(EELFLoggerDelegate.debugLogger, ("in WHILE LOOP LAST " + pos_last_select));
                }
            }

        }
        final_sql += " " + reportSQL.substring(pos);
        logger.debug(EELFLoggerDelegate.debugLogger, ("Final SQL " + final_sql));
        String sql = "SELECT " + legendCol + ", " + legendCol + "_1" + seriesCol.toString()
                + nvl(valueCols.toString(), ", 1")
                + groupCol.toString()
                + final_sql;
        logger.debug(EELFLoggerDelegate.debugLogger, ("Final sql in generateChartSQL " + sql));

        return sql;
	} 

    private String formatChartColumn(String colName) {

        logger.debug(EELFLoggerDelegate.debugLogger, ("Format Chart Column Input colName" + colName));
        colName = colName.trim();
        colName = Utils.replaceInString(colName, "TO_CHAR", "to_char");
        colName = Utils.replaceInString(colName, "to_number", "TO_NUMBER");
        colName = colName.replaceAll(",[\\s]*\\(", ",(");
        StringBuffer colNameBuf = new StringBuffer(colName);
        int pos = 0;
		int	posFormatStart = 0;
		int	posFormatEnd = 0;
        String format = "";
        if (colNameBuf.indexOf("999") == -1 && colNameBuf.indexOf("990") == -1) {
            logger.debug(EELFLoggerDelegate.debugLogger, (" return colName " + colNameBuf.toString()));
            return colNameBuf.toString();
        }
        while (colNameBuf.indexOf("to_char") != -1) {
            if (colNameBuf.indexOf("999") != -1 || colNameBuf.indexOf("990") != -1) {
                pos = colNameBuf.indexOf("to_char");
                colNameBuf.insert(pos, " TO_NUMBER ( CR_RAPTOR.SAFE_TO_NUMBER (");
                pos = colNameBuf.indexOf("to_char");
                colNameBuf.replace(pos, pos + 7, "TO_CHAR");
                logger.debug(EELFLoggerDelegate.debugLogger, ("After adding to_number " + colNameBuf.toString()));
                posFormatStart = colNameBuf.indexOf(",'", pos) + 1;
                posFormatEnd = colNameBuf.indexOf(")", posFormatStart);
                logger.debug(EELFLoggerDelegate.debugLogger, (posFormatStart + " " + posFormatEnd + " " + pos));
                format = colNameBuf.substring(posFormatStart, posFormatEnd);
                colNameBuf.insert(posFormatEnd + 1, " ," + format + ") , " + format + ")");
                logger.debug(EELFLoggerDelegate.debugLogger, ("colNameBuf " + colNameBuf.toString()));
            }
        }
        logger.debug(EELFLoggerDelegate.debugLogger, (" return colName " + colNameBuf.toString()));
        return colNameBuf.toString();
    }

    public String generateTotalSQLLinear(ReportParamValues paramValues, String userId, HttpServletRequest request)
            throws RaptorException {
        List reportCols = getAllColumns();
        String reportSQL = generateSQL(userId, request);

        StringBuffer sbSelect = new StringBuffer();
        StringBuffer sbTotal = new StringBuffer();
        StringBuffer colNames = new StringBuffer();
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {

            DataColumnType dc = (DataColumnType) iter.next();
            if (colNames.length() > 0)
                colNames.append(", ");
            colNames.append(dc.getColId());
        }
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dct = (DataColumnType) iter.next();

            String colName = getColumnSelectStr(dct, paramValues);

            sbSelect.append((sbSelect.length() == 0) ? "SELECT " : ", ");

            sbSelect.append(colName);
            sbSelect.append(" ");
            sbSelect.append(dct.getColId());

            sbTotal.append((sbTotal.length() == 0) ? "SELECT " : ", ");
            if (nvl(dct.getDisplayTotal()).length() > 0) {
                String displayTotal = dct.getDisplayTotal();
                StringBuffer sb = new StringBuffer();
                for (int i = 0; i < displayTotal.length(); i++) {
                    char ch = displayTotal.charAt(i);
                    if (ch == '+' || ch == '-')
                        sb.append(dct.getColId() + ")");
                    sb.append(ch);
				} 
                sb.append(dct.getColId() + ")");
                sbTotal.append(getSelectExpr(dct, sb.toString()));
            } else
                sbTotal.append("NULL");
            sbTotal.append(" total_");
            sbTotal.append(dct.getColId());
		} 

        logger.debug(EELFLoggerDelegate.debugLogger, ("REPORTWRAPPER " + reportSQL));
        int pos = 0;
        int pos_first_select = 0;
        int pos_dup_select = 0;
        int pos_prev_select = 0;
        int pos_last_select = 0;
        reportSQL = replaceNewLine(reportSQL, " from ", " FROM ");
        reportSQL = replaceNewLine(reportSQL, "from ", " FROM ");
        reportSQL = replaceNewLine(reportSQL, "FROM ", " FROM ");

        reportSQL = " " + reportSQL;
        reportSQL = replaceNewLine(reportSQL, "select ", " SELECT ");
        reportSQL = replaceNewLine(reportSQL, "SELECT ", " SELECT ");
        if (reportSQL.indexOf("FROM", pos) != -1) {
            pos = reportSQL.indexOf("FROM", pos);
            pos_dup_select = reportSQL.lastIndexOf("SELECT", pos);
            pos_first_select = reportSQL.indexOf("SELECT");
            logger.debug(EELFLoggerDelegate.debugLogger, ("pos_select " + pos_first_select + " " + pos_dup_select));
            if (pos_dup_select > pos_first_select) {
                logger.debug(EELFLoggerDelegate.debugLogger, ("********pos_dup_select ********" + pos_dup_select));
                pos_prev_select = pos_first_select;
                pos_last_select = pos_dup_select;
                while (pos_last_select > pos_prev_select) {
                    logger.debug(EELFLoggerDelegate.debugLogger,
                            ("pos_last , pos_prev " + pos_last_select + " " + pos_prev_select));
                    pos = reportSQL.indexOf("FROM", pos + 2);
                    pos_prev_select = pos_last_select;
                    pos_last_select = reportSQL.lastIndexOf("SELECT", pos);
                    logger.debug(EELFLoggerDelegate.debugLogger, ("in WHILE LOOP LAST " + pos_last_select));
                }
            }

        }

        logger.debug(EELFLoggerDelegate.debugLogger, (" *************** " + pos + " " + reportSQL));
        sbSelect.append(" " + reportSQL.substring(pos));
        logger.debug(EELFLoggerDelegate.debugLogger, (" **************** " + sbSelect.toString()));
        sbTotal.append(" FROM (");
        sbTotal.append(sbSelect.toString());
        sbTotal.append(") totalSQL");

        String dbType = "";
        String dbInfo = getDBInfo();
        if (!isNull(dbInfo) && (!dbInfo.equals(AppConstants.DB_LOCAL))) {
            try {
                dbType = remDbInfo.getDBType(dbInfo);
            } catch (Exception ex) {
                throw new RaptorException(ex);
            }
        }
        if ("DAYTONA".equals(dbType)) {
            sbTotal.append("(" + colNames + ")");
        }
        String sql = sbTotal.toString();
        sql = Utils.replaceInString(sql, " from ", " FROM ");
        sql = Utils.replaceInString(sql, "select ", "SELECT ");
        logger.debug(EELFLoggerDelegate.debugLogger, ("Before SQL Corrector " + sql));
        String corrected_SQL = new SQLCorrector().fixSQL(new StringBuffer(sql));
        logger.debug(EELFLoggerDelegate.debugLogger, ("************"));
        logger.debug(EELFLoggerDelegate.debugLogger, ("Corrected SQL " + corrected_SQL));
        return corrected_SQL;
	} 

    public String generateTotalSQLCrossTab(String sql, String rowColPos,
            String userId, HttpServletRequest request, ReportParamValues paramValues) throws RaptorException {
        List reportCols = getAllColumns();
        String reportSQL = sql;

        StringBuffer sbSelect = new StringBuffer();
        StringBuffer sbGroup = new StringBuffer();
        StringBuffer sbTotal = new StringBuffer();
        StringBuffer colNames = new StringBuffer();
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {

            DataColumnType dc = (DataColumnType) iter.next();
            if (colNames.length() > 0)
                colNames.append(", ");
            colNames.append(dc.getColId());
        }
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dct = (DataColumnType) iter.next();

            if (!dct.isVisible())
                continue;

            String colName = getColumnSelectStr(dct, paramValues);
            String colExpr = getSelectExpr(dct, colName);

            sbSelect.append((sbSelect.length() == 0) ? "SELECT " : ", ");

            if (nvl(dct.getCrossTabValue()).equals(rowColPos)) {
                sbSelect.append(dct.getColId());
                sbGroup.append((sbGroup.length() == 0) ? " GROUP BY " : ", ");
                sbGroup.append(dct.getColId());

                sbTotal.append((sbTotal.length() == 0) ? "SELECT " : ", ");
                sbTotal.append(dct.getColId());
            } else if (nvl(dct.getCrossTabValue()).equals(AppConstants.CV_VALUE)) {
				
                sbSelect.append(dct.getColId());

                String displayTotal = getCrossTabDisplayTotal(rowColPos);
                if (displayTotal.length() > 0) {
					
                    StringBuffer sb = new StringBuffer();
                    for (int i = 0; i < displayTotal.length(); i++) {
                        char ch = displayTotal.charAt(i);
                        if (ch == '+' || ch == '-')
                            sb.append(dct.getColId() + ")");
                        sb.append(ch);
					} 
                    sb.append(dct.getColId() + ")");

                    displayTotal = sb.toString();
                } else
                    displayTotal = "COUNT(*)";

                sbTotal.append((sbTotal.length() == 0) ? "SELECT " : ", ");
                sbTotal.append(getSelectExpr(dct, displayTotal));
                sbTotal.append(" total_");
                sbTotal.append(dct.getColId());
            } else {
				
                sbSelect.append(dct.getColId());
			} 

            sbSelect.append(" ");
            sbSelect.append(dct.getColId());
		} 

        sbSelect.append(reportSQL.substring(reportSQL.toUpperCase().indexOf(" FROM ")));

        sbTotal.append(" FROM (");
        sbTotal.append(sbSelect.toString());
        sbTotal.append(") totalSQL");
        sbTotal.append(sbGroup.toString());
        String dbType = "";
        String dbInfo = getDBInfo();
        if (!isNull(dbInfo) && (!dbInfo.equals(AppConstants.DB_LOCAL))) {
            try {
                dbType = remDbInfo.getDBType(dbInfo);
            } catch (Exception ex) {
                throw new RaptorException(ex);
            }
        }
        if ("DAYTONA".equals(dbType)) {
            sbTotal.append("(" + colNames + ")");
        }

        sql = "";
        if (getReportDefType().equals(AppConstants.RD_SQL_BASED)) {
            sql = Utils.replaceInString(sbTotal.toString(), " from ", " FROM ");
            sql = Utils.replaceInString(sql, "select ", "SELECT ");
            return new SQLCorrector().fixSQL(new StringBuffer(sql));
        }

        return sbTotal.toString();

	} 

    public String generateTotalSQLCrossTab(ReportParamValues paramValues, String rowColPos,
            String userId, HttpServletRequest request) throws RaptorException {
        List reportCols = getAllColumns();
        String reportSQL = generateSQL(userId, request);

        StringBuffer sbSelect = new StringBuffer();
        StringBuffer sbGroup = new StringBuffer();
        StringBuffer sbTotal = new StringBuffer();
        StringBuffer colNames = new StringBuffer();
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {

            DataColumnType dc = (DataColumnType) iter.next();
            if (colNames.length() > 0)
                colNames.append(", ");
            colNames.append(dc.getColId());
        }
        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dct = (DataColumnType) iter.next();

            if (!dct.isVisible())
                continue;

            String colName = getColumnSelectStr(dct, paramValues);
            String colExpr = getSelectExpr(dct, colName);

            sbSelect.append((sbSelect.length() == 0) ? "SELECT " : ", ");

            if (nvl(dct.getCrossTabValue()).equals(rowColPos)) {
                sbSelect.append(colExpr);

                sbGroup.append((sbGroup.length() == 0) ? " GROUP BY " : ", ");
                sbGroup.append(dct.getColId());

                sbTotal.append((sbTotal.length() == 0) ? "SELECT " : ", ");
                sbTotal.append(dct.getColId());
            } else if (nvl(dct.getCrossTabValue()).equals(AppConstants.CV_VALUE)) {
                sbSelect.append(colName);

                String displayTotal = getCrossTabDisplayTotal(rowColPos);
                if (displayTotal.length() > 0) {
                    StringBuffer sb = new StringBuffer();
                    for (int i = 0; i < displayTotal.length(); i++) {
                        char ch = displayTotal.charAt(i);
                        if (ch == '+' || ch == '-')
                            sb.append(dct.getColId() + ")");
                        sb.append(ch);
					} 
                    sb.append(dct.getColId() + ")");

                    displayTotal = sb.toString();
                } else
                    displayTotal = "COUNT(*)";

                sbTotal.append((sbTotal.length() == 0) ? "SELECT " : ", ");
                sbTotal.append(getSelectExpr(dct, displayTotal));
                sbTotal.append(" total_");
                sbTotal.append(dct.getColId());
            } else {
                sbSelect.append(colExpr);
			}

            sbSelect.append(" ");
            sbSelect.append(dct.getColId());
		}

        sbSelect.append(reportSQL.substring(reportSQL.toUpperCase().indexOf(" FROM ")));

        sbTotal.append(" FROM (");
        sbTotal.append(sbSelect.toString());
        sbTotal.append(") totalSQL");
        sbTotal.append(sbGroup.toString());
        String dbType = "";
        String dbInfo = getDBInfo();
        if (!isNull(dbInfo) && (!dbInfo.equals(AppConstants.DB_LOCAL))) {
            try {
                dbType = remDbInfo.getDBType(dbInfo);
            } catch (Exception ex) {
                throw new RaptorException(ex);
            }
        }
        if ("DAYTONA".equals(dbType)) {
            sbTotal.append("(" + colNames + ")");
        }

        String sql = "";
        if (getReportDefType().equals(AppConstants.RD_SQL_BASED)) {
            sql = Utils.replaceInString(sbTotal.toString(), " from ", " FROM ");
            sql = Utils.replaceInString(sql, "select ", "SELECT ");
            return new SQLCorrector().fixSQL(new StringBuffer(sql));
        }

        return sbTotal.toString();

	} 

    public String generateDistinctValuesSQL(ReportParamValues paramValues, DataColumnType dct,
            String userId, HttpServletRequest request) throws RaptorException {
        DataSourceType dst = getColumnTableById(dct.getColId());
        String colName = getColumnSelectStr(dct, paramValues);
        String colExpr = getSelectExpr(dct, colName);
        ReportRuntime rr = (ReportRuntime) request.getSession().getAttribute(AppConstants.SI_REPORT_RUNTIME);
        StringBuffer sb = new StringBuffer();
        sb.append("SELECT DISTINCT ");
        if (getReportDefType().equals(AppConstants.RD_SQL_BASED)) {
            sb.append(dct.getColId());
            sb.append(" FROM (");
            sb.append(rr.getWholeSQL());
            sb.append(") " + (Globals.isPostgreSQL() || Globals.isMySQL() ? " AS " : "") + " report_sql ORDER BY 1");
        } else {
            sb.append(colExpr);
            sb.append(" ");
            sb.append(dct.getColId());
            if (!colExpr.equals(colName)) {
                sb.append(", ");
                sb.append(colName);
			} 
            sb.append(" FROM ");
            sb.append(dst.getTableName());
            sb.append(" ");
            sb.append(dst.getTableId());
            sb.append(" ORDER BY ");
            sb.append(colName);
            if (dct.getColType().equals(AppConstants.CT_DATE))
                sb.append(" DESC");
		} 

        return sb.toString();
	} 

    public DataSourceType getTableWithoutColumns() {
        List dsList = getDataSourceList().getDataSource();
        for (Iterator iter = dsList.iterator(); iter.hasNext();) {
            DataSourceType ds = (DataSourceType) iter.next();

            if (ds.getDataColumnList().getDataColumn().isEmpty())
                return ds;
		} 

        return null;
	} 

    public CustomReportType cloneCustomReportClearTables() throws RaptorException {
        ReportWrapper nrw = new ReportWrapper(cloneCustomReport(), reportID, getOwnerID(),
                getCreateID(), getCreateDate(), getUpdateID(), getUpdateDate(), getMenuID(),
                isMenuApproved());

        DataSourceType ndst = null;
        while ((ndst = nrw.getTableWithoutColumns()) != null)
            nrw.deleteDataSourceType(ndst.getTableId());

        return nrw.getCustomReport();
	} 

    public String marshal() throws RaptorException {
        StringWriter sw = new StringWriter();
        ObjectFactory objFactory = new ObjectFactory();

        try {
            JAXBContext jc = JAXBContext.newInstance("org.onap.portalsdk.analytics.xmlobj");
            Marshaller m = jc.createMarshaller();
            m.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT, Boolean.TRUE);
            m.marshal(
                    (getTableWithoutColumns() == null) ? objFactory.createCustomReport(cr)
                            : objFactory.createCustomReport(cloneCustomReportClearTables()),
                    new StreamResult(sw));
        } catch (JAXBException ex) {
            logger.error(EELFLoggerDelegate.debugLogger, "Exception occured in marshal ", ex);
            throw new RaptorException(ex.getMessage(), ex.getCause());
        }
        return sw.toString();
	}

    public static CustomReportType unmarshalCR(String reportXML) throws RaptorException {
        try {
            JAXBContext jc = JAXBContext.newInstance("org.onap.portalsdk.analytics.xmlobj");
            Unmarshaller u = jc.createUnmarshaller();
            javax.xml.bind.JAXBElement<CustomReportType> doc =
                    (javax.xml.bind.JAXBElement<CustomReportType>) u.unmarshal(new java.io.StringReader(
                            reportXML));
            return doc.getValue();
        } catch (JAXBException ex) {
            logger.error(EELFLoggerDelegate.debugLogger, "Exception occured in unmarshalCR ", ex);
            throw new RaptorException(ex.getMessage(), ex.getCause());
        }


	} 

    protected static CustomReportType createBlankCR() throws RaptorException {
        return createBlankCR("N/A");
	}
    protected static CustomReportType createBlankCR(String createID) throws RaptorException {
        ObjectFactory objFactory = new ObjectFactory();
        CustomReportType cr = objFactory.createCustomReportType();
        try {
            cr.setReportName("");
            cr.setReportDescr("");
            cr.setChartType("");
            cr.setPublic(false);
            cr.setCreateId(createID);
            cr.setCreateDate(DatatypeFactory.newInstance().newXMLGregorianCalendar(new GregorianCalendar()));
            cr.setReportType("");
            cr.setPageSize(50);

            DataSourceList dataSourceList = objFactory.createDataSourceList();
            cr.setDataSourceList(dataSourceList);
        } catch (DatatypeConfigurationException ex) {
            logger.error(EELFLoggerDelegate.debugLogger, "Exception occured in createBlankCR ", ex);
            throw new RaptorException(ex.getMessage(), ex.getCause());
        }
        return cr;
	} 

    protected void replaceCustomReportWithClone() throws RaptorException {
        try {
            CustomReportType clone = cloneCustomReport();
            this.cr = clone;
        } catch (Exception e) {
            logger.debug(EELFLoggerDelegate.debugLogger,
                    ("[SYSTEM ERROR] ReportWrapper.replaceCustomReportWithClone generated exception for report ["
                            + reportID + "]. Exception: "),
                    e);
            throw new RaptorException(
                    "[SYSTEM ERROR] ReportWrapper.replaceCustomReportWithClone generated exception for report ["
                            + reportID + "]. Exception: " + e.getMessage(),
                    e.getCause());
        }
	}

    public FormatType cloneFormatType(ObjectFactory objFactory, FormatType ft)
            throws JAXBException {
        FormatType nft = objFactory.createFormatType();

        nft.setLessThanValue(ft.getLessThanValue());
        nft.setExpression(ft.getExpression());
        nft.setBold(ft.isBold());
        nft.setItalic(ft.isItalic());
        nft.setUnderline(ft.isUnderline());
        if (nvl(ft.getBgColor()).length() > 0)
            nft.setBgColor(ft.getBgColor());
        if (nvl(ft.getFontColor()).length() > 0)
            nft.setFontColor(ft.getFontColor());
        if (nvl(ft.getFontFace()).length() > 0)
            nft.setFontFace(ft.getFontFace());
        if (nvl(ft.getFontSize()).length() > 0)
            nft.setFontSize(ft.getFontSize());
        if (nvl(ft.getAlignment()).length() > 0)
            nft.setAlignment(ft.getAlignment());
        if (nvl(ft.getComment()).length() > 0)
            nft.setComment(ft.getComment());

        nft.setFormatId(ft.getFormatId());

        return nft;
	} 

    public SemaphoreType cloneSemaphoreType(ObjectFactory objFactory, SemaphoreType st)
            throws JAXBException {
        SemaphoreType nst = objFactory.createSemaphoreType();

        nst.setSemaphoreName(st.getSemaphoreName());
        nst.setSemaphoreType(st.getSemaphoreType());
        nst.setSemaphoreId(st.getSemaphoreId());
        if (nvl(st.getComment()).length() > 0)
            nst.setComment(st.getComment());

        if (st.getFormatList() != null) {
            FormatList formatList = objFactory.createFormatList();
            nst.setFormatList(formatList);

            for (Iterator iter = st.getFormatList().getFormat().iterator(); iter.hasNext();)
                formatList.getFormat().add(
                        cloneFormatType(objFactory, (FormatType) iter.next()));
        } // if

        return nst;
	}

    public Reports cloneDashboardType(ObjectFactory objFactory, Reports rpt)
            throws JAXBException {
        Reports nrpt = objFactory.createReports();

        nrpt.setReportId(rpt.getReportId());
        nrpt.setBgcolor(rpt.getBgcolor());
        return nrpt;
		} 

    public Marker cloneMarkerType(ObjectFactory objFactory, Marker marker)
            throws JAXBException {
        Marker nMarker = objFactory.createMarker();
        nMarker.setAddressColumn(marker.getAddressColumn());
        nMarker.setDataColumn(marker.getDataColumn());
        nMarker.setDataHeader(marker.getDataHeader());
        nMarker.setMarkerColor(marker.getMarkerColor());
        return nMarker;
		}

    public ChartDrillFormfield cloneChartDrillFormfield(ObjectFactory objFactory,
            ChartDrillFormfield chartDrillFormfield)
            throws JAXBException {
        ChartDrillFormfield nChartDrillFormfield = objFactory.createChartDrillFormfield();
        nChartDrillFormfield.setFormfield(chartDrillFormfield.getFormfield());
        return nChartDrillFormfield;
		} 

    public boolean isChartDrillDownContainsName(String name) {
        for (Iterator iter = getChartDrillOptions().getTargetFormfield().iterator(); iter
                .hasNext();) {
            org.onap.portalsdk.analytics.xmlobj.ChartDrillFormfield cdf =
                    (org.onap.portalsdk.analytics.xmlobj.ChartDrillFormfield) iter.next();
            if (cdf.getFormfield().equals(name)) {
                return true;
            }
        }
        return false;
    }

    public FormFieldType cloneFormFieldType(ObjectFactory objFactory, FormFieldType fft)
            throws JAXBException {
        FormFieldType nfft = objFactory.createFormFieldType();

        nfft.setColId(fft.getColId());
        nfft.setFieldName(fft.getFieldName());
        nfft.setFieldType(fft.getFieldType());
        if (nvl(fft.getVisible()).length() > 0)
            nfft.setVisible(fft.getVisible());
		if (nvl(fft.getValidationType()).length() > 0 || (fft.getValidationType() != null && fft.getValidationType().isEmpty()))
            nfft.setValidationType(fft.getValidationType());
        if (nvl(fft.getMandatory()).length() > 0)
            nfft.setMandatory(fft.getMandatory());
		if (nvl(fft.getDefaultValue()).length() > 0 || (fft.getDefaultValue() != null && fft.getDefaultValue().isEmpty()))
            nfft.setDefaultValue(fft.getDefaultValue());
        nfft.setOrderBySeq(fft.getOrderBySeq());
		if (nvl(fft.getFieldSQL()).length() > 0  || (fft.getFieldSQL()  != null && fft.getFieldSQL().isEmpty()))
            nfft.setFieldSQL(fft.getFieldSQL());
		if (nvl(fft.getFieldDefaultSQL()).length() > 0 || (fft.getFieldDefaultSQL()  != null && fft.getFieldDefaultSQL().isEmpty()))
            nfft.setFieldDefaultSQL(fft.getFieldDefaultSQL());
        if (fft.getRangeStartDate() != null)
            nfft.setRangeStartDate(fft.getRangeStartDate());
        if (fft.getRangeEndDate() != null)
            nfft.setRangeEndDate(fft.getRangeEndDate());
        if (fft.getRangeStartDateSQL() != null)
            nfft.setRangeStartDateSQL(fft.getRangeStartDateSQL());
        if (fft.getRangeEndDateSQL() != null)
            nfft.setRangeEndDateSQL(fft.getRangeEndDateSQL());

        if (nvl(fft.getComment()).length() > 0)
            nfft.setComment(fft.getComment());

        if (fft.getPredefinedValueList() != null) {
            PredefinedValueList predefinedValueList = objFactory.createPredefinedValueList();
            nfft.setPredefinedValueList(predefinedValueList);

            for (Iterator iter = fft.getPredefinedValueList().getPredefinedValue().iterator(); iter
                    .hasNext();)
                predefinedValueList.getPredefinedValue().add(new String((String) iter.next()));
		}
        if (nvl(fft.getDependsOn()).length() > 0)
            nfft.setDependsOn(fft.getDependsOn());

        nfft.setGroupFormField(
                (fft.isGroupFormField() != null && fft.isGroupFormField().booleanValue()) ? true : false);
        if (nvl(fft.getMultiSelectListSize()).length() > 0)
            nfft.setMultiSelectListSize(fft.getMultiSelectListSize());

        nfft.setFieldId(fft.getFieldId());
        return nfft;
	} 

    public JavascriptItemType cloneJavascriptType(ObjectFactory objFactory, JavascriptItemType jit)
            throws JAXBException {
        JavascriptItemType njit = objFactory.createJavascriptItemType();

        njit.setId(jit.getId());
        njit.setFieldId(jit.getFieldId());
        njit.setCallText(jit.getCallText());
        return njit;
	} 

    public ColFilterType cloneColFilterType(ObjectFactory objFactory, ColFilterType cft)
            throws JAXBException {
        ColFilterType ncft = objFactory.createColFilterType();

        ncft.setColId(cft.getColId());
        ncft.setFilterSeq(cft.getFilterSeq());
        ncft.setJoinCondition(cft.getJoinCondition());
        if (nvl(cft.getOpenBrackets()).length() > 0)
            ncft.setOpenBrackets(cft.getOpenBrackets());
        ncft.setExpression(cft.getExpression());
        if (nvl(cft.getArgType()).length() > 0)
            ncft.setArgType(cft.getArgType());
        if (nvl(cft.getArgValue()).length() > 0)
            ncft.setArgValue(cft.getArgValue());
        if (nvl(cft.getCloseBrackets()).length() > 0)
            ncft.setCloseBrackets(cft.getCloseBrackets());
        if (nvl(cft.getComment()).length() > 0)
            ncft.setComment(cft.getComment());

        return ncft;
	} 

    public DataColumnType cloneDataColumnType(ObjectFactory objFactory, DataColumnType dct)
            throws JAXBException {
        DataColumnType ndct = objFactory.createDataColumnType();

        ndct.setTableId(dct.getTableId());
        ndct.setDbColName(dct.getDbColName());
        if (nvl(dct.getCrossTabValue()).length() > 0)
            ndct.setCrossTabValue(dct.getCrossTabValue());
        ndct.setColName(dct.getColName());
        ndct.setDisplayName(dct.getDisplayName());
        if (dct.getDisplayWidth() > 0)
            ndct.setDisplayWidth(dct.getDisplayWidth());
        if (nvl(dct.getDisplayWidthInPxls()).length() > 0)
            ndct.setDisplayWidthInPxls(dct.getDisplayWidthInPxls());
        if (nvl(dct.getDisplayAlignment()).length() > 0)
            ndct.setDisplayAlignment(dct.getDisplayAlignment());
        if (nvl(dct.getDisplayHeaderAlignment()).length() > 0)
            ndct.setDisplayHeaderAlignment(dct.getDisplayHeaderAlignment());
        ndct.setOrderSeq(dct.getOrderSeq());
        ndct.setVisible(dct.isVisible());
        ndct.setCalculated(dct.isCalculated());
        ndct.setColType(dct.getColType());
        if (dct.getColType().equals(AppConstants.CT_HYPERLINK)) {
            ndct.setHyperlinkURL(dct.getHyperlinkURL());
            ndct.setHyperlinkType(dct.getHyperlinkType());
            if ("IMAGE".equals(dct.getHyperlinkType())) {
                ndct.setActionImg(dct.getActionImg());
            }
        }

        if (dct.getIndentation() != null) {
            ndct.setIndentation(dct.getIndentation());
        }

        if (nvl(dct.getColFormat()).length() > 0)
            ndct.setColFormat(dct.getColFormat());
        ndct.setGroupBreak(dct.isGroupBreak());
        ndct.setNowrap(dct.getNowrap());
        if (nvl(dct.getYAxis()).length() > 0)
            ndct.setYAxis(dct.getYAxis());
        if (dct.getOrderBySeq() != null && dct.getOrderBySeq() > 0)
            ndct.setOrderBySeq(dct.getOrderBySeq());
        if (nvl(dct.getOrderByAscDesc()).length() > 0)
            ndct.setOrderByAscDesc(dct.getOrderByAscDesc());
        if (nvl(dct.getDisplayTotal()).length() > 0)
            ndct.setDisplayTotal(dct.getDisplayTotal());
        if (nvl(dct.getColOnChart()).length() > 0)
            ndct.setColOnChart(dct.getColOnChart());
        if (dct.getChartSeq() != null)
            ndct.setChartSeq(dct.getChartSeq());
        if (nvl(dct.getChartColor()).length() > 0)
            ndct.setChartColor(dct.getChartColor());
        if (nvl(dct.getChartLineType()).length() > 0)
            ndct.setChartLineType(dct.getChartLineType());
        ndct.setChartSeries((dct.isChartSeries() != null && dct.isChartSeries().booleanValue()) ? true : false);
        ndct.setIsRangeAxisFilled(
                (dct.isIsRangeAxisFilled() != null && dct.isIsRangeAxisFilled().booleanValue()) ? true : false);

        if (dct.isCreateInNewChart() != null)
            ndct.setCreateInNewChart(dct.isCreateInNewChart());
        if (nvl(dct.getDrillDownType()).length() > 0)
            ndct.setDrillDownType(dct.getDrillDownType());
        ndct.setDrillinPoPUp(dct.isDrillinPoPUp() != null ? dct.isDrillinPoPUp() : false);
        if (nvl(dct.getDrillDownURL()).length() > 0)
            ndct.setDrillDownURL(dct.getDrillDownURL());
        if (nvl(dct.getDrillDownParams()).length() > 0)
            ndct.setDrillDownParams(dct.getDrillDownParams());
        if (nvl(dct.getComment()).length() > 0)
            ndct.setComment(dct.getComment());
        if (nvl(dct.getDependsOnFormField()).length() > 0)
            ndct.setDependsOnFormField(dct.getDependsOnFormField());
        if (dct.getColFilterList() != null) {
            ColFilterList colFilterList = objFactory.createColFilterList();
            ndct.setColFilterList(colFilterList);

            for (Iterator iter = dct.getColFilterList().getColFilter().iterator(); iter
                    .hasNext();)
                colFilterList.getColFilter().add(
                        cloneColFilterType(objFactory, (ColFilterType) iter.next()));
		}

        if (nvl(dct.getSemaphoreId()).length() > 0)
            ndct.setSemaphoreId(dct.getSemaphoreId());
        if (nvl(dct.getDbColType()).length() > 0)
            ndct.setDbColType(dct.getDbColType());
        else {
            ndct.setDbColType(dct.getColType());
            adjustColumnType(ndct);
        }
        if (nvl(dct.getChartGroup()).length() > 0)
            ndct.setChartGroup(dct.getChartGroup());

        if (nvl(dct.getYAxis()).length() > 0)
            ndct.setYAxis(dct.getYAxis());

        if (nvl(dct.getDependsOnFormField()).length() > 0)
            ndct.setDependsOnFormField(dct.getDependsOnFormField());

        if (nvl(dct.getNowrap()).length() > 0)
            ndct.setNowrap(dct.getNowrap());

        if (dct.getIndentation() != null) {
            ndct.setIndentation(dct.getIndentation());
        }

        ndct.setEnhancedPagination(
                (dct.isEnhancedPagination() != null && dct.isEnhancedPagination().booleanValue()) ? true : false);
        if (nvl(dct.getDataMiningCol()).length() > 0)
            ndct.setDataMiningCol(dct.getDataMiningCol());

        ndct.setColId(dct.getColId());

        return ndct;
	} 

    public DataSourceType cloneDataSourceType(ObjectFactory objFactory, DataSourceType dst)
            throws JAXBException {
        DataSourceType ndst = objFactory.createDataSourceType();

        ndst.setTableName(dst.getTableName());
        ndst.setTablePK(dst.getTablePK());
        ndst.setDisplayName(dst.getDisplayName());
        if (nvl(dst.getRefTableId()).length() > 0)
            ndst.setRefTableId(dst.getRefTableId());
        if (nvl(dst.getRefDefinition()).length() > 0)
            ndst.setRefDefinition(dst.getRefDefinition());
        if (nvl(dst.getComment()).length() > 0)
            ndst.setComment(dst.getComment());
        DataColumnList dataColumnList = objFactory.createDataColumnList();
        ndst.setDataColumnList(dataColumnList);

        for (Iterator iter = dst.getDataColumnList().getDataColumn().iterator(); iter
                .hasNext();)
            dataColumnList.getDataColumn().add(
                    cloneDataColumnType(objFactory, (DataColumnType) iter.next()));
        ndst.setTableId(dst.getTableId());

        return ndst;
	} 

    public CustomReportType cloneCustomReport() throws RaptorException {
        ObjectFactory objFactory = new ObjectFactory();
        CustomReportType ncr = objFactory.createCustomReportType();
        try {
            ncr.setReportName(cr.getReportName());
            ncr.setReportDescr(cr.getReportDescr());
            if (nvl(cr.getNumDashCols()).length() > 0)
                ncr.setNumDashCols(cr.getNumDashCols());
            if (nvl(cr.getDashboardLayoutHTML()).length() > 0)
                ncr.setDashboardLayoutHTML(cr.getDashboardLayoutHTML());
			if (nvl(cr.getDashboardLayoutJSON()).length() > 0)
				ncr.setDashboardLayoutJSON(cr.getDashboardLayoutJSON());			
            if (nvl(cr.getDbInfo()).length() > 0)
                ncr.setDbInfo(cr.getDbInfo());
            ncr.setChartType(cr.getChartType());
            if (nvl(cr.getChartTypeFixed()).length() > 0)
                ncr.setChartTypeFixed(cr.getChartTypeFixed());
            if (nvl(cr.getChartMultiSeries()).length() > 0)
                ncr.setChartMultiSeries(cr.getChartMultiSeries());
            if (nvl(cr.getChartLeftAxisLabel()).length() > 0)
                ncr.setChartLeftAxisLabel(cr.getChartLeftAxisLabel());
            if (nvl(cr.getChartRightAxisLabel()).length() > 0)
                ncr.setChartRightAxisLabel(cr.getChartRightAxisLabel());
            if (nvl(cr.getChartWidth()).length() > 0)
                ncr.setChartWidth(cr.getChartWidth());
            if (nvl(cr.getChartHeight()).length() > 0)
                ncr.setChartHeight(cr.getChartHeight());
            ncr.setShowChartTitle(cr.isShowChartTitle());
            ncr.setPublic(cr.isPublic());
            ncr.setHideFormFieldAfterRun(cr.isHideFormFieldAfterRun());
            ncr.setCreateId(cr.getCreateId());
            ncr.setCreateDate(cr.getCreateDate());
            if (nvl(cr.getReportSQL()).length() > 0)
                ncr.setReportSQL(cr.getReportSQL());
            if (nvl(cr.getReportTitle()).length() > 0)
                ncr.setReportTitle(cr.getReportTitle());
            if (nvl(cr.getReportSubTitle()).length() > 0)
                ncr.setReportSubTitle(cr.getReportSubTitle());
            if (nvl(cr.getReportHeader()).length() > 0)
                ncr.setReportHeader(cr.getReportHeader());
            if (cr.getFrozenColumns() != null)
                ncr.setFrozenColumns(cr.getFrozenColumns());
            if (nvl(cr.getPdfImgLogo()).length() > 0)
                ncr.setPdfImgLogo(cr.getPdfImgLogo());
            if (nvl(cr.getEmptyMessage()).length() > 0)
                ncr.setEmptyMessage(cr.getEmptyMessage());
            if (nvl(cr.getWidthNoColumn()).length() > 0)
                ncr.setWidthNoColumn(cr.getWidthNoColumn());
            if (nvl(cr.getDataGridAlign()).length() > 0)
                ncr.setDataGridAlign(cr.getDataGridAlign());
                ncr.setReportFooter(cr.getReportFooter());
                ncr.setNumFormCols(cr.getNumFormCols());
                ncr.setDisplayOptions(cr.getDisplayOptions());
                ncr.setDataContainerHeight(cr.getDataContainerHeight());
                ncr.setDataContainerWidth(cr.getDataContainerWidth());
                ncr.setAllowSchedule(cr.getAllowSchedule());
                ncr.setTopDown(cr.getTopDown());
                ncr.setSizedByContent(cr.getSizedByContent());
                ncr.setComment(cr.getComment());
                ncr.setDashboardOptions(cr.getDashboardOptions());
                ncr.setDashboardType(cr.isDashboardType());
                ncr.setReportInNewWindow(cr.isReportInNewWindow());
            ncr.setDisplayFolderTree(cr.isDisplayFolderTree());
            if (cr.getDashBoardReports() == null) {
                if (cr.getMaxRowsInExcelDownload() != null && cr.getMaxRowsInExcelDownload() > 0)
                    ncr.setMaxRowsInExcelDownload(cr.getMaxRowsInExcelDownload());
            }

            if (nvl(cr.getJavascriptElement()).length() > 0)
                ncr.setJavascriptElement(cr.getJavascriptElement());
            if (nvl(cr.getFolderId()).length() > 0)
                ncr.setFolderId(cr.getFolderId());
            ncr.setDrillURLInPoPUpPresent(
                    (cr.isDrillURLInPoPUpPresent() != null && cr.isDrillURLInPoPUpPresent().booleanValue()) ? true
                            : false);
                ncr.setIsOneTimeScheduleAllowed(cr.getIsOneTimeScheduleAllowed());
                ncr.setIsHourlyScheduleAllowed(cr.getIsHourlyScheduleAllowed());
                ncr.setIsDailyScheduleAllowed(cr.getIsDailyScheduleAllowed());
                ncr.setIsDailyMFScheduleAllowed(cr.getIsDailyMFScheduleAllowed());
                ncr.setIsWeeklyScheduleAllowed(cr.getIsWeeklyScheduleAllowed());
                ncr.setIsMonthlyScheduleAllowed(cr.getIsMonthlyScheduleAllowed());

            ncr.setPageSize(cr.getPageSize());
            ncr.setReportType(cr.getReportType());
			ncr.setFormFieldGroupsJSON(cr.getFormFieldGroupsJSON());
            DataSourceList dataSourceList = objFactory.createDataSourceList();
            ncr.setDataSourceList(dataSourceList);

            for (Iterator iter = cr.getDataSourceList().getDataSource().iterator(); iter.hasNext();) {
                dataSourceList.getDataSource().add(
                        cloneDataSourceType(objFactory, (DataSourceType) iter.next()));
            }

            if (cr.getFormFieldList() != null) {
                FormFieldList formFieldList = objFactory.createFormFieldList();
                ncr.setFormFieldList(formFieldList);
                ncr.getFormFieldList().setComment(formFieldList.getComment());

                for (Iterator iter = cr.getFormFieldList().getFormField().iterator(); iter
                        .hasNext();)
                    formFieldList.getFormField().add(
                            cloneFormFieldType(objFactory, (FormFieldType) iter.next()));
                formFieldList.setComment(cr.getFormFieldList().getComment());
			} 

            if (cr.getJavascriptList() != null) {
                JavascriptList javascriptList = objFactory.createJavascriptList();
                ncr.setJavascriptList(javascriptList);

                for (Iterator iter = cr.getJavascriptList().getJavascriptItem().iterator(); iter
                        .hasNext();)
                    javascriptList.getJavascriptItem().add(
                            cloneJavascriptType(objFactory, (JavascriptItemType) iter.next()));
			}

            if (cr.getSemaphoreList() != null) {
                SemaphoreList semaphoreList = objFactory.createSemaphoreList();
                ncr.setSemaphoreList(semaphoreList);

                for (Iterator iter = cr.getSemaphoreList().getSemaphore().iterator(); iter
                        .hasNext();) {
                    semaphoreList.getSemaphore().add(
                            cloneSemaphoreType(objFactory, (SemaphoreType) iter.next()));
                }
			} 

            if (nvl(cr.getDashboardOptions()).length() > 0)
                ncr.setDashboardOptions(cr.getDashboardOptions());
            if (cr.isDashboardType() != null)
                ncr.setDashboardType(cr.isDashboardType());
            if (cr.isReportInNewWindow() != null)
                ncr.setReportInNewWindow(cr.isReportInNewWindow());
            ncr.setDisplayFolderTree(cr.isDisplayFolderTree());
            if (cr.getDashBoardReports() == null) {
                if (cr.getMaxRowsInExcelDownload() != null && cr.getMaxRowsInExcelDownload() > 0)
                    ncr.setMaxRowsInExcelDownload(cr.getMaxRowsInExcelDownload());
            }

            if (cr.getDashBoardReports() != null) {
                DashboardReports dashboardReports = objFactory.createDashboardReports();
                ncr.setDashBoardReports(dashboardReports);

                for (Iterator iter = cr.getDashBoardReports().getReportsList().iterator(); iter
                        .hasNext();) {
                    dashboardReports.getReportsList().add(
                            cloneDashboardType(objFactory, (Reports) iter.next()));
                }
			} 

            if (cr.getChartAdditionalOptions() != null) {
                ChartAdditionalOptions chartAdditionalOptions = objFactory.createChartAdditionalOptions();
                if (nvl(cr.getChartAdditionalOptions().getChartMultiplePieOrder()).length() > 0)
                    chartAdditionalOptions
                            .setChartMultiplePieOrder(cr.getChartAdditionalOptions().getChartMultiplePieOrder());
                if (nvl(cr.getChartAdditionalOptions().getChartMultiplePieLabelDisplay()).length() > 0)
                    chartAdditionalOptions.setChartMultiplePieLabelDisplay(
                            cr.getChartAdditionalOptions().getChartMultiplePieLabelDisplay());

                if (nvl(cr.getChartAdditionalOptions().getChartOrientation()).length() > 0)
                    chartAdditionalOptions.setChartOrientation(cr.getChartAdditionalOptions().getChartOrientation());
                if (nvl(cr.getChartAdditionalOptions().getSecondaryChartRenderer()).length() > 0)
                    chartAdditionalOptions
                            .setSecondaryChartRenderer(cr.getChartAdditionalOptions().getSecondaryChartRenderer());

                if (nvl(cr.getChartAdditionalOptions().getChartDisplay()).length() > 0)
                    chartAdditionalOptions.setChartDisplay(cr.getChartAdditionalOptions().getChartDisplay());
                if (nvl(cr.getChartAdditionalOptions().getHideToolTips()).length() > 0)
                    chartAdditionalOptions.setHideToolTips(cr.getChartAdditionalOptions().getHideToolTips());
                if (nvl(cr.getChartAdditionalOptions().getHidechartLegend()).length() > 0)
                    chartAdditionalOptions.setHidechartLegend(cr.getChartAdditionalOptions().getHidechartLegend());
                if (nvl(cr.getChartAdditionalOptions().getLegendPosition()).length() > 0)
                    chartAdditionalOptions.setLegendPosition(cr.getChartAdditionalOptions().getLegendPosition());
                if (nvl(cr.getChartAdditionalOptions().getLabelAngle()).length() > 0)
                    chartAdditionalOptions.setLabelAngle(cr.getChartAdditionalOptions().getLabelAngle());

                if (nvl(cr.getChartAdditionalOptions().getIntervalFromdate()).length() > 0)
                    chartAdditionalOptions.setIntervalFromdate(cr.getChartAdditionalOptions().getIntervalFromdate());
                if (nvl(cr.getChartAdditionalOptions().getIntervalTodate()).length() > 0)
                    chartAdditionalOptions.setIntervalTodate(cr.getChartAdditionalOptions().getIntervalTodate());
                if (nvl(cr.getChartAdditionalOptions().getIntervalLabel()).length() > 0)
                    chartAdditionalOptions.setIntervalLabel(cr.getChartAdditionalOptions().getIntervalLabel());

                if (nvl(cr.getChartAdditionalOptions().getLastSeriesALineChart()).length() > 0)
                    chartAdditionalOptions
                            .setLastSeriesALineChart(cr.getChartAdditionalOptions().getLastSeriesALineChart());
                if (nvl(cr.getChartAdditionalOptions().getLastSeriesABarChart()).length() > 0)
                    chartAdditionalOptions
                            .setLastSeriesABarChart(cr.getChartAdditionalOptions().getLastSeriesABarChart());

                if (nvl(cr.getChartAdditionalOptions().getMaxLabelsInDomainAxis()).length() > 0)
                    chartAdditionalOptions
                            .setMaxLabelsInDomainAxis(cr.getChartAdditionalOptions().getMaxLabelsInDomainAxis());
                if (nvl(cr.getChartAdditionalOptions().getLinearRegression()).length() > 0)
                    chartAdditionalOptions.setLinearRegression(cr.getChartAdditionalOptions().getLinearRegression());
                if (nvl(cr.getChartAdditionalOptions().getLinearRegressionColor()).length() > 0)
                    chartAdditionalOptions
                            .setLinearRegressionColor(cr.getChartAdditionalOptions().getLinearRegressionColor());
                if (nvl(cr.getChartAdditionalOptions().getExponentialRegressionColor()).length() > 0)
                    chartAdditionalOptions.setExponentialRegressionColor(
                            cr.getChartAdditionalOptions().getExponentialRegressionColor());
                if (nvl(cr.getChartAdditionalOptions().getMaxRegression()).length() > 0)
                    chartAdditionalOptions.setMaxRegression(cr.getChartAdditionalOptions().getMaxRegression());
                if (nvl(cr.getChartAdditionalOptions().getRangeAxisUpperLimit()).length() > 0)
                    chartAdditionalOptions
                            .setRangeAxisUpperLimit(cr.getChartAdditionalOptions().getRangeAxisUpperLimit());
                if (nvl(cr.getChartAdditionalOptions().getRangeAxisLowerLimit()).length() > 0)
                    chartAdditionalOptions
                            .setRangeAxisLowerLimit(cr.getChartAdditionalOptions().getRangeAxisLowerLimit());
                if (nvl(cr.getChartAdditionalOptions().getOverlayItemValueOnStackBar()).length() > 0)
                    chartAdditionalOptions.setOverlayItemValueOnStackBar(
                            cr.getChartAdditionalOptions().getOverlayItemValueOnStackBar());
                chartAdditionalOptions.setAnimate((cr.getChartAdditionalOptions().isAnimate() != null
                        && cr.getChartAdditionalOptions().isAnimate().booleanValue()) ? true : false);

                if (nvl(cr.getChartAdditionalOptions().getKeepDomainAxisValueAsString()).length() > 0)
                    chartAdditionalOptions.setKeepDomainAxisValueAsString(
                            cr.getChartAdditionalOptions().getKeepDomainAxisValueAsString());

                // Animate
                chartAdditionalOptions
                        .setAnimateAnimatedChart((cr.getChartAdditionalOptions().isAnimateAnimatedChart() != null
                                && cr.getChartAdditionalOptions().isAnimateAnimatedChart().booleanValue()) ? true
                                        : false);
                chartAdditionalOptions.setStacked((cr.getChartAdditionalOptions().isStacked() != null
                        && cr.getChartAdditionalOptions().isStacked().booleanValue()) ? true : false);
                chartAdditionalOptions.setBarControls((cr.getChartAdditionalOptions().isBarControls() != null
                        && cr.getChartAdditionalOptions().isBarControls().booleanValue()) ? true : false);
                chartAdditionalOptions.setXAxisDateType((cr.getChartAdditionalOptions().isXAxisDateType() != null
                        && cr.getChartAdditionalOptions().isXAxisDateType().booleanValue()) ? true : false);
                chartAdditionalOptions.setLessXaxisTickers((cr.getChartAdditionalOptions().isLessXaxisTickers() != null
                        && cr.getChartAdditionalOptions().isLessXaxisTickers().booleanValue()) ? true : false);
                chartAdditionalOptions.setTimeAxis((cr.getChartAdditionalOptions().isTimeAxis() != null
                        && cr.getChartAdditionalOptions().isTimeAxis().booleanValue()) ? true : false);

                if (nvl(cr.getChartAdditionalOptions().getTimeSeriesRender()).length() > 0)
                    chartAdditionalOptions.setTimeSeriesRender(cr.getChartAdditionalOptions().getTimeSeriesRender());

                chartAdditionalOptions.setMultiSeries((cr.getChartAdditionalOptions().isMultiSeries() != null
                        && cr.getChartAdditionalOptions().isMultiSeries().booleanValue()) ? true : false);

                chartAdditionalOptions.setTopMargin(cr.getChartAdditionalOptions().getTopMargin() != null
                        ? cr.getChartAdditionalOptions().getTopMargin()
                        : new Integer(30));
                chartAdditionalOptions.setBottomMargin(cr.getChartAdditionalOptions().getBottomMargin() != null
                        ? cr.getChartAdditionalOptions().getBottomMargin()
                        : new Integer(50));
                chartAdditionalOptions.setLeftMargin(cr.getChartAdditionalOptions().getLeftMargin() != null
                        ? cr.getChartAdditionalOptions().getLeftMargin()
                        : new Integer(100));
                chartAdditionalOptions.setRightMargin(cr.getChartAdditionalOptions().getRightMargin() != null
                        ? cr.getChartAdditionalOptions().getRightMargin()
                        : new Integer(60));

                ncr.setChartAdditionalOptions(chartAdditionalOptions);
			} 

            if (nvl(cr.getJavascriptElement()).length() > 0)
                ncr.setJavascriptElement(cr.getJavascriptElement());
            if (nvl(cr.getFolderId()).length() > 0)
                ncr.setFolderId(cr.getFolderId());

            if (cr.getChartDrillOptions() != null) {
                ChartDrillOptions chartDrillOptions = objFactory.createChartDrillOptions();

                if (nvl(cr.getChartDrillOptions().getDrillReportId()).length() > 0)
                    chartDrillOptions.setDrillReportId(cr.getChartDrillOptions().getDrillReportId());

                for (Iterator iter = cr.getChartDrillOptions().getTargetFormfield().iterator(); iter
                        .hasNext();) {
                    chartDrillOptions.getTargetFormfield().add(
                            cloneChartDrillFormfield(objFactory, (ChartDrillFormfield) iter.next()));

                }

                if (nvl(cr.getChartDrillOptions().getDrillXAxisFormField()).length() > 0)
                    chartDrillOptions.setDrillXAxisFormField(cr.getChartDrillOptions().getDrillXAxisFormField());
                if (nvl(cr.getChartDrillOptions().getDrillYAxisFormField()).length() > 0)
                    chartDrillOptions.setDrillYAxisFormField(cr.getChartDrillOptions().getDrillYAxisFormField());
                if (nvl(cr.getChartDrillOptions().getDrillSeriesFormField()).length() > 0)
                    chartDrillOptions.setDrillSeriesFormField(cr.getChartDrillOptions().getDrillSeriesFormField());

                ncr.setChartDrillOptions(chartDrillOptions);
            }
                ncr.setIsOneTimeScheduleAllowed(cr.getIsOneTimeScheduleAllowed());
                ncr.setIsHourlyScheduleAllowed(cr.getIsHourlyScheduleAllowed());
                ncr.setIsDailyScheduleAllowed(cr.getIsDailyScheduleAllowed());
                ncr.setIsDailyMFScheduleAllowed(cr.getIsDailyMFScheduleAllowed());
                ncr.setIsWeeklyScheduleAllowed(cr.getIsWeeklyScheduleAllowed());
                ncr.setIsMonthlyScheduleAllowed(cr.getIsMonthlyScheduleAllowed());

            ncr.setPageSize(cr.getPageSize());
            ncr.setReportType(cr.getReportType());

            if (cr.getReportMap() != null) {
                ReportMap repMap = objFactory.createReportMap();
                if (nvl(cr.getReportMap().getMarkerColor()).length() > 0)
                    repMap.setMarkerColor(cr.getReportMap().getMarkerColor());
                if (nvl(cr.getReportMap().getUseDefaultSize()).length() > 0)
                    repMap.setUseDefaultSize(cr.getReportMap().getUseDefaultSize());
                if (nvl(cr.getReportMap().getHeight()).length() > 0)
                    repMap.setHeight(cr.getReportMap().getHeight());
                if (nvl(cr.getReportMap().getWidth()).length() > 0)
                    repMap.setWidth(cr.getReportMap().getWidth());
                if (nvl(cr.getReportMap().getIsMapAllowedYN()).length() > 0)
                    repMap.setIsMapAllowedYN(cr.getReportMap().getIsMapAllowedYN());
                if (nvl(cr.getReportMap().getAddAddressInDataYN()).length() > 0)
                    repMap.setAddAddressInDataYN(cr.getReportMap().getAddAddressInDataYN());
                if (nvl(cr.getReportMap().getAddressColumn()).length() > 0)
                    repMap.setAddressColumn(cr.getReportMap().getAddressColumn());
                if (nvl(cr.getReportMap().getDataColumn()).length() > 0)
                    repMap.setDataColumn(cr.getReportMap().getDataColumn());
                if (nvl(cr.getReportMap().getDefaultMapType()).length() > 0)
                    repMap.setDefaultMapType(cr.getReportMap().getDefaultMapType());
                if (nvl(cr.getReportMap().getLatColumn()).length() > 0)
                    repMap.setLatColumn(cr.getReportMap().getLatColumn());
                if (nvl(cr.getReportMap().getLongColumn()).length() > 0)
                    repMap.setLongColumn(cr.getReportMap().getLongColumn());
                if (nvl(cr.getReportMap().getColorColumn()).length() > 0)
                    repMap.setColorColumn(cr.getReportMap().getColorColumn());
                if (nvl(cr.getReportMap().getLegendColumn()).length() > 0)
                    repMap.setLegendColumn(cr.getReportMap().getLegendColumn());

                for (Iterator iter = cr.getReportMap().getMarkers().iterator(); iter
                        .hasNext();) {
                    repMap.getMarkers().add(
                            cloneMarkerType(objFactory, (Marker) iter.next()));

                }

                ncr.setReportMap(repMap);
            }

		} catch (JAXBException ex) { 
            logger.error(EELFLoggerDelegate.debugLogger, "Exception occured in cloneCustomReport ", ex);
            throw new RaptorException(ex.getMessage(), ex.getCause());
        }

        return ncr;
	} 



    private int getIntValue(String value, int defaultValue) {
        int iValue = defaultValue;
        try {
            iValue = Integer.parseInt(value);
        } catch (Exception e) {
            logger.error(EELFLoggerDelegate.debugLogger, "Exception occured in getIntValue ", e);
        }

        return iValue;
	} 

    public static String replaceNewLine(String strSource, String strFind, String chrReplace) {
        StringBuffer sbfTemp = new StringBuffer();

        try {
            int intIndex = strSource.indexOf(strFind, 0);
            if (intIndex >= 0) {
                int intStart = 0;

                int intTotalSize = strSource.length();

                while (intStart < intTotalSize &&
                        ((intIndex = strSource.indexOf(strFind, intStart)) >= 0)) {
                    if (intIndex == intStart) {
                        sbfTemp.append(chrReplace);
                    } else {
                        sbfTemp.append(strSource.substring(intStart, intIndex));
                        sbfTemp.append(chrReplace);
                    }
                    intStart = intIndex + strFind.length();
                }
                sbfTemp.append(strSource.substring(intStart));
            } else {
                sbfTemp.append(strSource);
            }
        } catch (Exception expGeneral) {
            logger.error(EELFLoggerDelegate.debugLogger, "Exception occured in replaceNewLine ", expGeneral);
            sbfTemp = new StringBuffer(strSource);
        }

        return sbfTemp.toString();
    }


    public String getFolderId() {
        return nvl(cr.getFolderId()).length() > 0 ? cr.getFolderId() : "NULL";
    }

    public void setFolderId(String folderId) {
        cr.setFolderId(folderId);
    }

    public String addZero(String num) {
        int numInt = 0;
        try {
            numInt = Integer.parseInt(num);
        } catch (NumberFormatException ex) {
            numInt = 0;
        }
        if (numInt < 10)
            return "0" + numInt;
        else
            return "" + numInt;
    }

    public String getIsDailyMFScheduleAllowed() {
        return cr.getIsDailyMFScheduleAllowed();
    }

    public void setIsDailyMFScheduleAllowed(String isDailyMFScheduleAllowed) {
        cr.setIsDailyMFScheduleAllowed(isDailyMFScheduleAllowed);
    }

    public String getIsDailyScheduleAllowed() {
        return cr.getIsDailyScheduleAllowed();
    }

    public void setIsDailyScheduleAllowed(String isDailyScheduleAllowed) {
        cr.setIsDailyScheduleAllowed(isDailyScheduleAllowed);
    }

    public String getIsHourlyScheduleAllowed() {
        return cr.getIsHourlyScheduleAllowed();
    }

    public void setIsHourlyScheduleAllowed(String isHourlyScheduleAllowed) {
        cr.setIsHourlyScheduleAllowed(isHourlyScheduleAllowed);
    }

    public String getIsMonthlyScheduleAllowed() {
        return cr.getIsMonthlyScheduleAllowed();
    }

    public void setIsMonthlyScheduleAllowed(String isMonthlyScheduleAllowed) {
        cr.setIsMonthlyScheduleAllowed(isMonthlyScheduleAllowed);
    }

    public String getIsOneTimeScheduleAllowed() {
        return cr.getIsOneTimeScheduleAllowed();
    }

    public void setIsOneTimeScheduleAllowed(String isOneTimeScheduleAllowed) {
        cr.setIsOneTimeScheduleAllowed(isOneTimeScheduleAllowed);
    }

    public String getIsWeeklyScheduleAllowed() {
        return cr.getIsWeeklyScheduleAllowed();
    }

    public void setIsWeeklyScheduleAllowed(String isWeeklyScheduleAllowed) {
        cr.setIsWeeklyScheduleAllowed(isWeeklyScheduleAllowed);

    }

    public static boolean isNull(String a) {
        if ((a == null) || (a.length() == 0) || "null".equalsIgnoreCase(a))
            return true;
        else
            return false;
    }

    public int getDependsOnFormFieldFlag(DataColumnType dc, HashMap formValues) {
        int flag = 0;
        String fieldValue = "";
        if (nvl(dc.getDependsOnFormField()).length() > 0 && nvl(dc.getDependsOnFormField()).indexOf("[") != -1) {
            if (formValues != null) {
                Set set = formValues.entrySet();
                String value = "";
                for (Iterator iter1 = set.iterator(); iter1.hasNext();) {
                    Map.Entry entry = (Entry) iter1.next();
                    value = (String) entry.getValue();
                    if (dc.getDependsOnFormField().equals("[" + entry.getKey() + "]")) {
                        fieldValue = nvl(value);

                        if (fieldValue.length() > 0 && !"NULL".equals(fieldValue)) {
                            flag = 0;
                        } else {
                            flag = 1;
                        }

                    }
                }
            }
        }

        return flag;
    }

    public String getClassifier() {
        return (cr.getDataminingOptions() != null ? cr.getDataminingOptions().getClassifier() : "");
    }

    public void setClassifier(String classifier) {
        cr.getDataminingOptions().setClassifier(classifier);
    }

    public int getForecastingPeriod() {
        return (cr.getDataminingOptions() != null
                ? new Integer(cr.getDataminingOptions().getForecastingUnits()).intValue()
                : -1);
    }

    public void setForecastingPeriod(String period) {
        cr.getDataminingOptions().setForecastingUnits(period);
    }

    public String getForecastingTimeFormat() {
        return (cr.getDataminingOptions() != null ? cr.getDataminingOptions().getTimeformat() : "");
    }

    public void setForecastingTimeFormat(String format) {
        cr.getDataminingOptions().setTimeformat(format);
    }

    /**
     * Get Number of Columns to Frozen in Data Grid
     */

    public int getFrozenColumns() {
        return cr.getFrozenColumns() == null ? 0 : cr.getFrozenColumns();
    }

    public String getFrozenColumnId() {
        int noOfColumns = cr.getFrozenColumns() == null ? 0 : cr.getFrozenColumns();
        if (noOfColumns != 0) {
            List reportCols = getOnlyVisibleColumns();
            int colIdx = 0;
            for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
                ++colIdx;
                DataColumnType dc = (DataColumnType) iter.next();
                if (colIdx == noOfColumns) {

                    return dc.getColId();
                } else
                    continue;
            } // for
            return "";
        } else
            return "";

    }

    /**
     * Set Number of Columns to Frozen in Data Grid
     */

    public void setFrozenColumns(int frozenColumns) {
        cr.setFrozenColumns(frozenColumns);
    }

    /**
     * @return the reportSQLWithRowNum for ZK Support
     */
    public String getReportSQLWithRowNum() {
        return reportSQLWithRowNum;
    }

    /**
     * @param reportSQLWithRowNum the reportSQLWithRowNum to set for ZK Support
     */
    public void setReportSQLWithRowNum(String reportSQLWithRowNum) {
        this.reportSQLWithRowNum = reportSQLWithRowNum;
    }

    public void setReportSQLOnlyFirstPart(String reportSQLOnlyFirstPart) {
        this.reportSQLOnlyFirstPart = reportSQLOnlyFirstPart;
    }

    public String getReportSQLOnlyFirstPart() {
        return this.reportSQLOnlyFirstPart;
    }

    public String getTemplateFile() throws RaptorException {
        return ReportLoader.getTemplateFile(getReportID());
    }

    public String getPdfImg() {
        return cr.getPdfImgLogo();
    }

    public String getEmptyMessage() {
        String emptyMessage = cr.getEmptyMessage();
        if (nvl(emptyMessage).length() <= 0)
            emptyMessage = Globals.getReportEmptyMessage();
        return emptyMessage;
    }

    public void setPdfImg(String img_loc) {
        cr.setPdfImgLogo(img_loc);
    }

    public void setEmptyMessage(String emptyMessage) {
        cr.setEmptyMessage(emptyMessage);
    }

    public void setDrillReportIdForChart(String reportId) {
        cr.getChartDrillOptions().setDrillReportId(reportId);
    }

    public String getDrillReportIdForChart() {
        return (cr.getChartDrillOptions() != null) ? cr.getChartDrillOptions().getDrillReportId() : "";
    }

    public void setDrillXAxisFormField(String formField) {
        cr.getChartDrillOptions().setDrillXAxisFormField(formField);
    }

    public String getDrillXAxisFormField() {
        return (cr.getChartDrillOptions() != null) ? cr.getChartDrillOptions().getDrillXAxisFormField() : "";
    }

    public void setDrillYAxisFormField(String formField) {
        cr.getChartDrillOptions().setDrillYAxisFormField(formField);
    }

    public String getDrillYAxisFormField() {
        return (cr.getChartDrillOptions() != null) ? cr.getChartDrillOptions().getDrillYAxisFormField() : "";
    }

    public void setDrillSeriesFormField(String formField) {
        cr.getChartDrillOptions().setDrillSeriesFormField(formField);
    }

    public String getDrillSeriesFormField() {
        return (cr.getChartDrillOptions() != null) ? cr.getChartDrillOptions().getDrillSeriesFormField() : "";
    }

    public boolean isEnhancedPaginationNeeded() {
        List reportCols = getAllColumns();

        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (dc.isEnhancedPagination() != null && dc.isEnhancedPagination().booleanValue())
                return true;
		} 
        return false;
    }

    public DataColumnType getColumnWhichNeedEnhancedPagination() {
        List reportCols = getAllColumns();

        for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
            DataColumnType dc = (DataColumnType) iter.next();
            if (dc.isEnhancedPagination() != null && dc.isEnhancedPagination().booleanValue())
                return dc;
		} 
        return null;
    }

    public void setDataGridAlign(String align) {
        cr.setDataGridAlign(align);
    }

    public String getDataGridAlign() {
        return (cr.getDataGridAlign() != null) ? cr.getDataGridAlign() : "left";
    }

    public void setWidthNoColumn(String width) {
        cr.setWidthNoColumn(width);
    }

    public String getWidthNoColumn() {
        return (cr.getWidthNoColumn() != null) ? cr.getWidthNoColumn() : "30px";
    }

    public void setWholeSQL(String sql) {
        wholeSQL = sql;
    }

    public String getWholeSQL() {
        return wholeSQL;
    }

}