glen_l

I am getting the same error under a different circumstance. The pattern does not allow me to use a "with" clause followed by a select that uses a sub-query count for a column. eg with groups as ( some query ) select table1.*,(select count(*) from groups where table1.id = groups.1) as usage_count from table1;

Have you managed to solve this? I'm having the same issue. I'm trying to use a long query using a "with clause" defining 2 tables. iReports produces the report without issue but when I publiush it the server errors with the same regex parsing problem. there's nothing wrong with the query and I don't really need Jasper to compare it to a regular expression for me, what can we do?

Update: It seems like when I take out the max and min values from my datatype it all works fine. Am I missing out a step?

Hi, i've had a quick search on here and can;t find a thing about this, and googled it extensively too, my issue is this. I have an input Control for a report that is linked to a parameter of type BigDecimal, the data type is number between -90 and 90 and the initial validation seems to work. ie "Fish" - You must enter a valid floating point number -100 - Number outside of range -10 - Validates fine. etc. Now the issue comes if I enter a valid number within range that has a decimal point in. If I do this the value get's through the first stage of validation but then I get this error: I don't think the BigDecimal here is linked to the parameter data type becasue I tried changing it to a Double and got the same BigDecimal error. Code: Post Edited by glen_l at 01/23/2012 14:15