convert string to date time / Parameter

Hi guys,

I need your help please. From my aplication software I get a report Parameter "DatVon" as string. (http://rfindler:8080/birt/frameset?__report=report/new_report_3.rptdesign&DatVon=@DatVon@)

But for further purposes and that the report could run I need the "string" as "date" format. See attached file.

I tried to parse the string into date with this script:

on initialize the report:
importPackage(Packages.java.text);
sdf = new SimpleDateFormat("yyyy-MM-dd");
sdf.parse(params["DatVon"]);

Please give my your suggestion how could I handle this.

Thanks
best regards
rf

P.S.
I know if I change the report paramater from date to string, than it would works. But than some other functions like javascript calendar etc. don?t works in my report.

Find more posts tagged with

Comments

mwilliams

Parsing the string to a date didn't work? What you have above should change the type correctly as long as they enter the string date in the format that you parse it onto. This won't change the parameter type, you'll need to set something like myDate = sdf.parse(params["DatVon"]); and then use myDate in your query or wherever you're using it. Let me know.

birtprofi

Hi Michael,

thanks for your reply. I solved the issue with set up a second parameter. The first parameter is hidden an get the string format from the url.

Into the second parameter I put the script

> importPackage(Packages.java.text);
> sdf = new SimpleDateFormat("dd.MM.yyyy");
> sdf.parse(params["DatVon"]);

and linked the second parameter to my query. This works perfect.

But now I have a question to your suggestion. How could I use a variable in my DataSet. (myDate = sdf.parse(params["DatVon"]);)
Have I use the property Binding for this issue?

greetings
Rafael

mwilliams

If you set a variable like myDate in your initialize script with the parsed date, you could use this value in your dataSet's beforeOpen script.

Is that what you're asking?

birtprofi

Hi michael,

yes this is what I am asking. But I never worked with variables in a dataset before.

Please see attached file (I made a sample database). I put the parse script on initialise of the report. At the moment I use this query in the dataset to get my information:

select * from Orders
where orderdate = ?

I use this script to parse my report parameter:

importPackage(Packages.java.text);
sdf = new SimpleDateFormat("dd.MM.yyyy");
mydate = sdf.parse(params["DatVon"]);

And how could I change the '?' in my query with variable 'mydate'?

If you have time, maybe you could show me this on my report.

best regards

Rafael

mwilliams

In this example, since you're bringing the date in in the dd.MM.yyyy format and the sample database likes the format yyyy-MM-dd, you can see what I did in the initialize script to change the format again to the acceptable format by the sample database. Then, I added the where statement in the beforeOpen script rather than in the dataSet editor. Let me know if you have questions.

birtprofi

Hi Michael,

thanks a lot for your great help. I didn?t know, that I could change the query text with before open script.
With this information I could improve my skils in designing reports.

best regards
Rafael

vishal44

<p>Hi,</p>
<p> </p>
<p>i am fetching date from database in format 20160520 (Todays date).</p>
<p> </p>
<p>I want to show this in report in format 20/05/2016.</p>
<p> </p>
<p>How can i do this.</p>
<p> </p>
<p>Thanks,</p>
<p>Vishal Kalbande</p>

jfranken

<p>Hi Vishal,</p>
<p> </p>
<p>The data binding for the data element will have the following expression by default:</p>
<p> </p>
<p>dataSetRow["column_name"]</p>
<p> </p>
<p>Replace the line above with something like:</p>
<p> </p>
<div>var str = dataSetRow["column_name"]</div>
<div>str.slice(6,8) + "/" + str.slice(4,6) + "/" + str.slice(0,4)</div>
<div> </div>
<div>If the data type for the field is set to "String", that should be all you need to do. If the data type is set to "Date", you'll need to edit the "Format DateTime" property for the data element to specify your desired display format.</div>
<div> </div>
<div>Regards,</div>
<div>Jeff</div>