Extend Table/Grid to Fit Page for different row height

udezonan · 2010-08-25T03:49:28+00:00

Hello i'm new in using birt i know there is a solution for this but that only work if the row height is fix but how about if the height is not fix? i have a table that the height expand according to the data from database. i put the data in a text. is there any way to get generated row…

udezonan

Hello

i'm new in using birt
i know there is a solution for this but that only work if the row height is fix
but how about if the height is not fix?
i have a table that the height expand according to the data from database.
i put the data in a text.
is there any way to get generated row height or number of text row?
or there is other solution?

thanks in advance

Find more posts tagged with

Comments

pabloMG

Is your problem that you have data that needs more than one line in some cells? If so, select the label in the cell, go to Properties -> Advanced -> Text -> Whitespace and select Auto.

udezonan

hello
no that not the issue i use text for that.
there will be multiple record where each will be for one row with multiple column
each row height will extend according to the length of the data

BirtRunn

I am not so much clear about your actual problem. Anyways. I am not sure about how to get height but if you want to know how many rows are fetched by data set, it is possible.
In Expression Builder -> select Available Coulmn Bindings -> select control name where you have bound data set
-> in 'Double Click to insert' section you will see 'RowNum' as last element which is BIRT's standard row counter parameter.
The value returned is total number of rows fetched by dataset.

mwilliams

Hi udezonan, 
 
I don't know if there's a good way to do this with random row heights. I'll try a couple things and post if I come up with something. You might log an enhancement request for an easy way to push the footer down to the bottom of the page for all situations. You can do so at <a class='bbc_url' href='http://www.birt-exchange.org/org/resources/bug-reporting/'>the bug report and enhancement request page</a>

udezonan

<blockquote class='ipsBlockquote' data-author="'BirtRunn'" data-cid="67737" data-time="1282731585" data-date="25 August 2010 - 03:19 AM">
I am not so much clear about your actual problem. Anyways. I am not sure about how to get height but if you want to know how many rows are fetched by data set, it is possible. 
In Expression Builder -> select Available Coulmn Bindings -> select control name where you have bound data set 
-> in 'Double Click to insert' section you will see 'RowNum' as last element which is BIRT's standard row counter parameter. 
The value returned is total number of rows fetched by dataset. </blockquote>
 
actually i was referring to this issue <a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/989-extend-table-to-fit-page/'>http://www.birt-exchange.org/org/devshare/designing-birt-reports/989-extend-table-to-fit-page/</a> but this solution only works for same row heights. if i set fix height some of the data will be hidden even though i've set overflow to visible 
 
mwilliams 
 
i hope you can find the workaround for this. i thank you in advance for your help regardless of the outcome. 
i'll log the request for this later

mwilliams

Unless you set a row height, there doesn't seem to be a way to access the actual rendered height of the row to use in your design. This probably makes it impossible to do in any easy way. A way that you could do it that might be pretty messy would be to count the characters of the column that's causing the row to be taller or shorter and either compute a probable amount of rows created by that many characters or substring the text with breaks so that you know for sure how many rows the row takes up. You can then keep track of this value and reset it on page breaks, which you may have to insert using script when you know your page is full. Then, you'd finish with the same idea from that post of mine from the devShare that you linked to above to push the footer down the rest of the page. Like I said, this will be messy, most likely, but it should work. Good luck if you try it! Let me know if you have questions.

udezonan

yea i notice that to.
my first idea was to get the number of row in the text element so i can use it in your previous example
but now i realize it quite impossible to know that
thanks for the idea. yes it will be hard and messy since i have to consider the width of the table column
which can turn my text to one or more rows. i'll try as much as i can.
will post the sample if i succeed
thanks again for your help

udezonan

Hello
ok this what i have so far
i still cannot get the calculation right
just how do you calculate the number of character for a row since some character has different width?
can anyone review my work and give some idea how to calculate it?
can we get the width of each character?

if i cannot solve this by tomorrow i'm have to switch to ireport

because my friend said i don't have to worry about this issue in ireport

some ouput

mwilliams

If you fix the column width, you could use substrings or split the string into an array of words and make your own rows with html and display the html in a text box in your row. This way you'd for sure know that each row fits and don't have to worry about character width because you'd make sure to use a limit of characters that would fit in the worst case of like all uppercase W's or something.

udezonan

Hai 
 
if anyone still interested i think i have manage to Extend Table/Grid to Fit Page for different row height 
but you still have to few more tweaking for row per page and max text length 
 
on initialize script 
//////////////////////// 
TotalDataRow = 0; 
maxCharacterPerRow = 46; 
maxRowsPerPage = 40; 
extendTable = ""; 
//////////////////////////// 
 
on fetch script 
//////////////////////////// 
if(count < data.size()){ 
 
row["flNo"] = count+1; 
row["flChckList"] = data.get(count).getChecklistItem(); 
row["flClauseNo"] = data.get(count).getClauseNo(); 
tmp = data.get(count).getFindings().replace("\n"," "); 
view = ""; 
if(count != (data.size()-1)) 
{ 
extendTable=""; 
//tmp=tmp+" "; 
} 
tmpList = tmp.split(" "); 
for(a=0;a<tmpList.length;a++) 
{ 
kira=1; 
tmp2 = tmpList[a].split(" "); 
bil2=0; 
for(b=0;b<tmp2.length-1;b++) 
{ 
bil2 += IA.TextCount(tmp2)+1; 
bilExtra = bil2+IA.TextCount(tmp2[b+1]); 
//view+="("+(bilExtra>maxCharacterPerRow)+" = "+bilExtra+" - "+maxCharacterPerRow+")"; 
if(bilExtra>maxCharacterPerRow) 
{ 
view += tmp2+" "; 
kira+=1; 
bil2=0; 
}else 
{ 
view += tmp2+" "; 
} 
} 
if(tmp2.length==0) 
{ 
view +=tmpList[a]+""; 
kira+=1; 
}else 
{ 
if(count == (data.size()-1) && IA.TextCount(tmp)<46){ 
view += tmp2[tmp2.length-1]+""; 
}else 
{ 
view += tmp2[tmp2.length-1]+" "; 
} 
//kira+=1; 
} 
//view+="("+tmp2.length+")"; 
TotalDataRow=TotalDataRow+kira; 
//bil = tmpList[a].length; 
//multi = bil/maxCharacterPerRow; 
//intmulti = parseInt(multi); 
//count=intmulti; 
//if(bil>(intmulti*maxCharacterPerRow)) 
// kira = intmulti+1 
// TotalDataRow=TotalDataRow+kira; 
} 
if(tmpList.length==0) 
TotalDataRow = 1; 
if(count != (data.size()-1)) 
{ 
view += " "; 
TotalDataRow = TotalDataRow+2; 
} 
row["flFindings"] = view;//tmp; 
row["flStatus"] = data.get(count).getStatus(); 
row["flEcarNo"] = data.get(count).getCarno_ofi(); 
 
txt=""; 
if(count == (data.size()-1)) 
{ 
//TotalDataRow=TotalDataRow+(2*data.size()); 
page = TotalDataRow/maxRowsPerPage; 
pageInInt = parseInt(page); 
rowForLastPage = maxRowsPerPage - ((TotalDataRow) - (maxRowsPerPage*pageInInt)); 
//txt = "a a "+rowForLastPage+"- "+(maxRowsPerPage*pageInInt)+"-"+pageInInt+"-"+(TotalDataRow)+"-"+maxRowsPerPage; 
//9- 80-2-111-40 
if(pageInInt>1) 
rowForLastPage = rowForLastPage-1; 
else 
rowForLastPage = rowForLastPage+1; 
for(q=0;q<rowForLastPage;q++) 
{ 
txt +=" "; 
} 
//row["flFindings"] = row["flFindings"] +txt; 
}else 
{ 
txt=""; 
} 
row["tableExtend"]=txt; 
count++; 
return true; 
} 
 
return false; 
/////////////////////////////////////////////////////////// 
 
also need some cleaning on the code 
i use java class to get text length since i get nothing when i use text.length in the script 
 
 
here the design

mwilliams

udezonan,

This would be a great post for the devShare!

udezonan

hai all

still this code is not perfect
some time you will have an extra page with 2 or 3 empty row
i only test it with few set of data and 1 set of design
if that is ok with you then this maybe your solution temporary
until BIRT implement something to solve this issue

mwilliams

When you log the enhancement request, be sure to put the info in here so that others who have this same issue that happen upon this thread will be able to go to the request and vote for it.

FrizzaUK

Hi,

I don't know whether this sorts your problem out but if you click on the row that you wish to dynamically expand (the whole row not just a single cell). Then within the Property Editor, click the General tab, set the 'Height' value to 100 and the measure to '%'.

I have used this myself to handle chunks of text that range from one line to say 20 lines.

Matt

keerthink

Hello Michael,
 
I have my table set to 100% height, but it only takes up the height of maximum content in each row. How do I extend my table to cover the entire available height irrespective of the number of rows on that page...?
I am using version 4.4.2
 
Thank you

mwilliams

This still works the same as it always has, unfortunately. You can either use the master page footer or you can extend the page by the number of rows needed by adding extra footer rows. The adding of extra rows obviously works best if you have a fixed row height. Otherwise, you have to try to calculate the number of lines the rows on a page take up so that you know how far to extend the page.