Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Birt Report Layuot(How to set inner table size to display full data row in a nested tables)
Birt Report Layuot [message #526765] Mon, 12 April 2010 20:24 Go to next message
Amy is currently offline Amy Friend
Messages: 29
Registered: April 2010
Junior Member
Hi,

I have a question for report layout.

I have 3 nested tables based on the data set. The 3rd inner table return differnt row data back. If I set the 2nd inner table size small, in the PDF file, I can't see all values for 3rd table.

How I can set the table size?

Thanks!

Report message to a moderator

Re: Birt Report Layuot [message #526979 is a reply to message #526765] Tue, 13 April 2010 15:37 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
Amy,

Are you using fixed or auto layout? Are you setting the width of any of
the tables?

Jason

Amy wrote:
> Hi,
>
> I have a question for report layout.
> I have 3 nested tables based on the data set. The 3rd inner table
> return differnt row data back. If I set the 2nd inner table size
> small, in the PDF file, I can't see all values for 3rd table.
> How I can set the table size?
>
> Thanks!

Report message to a moderator

Re: Birt Report Layuot [message #527028 is a reply to message #526979] Tue, 13 April 2010 18:29 Go to previous messageGo to next message
Amy is currently offline Amy Friend
Messages: 29
Registered: April 2010
Junior Member
Jason,

I set the width for 3 tables.

I am not sure where to set fixed or auto layout. I drag the table and inset 2nd table inside, and insert another one into the 2nd table. So, 3 nested table together.


1 table : 9.98 in
2 table: 9.9 in
3 table: 9.89 in



Thanks!

Amy

Report message to a moderator

Re: Birt Report Layuot [message #527047 is a reply to message #527028] Tue, 13 April 2010 19:47 Go to previous messageGo to next message
roadblock2thesun is currently offline roadblock2thesunFriend
Messages: 14
Registered: April 2010
Junior Member
The auto/fixed layout selection is at the very bottom of the the general section of the properties tab of the report design

Report message to a moderator

Re: Birt Report Layuot [message #527093 is a reply to message #527047] Wed, 14 April 2010 03:28 Go to previous messageGo to next message
Amy is currently offline Amy Friend
Messages: 29
Registered: April 2010
Junior Member
Jason ,

This works!

Thank you so much!!!

After I fix the 2nd and 3rd table, the data display good. But I have a new probelm coming up:

User only want to see the 1st table header once. I uncheck the repeat header, the header only show one time. But some times, the 1st table only show the header and 1 grid data on the first page, the 2nd/3rd table start a new page to show data. So, the first page look strange, only has a table header and a small data, all other are blank space. Start the 2nd page, the data repeat show on the following pages.

I try to play around the pagebreak, I didn't see the improvement.

If the data come back in 2nd/3rd table with small dataset, they connect with the 1st table header. Otherwise, it start a new page to display data.

Can you give some suggestion?

Thanks again!

Amy

[Updated on: Wed, 14 April 2010 04:03]

Report message to a moderator

Re: Birt Report Layuot [message #527095 is a reply to message #527047] Wed, 14 April 2010 04:01 Go to previous messageGo to next message
Amy is currently offline Amy Friend
Messages: 29
Registered: April 2010
Junior Member
Hi, roadblock2thesun,

Thank you so much! I find the auto/fixed layout selection place and it works after I use auto layout.

Amy

[Updated on: Wed, 14 April 2010 04:02]

Report message to a moderator

Re: Birt Report Layuot [message #527237 is a reply to message #527093] Wed, 14 April 2010 14:28 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
Amy,

Try modifying the page break interval on the tables page break property.
This will determine how many rows to display before doing a page break.

Jason

Amy wrote:
> Jason,
>
> This works!
>
> Thank you so much!!!
>
> After I fix the 2nd and 3rd table, the data display good. But I have a
> new probelm coming up:
>
> User only want to see the 1st table header once. I uncheck the repeat
> header, the header only show one time. But some times, the 1st table
> only show the header and 1 grid data on the first page, the 2nd/3rd
> table start a new page to show data. So, the first page look strange,
> only has a table header and a small data, all other are blank space.
> Start the 2nd page, the data repeat show on the following pages.
>
> I try to play around the pagebreak, I didn't see the improvement.
> If the data come back in 2nd/3rd table with small dataset, they connect
> with the 1st table header. Otherwise, it start a new page to display data.
>
> Can you give some suggestion?
>
> Thanks again!
>
> Amy

Report message to a moderator

Re: Birt Report Layuot [message #527327 is a reply to message #526765] Wed, 14 April 2010 20:29 Go to previous messageGo to next message
Amy is currently offline Amy Friend
Messages: 29
Registered: April 2010
Junior Member
Jason,


I try to modified the page break, interval setting. The report has no change.

The first page always has issue. If small data set back, teh data dispaly together. If bigger set data back, the 2nd table start a new page. The first page only has header and one grid data ( first table data) show.

I try to set the pageBreak before: Avoid for 2nd tale, it still go to the new page.

What is the Max number for page interval setting? Default is 40. I try 100, 200. It didn't work.

Can you help to look at the code?

Thanks!

**********************
Here is my file:

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.5.2.v20100208 Build &lt;2.5.2.v20100210-0630></property>
<property name="units">in</property>
<text-property name="displayName">Quote Report 1</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="layoutPreference">auto layout</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<data-sources>
<script-data-source name="Data Source Quote" id="7"/>
</data-sources>
<data-sets>
<script-data-set name="Quote" id="8">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">PolicyNumber</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">QuoteName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">DownloadDate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">State</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ReinsuranceYear</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">Producer</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ProducerAdd1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">ProducerAdd2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">ProducerCity</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">ProducerState</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">ProducerZip</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">ProducerPhone</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">AgencyName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">AgencyCode</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">AgencyAdd1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">AgencyAdd2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">AgencyCity</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">AgencyState</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">AgencyZip</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">AgencyPhone</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">CountyLines</property>
<property name="dataType">javaObject</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">CountyCropLists</property>
<property name="dataType">javaObject</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">PolicyNumber</property>
<text-property name="displayName">Policy Number</text-property>
</structure>
<structure>
<property name="columnName">QuoteName</property>
<text-property name="displayName">Quote Name</text-property>
</structure>
<structure>
<property name="columnName">DownloadDate</property>
<text-property name="displayName">Download Date</text-property>
</structure>
<structure>
<property name="columnName">State</property>
<text-property name="displayName">State</text-property>
</structure>
<structure>
<property name="columnName">ReinsuranceYear</property>
<text-property name="displayName">Reinsurance Year</text-property>
</structure>
<structure>
<property name="columnName">Producer</property>
<text-property name="displayName">Producer</text-property>
</structure>
<structure>
<property name="columnName">ProducerAdd1</property>
<property name="alias">Producer Add1</property>
<text-property name="displayName">Producer Add1</text-property>
</structure>
<structure>
<property name="columnName">ProducerAdd2</property>
<property name="alias">Producer Add2</property>
<text-property name="displayName">Producer Add2</text-property>
</structure>
<structure>
<property name="columnName">ProducerCity</property>
<property name="alias">Producer City</property>
<text-property name="displayName">Producer City</text-property>
</structure>
<structure>
<property name="columnName">ProducerState</property>
<property name="alias">Producer State</property>
<text-property name="displayName">Producer State</text-property>
</structure>
<structure>
<property name="columnName">ProducerZip</property>
<property name="alias">Producer Zip</property>
<text-property name="displayName">Producer Zip</text-property>
</structure>
<structure>
<property name="columnName">ProducerPhone</property>
<property name="alias">Producer Phone</property>
<text-property name="displayName">Producer Phone</text-property>
</structure>
<structure>
<property name="columnName">AgencyName</property>
<property name="alias">Agency Name</property>
<text-property name="displayName">Agency Name</text-property>
</structure>
<structure>
<property name="columnName">AgencyCode</property>
<text-property name="displayName">Agency Code</text-property>
</structure>
<structure>
<property name="columnName">AgencyAdd1</property>
<property name="alias">Agency Add1</property>
<text-property name="displayName">Agency Add1</text-property>
</structure>
<structure>
<property name="columnName">AgencyAdd2</property>
<property name="alias">Agency Add2</property>
<text-property name="displayName">Agency Add2</text-property>
</structure>
<structure>
<property name="columnName">AgencyCity</property>
<property name="alias">Agency City</property>
<text-property name="displayName">Agency City</text-property>
</structure>
<structure>
<property name="columnName">AgencyState</property>
<property name="alias">Agency State</property>
<text-property name="displayName">Agency State</text-property>
</structure>
<structure>
<property name="columnName">AgencyZip</property>
<property name="alias">Agency Zip</property>
<text-property name="displayName">Agency Zip</text-property>
</structure>
<structure>
<property name="columnName">AgencyPhone</property>
<property name="alias">Agency Phone</property>
<text-property name="displayName">Agency Phone</text-property>
</structure>
<structure>
<property name="columnName">CountyLines</property>
<text-property name="displayName">CountyLines</text-property>
</structure>
<structure>
<property name="columnName">CountyCropLists</property>
<text-property name="displayName">CountyCrop Lists</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">PolicyNumber</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">QuoteName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">DownloadDate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">State</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ReinsuranceYear</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">Producer</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">Producer Add1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">Producer Add2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">Producer City</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">Producer State</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">Producer Zip</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">Producer Phone</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">Agency Name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">AgencyCode</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">Agency Add1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">Agency Add2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">Agency City</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">Agency State</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">Agency Zip</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">Agency Phone</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">CountyLines</property>
<property name="dataType">javaObject</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">CountyCropLists</property>
<property name="dataType">javaObject</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source Quote</property>
<method name="open"><![CDATA[count = 0;

quoteDao = new Packages.com.gaic.quoter.reports.model.ReportQuoteDao();
rptQuoteList = quoteDao.getReportQuoteList();
//var rptCountyCropList;
//var rptQuote;
//var rptAcreageLineList;
//var AcreageLinesTemp;
]]></method>
<method name="fetch"><![CDATA[if(count < rptQuoteList.size())
{
rptQuote = rptQuoteList.get(count);

//Quote Info.
row["PolicyNumber"] = rptQuote.getPolicyNumber();
row["QuoteName"] = rptQuote.getQuoteName();
row["Producer"] = rptQuote.getProducer();
row["DownloadDate"] = rptQuote.getDownloadDate();
row["ReinsuranceYear"] = rptQuote.getReinsuranceYear().toString();
row["State"] = rptQuote.getState().toString();

//Producer
row["Producer"] = rptQuote.getProducer();
row["ProducerAdd1"] = rptQuote.getProducerAdd1();
row["ProducerAdd2"] = rptQuote.getProducerAdd2();
row["ProducerCity"] = rptQuote.getProducerCity();
row["ProducerState"] = rptQuote.getProducerState();
row["ProducerZip"] = rptQuote.getProducerZip();
row["ProducerPhone"] = rptQuote.getProducerPhone();

//Agency
row["AgencyName"] = rptQuote.getAgencyName();
row["AgencyCode"] = rptQuote.getAgencyCode();
row["AgencyAdd1"] = rptQuote.getAgencyAdd1();
row["AgencyAdd2"] = rptQuote.getAgencyAdd2();
row["AgencyCity"] = rptQuote.getAgencyCity();
row["AgencyState"] = rptQuote.getAgencyState();
row["AgencyZip"] = rptQuote.getAgencyZip();
row["AgencyPhone"] = rptQuote.getAgencyPhone();


//County Crop
//row["CountyCropLists"] = rptQuote.getReportCountyCrops();
rptCountyCropList = rptQuote.getReportCountyCrops();

count++;

return true;
}

return false;

]]></method>
<method name="close"><![CDATA[rptQuoteList = null;
]]></method>
</script-data-set>
<script-data-set name="CountyCrop" id="551">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">County</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Crop</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Practice</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">Type</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">InsurancePlan</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">UnitOption</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">Options</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CoverageLevel</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">Quote</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">Rid</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">PricePct</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">CountyCode</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CropCode</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">UnitOptionCode</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">OptionCode</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">CCovType</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">DisplayCode</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">AcreageLines</property>
<property name="dataType">javaObject</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">InsurancePlanCode</property>
<property name="dataType">string</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">County</property>
<text-property name="displayName">County</text-property>
</structure>
<structure>
<property name="columnName">Crop</property>
<text-property name="displayName">Crop</text-property>
</structure>
<structure>
<property name="columnName">Practice</property>
<text-property name="displayName">Practice</text-property>
</structure>
<structure>
<property name="columnName">Type</property>
<text-property name="displayName">Type</text-property>
</structure>
<structure>
<property name="columnName">InsurancePlan</property>
<property name="alias">Insurance Plan</property>
<text-property name="displayName">InsurancePlan</text-property>
</structure>
<structure>
<property name="columnName">UnitOption</property>
<text-property name="displayName">UnitOption</text-property>
</structure>
<structure>
<property name="columnName">Options</property>
<text-property name="displayName">Options</text-property>
</structure>
<structure>
<property name="columnName">CoverageLevel</property>
<text-property name="displayName">CoverageLevel</text-property>
</structure>
<structure>
<property name="columnName">Quote</property>
<text-property name="displayName">Quote</text-property>
</structure>
<structure>
<property name="columnName">Rid</property>
<text-property name="displayName">Rid</text-property>
</structure>
<structure>
<property name="columnName">PricePct</property>
<text-property name="displayName">PricePct</text-property>
</structure>
<structure>
<property name="columnName">CountyCode</property>
<property name="alias">County Code</property>
<text-property name="displayName">County Code</text-property>
</structure>
<structure>
<property name="columnName">CropCode</property>
<property name="alias">Crop Code</property>
<text-property name="displayName">Crop Code</text-property>
</structure>
<structure>
<property name="columnName">UnitOptionCode</property>
<property name="alias">UnitOption Code</property>
<text-property name="displayName">UnitOption Code</text-property>
</structure>
<structure>
<property name="columnName">OptionCode</property>
<property name="alias">Option Code</property>
<text-property name="displayName">Option Code</text-property>
</structure>
<structure>
<property name="columnName">CCovType</property>
<property name="alias">ccCov Type</property>
<text-property name="displayName">ccCov Type</text-property>
</structure>
<structure>
<property name="columnName">DisplayCode</property>
<property name="alias">Display Code</property>
<text-property name="displayName">Display Code</text-property>
</structure>
<structure>
<property name="columnName">AcreageLines</property>
<text-property name="displayName">AcreageLines</text-property>
</structure>
<structure>
<property name="columnName">InsurancePlanCode</property>
<text-property name="displayName">InsurancePlanCode</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">County</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Crop</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Practice</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">Type</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">Insurance Plan</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">UnitOption</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">Options</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CoverageLevel</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">Quote</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">Rid</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">PricePct</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">County Code</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">Crop Code</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">UnitOption Code</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">Option Code</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">ccCov Type</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">Display Code</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">AcreageLines</property>
<property name="dataType">javaObject</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">InsurancePlanCode</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source Quote</property>
<method name="open"><![CDATA[countCountyCrop = 0;
//rptCountyCropList=CountyCropListTemp
rptCountyCropList = rptQuote.getReportCountyCrops();
//var rptAcreageLineList;
//var AcreageLinesTemp;


]]></method>
<method name="fetch"><![CDATA[if(countCountyCrop < rptQuote.getReportCountyCrops().size())
{
//rptCountyCropList = rptQuote.getReportCountyCrops();

rptCountyCrop = rptCountyCropList.get(countCountyCrop);

row["County"] = rptCountyCrop.getCounty().getName();
row["CountyCode"] = rptCountyCrop.getCounty().getCode();
row["Crop"] = rptCountyCrop.getCrop().getName() ;
row["Crop Code"] = rptCountyCrop.getCrop().getCode() ;
row["Practice"] = rptCountyCrop.getPractice();
row["Type"] = rptCountyCrop.getType() ;
row["InsurancePlan"] = rptCountyCrop.getInsurancePlan() ;
row["InsurancePlanCode"] = rptCountyCrop.getInsurancePlan().getCode();

row["UnitOption"] = rptCountyCrop.getUnitOption().getName() ;
row["UnitOption Code"] = rptCountyCrop.getUnitOption().getCode() ;

row["Options"] = rptCountyCrop.getOptionName() ;
row["Option Code"] = rptCountyCrop.getOptionCode() ;
row["ccCov Type"] = rptCountyCrop.getCcCovType() ;
row["Display Code"] = rptCountyCrop.getDisplayCode() ;

row["CoverageLevel"] = rptCountyCrop.getCoverageLevel() ;
row["PricePct"] = rptCountyCrop.getPricePercent() ;
row["Rid"] = rptCountyCrop.getRid() ;

row["AcreageLines"] = rptCountyCrop.getReportAcreageLines();
//rptAcreageLineList = rptCountyCrop.getReportAcreageLines();

countCountyCrop++;

return true;
}

return false;
]]></method>
<method name="close"><![CDATA[ ]]></method>
</script-data-set>
<script-data-set name="AcreageLine" id="555">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">Acres</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Share</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">RateClassOptions</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">MapArea</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">Yield</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">RateYield</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">YieldCupSurcharge</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">ReportCountyCrop</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">Rid</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">Premium</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">Practice</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">Type</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">Unit</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">LineNumber</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">GuaranteePerAcre</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">TotalGuarantee</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">LiabilityPerAcre</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">Totalliability</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">TotalPremiumPerAcre</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">TotalPremium</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">SubsidyPerAcre</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">TotalSubsidy</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">ProducerPremiumPerAcre</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">TotalProducerPremium</property>
<property name="dataType">integer</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">Acres</property>
<text-property name="displayName">Acres</text-property>
</structure>
<structure>
<property name="columnName">Share</property>
<text-property name="displayName">Share</text-property>
</structure>
<structure>
<property name="columnName">RateClassOptions</property>
<text-property name="displayName">RateClassOptions</text-property>
</structure>
<structure>
<property name="columnName">MapArea</property>
<text-property name="displayName">MapArea</text-property>
</structure>
<structure>
<property name="columnName">Yield</property>
<text-property name="displayName">Yield</text-property>
</structure>
<structure>
<property name="columnName">RateYield</property>
<text-property name="displayName">RateYield</text-property>
</structure>
<structure>
<property name="columnName">YieldCupSurcharge</property>
<text-property name="displayName">YieldCupSurcharge</text-property>
</structure>
<structure>
<property name="columnName">ReportCountyCrop</property>
<text-property name="displayName">ReportCountyCrop</text-property>
</structure>
<structure>
<property name="columnName">Rid</property>
<text-property name="displayName">Rid</text-property>
</structure>
<structure>
<property name="columnName">Premium</property>
<text-property name="displayName">Premium</text-property>
</structure>
<structure>
<property name="columnName">Practice</property>
<text-property name="displayName">Practice</text-property>
</structure>
<structure>
<property name="columnName">Type</property>
<text-property name="displayName">Type</text-property>
</structure>
<structure>
<property name="columnName">Unit</property>
<text-property name="displayName">Unit</text-property>
</structure>
<structure>
<property name="columnName">LineNumber</property>
<text-property name="displayName">LineNumber</text-property>
</structure>

[Updated on: Wed, 14 April 2010 20:30]

Report message to a moderator

Re: Birt Report Layuot [message #527541 is a reply to message #527327] Thu, 15 April 2010 14:42 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
Amy,

you set it to 0 and it will be ignored. Can you reproduce your report
with the sample db? If you can post that sample.

Jason

Amy wrote:
> Jason,
>
>
> I try to modified the page break, interval setting. The report has change.
> The first page always has issue. If small data set back, teh data
> dispaly together. If bigger set data back, the 2nd table start a new
> page. The first page only has header and one grid data ( first table
> data) show.
> I try to set the pageBreak before: Avoid for 2nd tale, it still go to
> the new page.
>
> What is the Max number for page interval setting? Default is 40. I
> try 100, 200. It didn't work.
>
> Can you help to look at the code?
>
> Thanks!
>
> **********************
> Here is my file:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.5.2.v20100208 Build <2.5.2.v20100210-0630></property>
> <property name="units">in</property>
> <text-property name="displayName">Quote Report 1</text-property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="layoutPreference">auto layout</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <property name="imageDPI">96</property>
> <data-sources>
> <script-data-source name="Data Source Quote" id="7"/>
> </data-sources>
> <data-sets>
> <script-data-set name="Quote" id="8">
> <list-property name="resultSetHints">
> <structure>
> <property name="position">1</property>
> <property name="name">PolicyNumber</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">QuoteName</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">DownloadDate</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">State</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">ReinsuranceYear</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">Producer</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">ProducerAdd1</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">ProducerAdd2</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">ProducerCity</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">ProducerState</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">ProducerZip</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">ProducerPhone</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">AgencyName</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">AgencyCode</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">AgencyAdd1</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">AgencyAdd2</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">AgencyCity</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">18</property>
> <property name="name">AgencyState</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">19</property>
> <property name="name">AgencyZip</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">20</property>
> <property name="name">AgencyPhone</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">21</property>
> <property name="name">CountyLines</property>
> <property name="dataType">javaObject</property>
> </structure>
> <structure>
> <property name="position">22</property>
> <property name="name">CountyCropLists</property>
> <property name="dataType">javaObject</property>
> </structure>
> </list-property>
> <list-property name="columnHints">
> <structure>
> <property name="columnName">PolicyNumber</property>
> <text-property name="displayName">Policy
> Number</text-property>
> </structure>
> <structure>
> <property name="columnName">QuoteName</property>
> <text-property name="displayName">Quote
> Name</text-property>
> </structure>
> <structure>
> <property name="columnName">DownloadDate</property>
> <text-property name="displayName">Download
> Date</text-property>
> </structure>
> <structure>
> <property name="columnName">State</property>
> <text-property name="displayName">State</text-property>
> </structure>
> <structure>
> <property name="columnName">ReinsuranceYear</property>
> <text-property name="displayName">Reinsurance
> Year</text-property>
> </structure>
> <structure>
> <property name="columnName">Producer</property>
> <text-property
> name="displayName">Producer</text-property>
> </structure>
> <structure>
> <property name="columnName">ProducerAdd1</property>
> <property name="alias">Producer Add1</property>
> <text-property name="displayName">Producer
> Add1</text-property>
> </structure>
> <structure>
> <property name="columnName">ProducerAdd2</property>
> <property name="alias">Producer Add2</property>
> <text-property name="displayName">Producer
> Add2</text-property>
> </structure>
> <structure>
> <property name="columnName">ProducerCity</property>
> <property name="alias">Producer City</property>
> <text-property name="displayName">Producer
> City</text-property>
> </structure>
> <structure>
> <property name="columnName">ProducerState</property>
> <property name="alias">Producer State</property>
> <text-property name="displayName">Producer
> State</text-property>
> </structure>
> <structure>
> <property name="columnName">ProducerZip</property>
> <property name="alias">Producer Zip</property>
> <text-property name="displayName">Producer
> Zip</text-property>
> </structure>
> <structure>
> <property name="columnName">ProducerPhone</property>
> <property name="alias">Producer Phone</property>
> <text-property name="displayName">Producer
> Phone</text-property>
> </structure>
> <structure>
> <property name="columnName">AgencyName</property>
> <property name="alias">Agency Name</property>
> <text-property name="displayName">Agency
> Name</text-property>
> </structure>
> <structure>
> <property name="columnName">AgencyCode</property>
> <text-property name="displayName">Agency
> Code</text-property>
> </structure>
> <structure>
> <property name="columnName">AgencyAdd1</property>
> <property name="alias">Agency Add1</property>
> <text-property name="displayName">Agency
> Add1</text-property>
> </structure>
> <structure>
> <property name="columnName">AgencyAdd2</property>
> <property name="alias">Agency Add2</property>
> <text-property name="displayName">Agency
> Add2</text-property>
> </structure>
> <structure>
> <property name="columnName">AgencyCity</property>
> <property name="alias">Agency City</property>
> <text-property name="displayName">Agency
> City</text-property>
> </structure>
> <structure>
> <property name="columnName">AgencyState</property>
> <property name="alias">Agency State</property>
> <text-property name="displayName">Agency
> State</text-property>
> </structure>
> <structure>
> <property name="columnName">AgencyZip</property>
> <property name="alias">Agency Zip</property>
> <text-property name="displayName">Agency
> Zip</text-property>
> </structure>
> <structure>
> <property name="columnName">AgencyPhone</property>
> <property name="alias">Agency Phone</property>
> <text-property name="displayName">Agency
> Phone</text-property>
> </structure>
> <structure>
> <property name="columnName">CountyLines</property>
> <text-property
> name="displayName">CountyLines</text-property>
> </structure>
> <structure>
> <property name="columnName">CountyCropLists</property>
> <text-property name="displayName">CountyCrop
> Lists</text-property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">PolicyNumber</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">QuoteName</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">DownloadDate</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">State</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">ReinsuranceYear</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">Producer</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">Producer Add1</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">Producer Add2</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">Producer City</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">Producer State</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">Producer Zip</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">Producer Phone</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">Agency Name</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">AgencyCode</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">Agency Add1</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">Agency Add2</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">Agency City</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">18</property>
> <property name="name">Agency State</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">19</property>
> <property name="name">Agency Zip</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">20</property>
> <property name="name">Agency Phone</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">21</property>
> <property name="name">CountyLines</property>
> <property name="dataType">javaObject</property>
> </structure>
> <structure>
> <property name="position">22</property>
> <property name="name">CountyCropLists</property>
> <property name="dataType">javaObject</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source Quote</property>
> <method name="open"><![CDATA[count = 0;
>
> quoteDao = new Packages.com.gaic.quoter.reports.model.ReportQuoteDao();
> rptQuoteList = quoteDao.getReportQuoteList();
> //var rptCountyCropList;
> //var rptQuote;
> //var rptAcreageLineList;
> //var AcreageLinesTemp;
> ]]></method>
> <method name="fetch"><![CDATA[if(count < rptQuoteList.size())
> { rptQuote = rptQuoteList.get(count);
> //Quote Info.
> row["PolicyNumber"] = rptQuote.getPolicyNumber();
> row["QuoteName"] = rptQuote.getQuoteName();
> row["Producer"] = rptQuote.getProducer();
> row["DownloadDate"] = rptQuote.getDownloadDate();
> row["ReinsuranceYear"] = rptQuote.getReinsuranceYear().toString();
> row["State"] = rptQuote.getState().toString();
> //Producer
> row["Producer"] = rptQuote.getProducer();
> row["ProducerAdd1"] = rptQuote.getProducerAdd1();
> row["ProducerAdd2"] = rptQuote.getProducerAdd2();
> row["ProducerCity"] = rptQuote.getProducerCity();
> row["ProducerState"] = rptQuote.getProducerState();
> row["ProducerZip"] = rptQuote.getProducerZip();
> row["ProducerPhone"] = rptQuote.getProducerPhone();
> //Agency
> row["AgencyName"] = rptQuote.getAgencyName();
> row["AgencyCode"] = rptQuote.getAgencyCode();
> row["AgencyAdd1"] = rptQuote.getAgencyAdd1();
> row["AgencyAdd2"] = rptQuote.getAgencyAdd2();
> row["AgencyCity"] = rptQuote.getAgencyCity();
> row["AgencyState"] = rptQuote.getAgencyState();
> row["AgencyZip"] = rptQuote.getAgencyZip();
> row["AgencyPhone"] = rptQuote.getAgencyPhone();
>
> //County Crop
> //row["CountyCropLists"] = rptQuote.getReportCountyCrops();
> rptCountyCropList = rptQuote.getReportCountyCrops();
> count++; return true;
> }
>
> return false;
>
> ]]></method>
> <method name="close"><![CDATA[rptQuoteList = null;
> ]]></method>
> </script-data-set>
> <script-data-set name="CountyCrop" id="551">
> <list-property name="resultSetHints">
> <structure>
> <property name="position">1</property>
> <property name="name">County</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">Crop</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">Practice</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">Type</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">InsurancePlan</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">UnitOption</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">Options</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">CoverageLevel</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">Quote</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">Rid</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">PricePct</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">CountyCode</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">CropCode</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">UnitOptionCode</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">OptionCode</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">CCovType</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">DisplayCode</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">18</property>
> <property name="name">AcreageLines</property>
> <property name="dataType">javaObject</property>
> </structure>
> <structure>
> <property name="position">19</property>
> <property name="name">InsurancePlanCode</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> <list-property name="columnHints">
> <structure>
> <property name="columnName">County</property>
> <text-property name="displayName">County</text-property>
> </structure>
> <structure>
> <property name="columnName">Crop</property>
> <text-property name="displayName">Crop</text-property>
> </structure>
> <structure>
> <property name="columnName">Practice</property>
> <text-property
> name="displayName">Practice</text-property>
> </structure>
> <structure>
> <property name="columnName">Type</property>
> <text-property name="displayName">Type</text-property>
> </structure>
> <structure>
> <property name="columnName">InsurancePlan</property>
> <property name="alias">Insurance Plan</property>
> <text-property
> name="displayName">InsurancePlan</text-property>
> </structure>
> <structure>
> <property name="columnName">UnitOption</property>
> <text-property
> name="displayName">UnitOption</text-property>
> </structure>
> <structure>
> <property name="columnName">Options</property>
> <text-property
> name="displayName">Options</text-property>
> </structure>
> <structure>
> <property name="columnName">CoverageLevel</property>
> <text-property
> name="displayName">CoverageLevel</text-property>
> </structure>
> <structure>
> <property name="columnName">Quote</property>
> <text-property name="displayName">Quote</text-property>
> </structure>
> <structure>
> <property name="columnName">Rid</property>
> <text-property name="displayName">Rid</text-property>
> </structure>
> <structure>
> <property name="columnName">PricePct</property>
> <text-property
> name="displayName">PricePct</text-property>
> </structure>
> <structure>
> <property name="columnName">CountyCode</property>
> <property name="alias">County Code</property>
> <text-property name="displayName">County
> Code</text-property>
> </structure>
> <structure>
> <property name="columnName">CropCode</property>
> <property name="alias">Crop Code</property>
> <text-property name="displayName">Crop
> Code</text-property>
> </structure>
> <structure>
> <property name="columnName">UnitOptionCode</property>
> <property name="alias">UnitOption Code</property>
> <text-property name="displayName">UnitOption
> Code</text-property>
> </structure>
> <structure>
> <property name="columnName">OptionCode</property>
> <property name="alias">Option Code</property>
> <text-property name="displayName">Option
> Code</text-property>
> </structure>
> <structure>
> <property name="columnName">CCovType</property>
> <property name="alias">ccCov Type</property>
> <text-property name="displayName">ccCov
> Type</text-property>
> </structure>
> <structure>
> <property name="columnName">DisplayCode</property>
> <property name="alias">Display Code</property>
> <text-property name="displayName">Display
> Code</text-property>
> </structure>
> <structure>
> <property name="columnName">AcreageLines</property>
> <text-property
> name="displayName">AcreageLines</text-property>
> </structure>
> <structure>
> <property name="columnName">InsurancePlanCode</property>
> <text-property
> name="displayName">InsurancePlanCode</text-property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">County</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">Crop</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">Practice</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">Type</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">Insurance Plan</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">UnitOption</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">Options</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">CoverageLevel</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">Quote</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">Rid</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">PricePct</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">County Code</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">Crop Code</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">UnitOption Code</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">Option Code</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">ccCov Type</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">Display Code</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">18</property>
> <property name="name">AcreageLines</property>
> <property name="dataType">javaObject</property>
> </structure>
> <structure>
> <property name="position">19</property>
> <property name="name">InsurancePlanCode</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source Quote</property>
> <method name="open"><![CDATA[countCountyCrop = 0;
> //rptCountyCropList=CountyCropListTemp
> rptCountyCropList = rptQuote.getReportCountyCrops(); //var
> rptAcreageLineList;
> //var AcreageLinesTemp;
>
>
> ]]></method>
> <method name="fetch"><![CDATA[if(countCountyCrop <
> rptQuote.getReportCountyCrops().size())
> {
> //rptCountyCropList = rptQuote.getReportCountyCrops();
>
> rptCountyCrop = rptCountyCropList.get(countCountyCrop);
>
> row["County"] = rptCountyCrop.getCounty().getName();
> row["CountyCode"] = rptCountyCrop.getCounty().getCode();
> row["Crop"] = rptCountyCrop.getCrop().getName() ;
> row["Crop Code"] = rptCountyCrop.getCrop().getCode() ;
> row["Practice"] = rptCountyCrop.getPractice();
> row["Type"] = rptCountyCrop.getType() ;
> row["InsurancePlan"] = rptCountyCrop.getInsurancePlan() ;
> row["InsurancePlanCode"] = rptCountyCrop.getInsurancePlan().getCode();
>
> row["UnitOption"] = rptCountyCrop.getUnitOption().getName() ;
> row["UnitOption Code"] =
> rptCountyCrop.getUnitOption().getCode() ;
> row["Options"] =
> rptCountyCrop.getOptionName() ; row["Option Code"] =
> rptCountyCrop.getOptionCode() ; row["ccCov Type"] =
> rptCountyCrop.getCcCovType() ; row["Display Code"] =
> rptCountyCrop.getDisplayCode() ;
> row["CoverageLevel"] = rptCountyCrop.getCoverageLevel()
> ; row["PricePct"] = rptCountyCrop.getPricePercent()
> ; row["Rid"] = rptCountyCrop.getRid()
> ;
> row["AcreageLines"] =
> rptCountyCrop.getReportAcreageLines();
> //rptAcreageLineList = rptCountyCrop.getReportAcreageLines();
> countCountyCrop++;
> return true;
> }
>
> return false;
> ]]></method>
> <method name="close"><![CDATA[ ]]></method>
> </script-data-set>
> <script-data-set name="AcreageLine" id="555">
> <list-property name="resultSetHints">
> <structure>
> <property name="position">1</property>
> <property name="name">Acres</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">Share</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">RateClassOptions</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">MapArea</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">Yield</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">RateYield</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">YieldCupSurcharge</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">ReportCountyCrop</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">Rid</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">Premium</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">Practice</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">Type</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">Unit</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">LineNumber</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">GuaranteePerAcre</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">TotalGuarantee</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">LiabilityPerAcre</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">18</property>
> <property name="name">Totalliability</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">19</property>
> <property name="name">TotalPremiumPerAcre</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">20</property>
> <property name="name">TotalPremium</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">21</property>
> <property name="name">SubsidyPerAcre</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">22</property>
> <property name="name">TotalSubsidy</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">23</property>
> <property name="name">ProducerPremiumPerAcre</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">24</property>
> <property name="name">

Report message to a moderator

Previous Topic:Extending Charting: Where to start
Next Topic:Draw charts using chart engine api
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 17:26:08 GMT 2024

Powered by FUDForum. Page generated in 0.03845 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly