Home » Archived » BIRT » Problem in pdf(row cannot be drawn completely at the end the page)
Problem in pdf [message #510361] |
Wed, 27 January 2010 11:03 |
Uttam Ghosh Messages: 39 Registered: July 2009 |
Member |
|
|
Hi ,
I am working on
redhat , mysql 5, java 6, tomcat 5.5.9.
I have a table with multiple rows. When some row cannot be drawn at
the end the page it is drawn partly on the this page and the rest on the next page.
How can i solve this problem???
Please reply me
////////////// this 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>
<scalar-parameter name="faculty_id" id="1126">
<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>
</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_041109</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">concat(a.`first_name`,' ',a.`middle_name`,' ', a.`last_name`)</property>
<property name="displayName">concat(a.`first_name`,' ',a.`middle_name`,' ', a.`last_name`)</property>
</structure>
<structure>
<property name="columnName">permanent_address</property>
<property name="displayName">permanent_address</property>
</structure>
<structure>
<property name="columnName">father_name</property>
<property name="displayName">father_name</property>
</structure>
<structure>
<property name="columnName">mother_name</property>
<property name="displayName">mother_name</property>
</structure>
<structure>
<property name="columnName">telephone_number</property>
<property name="displayName">telephone_number</property>
</structure>
<structure>
<property name="columnName">gender</property>
<property name="displayName">gender</property>
</structure>
<structure>
<property name="columnName">mother_tongue</property>
<property name="displayName">mother_tongue</property>
</structure>
<structure>
<property name="columnName">nationality</property>
<property name="displayName">nationality</property>
</structure>
<structure>
<property name="columnName">sc_st_physically_disabbled_sports</property >
<property name="displayName">sc_st_physically_disabbled_sports</property >
</structure>
<structure>
<property name="columnName">muster_roll_number</property>
<property name="displayName">muster_roll_number</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">concat(a.`first_name`,' ',a.`middle_name`,' ', a.`last_name`)</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">permanent_address</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">father_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">mother_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">telephone_number</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">if(a.`dob`='0000-00-00', '', date_format(a.`dob`,'%D-%M-%Y'))</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">gender</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">mother_tongue</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">nationality</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">sc_st_physically_disabbled_sports</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">muster_roll_number</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="parameters">
<structure>
<property name="name">academic_session_id</property>
<property name="dataType">any</property>
<property name="position">1</property>
<expression name="defaultValue">7</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">academic_unit_id</property>
<property name="dataType">any</property>
<property name="position">2</property>
<expression name="defaultValue">3</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">faculty_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>
</list-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">concat(a.`first_name`,' ',a.`middle_name`,' ', a.`last_name`)</property>
<property name="nativeName">concat(a.`first_name`,' ',a.`middle_name`,' ', a.`last_name`)</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">permanent_address</property>
<property name="nativeName">permanent_address</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">father_name</property>
<property name="nativeName">father_name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">mother_name</property>
<property name="nativeName">mother_name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">telephone_number</property>
<property name="nativeName">telephone_number</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">if(a.`dob`='0000-00-00', '', date_format(a.`dob`,'%D-%M-%Y'))</property>
<property name="nativeName">if(a.`dob`='0000-00-00', '', date_format(a.`dob`,'%d-%m-%Y'))</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">gender</property>
<property name="nativeName">gender</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">mother_tongue</property>
<property name="nativeName">mother_tongue</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">nationality</property>
<property name="nativeName">nationality</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">sc_st_physically_disabbled_sports</property>
<property name="nativeName">sc_st_physically_disabbled_sports</property >
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">muster_roll_number</property>
<property name="nativeName">muster_roll_number</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">SELECT concat(a.`first_name`,' ',a.`middle_name`,' ', a.`last_name`),
a.`permanent_address`, a.`father_name`,
a.`mother_name`, a.`telephone_number`,
if(a.`dob`='0000-00-00', '', date_format(a.`dob`,'%d-%m-%Y'))
,
a.`gender`, a.`mother_tongue`, a.`nationality`,
a.`sc_st_physically_disabbled_sports`, c.`muster_roll_number`
FROM person_details a,
student_personal_details b,
student_enrollment c
WHERE b.person_id=a.person_id
AND c.`student_id`=b.`student_id`
AND c.`academic_session_id`= ?
AND c.`academic_unit_id`= ?
AND c.`course_id`= ?
AND c.`faculty_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="1004">
<list-property name="columnHints">
<structure>
<property name="columnName">name</property>
<property name="displayName">name</property>
</structure>
<structure>
<property name="columnName">name_2</property>
<property name="displayName">name</property>
</structure>
<structure>
<property name="columnName">academic_unit_name</property>
<property name="displayName">academic_unit_name</property>
</structure>
<structure>
<property name="columnName">name_4</property>
<property name="displayName">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">name_2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">academic_unit_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">name_4</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="parameters">
<structure>
<property name="name">academic_session_id</property>
<property name="dataType">any</property>
<property name="position">1</property>
<expression name="defaultValue">8</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">academic_unit_id</property>
<property name="dataType">any</property>
<property name="position">2</property>
<expression name="defaultValue">3</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">faculty_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>
</list-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">name_2</property>
<property name="nativeName">name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</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>
<structure>
<property name="position">4</property>
<property name="name">name_4</property>
<property name="nativeName">name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">SELECT distinct d.`name`,
g.`name`,
e.`academic_unit_name`,
f.`name`
FROM student_enrollment c, academic_session d,
academic_unit e, program f,
academic_program_course_offering g,
faculty_definition h
WHERE d.`academic_session_id`=c.`academic_session_id`
AND e.`academic_unit_id`=c.`academic_unit_id`
AND f.`program_id`=c.`program_id`
AND g.`course_id`=c.`course_id`
AND h.`faculty_id`=c.`faculty_id`
AND d.`academic_session_id`= ?
AND e.`academic_unit_id`= ?
AND g.`course_id`= ?
AND h.`faculty_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>name</design:name>
<design:position>1</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>name</design:name>
<design:position>2</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>name</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>name</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>academic_unit_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>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>4</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:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="crosstab-cell" id="4">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
<property name="paddingTop">0pt</property>
<property name="paddingLeft">0pt</property>
<property name="paddingBottom">0pt</property>
<property name="paddingRight">0pt</property>
</style>
<style name="crosstab" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
<property name="paddingTop">0pt</property>
<property name="paddingLeft">0pt</property>
<property name="paddingBottom">0pt</property>
<property name="paddingRight">0pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="type">a4</property>
<property name="orientation">landscape</property>
<property name="topMargin">0.2in</property>
<property name="leftMargin">0.25in</property>
<property name="bottomMargin">0.4in</property>
<property name="rightMargin">0.25in</property>
<property name="display">block</property>
<property name="pageBreakAfter">auto</property>
<property name="canShrink">true</property>
<property name="headerHeight">0.2in</property>
<property name="footerHeight">0.2in</property>
</simple-master-page>
</page-setup>
<body>
<label id="1220">
<text-property name="text"></text-property>
</label>
<grid id="908">
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<property name="width">100%</property>
<column id="909"/>
<row id="910">
<property name="backgroundColor">#FFFFFF</property>
<cell id="911">
<property name="fontSize">16px</property>
<label id="914">
<property name="fontSize">18px</property>
<text-property name="text">Kurukshetra University, Kurukshetra</text-property>
</label>
</cell>
</row>
<row id="941">
<property name="backgroundColor">#FFFFFF</property>
<cell id="942">
<property name="fontSize">16px</property>
<label id="943">
<text-property name="text">Student Personal Information</text-property>
</label>
</cell>
</row>
<row id="912">
<property name="backgroundColor">#FFFFFF</property>
<cell id="913">
<table id="1005">
<property name="width">100%</property>
<property name="dataSet">header</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">academic_session_id</property>
<expression name="expression">params["academic_session_id"].value</expression >
</structure>
<structure>
<property name="paramName">academic_unit_id</property>
<expression name="expression">params["academic_unit_id"].value</expression >
</structure>
<structure>
<property name="paramName">course_id</property>
<expression name="expression">params["course_id"].value</expression >
</structure>
<structure>
<property name="paramName">faculty_id</property>
<expression name="expression">params["faculty_id"].value</expression >
</structure>
</list-property>
<list-property name="boundDataColumns">
<structure>
<property name="name">name</property>
<property name="displayName">name</property>
<expression name="expression">dataSetRow["name"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">name_2</property>
<property name="displayName">name</property>
<expression name="expression">dataSetRow["name_2"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">academic_unit_name</property>
<property name="displayName">academic_unit_name</property>
<expression name="expression">dataSetRow["academic_unit_name"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">name_4</property>
<property name="displayName">name</property>
<expression name="expression">dataSetRow["name_4"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<column id="1034"/>
<column id="1029"/>
<column id="1039"/>
<column id="1031"/>
<column id="1041"/>
<column id="1032"/>
<detail>
<row id="1015">
<cell id="1033">
<property name="paddingTop">3pt</property>
<property name="paddingLeft">3pt</property>
<property name="paddingBottom">3pt</property>
<property name="paddingRight">3pt</property>
<label id="1035">
<text-property name="text">Session : </text-property>
</label>
</cell>
<cell id="1016">
<property name="paddingTop">3pt</property>
<property name="paddingLeft">3pt</property>
<property name="paddingBottom">3pt</property>
<property name="paddingRight">3pt</property>
<property name="textAlign">left</property>
<data id="1017">
<property name="resultSetColumn">name</property>
</data>
</cell>
<cell id="1038">
<property name="paddingTop">3pt</property>
<property name="paddingLeft">3pt</property>
<property name="paddingBottom">3pt</property>
<property name="paddingRight">3pt</property>
<label id="1042">
<property name="textAlign">center</property>
<text-property name="text"&
|
|
|
Re: Problem in pdf [message #510577 is a reply to message #510361] |
Wed, 27 January 2010 21:19 |
|
Can you try BIRT 2.5.1?
Uttam Ghosh wrote:
> Hi ,
> I am working on
> redhat , mysql 5, java 6, tomcat 5.5.9.
> I have a table with multiple rows. When some row cannot be drawn at
> the end the page it is drawn partly on the this page and the rest on the
> next page.
> How can i solve this problem???
> Please reply me
>
> ////////////// this 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>
> <scalar-parameter name="faculty_id" id="1126">
> <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>
> </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_041109</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">concat(a.`first_name`,'
> ',a.`middle_name`,' ', a.`last_name`)</property>
> <property name="displayName">concat(a.`first_name`,'
> ',a.`middle_name`,' ', a.`last_name`)</property>
> </structure>
> <structure>
> <property name="columnName">permanent_address</property>
> <property
> name="displayName">permanent_address</property>
> </structure>
> <structure>
> <property name="columnName">father_name</property>
> <property name="displayName">father_name</property>
> </structure>
> <structure>
> <property name="columnName">mother_name</property>
> <property name="displayName">mother_name</property>
> </structure>
> <structure>
> <property name="columnName">telephone_number</property>
> <property name="displayName">telephone_number</property>
> </structure>
> <structure>
> <property name="columnName">gender</property>
> <property name="displayName">gender</property>
> </structure>
> <structure>
> <property name="columnName">mother_tongue</property>
> <property name="displayName">mother_tongue</property>
> </structure>
> <structure>
> <property name="columnName">nationality</property>
> <property name="displayName">nationality</property>
> </structure>
> <structure>
> <property
> name="columnName">sc_st_physically_disabbled_sports</property >
> <property
> name="displayName">sc_st_physically_disabbled_sports</property >
> </structure>
> <structure>
> <property
> name="columnName">muster_roll_number</property>
> <property
> name="displayName">muster_roll_number</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">concat(a.`first_name`,'
> ',a.`middle_name`,' ', a.`last_name`)</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">permanent_address</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">father_name</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">mother_name</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">telephone_number</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">if(a.`dob`='0000-00-00',
> '', date_format(a.`dob`,'%D-%M-%Y'))</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">gender</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">mother_tongue</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">nationality</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property
> name="name">sc_st_physically_disabbled_sports</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">muster_roll_number</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="parameters">
> <structure>
> <property name="name">academic_session_id</property>
> <property name="dataType">any</property>
> <property name="position">1</property>
> <expression name="defaultValue">7</expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">academic_unit_id</property>
> <property name="dataType">any</property>
> <property name="position">2</property>
> <expression name="defaultValue">3</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">faculty_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>
> </list-property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">concat(a.`first_name`,'
> ',a.`middle_name`,' ', a.`last_name`)</property>
> <property name="nativeName">concat(a.`first_name`,'
> ',a.`middle_name`,' ', a.`last_name`)</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">permanent_address</property>
> <property name="nativeName">permanent_address</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">father_name</property>
> <property name="nativeName">father_name</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">mother_name</property>
> <property name="nativeName">mother_name</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">telephone_number</property>
> <property name="nativeName">telephone_number</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">if(a.`dob`='0000-00-00', '',
> date_format(a.`dob`,'%D-%M-%Y'))</property>
> <property name="nativeName">if(a.`dob`='0000-00-00',
> '', date_format(a.`dob`,'%d-%m-%Y'))</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">gender</property>
> <property name="nativeName">gender</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">mother_tongue</property>
> <property name="nativeName">mother_tongue</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">nationality</property>
> <property name="nativeName">nationality</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property
> name="name">sc_st_physically_disabbled_sports</property>
> <property
> name="nativeName">sc_st_physically_disabbled_sports</property >
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">muster_roll_number</property>
> <property
> name="nativeName">muster_roll_number</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> </list-property>
> <property name="queryText">SELECT concat(a.`first_name`,'
> ',a.`middle_name`,' ', a.`last_name`), a.`permanent_address`,
> a.`father_name`, a.`mother_name`, a.`telephone_number`,
> if(a.`dob`='0000-00-00', '', date_format(a.`dob`,'%d-%m-%Y'))
> ,
>
> a.`gender`, a.`mother_tongue`, a.`nationality`,
> a.`sc_st_physically_disabbled_sports`, c.`muster_roll_number`
>
> FROM person_details a,
> student_personal_details b,
> student_enrollment c
>
> WHERE b.person_id=a.person_id AND c.`student_id`=b.`student_id`
>
> AND c.`academic_session_id`= ?
> AND c.`academic_unit_id`= ?
> AND c.`course_id`= ?
> AND c.`faculty_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="1004">
> <list-property name="columnHints">
> <structure>
> <property name="columnName">name</property>
> <property name="displayName">name</property>
> </structure>
> <structure>
> <property name="columnName">name_2</property>
> <property name="displayName">name</property>
> </structure>
> <structure>
> <property
> name="columnName">academic_unit_name</property>
> <property
> name="displayName">academic_unit_name</property>
> </structure>
> <structure>
> <property name="columnName">name_4</property>
> <property name="displayName">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">name_2</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">academic_unit_name</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">name_4</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="parameters">
> <structure>
> <property name="name">academic_session_id</property>
> <property name="dataType">any</property>
> <property name="position">1</property>
> <expression name="defaultValue">8</expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">academic_unit_id</property>
> <property name="dataType">any</property>
> <property name="position">2</property>
> <expression name="defaultValue">3</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">faculty_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>
> </list-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">name_2</property>
> <property name="nativeName">name</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</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>
> <structure>
> <property name="position">4</property>
> <property name="name">name_4</property>
> <property name="nativeName">name</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> </list-property>
> <property name="queryText">SELECT distinct d.`name`,
> g.`name`, e.`academic_unit_name`, f.`name`
> FROM student_enrollment c, academic_session d, academic_unit e, program
> f, academic_program_course_offering g, faculty_definition h
>
> WHERE d.`academic_session_id`=c.`academic_session_id` AND
> e.`academic_unit_id`=c.`academic_unit_id` AND
> f.`program_id`=c.`program_id` AND g.`course_id`=c.`course_id`
> AND h.`faculty_id`=c.`faculty_id`
> AND d.`academic_session_id`= ?
> AND e.`academic_unit_id`= ?
> AND g.`course_id`= ?
> AND h.`faculty_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>name</design:name>
> <design:position>1</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>name</design:name>
> <design:position>2</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>name</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>name</design:label>
> <design:formattingHints>
> <design:displaySize>100</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>academic_unit_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>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>4</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:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="crosstab-cell" id="4">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> <property name="paddingTop">0pt</property>
> <property name="paddingLeft">0pt</property>
> <property name="paddingBottom">0pt</property>
> <property name="paddingRight">0pt</property>
> </style>
> <style name="crosstab" id="5">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> <property name="paddingTop">0pt</property>
> <property name="paddingLeft">0pt</property>
> <property name="paddingBottom">0pt</property>
> <property name="paddingRight">0pt</property>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <property name="type">a4</property>
> <property name="orientation">landscape</property>
> <property name="topMargin">0.2in</property>
> <property name="leftMargin">0.25in</property>
> <property name="bottomMargin">0.4in</property>
> <property name="rightMargin">0.25in</property>
> <property name="display">block</property>
> <property name="pageBreakAfter">auto</property>
> <property name="canShrink">true</property>
> <property name="headerHeight">0.2in</property>
> <property name="footerHeight">0.2in</property>
> </simple-master-page>
> </page-setup>
> <body>
> <label id="1220">
> <text-property name="text"></text-property>
> </label>
> <grid id="908">
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <property name="width">100%</property>
> <column id="909"/>
> <row id="910">
> <property name="backgroundColor">#FFFFFF</property>
> <cell id="911">
> <property name="fontSize">16px</property>
> <label id="914">
> <property name="fontSize">18px</property>
> <text-property name="text">Kurukshetra
> University, Kurukshetra</text-property>
> </label>
> </cell>
> </row>
> <row id="941">
> <property name="backgroundColor">#FFFFFF</property>
> <cell id="942">
> <property name="fontSize">16px</property>
> <label id="943">
> <text-property name="text">Student Personal
> Information</text-property>
> </label>
> </cell>
> </row>
> <row id="912">
> <property name="backgroundColor">#FFFFFF</property>
> <cell id="913">
> <table id="1005">
> <property name="width">100%</property>
> <property name="dataSet">header</property>
> <list-property name="paramBindings">
> <structure>
> <property
> name="paramName">academic_session_id</property>
> <expression
> name="expression">params["academic_session_id"].value</expression >
> </structure>
> <structure>
> <property
> name="paramName">academic_unit_id</property>
> <expression
> name="expression">params["academic_unit_id"].value</expression >
> </structure>
> <structure>
> <property
> name="paramName">course_id</property>
> <expression
> name="expression">params["course_id"].value</expression >
> </structure>
> <structure>
> <property
> name="paramName">faculty_id</property>
> <expression
> name="expression">params["faculty_id"].value</expression >
> </structure>
> </list-property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">name</property>
> <property name="displayName">name</property>
> <expression
> name="expression">dataSetRow["name"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">name_2</property>
> <property name="displayName">name</property>
> <expression
> name="expression">dataSetRow["name_2"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
>
|
|
| |
Re: Problem in pdf [message #511530 is a reply to message #511305] |
Mon, 01 February 2010 22:11 |
|
I am pretty certain this bug was fixed in the 2.5.1 release. I do not
know of a work around with the exception of playing with putting page
breaks on various elements. You may be able to search bugzilla to find
where it was fixed and add a comment to the bug.
Jason
Uttam Ghosh wrote:
> Thanks Jeson for your reply.
> I had tried with BIRT 2.5.0 before writing in this community. But due
> to some reason I can't be able to update birt at this moment. I have
> to develop by this version. Is it not possible to solve this problem in
> birt 2.3 ????
>
> Please reply
|
|
| |
Goto Forum:
Current Time: Fri Apr 26 14:58:10 GMT 2024
Powered by FUDForum. Page generated in 0.03675 seconds
|