VillageIdiot Posted August 11, 2015 Share Posted August 11, 2015 Hi folks,Here's a general question for you - why might a plsql query that produces a resultset in SQL developer produce the same result set but with all values as zero in JasperSoft Studio (and in the report it produces), as well as the report produced by a java app running the same report? They're both being run against the same database, so I expect the same figures.e.g in sql developerSome ColumnValue 1Value 2Value 3This994118That13193Something else232335in jaspersoft studio data preview and in generated reportSome ColumnValue 1Value 2Value 3This000That000Something else000 Link to comment Share on other sites More sharing options...
VillageIdiot Posted August 11, 2015 Author Share Posted August 11, 2015 And the same all-zero thing in the data preview window too, by the way. Link to comment Share on other sites More sharing options...
VillageIdiot Posted August 11, 2015 Author Share Posted August 11, 2015 I reduced the query to one result line that I know has non-zero values in it and these display correctly in the data preview window. The first row of the full result set is all zeros so it looks like JasperStudio is using the first row results for all row output, although I cannot see why it would do this. The expressions in the table are just simple field references. Link to comment Share on other sites More sharing options...
VillageIdiot Posted August 11, 2015 Author Share Posted August 11, 2015 OK, hands up, I'm an idiot! Updated the oracle driver, it works. 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