It's all about the answers!

Ask a question

BIRT How to set the EnumerationList at Dataset Parameters

HIROAKI JOSAKO (41219) | asked Apr 01 '16, 4:11 a.m.
For example if it is registered as follows,
How setting can I and you want to create a Dataset of the case, including some?
What to do
Parameters on how to set up?
We do not understand.

11111  |enum1|enum2|enum3|

11112  |enum1|enum3|enum4|
11113  |enum2|enum3|enum5|


11111  |enum1|enum2|enum3|


Donald Nong commented Apr 06 '16, 12:16 a.m.

You can easily do this with filters, but I know that you're strongly against using filters. Do you "have to" use parameters?

HIROAKI JOSAKO commented Apr 06 '16, 8:24 p.m.

Hi Donald
as much as possible, to use parameters

Workitem Type, you are using the choices often Enumeration is often the more the number of WI.
Example´╝Ü Release Version of model+grade

Donald Nong commented Apr 11 '16, 2:52 a.m.

By "use parameters", I assume that you expect that BIRT can construct an SQL with the given condition so that the query only returns the result you want? To be honest, I cannot construct such SQL in a simple way with the "LIKE" operator. I think you need to use filters.

HIROAKI JOSAKO commented May 10 '16, 1:22 a.m.

Hi Donald
Idea of Osawa-san might solve.
To prepare a dummy text that created the function to extract only the data necessary for the data set once array variable(Java map.object) .
I think that I can by re-setting the object to the Script Dataset.

Have you ever made in this way until now.
Standard report "cumlative report" has been created in this way.

But, it is very difficult, low scalability.
We decided to develop only when it becomes really necessary.

Donald Nong commented May 10 '16, 2:12 a.m.

Are you referring to my answer in the post that Ohsawa san linked? If so, I only went as far as what I wrote in the post. I did not develop any actual reports - I only found a way to solve a problem when I saw it.

Accepted answer

permanent link
Kohji Ohsawa (595128) | answered Apr 05 '16, 3:55 a.m.
Hi Josako-san,

I am trying to figure out how to do what you want to do, but I haven't found it.  Would it be possible for you to separate enum list into multiple rows and query it? If so, the post below would be helpful.
HIROAKI JOSAKO selected this answer as the correct answer

2 other answers

permanent link
Tadahiro Hara (904) | answered Apr 20 '16, 2:57 a.m.
Hi Josako-san

As Donald-san mentioned, I also think using advanced data set and filters is needed.
In addition, I think JavaScript is also needed to build parameter string.

For implementing JavaScript , please see this page

Integrating BIRT

In below pages, some reports design files have JavaScript Implementation.
please refer it.
Reports Central

permanent link
HIROAKI JOSAKO (41219) | answered May 10 '16, 1:28 a.m.
Ohsawa-san, Hara-san

Thanks for Idea.

I understand that it's technically possible.
Consider how to design.
When it is no longer able to organize complex design, we will question here.

Your answer

Register or to post your answer.