Eclipse Community Forums: BIRT » How to show the image in birt report?

Help

Home

Home » Archived » BIRT » How to show the image in birt report?(How to show the image in birt report?)

Show: Today's Messages :: Show Polls :: Message Navigator

How to show the image in birt report? [message #657248]

Wed, 02 March 2011 07:41

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();
}
}
}

Report message to a moderator

Re: How to show the image in birt report? [message #657404 is a reply to message #657248]

Wed, 02 March 2011 16:47

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(); } }
> }
>

Report message to a moderator

Re: How to show the image in birt report? [message #657488 is a reply to message #657404]

Thu, 03 March 2011 00:47

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


Report message to a moderator

Re: How to show the image in birt report? [message #657515 is a reply to message #657488]

Thu, 03 March 2011 06:56

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 07: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 07:55

Bob

Messages: 5
Registered: March 2011

Junior Member

Hi Jason,

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

Best regards,
Bob

Report message to a moderator

Re: How to show the image in birt report? [message #657534 is a reply to message #657526]

Thu, 03 March 2011 08:36

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 ??

Report message to a moderator

Re: How to show the image in birt report? [message #657552 is a reply to message #657534]

Thu, 03 March 2011 09:25

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

Report message to a moderator

Re: How to show the image in birt report? [message #657566 is a reply to message #657552]

Thu, 03 March 2011 10:18

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

Report message to a moderator

Re: How to show the image in birt report? [message #657662 is a reply to message #657526]

Thu, 03 March 2011 15:24

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

Report message to a moderator

Re: How to show the image in birt report? [message #657811 is a reply to message #657534]

Fri, 04 March 2011 08:05

Bob

Messages: 5
Registered: March 2011

Junior Member

Hi Magnet,

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

Regards,
Bob

Report message to a moderator

Re: How to show the image in birt report? [message #657818 is a reply to message #657811]

Fri, 04 March 2011 08:48

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

Report message to a moderator

Previous Topic:	Group Header in Detail Line
Next Topic:	Proxy error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 01:05:45 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter