Birt report for all work items across project area is blank
Hi,
I have authored a custom report using BIRT , which fetches "task" work-items across all project areas.
The expected result set is more than 50,000 work -items.
However, report runs for few minutes and after that, it just goes blank.
But when I preview the report in BIRT, it displays the data correctly.
what could be issue here and how can it be resolved ?
6 answers
First of all BIRT Preview can display different results due to https://jazz.net/wiki/bin/view/Main/ReportsViewingDifferences
Also please check "Include Archived" checkbox as it may filter out work items by default.
Comments
Thanks Vladimir.
we are using RTC 3.0.1.
Also, these work-item / project areas/ team areas are not archived. out of 50,000 work-items expected, actually report shows nothing.
It is completely blank page.
Is there any restriction on number of work-items shown in the RTC BIRT report ? is there any setting / switch that could be responsible for it ?
I'm not aware of any limits, 50k work items is usual. I guess you should debug your report and insert some "total.count();" to identify stage where data are lost.
you know how we can change this property? only happens when we have more than 1000 work items.
Same BIRT custom report if result size is under 1000, works.
Is it possible to configure the result set size property?
Comments
Result set limit works in BIRT Preview only, in RTC there's no limit I'm aware of. Do you want to make BIRT Preview able to fetch more than 1000 rows?
Hi Vladimir, I think I have problems with my custom report. Let me check the custom report in the coming days I hope to answer this post.
Thank you for your quick response.