It's all about the answers!

Ask a question

why BIRT report across multiple RTC projects do not list all WIs which would have otherwise listed project by project

long TRUONG (3654115146) | asked Mar 07 '13, 11:06 p.m.
 Eclipse Helios 3.6.2
BIRT 2.6.2
RTC client plugin 4.0
same results on both RTC 4.0 server and RTC 4.0.1 server

Trying to create a BIRT report to list all WIs across multiple projects:
  • When PROJECT_AREA_NAME is set to a certain project, the report shows 257 rows with the most recent WI_ID 9720
  • When PROJECT_AREA_NAME is left blank and the warning is ignored, the report shows 1001 rows with most recent WI_ID 5945
  • It looks obvious that it was not a full report across multiple projects. How can a full report across projects can be generated ?
  • Note that the 500 rows limit on viewing was overridden with unlimited even though this limit should not effect reports in xls or pdf.
Also, is there a way to specify more than 1 PROJECT_AREA_NAME in one single report ?

Accepted answer

permanent link
Rafik Jaouani (5.0k16) | answered Mar 08 '13, 11:27 a.m.
There is a hard coded limit of 1000 that cannot be changed when you preview reports in the BIRT designer. You will need to deploy the Report to the server to see the full list. But reports like the one you describe are really not recommended as they could cause out of memory problems on the server. Displaying a report that lists thousands of Work Items is not a good idea.
long TRUONG selected this answer as the correct answer

Albert Yao commented Apr 08 '15, 2:34 a.m. | edited Apr 08 '15, 2:37 a.m.

The limit is 1000 or 500?

Could the limit count be changed or configured?

long TRUONG commented Jan 03 '17, 11:01 p.m.

 Limit is 500 (can be overridden, but broken into pages) on browser and 1000 (hard coded) in BIRT reports, as experienced in original posting.

Your answer

Register or to post your answer.