Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Table fits the whole page
AlexK1988
Hi,
I want to generate a report with more than one page. On each side are tables, which should extend to the bottom. The last page of the table ends where no more data is available. I found a way to put the footer at the bottom of the last page, but my problem is to extend the entire table. Specifically, each row of the table has a color which alternates (gray, white, gray, ...). This should continue until the end of the page also if there is no content in the lines, too.
Could anyone help me with this problem?
Thanks a lot.
Alex
Find more posts tagged with
Comments
AlexK1988
Hello again,
because of my bad english I created an example.
I hope it is possible to create such reports.
Thank you
Greetings
Alex
mwilliams
If your table is grouped and page breaks by group, you could add extra group footer lines and alternate their colors and show/hide each row based on how many lines of actual data are on your page.
Hope this helps. Let me know if you have questions.
AlexK1988
Hello,
thanks for your answer. I tried an example, where the footer fit the whole page. In this example there would add a second footer above the footer and there is the following script:
<VALUE-OF format="HTML">while (rowCount < maxRows){
extendTable = extendTable + "<br>";
rowCount++;
}
extendTable;</VALUE-OF>
I think the Problem is, that the script doesn`t add rows, but add lines in the row. If I could add rows, it would be easy to change the color.
I have no idea to add rows ^^.
Thanks for your help.
Alex
mwilliams
Alex,
I meant actually adding "group footer" rows to your chart and alternating their color and using the visibility setting in the property editor to show/hide how ever many you need. I can create an example if need be. Just let me know your BIRT version.
AlexK1988
Hello,
sry, my fail. That would be great, if you can create me an example. I have the version 2.6.2.
Thank you very much.
Alex
mwilliams
Alex,
Take a look at this report. I use a runningcount aggregation on the group to make a standard highlight pattern, then I use a count aggregation to grab the lines for the group so I know how many of the extra footer rows to show/hide using their visibility expressions. Let me know if you have questions.
AlexK1988
Hey,
wow, thats fine. It would work in my context. But i have a further question. If I type a page break intervall of 19 for example, is it possible to get the count of rows which are filled on the current page (If there are less then 19 data rows)?
Thank you a lot.
Alex
mwilliams
So, in this scenario you're not grouping your report? You just have a page break interval of 19? If this is the case, you'd only need the "extended" rows on the last page, so you could use table footer rows instead of group footer rows and you'd just iterate a variable in the onCreate of the detail row to keep track of lines and reset it to 0 in the onPageBreak event.
AlexK1988
Yes, in this scenario are no groups. I am trying your example.
It is very well that you help me at my questions, but is there a good documentation how I could find such things?
I couldn't find anything.
Thank you.
Alex
mwilliams
Your best resource is probably going to be the javadoc and asking questions in here. There are also books available to help with BIRT. The two best ones IMO are the Eclipse Series ones. You can find them at Amazon.com.
AlexK1988
I'm excited about your help. My report is running very fine.
In my next example I want to show a tree structure. The tree is shown, but I have to know if it is possible to merge cells during creating the report. In detail: The Report is generated line by line. In each line is a dataset. Right to the dataset there are cells. They should be merched with the first cell.
I hope the context is clear.
Thank you
Alex
mwilliams
Alex,
Can you explain this a little more? I'm not sure I'm quite understanding. You just want to merge cells? Why can't you do this at design time? Or is that all you're asking?
AlexK1988
Hm, I want to merge cells by creating the Report. I'm afraid thats not possible.
I have a productstructure for example in a tree structure like this:
mwilliams
Can't argue too much with something that works!
mwilliams
In the onCreate for a table cell, you can set the column span or row span to allow text to go to the next column or row. Not sure if this will help or not.
this.colSpan = 2; //would allow your text to go to the next column.
AlexK1988
Ok, that wasn't my Problem, but I could fix my problem with your help
Thanks.
If there are further problems I would write it in here.
Alex
mwilliams
If you have a new question and it's of a new topic, please start a new thread with the title of the new issue so it's more searchable. Thanks!