It's all about the answers!

Ask a question

BIRT script report return empty result

pugazhenthi samidurai (26423942) | asked Feb 17 '12, 1:17 a.m.
Hi ,

i have followed the Story Points report for developing script report.

i have Created the Data set (Development)for retrieving data from LIVE_WORKITEM_CNT table. And created another data set (script data set).

check my development process below.

1. i have added the following code into Report initialize method


Development = [];

2. Added the following code in Development dataset onFetch method

if (typeof(Development) == "undefined") {
var point = new Object();

point.wiid = row;
//point.summary = row;
//point.witype = row;
//point.wicount = row;


3. Then added the below code into fetch method of scripted data set.

if (Development.length == dataSetIndex) {
return false;
} else {
var DevData = Development;
row = DevData.wiid;
//row = DevData.summary;
//row = DevData.witype;
//row = DevData.wicount;
return true;

and dataSetIndex = 0; on open method.

4. finally i have inserted the dataset columns into report layout.

while running preview its shown empty results.

Kindly help on this. i am searching more than 4-6 days.



One answer

permanent link
Rafik Jaouani (5.0k16) | answered Feb 18 '12, 7:56 p.m.
Looks like you did things the right way but the devil is in the details. I will need to see the full report design to see why it is not working. Things to check:
Make sure the non scripted data set gets fetched by dropping it on the report design surface or you can bind it to a dynamic text item and add the following javascript to the dynamic text item: Total.count();

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.