why BIRT report across multiple RTC projects do not list all WIs which would have otherwise listed project by project
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
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.