|getting row count of table/dataset [message #1058557]
||Tue, 14 May 2013 13:04
| nari noori
Registered: November 2012
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:
and trying to get the variable in a dynamic text, but the variable always retrns null:
Powered by FUDForum
. Page generated in 0.19516 seconds