nparem Posted August 10, 2010 Share Posted August 10, 2010 We have a field in a DB called cycle_string with values in the following format: '2010 17 08/10/10 08/23/10 69'. When I add query into input control, in the preview this string transforms into '[b@1a9e5f2'. All other input controls are working fine. And the same report with this input control works fine in JasperServer 3.0. What the problem with this? Any suggestions will be appreciated. Attachment 1 is a screen shot of this input control in JasperServer 3.0, and attachment 2 is screenshot of it in JasperServer 3.7.Thank you. Link to comment Share on other sites More sharing options...
nparem Posted August 11, 2010 Author Share Posted August 11, 2010 This is a real problem for us. I tried to downgrade to 3.5.0, and got the same problem -- I have an input control with a simple query: SELECT cycle_string FROM rp.v_offer_cycle; And instead of getting '2010 17 08/10/10 08/23/10 69' I see '[b@1a9e5f2' in Report Options. Can anything be done to fix this? Link to comment Share on other sites More sharing options...
lasinir Posted August 17, 2010 Share Posted August 17, 2010 OKay, I had this occuring in my migration from 3.5CE to 3.7CE, but only when I started to update/make changes to the reports via ireport (3.7.3).Previously I copied the JRML file and pasted into 3.7.3 and it ran with out a problem.But when I started to edit it and change the reports I was running, the datafields started corrupting the same as the ones you mentioned, "[@dks434" and so on.But strangely enough I stumbled accross the fix (or atleast it fixed it for me).I went into the dataset of the report that was causing the problem, and edited the query, I then did a read fields and at this point my items that were in the field type column changed. Click ok to commit this update, and hey presto, no more corrupted entries.Of course I was trying other things to fix it ,but none of them had this level of visible change to something that might actaully be about data mis-formating.Hope this helps and let me and others know if it does.-lasinir Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now