It's all about the answers!

Ask a question

Planned for "Unassigned" - BIRT Reports


Bharath M (5465428) | asked Dec 13 '09, 8:09 a.m.
Hi,

I'm trying for a report using LIVE_SNAPSHOT on Project Area X with following conditions.

Status of workitem is New and Planned for is Unassigned.

In report designer , when I try to use a filter for Planned For, in the select list I don't see "Unassigned". Instead I see "{Null}". Are these two same? Using "{Null}" doesn't give me correct results.

Any ideas?

Thanks,
Bharath

15 answers



permanent link
Rafik Jaouani (5.0k16) | answered Jan 04 '10, 9:27 a.m.
JAZZ DEVELOPER
Yes you can, the data set parameter value is actually a block of javascript code.

permanent link
Bharath M (5465428) | answered Jan 04 '10, 9:52 a.m.
I tried to use the following code for the default value of a parameter. This is just for a test, logic may not be meaningful.

var sev = row;
if (sev == 'Normal'){
'{Null}'
}else{
'Unclassified'
}

But it throws a reference error :

ReferenceError: "row" is not defined

permanent link
Bharath M (5465428) | answered Jan 15 '10, 2:20 a.m.
Any clue about this?

Thanks,
Bharath

permanent link
Rafik Jaouani (5.0k16) | answered Jan 15 '10, 7:47 a.m.
JAZZ DEVELOPER
I am afraid the above cannot be done for now. In 3.0, we added a new data set type that would allow to pass an SQL like condition to the data set.

Can you please send me your design file through a work item and I will see if I can do something with it?

permanent link
Bharath M (5465428) | answered Feb 16 '10, 9:58 a.m.
Any chance trying your report on a 2.0.0.1 or 2.0.0.2 server? We fixed sveral issues related to the handling of null in 2.0.0.1.


Hi Rafik, our issue is fixed in 2.0.0.2 . Thanks

--Bharath

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.