How to make Date Range Parameter with Birt Custom Reports
8 answers
Hello everyone!.
Iam trying to make a table that shows the defects From a "date" to a "date".
What i done so far is crossing tables for the names for severity , priority and state (and no the values ). But i need the Date range parameter.
Any idea for this please?!
Hi Cesar,
Based on the table which you are using (for example, LIVE_WORKITEM_CNT), when you create your dataset, on Fact Information, you have Selected Columns part and Selected Parameters part. If you choose CREATION_DATE, you must check it under Selected Parameters, and in Data Explorer view, you have Report Parameters. Right click, and say New parameter. You'll get a short dialog window. Type the name and prompt text, and under data type choose Date. Display it as text box. Other options leave default.
After doing this, edit your dataset, select Parameters, and on CREATION_DATE click edit. You'll see the option Link to the report parameter, find your parameter, select it, and click ok. Run report, and enter some date.
you can also add a filter in dataset (CREATION_DATE), and bind it to report parameter which you created. here you have a few options: equal, not equal, greater than, less than etc etc...
That should work.
Regards
Hello everyone!.
Iam trying to make a table that shows the defects From a "date" to a "date".
What i done so far is crossing tables for the names for severity , priority and state (and no the values ). But i need the Date range parameter.
Any idea for this please?!
Hi Cesar,
Based on the table which you are using (for example, LIVE_WORKITEM_CNT), when you create your dataset, on Fact Information, you have Selected Columns part and Selected Parameters part. If you choose CREATION_DATE, you must check it under Selected Parameters, and in Data Explorer view, you have Report Parameters. Right click, and say New parameter. You'll get a short dialog window. Type the name and prompt text, and under data type choose Date. Display it as text box. Other options leave default.
After doing this, edit your dataset, select Parameters, and on CREATION_DATE click edit. You'll see the option Link to the report parameter, find your parameter, select it, and click ok. Run report, and enter some date.
you can also add a filter in dataset (CREATION_DATE), and bind it to report parameter which you created. here you have a few options: equal, not equal, greater than, less than etc etc...
That should work.
Regards
Hi Milan :)
I done that, but thats only for filter a single date, for example choosing 5 November 2010, but what i need is a filter that shows me defects that were modified betwen dates for example november 2 and november 5.
I hope you could help me with this!
Hello everyone!.
Iam trying to make a table that shows the defects From a "date" to a "date".
What i done so far is crossing tables for the names for severity , priority and state (and no the values ). But i need the Date range parameter.
Any idea for this please?!
Hi Cesar,
Based on the table which you are using (for example, LIVE_WORKITEM_CNT), when you create your dataset, on Fact Information, you have Selected Columns part and Selected Parameters part. If you choose CREATION_DATE, you must check it under Selected Parameters, and in Data Explorer view, you have Report Parameters. Right click, and say New parameter. You'll get a short dialog window. Type the name and prompt text, and under data type choose Date. Display it as text box. Other options leave default.
After doing this, edit your dataset, select Parameters, and on CREATION_DATE click edit. You'll see the option Link to the report parameter, find your parameter, select it, and click ok. Run report, and enter some date.
you can also add a filter in dataset (CREATION_DATE), and bind it to report parameter which you created. here you have a few options: equal, not equal, greater than, less than etc etc...
That should work.
Regards
Hi Milan :)
I done that, but thats only for filter a single date, for example choosing 5 November 2010, but what i need is a filter that shows me defects that were modified betwen dates for example november 2 and november 5.
I hope you could help me with this!
Cesar,
I sent you a mail with example. All that you need is to add two filters with MODIFIED_DATE, and link them on two report parameters.
Regards,
Hi Milan
Thanks for the report, i dint noticed that I can asociated filters with parameters.
Thanks for the idea, but now i can not filter data extract from dynamic text boxes, am trying now.
But thanks very much :D!
What did you mean by extracting from dynamic text?
Hi Millan.
I have used the filter option to set a range of dates for the RESOLUTION_DATE field, but it does not work for the onfetch event in the dataset. It seems that the filter is applied after the fetch data process.
Any idea to solve this problem?