one row per page

mohammadgh · 2009-08-31T03:11:43+00:00

hi I want to have a report with one row per page. I created a new style and set the pageBreakAfter to always. but it show all the rows in one page. there is another sample by Jason W that i found here EclipseZone - One…

mohammadgh

hi 
I want to have a report with one row per page. 
I created a new style and set the pageBreakAfter to always. 
but it show all the rows in one page. 
there is another sample by Jason W that i found here <a class='bbc_url' href='http://www.eclipsezone.com/eclipse/forums/t70982.html'>EclipseZone - One Row Per Page ...</a>. 
(onerw.rptdesign) 
it is a report with one row per page but i can't find the way to create similar pages. 
any help will be greatly appreciated. 
Mohammad Ghasemi Hamed 
mypage : 
 
<?xml version="1.0" encoding="UTF-8"?> 
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17" 
id="1"> 
<property name="createdBy">Eclipse BIRT Designer Version 
2.3.2.r232_20090202 Build <2.3.2.v20090304-1357></property> 
<data-sources> 
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Demo Data Source" id="5"> 
<property name="odaDriverClass">com.mysql.jdbc.Driver</property> 
<property name="odaURL">jdbc:mysql://localhost/classicmodel</property> 
<property name="odaUser">root</property> 
<encrypted-property name="odaPassword" encryptionID="base64">cm9vdA==</encrypted-property> 
</oda-data-source> 
</data-sources> 
<data-sets> 
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="ds" id="6"> 
<structure name="cachedMetaData"> 
<list-property name="resultSet"> 
<structure> 
<property name="position">1</property> 
<property name="name">customerNumber</property> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="position">2</property> 
<property name="name">customerName</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">3</property> 
<property name="name">city</property> 
<property name="dataType">string</property> 
</structure> 
</list-property> 
</structure> 
<property name="dataSource">Demo Data Source</property> 
<list-property name="resultSet"> 
<structure> 
<property name="position">1</property> 
<property name="name">customerNumber</property> 
<property name="nativeName">customerNumber</property> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="position">2</property> 
<property name="name">customerName</property> 
<property name="nativeName">customerName</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">3</property> 
<property name="name">city</property> 
<property name="nativeName">city</property> 
<property name="dataType">string</property> 
</structure> 
</list-property> 
<property name="queryText">Select customerNumber, customerName, city From customers</property> 
</oda-data-set> 
</data-sets> 
<styles> 
<style name="crosstab-cell" id="2"> 
<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> 
</style> 
<style name="crosstab" id="3"> 
<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> 
</style> 
<style name="gogoori" id="29"> 
<property name="pageBreakAfter">always</property> 
<property name="pageBreakBefore">avoid</property> 
<property name="pageBreakInside">avoid</property> 
 
</style> 
</styles> 
<page-setup> 
<simple-master-page name="Master Page" id="4"/> 
</page-setup> 
<body> 
<table name="table" id="7"> 
<property name="width">100%</property> 
<property name="dataSet">ds</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">customerNumber</property> 
<expression name="expression">dataSetRow["customerNumber"]</expression> 
</structure> 
<structure> 
<property name="name">customerName</property> 
<expression name="expression">dataSetRow["customerName"]</expression> 
</structure> 
<structure> 
<property name="name">city</property> 
<expression name="expression">dataSetRow["city"]</expression> 
</structure> 
</list-property> 
<property name="pageBreakInterval">1</property> 
<column id="26"/> 
<column id="27"/> 
<column id="28"/> 
<header> 
<row id="8"> 
<property name="style">gogoori</property> 
<property name="pageBreakBefore">auto</property> 
<property name="pageBreakInside">auto</property> 
 
<cell id="9"> 
<label name="customerNumber" id="10"> 
<text-property name="text">customerNumber</text-property> 
</label> 
</cell> 
<cell id="11"> 
<label name="customerName" id="12"> 
<text-property name="text">customerName</text-property> 
</label> 
</cell> 
<cell id="13"> 
<label name="city" id="14"> 
<text-property name="text">city</text-property> 
</label> 
</cell> 
</row> 
</header> 
<detail> 
<row id="15"> 
<property name="style">gogoori</property> 
<cell id="16"> 
<data name="data_customerNumber" id="17"> 
<property name="resultSetColumn">customerNumber</property> 
</data> 
</cell> 
<cell id="18"> 
<data name="data_customerName" id="19"> 
<property name="resultSetColumn">customerName</property> 
</data> 
</cell> 
<cell id="20"> 
<data name="data_city" id="21"> 
<property name="resultSetColumn">city</property> 
</data> 
</cell> 
</row> 
</detail> 
<footer> 
<row id="22"> 
<cell id="23"/> 
<cell id="24"/> 
<cell id="25"/> 
</row> 
</footer> 
</table> 
</body> 
</report>

Find more posts tagged with

Comments

mwilliams

Hi mohammadgh,

If you select your detail row and go to the pagebreak section of the property editor and set the page break after to "always", you should get one row per page.

Hope this helps.

mohammadgh

thanks Michael,
It worked !!!

mwilliams

No problem. Let us know whenever you have questions.

strikenoir

OK that worked for the table layout.

What if the layout is list?

How to make the report show 1 record per page?

mwilliams

Hi strikenoir,

Select the list, go to the page break section of the property editor, and make the page break interval '1'. This should do it.

strikenoir

Dear Michael

Yes it worked perfectly.

But at the end of the report, it's still giving a page break (I know, I expected this).

How to tell BIRT not to page break at the end of the row? (only at every other pages)

Sorry for the very beginner question. I wish there are examples for these simple questions.

mwilliams

strikenoir,

I didn't notice this happening when I did this. Do you have a page break after set on your list in addition to the page break interval?

Avinash02

Dear michael,

What about Grid ?? if we have GRID in the rptdesign.

How to do per page per record ??

regards,
Avinash

mwilliams

Hi Avinash,

If you have a grid, it has a set number of rows. Therefore, you'd just need to select each row of the grid and set the page break after to always.

Avinash02

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="70803" data-time="1291046324" data-date="29 November 2010 - 08:58 AM">
Hi Avinash, 
 
If you have a grid, it has a set number of rows. Therefore, you'd just need to select each row of the grid and set the page break after to always. </blockquote>
 
 
Hi Michael, 
 
Thanx.. it really helped me a lot. We can also make it work by keep grid in the table detail rows then page break.. i found by myself thought of sharing.. 
 
I have 1 more issue michael. When i try to run my rpt file .. it runs smoothly when i pass parameter only for 1 day.. but when i try to pass more then 2 days it throws an exception "[java.lang.NullPointerException]". 
 
Sorry to ask u in the same Thread but Plz it help me a lot, even a little will help.. 
 
Thanks & regard, 
Avinash

mwilliams

Avinash,

Can you recreate this issue with the sample database? Do you have any script that might be trying to process a null value in the situation of more than one day? If you are unable to recreate the issue, please attach your report design and let me know your BIRT version.

Avinash02

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="70956" data-time="1291303778" data-date="02 December 2010 - 08:29 AM">
Avinash, 
 
Can you recreate this issue with the sample database? Do you have any script that might be trying to process a null value in the situation of more than one day? If you are unable to recreate the issue, please attach your report design and let me know your BIRT version. </blockquote>
 
Micheal, 
 
I don't think there are any scripts which are trying to process a null value b'coz for example if i put dates 
 
2010-01-01 
2010-01-03 
 
for this dates, report will run but for dates 
 
2010-01-01 
2010-01-04 
 
this throws a null pointer exception, but if i pass dates 
 
2010-01-03 
2010-01-04 
 
report run smoothly . so its clear that there is no null values 
 
the problem is i am not able to get the data in bulk .i.e.. for more dates 
i need data atleast for 10 days 
 
i m attaching the rptdesign file... My BIRT version is 2.5.2 
plz help me as the days are passing by this report is coming up in priority.. 
 
Regards, 
Avinash

mwilliams

Avinash,

How many rows of data do you get with one day? Is there any way you can reproduce this issue with the sample database or with a .csv file of data so that I can see it happen?

mwilliams

Another question. Where are you using all the report variables you created?

Avinash02

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="71064" data-time="1291673139" data-date="06 December 2010 - 03:05 PM">
Another question. Where are you using all the report variables you created? </blockquote>
 
 
Dear Micheal, 
 
Thanx a lot of reminding me of the report variables. 
It was my silly mistake only, to use report variable in someplace 
where i should be using report parameters. 
 
thanx a lot micheal u saved me. 
 
 
Thanks & Regard, 
Avinash

mwilliams

Avinash,

Not a problem! A second set of eyes is sometimes all you need! Let us know whenever you have questions!

Avinash02

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="71093" data-time="1291733138" data-date="07 December 2010 - 07:45 AM">
Avinash, 
 
Not a problem! A second set of eyes is sometimes all you need! Let us know whenever you have questions! </blockquote>
 
 
Hi micheal, 
 
u know that we get more options for beautification, when we use TABLES and GRIDS in the birt. 
but CROSS TAB doesn't provide such features.... 
 
But cross tab have unique feature by which we can fetch data by crossing two or more rows of one or more table at a time.. and it really is quick to develop thus save time. 
 
the point is i have been using cross tab in some of my reports but can't able to do beautification 
can i find an update or some plugins for cross tab so that it can be possible. 
 
moreover i have tried to keep cross tab within the gird or table the output of the web viewer is fine 
but as soon as i convert the output to excel... it give blank columns in between the data.. 
and is unpredictable..its like a bug. 
 
any suggestion will help. 
 
Thanks & Regards, 
Avinash

mwilliams

Avinash,

What are you trying to do as far as "beautification goes"? Maybe I can help.

With the XLS output, the emitter is trying to use cells to create the exact layout that your HTML shows. This sometimes creates an issue of using empty cells for padding. What is your BIRT version again? If using an older version, upgrading could possibly help this. Also, there is a Tribix XLS emitter out there that can be used instead. It sometimes formats a little differently than the default emitter. It may be better, worse, or the same. It really all depends on your design's layout complexity.

Avinash02

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="71173" data-time="1291845850" data-date="08 December 2010 - 03:04 PM">
Avinash, 
 
What are you trying to do as far as "beautification goes"? Maybe I can help. 
 
With the XLS output, the emitter is trying to use cells to create the exact layout that your HTML shows. This sometimes creates an issue of using empty cells for padding. What is your BIRT version again? If using an older version, upgrading could possibly help this. Also, there is a Tribix XLS emitter out there that can be used instead. It sometimes formats a little differently than the default emitter. It may be better, worse, or the same. It really all depends on your design's layout complexity. </blockquote>
 
 
Hi micheal, 
 
kindly find attached the Crosstab_sample1 and 2 rptdesign 
 
in first sample u will notice a gird above the cross tab 
having a label only WITH JUST 1 COLUMN 
 
in the second sample u will notice a gird above the cross tab 
having 5 labels AND 5 COLUMNS 
 
CONVERT BOTH REPORT OUTPUT INTO EXCEL 
AND COMPARE U WILL FIND THAT IN THE SECOND REPORT OUTPUT BLANK COLUMNS 
ARE COMING IN THE EXCEL FORMAT OUTPUT 
 
as far as i have found out.. untill the grid have 1 column .. the blank column will not come 
but if increased more than 1 column, blank column will come when converted into excel format 
 
i don't know if it is a bug or anything else.. 
 
i have also try to keep cross tab inside the Gird and table(with no detail row) but result is same i.e blank column keep coming 
 
I have make the layout from FIXED to AUTO. 
 
My Birt version is 2.5.2 
 
If just that blank column doesn't come... i can use gird for beautification in cross tab 
 
Regards, 
Avinash

mwilliams

Avinash,

These blank cells are definitely caused by BIRT trying to exactly match the layout of your report. Unfortunately, since the crosstab is variable in width because of the dynamic amount of columns, I don't know that there's going to be a good way to solve this. I tried setting widths of columns and ended up with the same issue. Have you tried the Tribix emitter? You could log a bug for this, requesting that when auto layout is used, columns are sized so that there are no blank columns. Looks would be forfeited in this scenario, but it sounds like you're more worried about the blanks than the report looking the way you have it designed.

Avinash02

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="71277" data-time="1292252039" data-date="13 December 2010 - 07:53 AM">
Avinash, 
 
These blank cells are definitely caused by BIRT trying to exactly match the layout of your report. Unfortunately, since the crosstab is variable in width because of the dynamic amount of columns, I don't know that there's going to be a good way to solve this. I tried setting widths of columns and ended up with the same issue. Have you tried the Tribix emitter? You could log a bug for this, requesting that when auto layout is used, columns are sized so that there are no blank columns. Looks would be forfeited in this scenario, but it sounds like you're more worried about the blanks than the report looking the way you have it designed. </blockquote>
 
Hi micheal, 
 
Merry Christmas, 
 
No, i haven't tried Tribix emitter .. i m not concerned with looks .. but its the demand u know.. thats y.. 
 
Regards, 
Aviansh

mwilliams

Avinash,

Give the Tribix emitter a try. There is also a possibility that using the CSV emitter that is available might work. If those don't work, create a bug/enhancement request to have an unformatted XLS output that doesn't worry about matching the design. If you post the info in here for your enhancement request, others will be able to click on it and vote for it as an enhancement if they have the same issue.

http://www.birt-exchange.org/org/resources/bug-reporting/

neilmn

Hi Michael,
 
I am doing a report and my goal is to display the record per page. 
 
For example, I have this query Select * from orders where order_number in ('12345','67890')
 
The script returns 4 rows (two rows for 12345 and two rows for 67890) I want these rows to be printed on two separate pages as shown in the format below.
 
Page1:
 
12345 
 
Juan dela Cruz Sr
Juan dela Cruz Jr
 
Page2:
 
67890 
 
Mark Hernandez Sr
Mark Hernandez Jr
 
I want the order_number to be printed once per page (no repeat)
 
Your input is very much appreaciated. Thanks!