BIRT How to set the EnumerationList at Dataset Parameters
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. Example: Dataset WI_ID MEDIUM_STRING_VALUE 11111 |enum1|enum2|enum3| 11112 |enum1|enum3|enum4| 11113 |enum2|enum3|enum5| Set Parameter enum1,enum2 RESULT: WI_ID MEDIUM_STRING_VALUE 11111 |enum1|enum2|enum3| Please. |
Accepted answer
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.
https://jazz.net/forum/questions/115288/how-to-create-a-birt-report-with-enumeration-list
HIROAKI JOSAKO selected this answer as the correct answer
|
2 other answers
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
http://www.eclipse.org/birt/documentation/integrating/scripting.php
In below pages, some reports design files have JavaScript Implementation. please refer it. Reports Central https://jazz.net/wiki/bin/view/Main/ReportsCentral |
|
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
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.
Comments
You can easily do this with filters, but I know that you're strongly against using filters. Do you "have to" use parameters?
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
firstmodel_base_0102
firstmodel_deluxedition_0204
firstmodel_miniedition_0204
secondemodel_base_1204
pre_release_base_2016_01
.
.
.
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.
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.
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.