| getting row count of table/dataset [message #1058557] |
Tue, 14 May 2013 09:04  |
Eclipse User |
|
|
|
Hi,
im using birt 4.2.
i want to achieve this:
my report has one table. if the user tries to export a report to excel that has over 1000 rows, hide the report table and show a custom message in excel to user: Dear user, you are not allowed to export a report to excel that has over 1000 rows, use csv export instead)
Therefore i set the visibility(under properties) on table to hide the table when Total.count()>1000.
So far so good. Then i have made dynamic-text that says (Dear user, you are not allowed to export a report to excel that has over 1000 rows, use csv export instead). I want to set its visibility only to excel, but i am not able to use Total.count() outside the table.
How to get the table's row count outside the table ?
i have also tried to set the total count in different table-events:
reportContext.setGlobalVariable("numberofrows", Total.count());
and trying to get the variable in a dynamic text, but the variable always retrns null:
reportContext.getGlobalVariable("numberofrows");
|
|
|
|
Powered by
FUDForum. Page generated in 0.04519 seconds
Home