mariopielak Posted September 16, 2010 Share Posted September 16, 2010 I have issue with date type input control in new JasperServer 3.7.1...My input control can't be optional.. I must choose date...In an earlier version JasperServer 3.7.0 It was possible to put empty date inside this control Anybody help? Link to comment Share on other sites More sharing options...
knoll0 Posted November 9, 2010 Share Posted November 9, 2010 Hi all, Ive got a similar Problem. Dates HAVE to be optional in my Reports sometimes. Now i can't make dates optional anymore.In addition to that i used to have a flexible query which don't work aswell.Explanation of the main query (simplified):SELECT<FIELDS>FROM<TABLE>WHERE 1=1--- Welches Datum$P!{PAR_DATUMSART_VALUE} Explanation of $P!{PAR_DATUMSART_VALUE} (simplified):($P{PAR_DATUMSART}.equals(null)==true ? "" : " AND convert(CHAR(21),"+ $P{PAR_DATUMSART} +",120) BETWEEN '"+ $P{PAR_DATUMVON_VALUE} +"' AND '"+ $P{PAR_DATUMBIS_VALUE} +"' ")So this used to work fine in 3.7.0.1 but now the Query String isn't built dynamically anymore.No matter if there is $P{PAR_DATUMSART}.equals(null)==true is true or not it ALWAYS appends the code to the Query-String but it shouldnt.Any suggestions on that would be highly welcome, have to fix that problem soon.Thanks alot! 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