It's all about the answers!

Ask a question

BIRT: Not all workitems shown in the result preview


Katrin Heymann (19824563) | asked Apr 15 '13, 7:00 a.m.
I created BIRT report template based on WORKITEMS-SNAPSHOT.

My problem is that not all workitems are shown on the preview and when I run the report.
More than 4000 items exists and only max. 150 were shown in both ways.

Anyone have an idea how to solve it ?

2 answers



permanent link
Piotr Aniola (3.7k11738) | answered Apr 15 '13, 7:32 a.m.
First, check if all the expected workitems are displayed in the preview if the data source. If so, you have a problem with display. If not, then the problem lies in the data source itself.

Also, make sure your data warehouse jobs are running correctly.

Comments
Katrin Heymann commented Apr 15 '13, 8:16 a.m.

Same result in the preview of the data source.

All dataware warehouse jobs were running with state "Succeeded".


permanent link
Bill Taylor (1441535) | answered Apr 15 '13, 11:04 a.m.
Preview Results is limited to 500 rows and you get a warning that more are available.

Preview (in Report Designer) is similarly limited but can be increased.

Running an installed report has no such limitation.

Only getting 150 suggests you might be filtering some entries out?

Comments
Katrin Heymann commented Apr 16 '13, 3:27 a.m.

I have added some filter but it seems that only the first 500 entries in the database were evaluated.

The result of the report with filter only shows the same WI IDs.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.