Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » How to show the image in birt report?(How to show the image in birt report?)
How to show the image in birt report? [message #657248] Wed, 02 March 2011 02:41 Go to next message
Bob  is currently offline Bob
Messages: 5
Registered: March 2011
Junior Member
Hi

Currently, I use birt API to generate a report. I design this report with birt, has a image need to show in this report. And the image name is dynamic from database. I have completed the source code, and it can generate report successfully, but the image can't show in report. Following is my source code:

package com.ncs.report;

import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.logging.Level;

import junit.framework.Test;

import org.eclipse.birt.core.exception.BirtException;
import org.eclipse.birt.core.framework.Platform;
import org.eclipse.birt.report.engine.api.EngineConfig;
import org.eclipse.birt.report.engine.api.EngineConstants;
import org.eclipse.birt.report.engine.api.HTMLActionHandler;
import org.eclipse.birt.report.engine.api.HTMLEmitterConfig;
import org.eclipse.birt.report.engine.api.HTMLRenderContext;
import org.eclipse.birt.report.engine.api.HTMLRenderOption;
import org.eclipse.birt.report.engine.api.HTMLServerImageHandler;
import org.eclipse.birt.report.engine.api.IReportEngine;
import org.eclipse.birt.report.engine.api.IReportEngineFactory;
import org.eclipse.birt.report.engine.api.IReportRunnable;
import org.eclipse.birt.report.engine.api.IRunAndRenderTask;
import org.eclipse.birt.report.engine.api.PDFRenderOption;
import org.eclipse.birt.report.model.api.ElementFactory;
import org.eclipse.birt.report.model.api.OdaDataSourceHandle;
import org.eclipse.birt.report.model.api.ReportDesignHandle;
import org.eclipse.birt.report.model.api.activity.SemanticException ;
import org.eclipse.birt.report.model.api.elements.structures.Embedd edImage;

import com.actuate.eservices.moe.erdf.RegistryServiceWrapper;

public class TestReport {


/**
* @param args
*/
public static void main(String[] args) throws BirtException{
try{
final EngineConfig config = new EngineConfig();
String reportName="RPTLSI05_report";
config.setEngineHome("D:\\abc\\Eclipse report\\ReportEngine");
config.setLogConfig("D:\\reportLog",Level.FINE);
config.setResourcePath("D:\\abc\\sams\\trunk\\az\\modules\\rpt\\brdf\\Libraries ");
Platform.startup(config);
IReportEngineFactory factory =(IReportEngineFactory)Platform.createFactoryObject(IReportE ngineFactory.EXTENSION_REPORT_ENGINE_FACTORY);
IReportEngine engine = factory.createReportEngine(config);
engine.changeLogLevel(Level.WARNING);
IReportRunnable design= engine.openReportDesign(" D:\\abc\\sams\\trunk\\az\\modules\\rpt\\brdf\\rptdesign\\ls\ \reports\\RPTLSI05_report.rptdesign ");
ReportDesignHandle report = (ReportDesignHandle) design.getDesignHandle();
buildReport(report);
IRunAndRenderTask task = engine.createRunAndRenderTask(design);
task.getAppContext().put(EngineConstants.APPCONTEXT_CLASSLOA DER_KEY, Test.class.getClassLoader());
//start
HTMLEmitterConfig emitterConfig = new HTMLEmitterConfig( );
emitterConfig.setActionHandler( new HTMLActionHandler( ) );
HTMLServerImageHandler imageHandler = new HTMLServerImageHandler( );
emitterConfig.setImageHandler( imageHandler );
config.getEmitterConfigs( ).put( "html", emitterConfig );
HTMLRenderContext renderContext = new HTMLRenderContext ();
// renderContext.setBaseURL("http://localhost/");
// renderContext.setBaseImageURL("http://localhost/myimages");
//renderContext.setImageDirectory("d:\\myimages");
renderContext.setSupportedImageFormats("JPG;PNG;BMP;SVG");
HashMap<String, HTMLRenderContext> contextMap = new HashMap<String, HTMLRenderContext>();
//contextMap.put( EngineConstants.APPCONTEXT_HTML_RENDER_CONTEXT, renderContext );
contextMap.put( EngineConstants.APPCONTEXT_PDF_RENDER_CONTEXT, renderContext );
task.setAppContext( contextMap );
//end
Map<String,Object> reportParameterMap = new HashMap<String,Object>();
reportParameterMap.put("Scheme", "2010ISD1ANL");
reportParameterMap.put("Interview Schedule Id", null);
task.setParameterValues(reportParameterMap);
task.validateParameters();
PDFRenderOption options = new PDFRenderOption();
options.setOutputFileName("D:\\p350\\Generated Report\\"+reportName+".pdf");
options.setOutputFormat("pdf");
task.setRenderOption(options);
task.run();
Platform.shutdown();
task.close();
engine.shutdown();;
System.exit(0);
}catch(Exception e){
e.printStackTrace();
System.exit(0);
}
}


protected static void buildReport(ReportDesignHandle designHandle) {
try {
ElementFactory designFactory = designHandle.getElementFactory();
buildDataSource(designFactory, designHandle);
} catch (SemanticException e) {
e.printStackTrace();
}

}

protected static void buildDataSource(ElementFactory designFactory,
ReportDesignHandle designHandle) throws SemanticException {
RegistryServiceWrapper regSrvcWrapper = new RegistryServiceWrapper("AZ");
String[] regParams = regSrvcWrapper.getRegistryParameters("az");
String dataSource = regParams[0];
String dbUsername = regParams[1];
String appCode = regParams[2];
String keyCode = regParams[3];
String level1Code = regParams[4];
System.out.println("dataSource===============> "+dataSource);
System.out.println("dbUsername===============> "+dbUsername);
System.out.println("appCode===============> "+appCode);
System.out.println("keyCode===============> "+keyCode);
System.out.println("level1Code===============> "+level1Code);
regSrvcWrapper.initialize(appCode,"az");
if (dbUsername == null)
dbUsername = regSrvcWrapper.getRegistryValue("USER", level1Code);
String dbPassword = regSrvcWrapper.getRegistryValue(keyCode, level1Code);
System.out.println("dbPassword===============> "+dbPassword);
clearDataSource(designHandle);
OdaDataSourceHandle dsHandle = designFactory.newOdaDataSource("Oracle Data Source", "org.eclipse.birt.report.data.oda.jdbc");
dsHandle.setProperty( "odaDriverClass","oracle.jdbc.driver.OracleDriver");
dsHandle.setProperty( "odaURL", dataSource);
System.out.println("odaURL===============> "+dataSource);
dsHandle.setProperty( "odaUser", dbUsername);
dsHandle.setProperty( "odaPassword", dbPassword);
designHandle.getDataSources().add(dsHandle);
}

protected static void clearDataSource(ReportDesignHandle designHandle) {
int count = designHandle.getDataSources().getCount();
try {
for (int i = 0; i < count; i++){
designHandle.getDataSources().drop(i);
}
} catch (SemanticException e) {
e.printStackTrace();
}
}
}
Re: How to show the image in birt report? [message #657404 is a reply to message #657248] Wed, 02 March 2011 11:47 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Bob,

Can you post the xml from the report design?

Jason

On 3/2/2011 2:41 AM, Bob wrote:
> Hi
>
> Currently, I use birt API to generate a report. I design this report
> with birt, has a image need to show in this report. And the image name
> is dynamic from database. I have completed the source code, and it can
> generate report successfully, but the image can't show in report.
> Following is my source code:
>
> package com.ncs.report;
>
> import java.util.HashMap;
> import java.util.List;
> import java.util.Map;
> import java.util.logging.Level;
>
> import junit.framework.Test;
>
> import org.eclipse.birt.core.exception.BirtException;
> import org.eclipse.birt.core.framework.Platform;
> import org.eclipse.birt.report.engine.api.EngineConfig;
> import org.eclipse.birt.report.engine.api.EngineConstants;
> import org.eclipse.birt.report.engine.api.HTMLActionHandler;
> import org.eclipse.birt.report.engine.api.HTMLEmitterConfig;
> import org.eclipse.birt.report.engine.api.HTMLRenderContext;
> import org.eclipse.birt.report.engine.api.HTMLRenderOption;
> import org.eclipse.birt.report.engine.api.HTMLServerImageHandler;
> import org.eclipse.birt.report.engine.api.IReportEngine;
> import org.eclipse.birt.report.engine.api.IReportEngineFactory;
> import org.eclipse.birt.report.engine.api.IReportRunnable;
> import org.eclipse.birt.report.engine.api.IRunAndRenderTask;
> import org.eclipse.birt.report.engine.api.PDFRenderOption;
> import org.eclipse.birt.report.model.api.ElementFactory;
> import org.eclipse.birt.report.model.api.OdaDataSourceHandle;
> import org.eclipse.birt.report.model.api.ReportDesignHandle;
> import org.eclipse.birt.report.model.api.activity.SemanticException ;
> import org.eclipse.birt.report.model.api.elements.structures.Embedd
> edImage;
>
> import com.actuate.eservices.moe.erdf.RegistryServiceWrapper;
> public class TestReport {
>
>
> /**
> * @param args
> */
> public static void main(String[] args) throws BirtException{
> try{ final EngineConfig config = new EngineConfig();
> String reportName="RPTLSI05_report";
> config.setEngineHome("D:\\abc\\Eclipse report\\ReportEngine");
> config.setLogConfig("D:\\reportLog",Level.FINE);
> config.setResourcePath("D:\\abc\\sams\\trunk\\az\\modules\\rpt\\brdf\\Libraries
> ");
> Platform.startup(config);
> IReportEngineFactory factory
> =(IReportEngineFactory)Platform.createFactoryObject(IReportE
> ngineFactory.EXTENSION_REPORT_ENGINE_FACTORY);
> IReportEngine engine = factory.createReportEngine(config);
> engine.changeLogLevel(Level.WARNING);
> IReportRunnable design= engine.openReportDesign("
> D:\\abc\\sams\\trunk\\az\\modules\\rpt\\brdf\\rptdesign\\ls\
> \reports\\RPTLSI05_report.rptdesign ");
> ReportDesignHandle report = (ReportDesignHandle) design.getDesignHandle();
> buildReport(report);
> IRunAndRenderTask task = engine.createRunAndRenderTask(design);
> task.getAppContext().put(EngineConstants.APPCONTEXT_CLASSLOA DER_KEY,
> Test.class.getClassLoader());
> //start
> HTMLEmitterConfig emitterConfig = new HTMLEmitterConfig( );
> emitterConfig.setActionHandler( new HTMLActionHandler( ) );
> HTMLServerImageHandler imageHandler = new HTMLServerImageHandler( );
> emitterConfig.setImageHandler( imageHandler ); config.getEmitterConfigs(
> ).put( "html", emitterConfig ); HTMLRenderContext renderContext = new
> HTMLRenderContext ();
> // renderContext.setBaseURL("http://localhost/"); //
> renderContext.setBaseImageURL("http://localhost/myimages");
> //renderContext.setImageDirectory("d:\\myimages");
> renderContext.setSupportedImageFormats("JPG;PNG;BMP;SVG");
> HashMap<String, HTMLRenderContext> contextMap = new HashMap<String,
> HTMLRenderContext>();
> //contextMap.put( EngineConstants.APPCONTEXT_HTML_RENDER_CONTEXT,
> renderContext ); contextMap.put(
> EngineConstants.APPCONTEXT_PDF_RENDER_CONTEXT, renderContext );
> task.setAppContext( contextMap ); //end
> Map<String,Object> reportParameterMap = new HashMap<String,Object>();
> reportParameterMap.put("Scheme", "2010ISD1ANL");
> reportParameterMap.put("Interview Schedule Id", null);
> task.setParameterValues(reportParameterMap);
> task.validateParameters();
> PDFRenderOption options = new PDFRenderOption();
> options.setOutputFileName("D:\\p350\\Generated
> Report\\"+reportName+".pdf");
> options.setOutputFormat("pdf");
> task.setRenderOption(options);
> task.run();
> Platform.shutdown();
> task.close();
> engine.shutdown();;
> System.exit(0);
> }catch(Exception e){
> e.printStackTrace();
> System.exit(0);
> }
> }
>
>
> protected static void buildReport(ReportDesignHandle designHandle) { try
> { ElementFactory designFactory = designHandle.getElementFactory();
> buildDataSource(designFactory, designHandle); } catch (SemanticException
> e) { e.printStackTrace(); }
> }
>
> protected static void buildDataSource(ElementFactory designFactory,
> ReportDesignHandle designHandle) throws SemanticException {
> RegistryServiceWrapper regSrvcWrapper = new RegistryServiceWrapper("AZ");
> String[] regParams = regSrvcWrapper.getRegistryParameters("az");
> String dataSource = regParams[0];
> String dbUsername = regParams[1];
> String appCode = regParams[2];
> String keyCode = regParams[3];
> String level1Code = regParams[4];
> System.out.println("dataSource===============> "+dataSource);
> System.out.println("dbUsername===============> "+dbUsername);
> System.out.println("appCode===============> "+appCode);
> System.out.println("keyCode===============> "+keyCode);
> System.out.println("level1Code===============> "+level1Code);
> regSrvcWrapper.initialize(appCode,"az");
> if (dbUsername == null)
> dbUsername = regSrvcWrapper.getRegistryValue("USER", level1Code);
> String dbPassword = regSrvcWrapper.getRegistryValue(keyCode, level1Code);
> System.out.println("dbPassword===============> "+dbPassword);
> clearDataSource(designHandle);
> OdaDataSourceHandle dsHandle = designFactory.newOdaDataSource("Oracle
> Data Source", "org.eclipse.birt.report.data.oda.jdbc");
> dsHandle.setProperty(
> "odaDriverClass","oracle.jdbc.driver.OracleDriver");
> dsHandle.setProperty( "odaURL", dataSource);
> System.out.println("odaURL===============> "+dataSource);
> dsHandle.setProperty( "odaUser", dbUsername); dsHandle.setProperty(
> "odaPassword", dbPassword); designHandle.getDataSources().add(dsHandle);
> }
>
> protected static void clearDataSource(ReportDesignHandle designHandle) {
> int count = designHandle.getDataSources().getCount(); try { for (int i =
> 0; i < count; i++){
> designHandle.getDataSources().drop(i); }
> } catch (SemanticException e) { e.printStackTrace(); } }
> }
>
Re: How to show the image in birt report? [message #657488 is a reply to message #657404] Wed, 02 March 2011 19:47 Go to previous messageGo to next message
Bob  is currently offline Bob
Messages: 5
Registered: March 2011
Junior Member
Hi Jason,

Refer to following:

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 2.2.2.v20080718-1613 Build &lt;2.2.2.v20080718-1613></property>
    <property name="units">in</property>
    <property name="comments">Copyright (c) 2007 &lt;&lt;Your Company Name here>></property>
    <html-property name="description">This is a sample report template for portrait layout.</html-property>
    <property name="theme">BRDF_themes.defaultTheme_Plain</property>
    <text-property name="displayName">Sample xxx Portrait Report Report</text-property>
    <property name="iconFile">/templates/simple_listing.gif</property>
    <list-property name="libraries">
        <structure>
            <property name="fileName">BRDF_masterpages.rptlibrary</property>
            <property name="namespace">BRDF_masterpages</property>
        </structure>
        <structure>
            <property name="fileName">BRDF_themes.rptlibrary</property>
            <property name="namespace">BRDF_themes</property>
        </structure>
        <structure>
            <property name="fileName">BRDF_structure.rptlibrary</property>
            <property name="namespace">BRDF_structure</property>
        </structure>
        <structure>
            <property name="fileName">BRDF_datasources.rptlibrary</property>
            <property name="namespace">BRDF_datasources</property>
        </structure>
        <structure>
            <property name="fileName">/themes.rptlibrary</property>
            <property name="namespace">themes</property>
        </structure>
        <structure>
            <property name="fileName">BRDF_controls.rptlibrary</property>
            <property name="namespace">BRDF_controls</property>
        </structure>
    </list-property>
    <list-property name="includeScripts">
        <property>JavaScripts/escapeSpecialCharacter.js</property>
    </list-property>
    <parameters>
        <parameter-group name="System Parameters" id="884">
            <parameters>
                <scalar-parameter name="rp_appName" id="885">
                    <property name="hidden">true</property>
                    <text-property name="helpText">For registry service integration</text-property>
                    <property name="valueType">static</property>
                    <property name="dataType">string</property>
                    <property name="paramType">simple</property>
                    <property name="isRequired">false</property>
                    <property name="controlType">text-box</property>
                    <property name="defaultValue">az</property>
                    <property name="distinct">true</property>
                    <structure name="format">
                        <property name="category">Unformatted</property>
                    </structure>
                </scalar-parameter>
                <scalar-parameter name="rp_reportID" id="197">
                    <property name="hidden">true</property>
                    <text-property name="helpText">Static report label - unique per report</text-property>
                    <property name="valueType">static</property>
                    <property name="dataType">string</property>
                    <property name="paramType">simple</property>
                    <property name="isRequired">false</property>
                    <property name="controlType">text-box</property>
                    <property name="defaultValue">RPTLSI05</property>
                    <property name="distinct">true</property>
                    <structure name="format">
                        <property name="category">Unformatted</property>
                    </structure>
                </scalar-parameter>
                <scalar-parameter name="rp_reportTitle" id="198">
                    <property name="hidden">true</property>
                    <text-property name="helpText">Report title - unique per report</text-property>
                    <property name="valueType">static</property>
                    <property name="dataType">string</property>
                    <property name="paramType">simple</property>
                    <property name="isRequired">false</property>
                    <property name="controlType">text-box</property>
                    <property name="defaultValue">Interview Booklet a€" Pre-U</property>
                    <property name="distinct">true</property>
                    <structure name="format">
                        <property name="category">Unformatted</property>
                    </structure>
                </scalar-parameter>
            </parameters>
        </parameter-group>
        <scalar-parameter name="Scheme" id="902">
            <method name="validate"><![CDATA[if(params["Scheme"].value=='----1'){
	false;
}else{
	true;
}]]></method>
            <property name="valueType">dynamic</property>
            <property name="dataType">string</property>
            <property name="paramType">simple</property>
            <text-property name="promptText">Scheme</text-property>
            <property name="controlType">list-box</property>
            <property name="dataSetName">paramScheme</property>
            <expression name="valueExpr">dataSetRow["SCHEME_ID"]</expression>
            <expression name="labelExpr">dataSetRow["SCHEME_NAME"]</expression>
            <property name="mustMatch">true</property>
            <property name="fixedOrder">true</property>
            <property name="defaultValue">----1</property>
            <property name="distinct">true</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="Interview Schedule Id" id="1291">
            <property name="hidden">false</property>
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="paramType">simple</property>
            <text-property name="promptText">Interview Schedule Id</text-property>
            <property name="isRequired">false</property>
            <property name="controlType">text-box</property>
            <property name="distinct">true</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
    </parameters>
    <data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Oracle Data Source" id="851"
 extends="BRDF_datasources.Oracle Data Source">
            <property name="odaDriverClass">com.actuate.jdbc.oracle.OracleDriver</property>
            <property name="odaURL">jdbc:actuate:oracle://192.168.81.238:1521;ServiceName=azd</property>
            <property name="odaUser">az03</property>
            <encrypted-property name="odaPassword" encryptionID="jce">e783a2121bdf69ddcaab65efdde92e0b</encrypted-property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="paramScheme" id="901">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">SCHEME_ID</property>
                    <property name="displayName">SCHEME_ID</property>
                </structure>
                <structure>
                    <property name="columnName">SCHEME_NAME</property>
                    <property name="displayName">SCHEME_NAME</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">SCHEME_ID</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">SCHEME_NAME</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Oracle Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">SCHEME_ID</property>
                    <property name="nativeName">SCHEME_ID</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">SCHEME_NAME</property>
                    <property name="nativeName">SCHEME_NAME</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
            </list-property>
            <property name="queryText">SELECT '----1' SCHEME_ID,'Please Select' SCHEME_NAME FROM DUAL
  UNION ALL
  SELECT *
  FROM (
     SELECT S.SCHEME_ID,S.SCHEME_NAME
     FROM AZ_SCHEME S
     WHERE S.RECRUITMENT_YR BETWEEN TO_NUMBER(TO_CHAR(SYSDATE,'YYYY'))-10 AND TO_NUMBER (TO_CHAR(SYSDATE,'YYYY'))+1
     AND S.STATUS_CD = 'A'
     AND   S.SCHOLARSHIP_TYPE_CD = 'L'
    ORDER BY S.SCHEME_NAME
  )

</property>
            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
  <Version>1.0</Version>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>SCHEME_ID</design:name>
            <design:position>1</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>20</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>SCHEME_ID</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>SCHEME_ID</design:label>
            <design:formattingHints>
              <design:displaySize>20</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>SCHEME_NAME</design:name>
            <design:position>2</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>50</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>SCHEME_NAME</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>SCHEME_NAME</design:label>
            <design:formattingHints>
              <design:displaySize>50</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="main" id="903">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">SCHEME_NAME</property>
                    <property name="displayName">SCHEME_NAME</property>
                </structure>
                <structure>
                    <property name="columnName">UPLOAD_PHOTO_FILENAME</property>
                    <property name="displayName">UPLOAD_PHOTO_FILENAME</property>
                </structure>
                <structure>
                    <property name="columnName">APPLICANT_ID</property>
                    <property name="displayName">APPLICANT_ID</property>
                </structure>
                <structure>
                    <property name="columnName">INTERVIEW_TIME</property>
                    <property name="displayName">INTERVIEW_TIME</property>
                </structure>
                <structure>
                    <property name="columnName">FULL_NAME</property>
                    <property name="displayName">FULL_NAME</property>
                </structure>
                <structure>
                    <property name="columnName">DOB</property>
                    <property name="displayName">DOB</property>
                </structure>
                <structure>
                    <property name="columnName">GENDER_CD</property>
                    <property name="displayName">GENDER_CD</property>
                </structure>
                <structure>
                    <property name="columnName">CITIZENSHIP</property>
                    <property name="displayName">CITIZENSHIP</property>
                </structure>
                <structure>
                    <property name="columnName">NRIC</property>
                    <property name="displayName">NRIC</property>
                </structure>
                <structure>
                    <property name="columnName">FIN</property>
                    <property name="displayName">FIN</property>
                </structure>
                <structure>
                    <property name="columnName">ADDRESS_LINE1</property>
                    <property name="displayName">ADDRESS_LINE1</property>
                </structure>
                <structure>
                    <property name="columnName">ADDRESS_LINE2</property>
                    <property name="displayName">ADDRESS_LINE2</property>
                </structure>
                <structure>
                    <property name="columnName">ADDRESS_LINE3</property>
                    <property name="displayName">ADDRESS_LINE3</property>
                </structure>
                <structure>
                    <property name="columnName">TEL_NO</property>
                    <property name="displayName">TEL_NO</property>
                </structure>
                <structure>
                    <property name="columnName">CCA_GRADE</property>
                    <property name="displayName">CCA_GRADE</property>
                </structure>
                <structure>
                    <property name="columnName">SELF_WRITE_UP</property>
                    <property name="displayName">SELF_WRITE_UP</property>
                </structure>
                <structure>
                    <property name="columnName">IP_YN</property>
                    <property name="displayName">IP_YN</property>
                </structure>
                <structure>
                    <property name="columnName">INTERVIEW_DT</property>
                    <property name="displayName">INTERVIEW_DT</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">SCHEME_NAME</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">UPLOAD_PHOTO_FILENAME</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">APPLICANT_ID</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">INTERVIEW_TIME</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">FULL_NAME</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">DOB</property>
                        <property name="dataType">date-time</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">GENDER_CD</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">CITIZENSHIP</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">NRIC</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">10</property>
                        <property name="name">FIN</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">11</property>
                        <property name="name">ADDRESS_LINE1</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">12</property>
                        <property name="name">ADDRESS_LINE2</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">13</property>
                        <property name="name">ADDRESS_LINE3</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">14</property>
                        <property name="name">TEL_NO</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">15</property>
                        <property name="name">CCA_GRADE</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">16</property>
                        <property name="name">SELF_WRITE_UP</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">17</property>
                        <property name="name">IP_YN</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">18</property>
                        <property name="name">INTERVIEW_DT</property>
                        <property name="dataType">date-time</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Oracle Data Source</property>
            <method name="beforeOpen"><![CDATA[paramInterviewSchId = params["Interview Schedule Id"].value;
if(params["Interview Schedule Id"].value!=null && params["Interview Schedule Id"].value !=""){
	this.queryText = this.queryText.replaceAll("##InterviewScheduleId##"," AND   ISL.INTERVIEW_SCHED_ID = '"+escapeSpecialChar(paramInterviewSchId)+"'");
}else{
	this.queryText = this.queryText.replaceAll("##InterviewScheduleId##","");
}]]></method>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">SCHEME_NAME</property>
                    <property name="nativeName">SCHEME_NAME</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">UPLOAD_PHOTO_FILENAME</property>
                    <property name="nativeName">UPLOAD_PHOTO_FILENAME</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">APPLICANT_ID</property>
                    <property name="nativeName">APPLICANT_ID</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">3</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">INTERVIEW_TIME</property>
                    <property name="nativeName">INTERVIEW_TIME</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">FULL_NAME</property>
                    <property name="nativeName">FULL_NAME</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">DOB</property>
                    <property name="nativeName">DOB</property>
                    <property name="dataType">date-time</property>
                    <property name="nativeDataType">93</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">GENDER_CD</property>
                    <property name="nativeName">GENDER_CD</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">CITIZENSHIP</property>
                    <property name="nativeName">CITIZENSHIP</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">NRIC</property>
                    <property name="nativeName">NRIC</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">10</property>
                    <property name="name">FIN</property>
                    <property name="nativeName">FIN</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">11</property>
                    <property name="name">ADDRESS_LINE1</property>
                    <property name="nativeName">ADDRESS_LINE1</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">12</property>
                    <property name="name">ADDRESS_LINE2</property>
                    <property name="nativeName">ADDRESS_LINE2</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">13</property>
                    <property name="name">ADDRESS_LINE3</property>
                    <property name="nativeName">ADDRESS_LINE3</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">14</property>
                    <property name="name">TEL_NO</property>
                    <property name="nativeName">TEL_NO</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">15</property>
                    <property name="name">CCA_GRADE</property>
                    <property name="nativeName">CCA_GRADE</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">16</property>
                    <property name="name">SELF_WRITE_UP</property>
                    <property name="nativeName">SELF_WRITE_UP</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">17</property>
                    <property name="name">IP_YN</property>
                    <property name="nativeName">IP_YN</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">18</property>
                    <property name="name">INTERVIEW_DT</property>
                    <property name="nativeName">INTERVIEW_DT</property>
                    <property name="dataType">date-time</property>
                    <property name="nativeDataType">93</property>
                </structure>
            </list-property>
            <property name="queryText">SELECT S.SCHEME_NAME,NVL2(APP.APPLICANT_ID,'D:\\'||APP.APPLICANT_ID||'.jpg',NULL) UPLOAD_PHOTO_FILENAME,
     APP.APPLICANT_ID,LTRIM(TO_CHAR(TO_DATE(ISTAL.INTERVIEW_TIME,'HH24MI'),'HH12.MI AM'),'0') INTERVIEW_TIME,
       APP.FULL_NAME,APP.DOB DOB,APP.GENDER_CD,
       AZ_PKG_COM_4RPT.AZ_FN_GETCODEDESC('citizen',APP.CITIZENSHIP_CD) CITIZENSHIP,APP.NRIC,APP.FIN,
       ADDR.ADDRESS_LINE1,ADDR.ADDRESS_LINE2,ADDR.ADDRESS_LINE3,APP.TEL_NO,
        AZ_PKG_COM_4RPT.AZ_FN_GETCODEDESC('oLvlGrade',APP.OVERALL_CCA_GRADE) CCA_GRADE,APPS.SELF_WRITE_UP,APP.IP_YN,
        ISL.INTERVIEW_DT INTERVIEW_DT
FROM AZ_APPLICANT APP,
     AZ_APPLICANT_SCHEME APPS,
     AZ_INTERVIEW_SCHED_LS ISL,
     AZ_INTERVIEW_SCHED_TO_APPL_LS ISTAL,
     AZ_SCHEME S,
     AZ_APPLICANT_ADDR ADDR
WHERE S.SCHEME_ID = APPS.SCHEME_ID
AND   APPS.APPLICANT_ID = APP.APPLICANT_ID
AND   ISL.SCHEME_ID = S.SCHEME_ID
AND   ISTAL.SCHEDULE_ID = ISL.SCHEDULE_ID
AND   ISTAL.APPLICANT_SCHEME_ID = APPS.APPLICANT_SCHEME_ID
AND   ADDR.APPLICANT_ID = APP.APPLICANT_ID
AND   ADDR.ADDR_TYPE = 'H'
AND   S.SCHEME_ID = '2010ISD1ANL'
--##InterviewScheduleId##
ORDER BY ISL.INTERVIEW_DT,TO_DATE(ISTAL.INTERVIEW_TIME,'HH24MI')</property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="familyBkg" id="943">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">FULL_NAME</property>
                    <property name="displayName">FULL_NAME</property>
                </structure>
                <structure>
                    <property name="columnName">RELATIONSHIP</property>
                    <property name="displayName">RELATIONSHIP</property>
                </structure>
                <structure>
                    <property name="columnName">CITIZENSHIP</property>
                    <property name="displayName">CITIZENSHIP</property>
                </structure>
                <structure>
                    <property name="columnName">OCCUPATION</property>
                    <property name="displayName">OCCUPATION</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">FULL_NAME</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">RELATIONSHIP</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">CITIZENSHIP</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">OCCUPATION</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Oracle Data Source</property>
            <list-property name="parameters">
                <structure>
                    <property name="name">app_id</property>
                    <property name="nativeName"></property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">3</property>
                    <property name="position">1</property>
                    <expression name="defaultValue">1</expression>
                    <property name="allowNull">false</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
                <structure>
                    <property name="name">app_id1</property>
                    <property name="nativeName"></property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">3</property>
                    <property name="position">2</property>
                    <expression name="defaultValue">1</expression>
                    <property name="allowNull">false</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
            </list-property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">FULL_NAME</property>
                    <property name="nativeName">FULL_NAME</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">RELATIONSHIP</property>
                    <property name="nativeName">RELATIONSHIP</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">CITIZENSHIP</property>
                    <property name="nativeName">CITIZENSHIP</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">OCCUPATION</property>
                    <property name="nativeName">OCCUPATION</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
            </list-property>
            <property name="queryText">SELECT FAM.FULL_NAME,AZ_PKG_COM_4RPT.AZ_FN_GETCODEDESC('paRelation',FAM.RELATIONSHIP_CD) RELATIONSHIP,
       AZ_PKG_COM_4RPT.AZ_FN_GETCODEDESC('citizen',FAM.CITIZENSHIP_CD) CITIZENSHIP,
       FAM.OCCUPATION
FROM AZ_APPLICANT_FAMILY FAM
WHERE FAM.APPLICANT_ID = ?
AND   FAM.RELATIONSHIP_CD IN ('F','M','G')
UNION ALL
SELECT FAM.FULL_NAME,AZ_PKG_COM_4RPT.AZ_FN_GETCODEDESC('sbRelation',FAM.RELATIONSHIP_CD) RELATIONSHIP,
       AZ_PKG_COM_4RPT.AZ_FN_GETCODEDESC('citizen',FAM.CITIZENSHIP_CD) CITIZENSHIP,
       FAM.OCCUPATION
FROM AZ_APPLICANT_FAMILY FAM
WHERE FAM.APPLICANT_ID = ?
AND   FAM.RELATIONSHIP_CD IN ('S','B')</property>
            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
  <Version>1.0</Version>
  <design:DataSetParameters>
    <design:parameterDefinitions>
      <design:inOutMode>In</design:inOutMode>
      <design:attributes>
        <design:name></design:name>
        <design:position>1</design:position>
        <design:nativeDataTypeCode>3</design:nativeDataTypeCode>
        <design:precision>38</design:precision>
        <design:scale>0</design:scale>
        <design:nullability>NotNullable</design:nullability>
      </design:attributes>
    </design:parameterDefinitions>
    <design:parameterDefinitions>
      <design:inOutMode>In</design:inOutMode>
      <design:attributes>
        <design:name></design:name>
        <design:position>2</design:position>
        <design:nativeDataTypeCode>3</design:nativeDataTypeCode>
        <design:precision>38</design:precision>
        <design:scale>0</design:scale>
        <design:nullability>NotNullable</design:nullability>
      </design:attributes>
    </design:parameterDefinitions>
  </design:DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>FULL_NAME</design:name>
            <design:position>1</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>80</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>FULL_NAME</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>FULL_NAME</design:label>
            <design:formattingHints>
              <design:displaySize>80</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>RELATIONSHIP</design:name>
            <design:position>2</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>4000</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>RELATIONSHIP</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>RELATIONSHIP</design:label>
            <design:formattingHints>
              <design:displaySize>4000</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>CITIZENSHIP</design:name>
            <design:position>3</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>4000</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>CITIZENSHIP</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>CITIZENSHIP</design:label>
            <design:formattingHints>
              <design:displaySize>4000</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>OCCUPATION</design:name>
            <design:position>4</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>300</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>OCCUPATION</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>OCCUPATION</design:label>
            <design:formattingHints>
              <design:displaySize>100</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="academicInfoSec" id="1058">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">SEC_SCHOOL</property>
                    <property name="displayName">SEC_SCHOOL</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">SEC_SCHOOL</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Oracle Data Source</property>
            <list-property name="parameters">
                <structure>
                    <property name="name">app_id</property>
                    <property name="nativeName"></property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">3</property>
                    <property name="position">1</property>
                    <expression name="defaultValue">1</expression>
                    <property name="allowNull">false</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
            </list-property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">SEC_SCHOOL</property>
                    <property name="nativeName">SEC_SCHOOL</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
            </list-property>
            <property name="queryText">SELECT 
CASE
  WHEN APPL.IP_YN = 'Y' THEN AZ_PKG_COM_4RPT.az_fn_getCodeDesc('locSch',EDU.SCHOOL_CD)
  ELSE EDU.SECONDARY_SCHOOL_NAME
END SEC_SCHOOL
FROM AZ_APPLICANT APPL LEFT JOIN AZ_APPLICANT_EDU_BKG EDU
ON EDU.APPLICANT_ID = APPL.APPLICANT_ID AND EDU.EDU_TYPE_CD = 'SEC'
WHERE APPL.APPLICANT_ID = ?</property>
            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
  <Version>1.0</Version>
  <design:DataSetParameters>
    <design:parameterDefinitions>
      <design:inOutMode>In</design:inOutMode>
      <design:attributes>
        <design:name></design:name>
        <design:position>1</design:position>
        <design:nativeDataTypeCode>3</design:nativeDataTypeCode>
        <design:precision>38</design:precision>
        <design:scale>0</design:scale>
        <design:nullability>NotNullable</design:nullability>
      </design:attributes>
    </design:parameterDefinitions>
  </design:DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>SEC_SCHOOL</design:name>
            <design:position>1</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>4000</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>SEC_SCHOOL</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>SEC_SCHOOL</design:label>
            <design:formattingHints>
              <design:displaySize>4000</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="academicInfoJC" id="1059">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">JC_SCHOOL</property>
                    <property name="displayName">JC_SCHOOL</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">JC_SCHOOL</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Oracle Data Source</property>
            <list-property name="parameters">
                <structure>
                    <property name="name">app_id</property>
                    <property name="nativeName"></property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">3</property>
                    <property name="position">1</property>
                    <expression name="defaultValue">1</expression>
                    <property name="allowNull">false</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
            </list-property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">JC_SCHOOL</property>
                    <property name="nativeName">JC_SCHOOL</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
            </list-property>
            <property name="queryText">SELECT AZ_PKG_COM_4RPT.AZ_FN_GETCODEDESC('locSch',EDU.SCHOOL_CD) JC_SCHOOL
FROM AZ_APPLICANT_EDU_BKG EDU
WHERE EDU.APPLICANT_ID = ?
AND EDU.EDU_TYPE_CD = 'JC'</property>
            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
  <Version>1.0</Version>
  <design:DataSetParameters>
    <design:parameterDefinitions>
      <design:inOutMode>In</design:inOutMode>
      <design:attributes>
        <design:name></design:name>
        <design:position>1</design:position>
        <design:nativeDataTypeCode>3</design:nativeDataTypeCode>
        <design:precision>38</design:precision>
        <design:scale>0</design:scale>
        <design:nullability>NotNullable</design:nullability>
      </design:attributes>
    </design:parameterDefinitions>
  </design:DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:name>SEC_SCHOOL</design:name>
            <design:position>1</design:position>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>4000</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>Nullable</design:nullability>
            <design:uiHints>
              <design:displayName>SEC_SCHOOL</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>SEC_SCHOOL</design:label>
            <design:formattingHints>
              <design:displaySize>4000</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="subject" id="1090">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">SUBJECT</property>
                    <property name="displayName">SUBJECT</property>
                </structure>
                <structure>
                    <property name="columnName">GRADE</property>
                    <property name="displayName">GRADE</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">SUBJECT</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">GRADE</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Oracle Data Source</property>
            <list-property name="parameters">
                <structure>
                    <property name="name">app_id</property>
                    <property name="nativeName"></property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">3</property>
                    <property name="position">1</property>
                    <expression name="defaultValue">1</expression>
                    <property name="allowNull">false</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</prop



icon3.gif  Re: How to show the image in birt report? [message #657515 is a reply to message #657488] Thu, 03 March 2011 01:56 Go to previous messageGo to next message
Magnet is currently offline Magnet
Messages: 7
Registered: March 2011
Location: Mumbai
Junior Member
Sorry , I am posting the reply without looking at your xml file ... so it might be little bit out of synch. I hav only seen the requirement posted by you.

Is your image file is stored in disk or database ?? What I understood so far is that only image file name is dynamic , actual image is in disk only ... if so ..

1.) Bind your image element with the table containing the
2.) Make Image element property as "Image file in shared resources"
3.) Under enter resource file -> Use the function button - > point to Available Column binding >Select table under sub category -> select the column name & insert
4.) do not hard code any path in the design file or set in the api
5.) Put all the related images in the resource folder that you have set in the web.xml file.

[Updated on: Thu, 03 March 2011 02:17]

Report message to a moderator

Re: How to show the image in birt report? [message #657526 is a reply to message #657515] Thu, 03 March 2011 02:55 Go to previous messageGo to next message
Bob  is currently offline Bob
Messages: 5
Registered: March 2011
Junior Member
Hi Jason,

Thank you very much! It can work base on your solution.

Best regards,
Bob
Re: How to show the image in birt report? [message #657534 is a reply to message #657526] Thu, 03 March 2011 03:36 Go to previous messageGo to next message
Magnet is currently offline Magnet
Messages: 7
Registered: March 2011
Location: Mumbai
Junior Member
Bob wrote on Thu, 03 March 2011 02:55
Hi Jason,

Thank you very much! It can work base on your solution.

Best regards,
Bob


Hey Bob..
are you referring about my solution ??
Re: How to show the image in birt report? [message #657552 is a reply to message #657534] Thu, 03 March 2011 04:25 Go to previous messageGo to next message
Bob  is currently offline Bob
Messages: 5
Registered: March 2011
Junior Member
Hi Jason,

I do it follow your solution, and it can work now, I'm so happy!
Thanks a lots.

Regards,
Bob
Re: How to show the image in birt report? [message #657566 is a reply to message #657552] Thu, 03 March 2011 05:18 Go to previous messageGo to next message
Magnet is currently offline Magnet
Messages: 7
Registered: March 2011
Location: Mumbai
Junior Member
Bob wrote on Thu, 03 March 2011 04:25
Hi Jason,

I do it follow your solution, and it can work now, I'm so happy!
Thanks a lots.

Regards,
Bob


Rolling Eyes Rolling Eyes
Re: How to show the image in birt report? [message #657662 is a reply to message #657526] Thu, 03 March 2011 10:24 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Bob,

Abhishek answered your question.

Jason

On 3/3/2011 2:55 AM, Bob wrote:
> Hi Jason,
>
> Thank you very much! It can work base on your solution.
>
> Best regards,
> Bob
Re: How to show the image in birt report? [message #657811 is a reply to message #657534] Fri, 04 March 2011 03:05 Go to previous messageGo to next message
Bob  is currently offline Bob
Messages: 5
Registered: March 2011
Junior Member
Hi Magnet,

Sorry, I misunderstand you're Jason. Thanks a lots.

Regards,
Bob
Re: How to show the image in birt report? [message #657818 is a reply to message #657811] Fri, 04 March 2011 03:48 Go to previous message
Magnet is currently offline Magnet
Messages: 7
Registered: March 2011
Location: Mumbai
Junior Member
Bob wrote on Fri, 04 March 2011 03:05
Hi Magnet,

Sorry, I misunderstand you're Jason. Thanks a lots.

Regards,
Bob


Hey bob

Thats perfectly fine.. I was just trying to put some humor .. at the same time wanted to know if there are any other solution used offline. I am happy that my first solution posted at the forum was useful & made you happy.... cheers!!

Magnet
Previous Topic:Group Header in Detail Line
Next Topic:Proxy error
Goto Forum:
  


Current Time: Fri Aug 29 12:32:11 EDT 2014

Powered by FUDForum. Page generated in 0.14657 seconds