Eclipse Community Forums: BIRT » getting row count of table/dataset

Help

Home

Home » Archived » BIRT » getting row count of table/dataset

Show: Today's Messages :: Show Polls :: Message Navigator

getting row count of table/dataset [message #1058557]

Tue, 14 May 2013 13:04

nari noori

Messages: 33
Registered: November 2012

Member

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");

Report message to a moderator