Eclipse Community Forums: BIRT » Problem with date parameters changing to string

Home » Archived » BIRT » Problem with date parameters changing to string

Problem with date parameters changing to string [message #1064373]

Tue, 18 June 2013 20:18

Eclipse User

I have a series of reports that use a StartDate and EndDate.

I set up the first date set in a report, export it to the library, then inherit it into additional reports from the library.

The parameters are set up a data type date, text box, format as short date, required.

The StartDate default is: BirtDateTime.addDay(BirtDateTime.now(), -90) and the
EndDate is set up as BirtDateTime.now().

When previewing in the designer I frequently get a display of date-time - when I check the parameter in the report the type has changed to String.

This has happened many times. I never save these date parameters as anything except datatype date.

Once deployed, they do not change the data type.

This is time consuming to continually correct, and the possibility of deploying a badly formatted report is real.

What should I be doing differently? I am using 3.7.2

Any suggestions would be welcome.

Dave

[Updated on: Tue, 18 June 2013 20:24] by Moderator

Re: Problem with date parameters changing to string [message #1064395 is a reply to message #1064373]

Wed, 19 June 2013 01:24

Eclipse User

When does this change take place? Any way you can attach a sample report that I can run that I'll see this issue? I can't recall ever seeing anything like what you're describing. Also, have you tried a newer version to see if you see the same issue?

Re: Problem with date parameters changing to string [message #1064512 is a reply to message #1064395]

Wed, 19 June 2013 11:05

Eclipse User

Thanks for responding. I will truncate a database and report and upload them. I've also had other parameters change from radio button to text box.

It happens when I am fine tuning a report and test it. It's very strange.

Thanks for your support!

Re: Problem with date parameters changing to string [message #1064538 is a reply to message #1064512]

Wed, 19 June 2013 14:30

Eclipse User

Now that sounds very buggy. You might include some steps that you do where this problem pops up so I have some direction to be able to see it. Smile

Re: Problem with date parameters changing to string [message #1064738 is a reply to message #1064538]

Thu, 20 June 2013 13:54

Eclipse User

I'll work on identifying a work flow that produces the result. I hate it when issues appear to be intermittent; they never really are but finding the source can be a bear!

Re: Problem with date parameters changing to string [message #1065661 is a reply to message #1064738]

Thu, 27 June 2013 01:02

Eclipse User

Find any more out on this?

Re: Problem with date parameters changing to string [message #1065802 is a reply to message #1064373]

Thu, 27 June 2013 10:23

Eclipse User

Don't know if this can help, but i noticed something similar: every time i delete the question marks that identify the parameter in the query, not only the configuration of those parameters disappears, but the configuration of the corresponding report parameter is re-set to default values.

Re: Problem with date parameters changing to string [message #1065807 is a reply to message #1065802]

Thu, 27 June 2013 10:30

Eclipse User

What version are you using Paolo?

Re: Problem with date parameters changing to string [message #1065841 is a reply to message #1065807]

Thu, 27 June 2013 13:55

Eclipse User

Hi Micheal!

I'm using the version (4.2.2), in the all-inclusive reporting Juno installation 32bit.
Oh, and what i described happens both in windows (winxp sp3) and linux (ubuntu 12.04) enviroment.
Than again, i'm not really sure if what i'm reporting is on-topic or not, sorry.

Re: Problem with date parameters changing to string [message #1065952 is a reply to message #1065841]

Fri, 28 June 2013 09:18

Eclipse User

Hi Paolo,

Thank you for the insight! The sequence you describe is consistent with the conditions the issue occurs for me. I have been change data sources from views to stored procedures, so I have to re-set the parameters. Now that I am looking for it, that appears to be the issue.

Michael, thank you for your input. I was having trouble getting replication since I didn't think of the data source change to be the problem. I think this resolves my issue as a work around since I now know the conditions. Resetting the parameter is a small price until the code can be corrected. Thank you for your help. Is there anything else you need from me to address the issue? I am using 3.7.2 on windows 7 64, with MS SQL 2008.

Paolo, I certainly think this is on-topic.

Thank you for your help!

Dave

Re: Problem with date parameters changing to string [message #1065964 is a reply to message #1065952]

Fri, 28 June 2013 09:52

Eclipse User

Glad to be of assistance! Smile

Re: Problem with date parameters changing to string [message #1066889 is a reply to message #1065964]

Fri, 05 July 2013 01:13

Eclipse User

Thanks Paolo. I'll take a look at this in the morning so I can see it for myself.

Re: Problem with date parameters changing to string [message #1067035 is a reply to message #1066889]

Fri, 05 July 2013 10:29

Eclipse User

I've not seen this still, but you should probably log a bug for it. Be sure to give step by step instructions on how to reproduce the issue.