Can data be controlled dynamically?

In reports, we set particular height and width of page according to the paper where we want to print. But the issue is in some reports the data is large, so it gets cuts ie exceeds the paper with page height remaining the same. Whereas in some reports the data is small and the page gets wasted with the same height.

As the data is generated at run time, is there any way to control the data so as to accomodate the data to paper size ie any 'FIT TO PAGE SIZE OPTION' in HTML as there is in PDF?

I have set the height=20in & width=10in in master page to accomodate maximum no. of columns in report. Is there any way to control the no of detail rows on each page so that it looks like 'Fit to paper size' after printing?

Thanks in advance

Kirti Wankhade

Find more posts tagged with

Comments

mwilliams

You want to be able to limit the number of detail rows so that the entire report fits onto a single page? Or you're wanting to shrink the details to fit on the page size? Let me know.

kirti1105

I want the details rows to fit to the page size so that it looks good.

mwilliams

So, you don't know how many rows will be in the report? You want to figure that out and then set a height for the rows so that all the data fits into one page? If so, what about the case in which there is so much data that the print is unreadable at the size that allows it to fit? Let me know.

kirti1105

I want the data should be readable and fitted to paper size, number of pages doesnt matter. But the spaces left blenk matters, ie dont want to waste the page. AS the data gets generated at runtime, we cant predict how many rows would be there in a single page. Also, some columns like address has more data than other columns, so the rows height also varies. I have kept the row height as blank in order to accomodate all the data for that particular record. Thats y i asked for any option that would dynamically set the page height to printable paper.

Can u explain the use of "Page Break Interval" option for a table. Because i tried to set it different for different reports. And observed that in some cases, it if "Page Break Interval" is set to 30 n increased by 2 then rows increase by 2 n if changed to 40 , first page appears blank.

mwilliams

If you just want the data to run all the way to the end of the page and then break naturally, just set the page break interval to 0. Then, the data will only break on the natural page breaks of the page size. Hope this helps.

kirti1105

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="92818" data-time="1325013898" data-date="27 December 2011 - 12:24 PM">
If you just want the data to run all the way to the end of the page and then break naturally, just set the page break interval to 0. Then, the data will only break on the natural page breaks of the page size. Hope this helps. </blockquote>

kirti1105

I tried it. But tin the viewer it looks 'fit to the size' sort but in the print out the records get cut along with the footer. Also i have set the height as 20 in master page. Also, tried altering the height to 18, 15 while keeping the pagebreak interval=0 . But the same problem in print out persists. Is there any other setting which needs to be kept fixed. Also, tried to make the height=0. But then the number of records on a single page gets reduced.

mwilliams

Can you reproduce your issue with the sample database, so I can see what you're seeing?

lrnrit

<blockquote class='ipsBlockquote' data-author="'kirti1105'" data-cid="92825" data-time="1325050556" data-date="27 December 2011 - 10:35 PM">
I tried it. But tin the viewer it looks 'fit to the size' sort but in the print out the records get cut along with the footer. Also i have set the height as 20 in master page. Also, tried altering the height to 18, 15 while keeping the pagebreak interval=0 . But the same problem in print out persists. Is there any other setting which needs to be kept fixed. Also, tried to make the height=0. But then the number of records on a single page gets reduced. </blockquote>
 
 
Hi , 
 
 
Is row is getting cut in between at the end of page for Pdf or after printing PDF? 
 
I Think its happening because of your master page size , i am not sure. 
what layout you are using fixed or auto. And Please also check printer properties because i ran into similar issue because of that only. 
 
Pls let me know you find solution of this 
 
lrnit

johnw

Problems like this are usually caused by excessive, conflicting style properties being set, and the render engine accommodating as best as it can. The PDF render engine works slightly different than the HTML render engine since it is trying to print to page, so it has to work within the confines of a set area. What happens more often than not is that someone sets explicit widths on the table, and on the columns. For some odd reason this causes the widths to overflow into each other, cutting off data. You can set the white space property to line wrapping, but it can still happen. This happens a lot with the Excel emitter, especially when there are a large number of columns and you are using a set page width, so columns look like the disappear.

As a best practice, set either the table width or the column width, but not both.

Other elements, such as font size, play into this as well. If you have a column that is set to a particular size, and if the font is too big and the line wrapping property is set to false, it will get cut off.

You can script this so that different formatting gets applied with PDF than with HTML. But without seeing the design file its hard to know. Can you post the design file or a resulting rptdocument file so we can take a look?

johnw

Also, if you post the rptdocument file, make sure the report doesn't contain sensitive data that shouldnt be viewed publicly.

kirti1105

In my reports data will be generated at runtime. I m using Type=custom in order to set the width and height to accomodate all the columns and data. I m using legal paper to take the print outsof birt reports. In reports, i m using simple tables n some have grouping in them.And the issue is data gets cutted after printing. Also, Im using HTML option while printing n not pdf.
Also, I m posting the rpt design file. Its doesnt contain any sensitive data as it is for my local use.