Home » Archived » BIRT » problem to Display from blob
problem to Display from blob [message #369073] |
Mon, 27 July 2009 10:17 |
Uttam Ghosh Messages: 39 Registered: July 2009 |
Member |
|
|
Hi,
I am working on
1. Redhat Enterprise 5
2. jakarta-tomcat 5.5.9
3. mysql 5.0.22
4. java 6
5. birt 2.3
I have a simple rptdesign, which have to display data from blob. My query
is displaying correct data when i am running this from mysql console but
it is displaying wrong data from birt preview.
This the data from birt preview
//////////////////////////////////////////////////////////// /
55 4E 49 54 20 2D 20 49 ...
55 4E 49 54 20 2D 20 49 ...
55 4E 49 54 20 49 09 09 ...
55 4E 49 54 20 2D 20 49 ...
////////////////////////////////////////////////////////////
This the original data from blob
//////////////////////////////////////////////////////////// //////////////////////////
UNIT - I
Controllability & Observability: Introduction, general concept of
controllability, general concept of observability, controllability tests
for continuous time systems, observability tests for continuous time
systems, controllability & observability for discrete time systems,
controllability & observability of state model in Jordan canonical form,
loss of controllability & observability due to sampling, controllability &
observability canonical forms of state model.
UNIT - II
State variables and input output descriptions: introduction, input output
maps from state models, LTI continuous time systems, LTI discrete time
systems, linear time varying systems, output controllability,
reducibility, state model from input output maps realization of scalar
transfer functions, phase variable canonical forms, realization of
transfer function matrices, realization of pulse transfer functions.
UNIT - III
Stability: Introduction, equilibrium points, stability concepts and
definitions, stability of linear time invariant systems, equilibrium
stability of non-linear continuous time autonomous systems, direct method
of Lyapunov and the linear continuous time autonomous systems, aids to
find Lyapunov functions for non-linear continuous time autonomous systems,
use of Lyapunov functions to estimate transients, the direct method of
Lyapunov and discrete time autonomous systems.
UNIT - IV
Model control: Introduction, controllable and observable companion forms
for single input/single output systems & multi-input/multi-output systems,
the effect of state feedback on controllability & observability, pole
placement by state feedback, full order observers, the separation
principle, reduced order observers, deadbeat control by state feedback,
deadbeat observers.
REFERENCE BOOKS:
1.Modern control system theory by M. Gopal (New age international)
2.Modern control systems a manual of design methods by John A Borrie
(Prentice hall international)
3.Digital control and state variable methods by M. Gopal (Tata McGraw Hill)
//////////////////////////////////////////////////////////// /////////////////////////
this is my query
/////////////////////////
select
a.syllabus
from subject_curriculum a,subject b,course_offering c,
course_structure d
where a.subject_id=b.subject_id
and a.subject_curriculum_id=c.subject_curriculum_id
and c.course_structure_item_id=d.course_structure_item_id
and d.academic_unit_id= ?
and d.program_id= ?
and d.course_id= ?
and d.program_unit_id= ?
and c.academic_session_id= ?
group by b.subject_id
////////////////////////////////////////////////
this is my rptdesign
///////////////////////////////////////////////
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.16"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.3.0.v20080606 Build <2.3.0.v20080618-0630></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="layoutPreference">auto layout</property>
<parameters>
<scalar-parameter name="academic_unit_id" id="903">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<property name="defaultValue">3</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="program_id" id="904">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</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="course_id" id="905">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</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="program_unit_id" id="906">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</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="academic_session_id" id="907">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<property name="defaultValue">8</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="Data Source"
id="336">
<property
name="odaDriverClass">com.mysql.jdbc.Driver</property>
<property name="odaURL">jdbc:mysql://localhost/kuk</property>
<property name="odaUser">root</property>
<encrypted-property name="odaPassword"
encryptionID="base64">YWt0cGw=</encrypted-property>
<property
name="odaJndiName">java:comp/env/jdbc/kukDB</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="337">
<list-property name="columnHints">
<structure>
<property name="columnName">subject_name</property>
<property name="displayName">subject_name</property>
</structure>
<structure>
<property name="columnName">subject_code</property>
<property name="displayName">subject_code</property>
</structure>
<structure>
<property name="columnName">lec_per_week</property>
<property name="displayName">lec_per_week</property>
</structure>
<structure>
<property name="columnName">tut_per_week</property>
<property name="displayName">tut_per_week</property>
</structure>
<structure>
<property
name="columnName">sessional_per_week</property>
<property
name="displayName">sessional_per_week</property>
</structure>
<structure>
<property name="columnName">credit_hours</property>
<property name="displayName">credit_hours</property>
</structure>
<structure>
<property name="columnName">full_marks</property>
<property name="displayName">full_marks</property>
</structure>
<structure>
<property name="columnName">elective</property>
<property name="displayName">elective</property>
</structure>
<structure>
<property name="columnName">base_subject</property>
<property name="displayName">base_subject</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">subject_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">subject_code</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">lec_per_week</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">tut_per_week</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">sessional_per_week</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">credit_hours</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">full_marks</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">elective</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">base_subject</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="parameters">
<structure>
<property name="name">academic_unit_id</property>
<property name="dataType">any</property>
<property name="position">1</property>
<expression name="defaultValue">3</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">program_id</property>
<property name="dataType">any</property>
<property name="position">2</property>
<expression name="defaultValue">1</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">course_id</property>
<property name="dataType">any</property>
<property name="position">3</property>
<expression name="defaultValue">1</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">program_unit_id</property>
<property name="dataType">any</property>
<property name="position">4</property>
<expression name="defaultValue">1</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">academic_session_id</property>
<property name="dataType">any</property>
<property name="position">5</property>
<expression name="defaultValue">8</expression>
<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">subject_name</property>
<property name="nativeName">subject_name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">subject_code</property>
<property name="nativeName">subject_code</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">lec_per_week</property>
<property name="nativeName">lec_per_week</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">tut_per_week</property>
<property name="nativeName">tut_per_week</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">sessional_per_week</property>
<property
name="nativeName">sessional_per_week</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">credit_hours</property>
<property name="nativeName">credit_hours</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">full_marks</property>
<property name="nativeName">full_marks</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">elective</property>
<property name="nativeName">elective</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">base_subject</property>
<property name="nativeName">base_subject</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
</list-property>
<property name="queryText">select
b.subject_name ,
b.subject_code ,
a.lec_per_week ,
a.tut_per_week ,
a.sessional_per_week ,
a.credit_hours ,
a.full_marks ,
a.elective ,
a.base_subject
from subject_curriculum a,subject b,course_offering c,
course_structure d
where a.subject_id=b.subject_id
and a.subject_curriculum_id=c.subject_curriculum_id
and c.course_structure_item_id=d.course_structure_item_id
and d.academic_unit_id= ?
and d.program_id= ?
and d.course_id= ?
and d.program_unit_id= ?
and c.academic_session_id= ?
group by b.subject_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:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>student_id</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>student_id</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>student_id</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>academic_unit_name</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>60</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>academic_unit_name</design:displayName >
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>academic_unit_name</design:label>
<design:formattingHints>
<design:displaySize>60</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>name</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>60</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>name</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>name</design:label>
<design:formattingHints>
<design:displaySize>60</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>examination_year</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>30</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>examination_year</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>examination_year</design:label>
<design:formattingHints>
<design:displaySize>30</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>muster_roll_number</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>muster_roll_number</design:displayName >
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>muster_roll_number</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>registration_no</design:name>
<design:position>6</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>60</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>registration_no</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>registration_no</design:label>
<design:formattingHints>
<design:displaySize>60</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>concat(a.first_name,' ', a.middle_name,' ',
a.last_name)</design:name>
<design:position>7</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>152</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>concat(a.first_name,' ', a.middle_name,'
', a.last_name)</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>concat(a.first_name,' ', a.middle_name,' ',
a.last_name)</design:label>
<design:formattingHints>
<design:displaySize>152</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>father_name</design:name>
<design:position>8</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>100</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>father_name</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>father_name</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>college_name</design:name>
<design:position>9</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>150</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>college_name</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>college_name</design:label>
<design:formattingHints>
<design:displaySize>150</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>college_name</design:name>
<design:position>10</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>150</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>college_name</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>college_name</design:label>
<design:formattingHints>
<design:displaySize>150</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="header" id="918">
<list-property name="columnHints">
<structure>
<property name="columnName">name</property>
<property name="displayName">name</property>
</structure>
<structure>
<property
name="columnName">academic_unit_name</property>
<property
name="displayName">academic_unit_name</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">academic_unit_name</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">name</property>
<property name="nativeName">name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">academic_unit_name</property>
<property
name="nativeName">academic_unit_name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select a.name,b.academic_unit_name
from academic_program_course_offering a,
academic_unit b
where
a.academic_unit_id=a.academic_unit_id
and a.course_id='1'
and b.academic_unit_id='3'
and b.academic_unit_id=b.academic_unit_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:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>subject_name</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>Subject Name</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>Subject Name</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>subject_code</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>30</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>Subject Code</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>Subject Code</design:label>
<design:formattingHints>
<design:displaySize>30</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>lec_per_week</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>Lecture per Week</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>Lecture per Week</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>tut_per_week</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>Tutorial per Week</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>Tutorial per Week</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>sessional_per_week</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>Sessional per Week</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>Sessional per Week</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>credit_hours</design:name>
<design:position>6</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>Credit Hour</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>Credit Hour</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>full_marks</design:name>
<design:position>7</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>Full Marks</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>Full Marks</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>elective</design:name>
<design:position>8</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>3</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>Elective</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>Elective</design:label>
<design:formattingHints>
<design:displaySize>3</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>base_subject</design:name>
<design:position>9</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>Base Subject</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>Base Subject</design:label>
<design:formattingHints>
<design:displaySize>11</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="Syllabus" id="1004">
<list-property name="columnHints">
<structure>
<property name="columnName">syllabus</property>
<property name="displayName">syllabus</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">syllabus</property>
<property name="dataType">blob</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="parameters">
<structure>
<property name="name">academic_unit_id</property>
<property name="dataType">any</property>
<property name="position">1</property>
<expression name="defaultValue">3</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">program_id</property>
<property name="dataType">any</property>
<property name="position">2</property>
<expression name="defaultValue">2</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">course_id</property>
<property name="dataType">any</property>
<property name="position">3</property>
<expression name="defaultValue">2</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">program_unit_id</property>
<property name="dataType">any</property>
<property name="position">4</property>
<expression name="defaultValue">9</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">academic_session_id</property>
<property name="dataType">any</property>
<property name="position">5</property>
<expression name="defaultValue">8</expression>
<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">syllabus</property>
<property name="nativeName">syllabus</property>
<property name="dataType">blob</property>
<property name="nativeDataType">-4</property>
</structure>
</list-property>
<property name="queryText">select
a.syllabus
from subject_curriculum a,subject b,course_offering c,
course_structure d
where a.subject_id=b.subject_id
and a.subject_curriculum_id=c.subject_curriculum_id
and c.course_structure_item_id=d.course_structure_item_id
and d.academic_unit_id= ?
and d.program_id= ?
and d.course_id= ?
and d.program_unit_id= ?
and c.academic_session_id= ?
group by b.subject_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:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>subject_name</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>200</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>subject_name</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>subject_name</design:label>
<design:formattingHints>
<design:displaySize>200</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>subject_code</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>30</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>subject_code</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>subject_code</design:label>
<design:formattingHints>
<design:displaySize>30</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>lec_per_week</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>lec_per_week</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>lec_per_week</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>tut_per_week</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>tut_per_week</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>tut_per_week</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>sessional_per_week</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>sessional_per_week</design:displayName >
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>sessional_per_week</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
<
|
|
|
Re: problem to Display from blob [message #369082 is a reply to message #369073] |
Mon, 27 July 2009 18:24 |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.windstream.net
Uttam,
Use a dynamic text element to display CLOB data. Do not use a data
element.
Jason
Uttam Ghosh wrote:
> Hi,
>
> I am working on
> 1. Redhat Enterprise 5
> 2. jakarta-tomcat 5.5.9
> 3. mysql 5.0.22
> 4. java 6
> 5. birt 2.3
> I have a simple rptdesign, which have to display data from blob. My
> query is displaying correct data when i am running this from mysql
> console but it is displaying wrong data from birt preview.
>
> This the data from birt preview
>
> //////////////////////////////////////////////////////////// /
> 55 4E 49 54 20 2D 20 49 ...
> 55 4E 49 54 20 2D 20 49 ...
> 55 4E 49 54 20 49 09 09 ...
> 55 4E 49 54 20 2D 20 49 ...
> ////////////////////////////////////////////////////////////
> This the original data from blob
> //////////////////////////////////////////////////////////// //////////////////////////
>
> UNIT - I
>
> Controllability & Observability: Introduction, general concept of
> controllability, general concept of observability, controllability tests
> for continuous time systems, observability tests for continuous time
> systems, controllability & observability for discrete time systems,
> controllability & observability of state model in Jordan canonical form,
> loss of controllability & observability due to sampling, controllability
> & observability canonical forms of state model.
>
>
>
> UNIT - II
>
> State variables and input output descriptions: introduction, input
> output maps from state models, LTI continuous time systems, LTI discrete
> time systems, linear time varying systems, output controllability,
> reducibility, state model from input output maps realization of scalar
> transfer functions, phase variable canonical forms, realization of
> transfer function matrices, realization of pulse transfer functions.
>
>
>
> UNIT - III
>
> Stability: Introduction, equilibrium points, stability concepts and
> definitions, stability of linear time invariant systems, equilibrium
> stability of non-linear continuous time autonomous systems, direct
> method of Lyapunov and the linear continuous time autonomous systems,
> aids to find Lyapunov functions for non-linear continuous time
> autonomous systems, use of Lyapunov functions to estimate transients,
> the direct method of Lyapunov and discrete time autonomous systems.
>
>
>
> UNIT - IV
>
> Model control: Introduction, controllable and observable companion forms
> for single input/single output systems & multi-input/multi-output
> systems, the effect of state feedback on controllability &
> observability, pole placement by state feedback, full order observers,
> the separation principle, reduced order observers, deadbeat control by
> state feedback, deadbeat observers.
>
>
>
> REFERENCE BOOKS:
>
> 1.Modern control system theory by M. Gopal (New age international)
>
> 2.Modern control systems a manual of design methods by John A Borrie
> (Prentice hall international)
>
> 3.Digital control and state variable methods by M. Gopal (Tata McGraw Hill)
>
>
> //////////////////////////////////////////////////////////// /////////////////////////
>
>
> this is my query
> /////////////////////////
> select a.syllabus
>
> from subject_curriculum a,subject b,course_offering c,
> course_structure d
> where a.subject_id=b.subject_id and
> a.subject_curriculum_id=c.subject_curriculum_id and
> c.course_structure_item_id=d.course_structure_item_id and
> d.academic_unit_id= ?
> and d.program_id= ?
> and d.course_id= ?
> and d.program_unit_id= ?
> and c.academic_session_id= ?
> group by b.subject_id
> ////////////////////////////////////////////////
>
> this is my rptdesign
> ///////////////////////////////////////////////
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.16"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.3.0.v20080606 Build <2.3.0.v20080618-0630></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="layoutPreference">auto layout</property>
> <parameters>
> <scalar-parameter name="academic_unit_id" id="903">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">3</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="program_id" id="904">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="controlType">text-box</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="course_id" id="905">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="controlType">text-box</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="program_unit_id" id="906">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="controlType">text-box</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="academic_session_id" id="907">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="paramType">simple</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">8</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="Data Source"
> id="336">
> <property name="odaDriverClass">com.mysql.jdbc.Driver</property>
> <property name="odaURL">jdbc:mysql://localhost/kuk</property>
> <property name="odaUser">root</property>
> <encrypted-property name="odaPassword"
> encryptionID="base64">YWt0cGw=</encrypted-property>
> <property name="odaJndiName">java:comp/env/jdbc/kukDB</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="337">
> <list-property name="columnHints">
> <structure>
> <property name="columnName">subject_name</property>
> <property name="displayName">subject_name</property>
> </structure>
> <structure>
> <property name="columnName">subject_code</property>
> <property name="displayName">subject_code</property>
> </structure>
> <structure>
> <property name="columnName">lec_per_week</property>
> <property name="displayName">lec_per_week</property>
> </structure>
> <structure>
> <property name="columnName">tut_per_week</property>
> <property name="displayName">tut_per_week</property>
> </structure>
> <structure>
> <property
> name="columnName">sessional_per_week</property>
> <property
> name="displayName">sessional_per_week</property>
> </structure>
> <structure>
> <property name="columnName">credit_hours</property>
> <property name="displayName">credit_hours</property>
> </structure>
> <structure>
> <property name="columnName">full_marks</property>
> <property name="displayName">full_marks</property>
> </structure>
> <structure>
> <property name="columnName">elective</property>
> <property name="displayName">elective</property>
> </structure>
> <structure>
> <property name="columnName">base_subject</property>
> <property name="displayName">base_subject</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">subject_name</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">subject_code</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">lec_per_week</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">tut_per_week</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">sessional_per_week</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">credit_hours</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">full_marks</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">elective</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">base_subject</property>
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="parameters">
> <structure>
> <property name="name">academic_unit_id</property>
> <property name="dataType">any</property>
> <property name="position">1</property>
> <expression name="defaultValue">3</expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">program_id</property>
> <property name="dataType">any</property>
> <property name="position">2</property>
> <expression name="defaultValue">1</expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">course_id</property>
> <property name="dataType">any</property>
> <property name="position">3</property>
> <expression name="defaultValue">1</expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">program_unit_id</property>
> <property name="dataType">any</property>
> <property name="position">4</property>
> <expression name="defaultValue">1</expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">academic_session_id</property>
> <property name="dataType">any</property>
> <property name="position">5</property>
> <expression name="defaultValue">8</expression>
> <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">subject_name</property>
> <property name="nativeName">subject_name</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">subject_code</property>
> <property name="nativeName">subject_code</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">lec_per_week</property>
> <property name="nativeName">lec_per_week</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">tut_per_week</property>
> <property name="nativeName">tut_per_week</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">sessional_per_week</property>
> <property
> name="nativeName">sessional_per_week</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">credit_hours</property>
> <property name="nativeName">credit_hours</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">full_marks</property>
> <property name="nativeName">full_marks</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">elective</property>
> <property name="nativeName">elective</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">base_subject</property>
> <property name="nativeName">base_subject</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> </list-property>
> <property name="queryText">select b.subject_name ,
> b.subject_code ,
> a.lec_per_week ,
> a.tut_per_week ,
> a.sessional_per_week ,
> a.credit_hours ,
> a.full_marks ,
> a.elective ,
> a.base_subject
> from subject_curriculum a,subject b,course_offering c,
> course_structure d
> where a.subject_id=b.subject_id and
> a.subject_curriculum_id=c.subject_curriculum_id and
> c.course_structure_item_id=d.course_structure_item_id and
> d.academic_unit_id= ?
> and d.program_id= ?
> and d.course_id= ?
> and d.program_unit_id= ?
> and c.academic_session_id= ?
> group by b.subject_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:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>student_id</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>student_id</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>student_id</design:label>
> <design:formattingHints>
> <design:displaySize>10</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>academic_unit_name</design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>60</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>academic_unit_name</design:displayName >
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>academic_unit_name</design:label>
> <design:formattingHints>
> <design:displaySize>60</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>name</design:name>
> <design:position>3</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>60</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>name</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>name</design:label>
> <design:formattingHints>
> <design:displaySize>60</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>examination_year</design:name>
> <design:position>4</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>30</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>examination_year</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>examination_year</design:label>
> <design:formattingHints>
> <design:displaySize>30</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>muster_roll_number</design:name>
> <design:position>5</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>50</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>muster_roll_number</design:displayName >
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>muster_roll_number</design:label>
> <design:formattingHints>
> <design:displaySize>50</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>registration_no</design:name>
> <design:position>6</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>60</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>registration_no</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>registration_no</design:label>
> <design:formattingHints>
> <design:displaySize>60</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>concat(a.first_name,' ', a.middle_name,' ',
> a.last_name)</design:name>
> <design:position>7</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>152</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>concat(a.first_name,' ',
> a.middle_name,' ', a.last_name)</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>concat(a.first_name,' ', a.middle_name,' ',
> a.last_name)</design:label>
> <design:formattingHints>
> <design:displaySize>152</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>father_name</design:name>
> <design:position>8</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>100</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>father_name</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>father_name</design:label>
> <design:formattingHints>
> <design:displaySize>100</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>college_name</design:name>
> <design:position>9</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>150</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>college_name</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>college_name</design:label>
> <design:formattingHints>
> <design:displaySize>150</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>college_name</design:name>
> <design:position>10</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>150</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>college_name</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>college_name</design:label>
> <design:formattingHints>
> <design:displaySize>150</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="header" id="918">
> <list-property name="columnHints">
> <structure>
> <property name="columnName">name</property>
> <property name="displayName">name</property>
> </structure>
> <structure>
> <property
> name="columnName">academic_unit_name</property>
> <property
> name="displayName">academic_unit_name</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">name</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">academic_unit_name</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">name</property>
> <property name="nativeName">name</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">academic_unit_name</property>
> <property
> name="nativeName">academic_unit_name</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> </list-property>
> <property name="queryText">select a.name,b.academic_unit_name
>
> from academic_program_course_offering a,
> academic_unit b
> where a.academic_unit_id=a.academic_unit_id
> and a.course_id='1'
> and b.academic_unit_id='3'
> and b.academic_unit_id=b.academic_unit_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:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>subject_name</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>200</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>Subject Name</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>Subject Name</design:label>
> <design:formattingHints>
> <design:displaySize>200</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>subject_code</design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>30</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>Subject Code</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>Subject Code</design:label>
> <design:formattingHints>
> <design:displaySize>30</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>lec_per_week</design:name>
> <design:position>3</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>11</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>Lecture per Week</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>Lecture per Week</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>tut_per_week</design:name>
> <design:position>4</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>11</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>Tutorial per Week</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>Tutorial per Week</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>sessional_per_week</design:name>
> <design:position>5</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>11</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>Sessional per Week</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>Sessional per Week</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>credit_hours</design:name>
> <design:position>6</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>Credit Hour</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>Credit Hour</design:label>
> <design:formattingHints>
> <design:displaySize>10</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>full_marks</design:name>
> <design:position>7</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>11</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>Full Marks</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>Full Marks</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>elective</design:name>
> <design:position>8</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>3</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>Elective</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>Elective</design:label>
> <design:formattingHints>
> <design:displaySize>3</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>base_subject</design:name>
> <design:position>9</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>11</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>Base Subject</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>Base Subject</design:label>
> <design:formattingHints>
> <design:displaySize>11</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="Syllabus" id="1004">
> <list-property name="columnHints">
> <structure>
> <property name="columnName">syllabus</property>
> <property name="displayName">syllabus</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">syllabus</property>
> <property name="dataType">blob</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="parameters">
> <structure>
> <property name="name">academic_unit_id</property>
> <property name="dataType">any</property>
> <property name="position">1</property>
> <expression name="defaultValue">3</expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">program_id</property>
> <property name="dataType">any</property>
> <property name="position">2</property>
> <expression name="defaultValue">2</expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">course_id</property>
> <property name="dataType">any</property>
> <property name="position">3</property>
> <expression name="defaultValue">2</expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">program_unit_id</property>
> <property name="dataType">any</property>
> <property name="position">4</property>
> <expression name="defaultValue">9</expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">academic_session_id</property>
> <property name="dataType">any</property>
> <property name="position">5</property>
> <expression name="defaultValue">8</expression>
> <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">syllabus</property>
> <property name="nativeName">syllabus</property>
> <property name="dataType">blob</property>
> <property name="nativeDataType">-4</property>
> </structure>
> </list-property>
> <property name="queryText">select a.syllabus
>
> from subject_curriculum a,subject b,course_offering c,
> course_structure d
> where a.subject_id=b.subject_id and
> a.subject_curriculum_id=c.subject_curriculum_id and
> c.course_structure_item_id=d.course_structure_item_id and
> d.academic_unit_id= ?
> and d.program_id= ?
> and d.course_id= ?
> and d.program_unit_id= ?
> and c.academic_session_id= ?
> group by b.subject_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:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>subject_name</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>200</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>subject_name</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>subject_name</design:label>
> <design:formattingHints>
> <design:displaySize>200</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>subject_code</design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode><
|
|
|
Goto Forum:
Current Time: Thu Sep 19 08:26:53 GMT 2024
Powered by FUDForum. Page generated in 0.04428 seconds
|