roosit
-
Posts
34 -
Joined
-
Last visited
roosit's Achievements
-
http://www.roosit.nl/files/jasper-demo.mp4
-
It is not in the report otherwise quotes would have been shown in internal preview and other exports.
-
it is TXT export not CSV. If the error was in the report, it would propably show in both exports
-
http://www.roosit.nl/files/jasper-demo.mp4
-
when i schedule a txt export i will receive a file looking like this (using JRTextExporter) aaaaaa,~06012015,~bbbbbbb,~ccccccc,~dddddddddddddd,~07:53:07~~~~~~~~~~~~~~~~~~~~~~~~eeeeeeeeeeeeeee,~06012015,~ffffffff,~ggggg,~hhhhhh,~07:46:54~~~~~~~~~~~~~~~~~~~~~~~~iiiiiiiiiiiiiiiiiiiii,~06012015,~jjjjjjjjjj,~kkkkkkk,~llllllllllllll,~01:40:03~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~mmmmmmmmmmmmmmm,~06012015,~nnnn,~oooo,~pppppppppp,~01:16:06~~~~~~~~~~~~~~~~~~~~~~~~~qqqqqqqqqqqqqqq,~06012015,~rrrr,~ssss,~ttttt,~00:46:41~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~space replaced with ~ [/code] 1. can i set some parameter preventing the printing of trailing white spaces? isTrimLineRightisTrimLineRight? 2. can i set some parameter preventing the printing of blank lines/lines with spaces only?
-
i get now this csv export: "aaaaaaaaaaaaaaa, 06022015, bbbb, cccc, ddddd, 00:34:05" "eeeeeeeeeeeeeeee, 06022015, ffff, gggg, hhhhhhhhhhh, 02:14:48" "iiiiiiiiiiiiiiii, 06022015, jjjj, kkkk, lllllll, 00:32:33" "mmmmmmmmmmmmmmmm, 06032015, nnnn, oooo, ppppppp, 02:36:31" "qqqqqqqqqqqqqqq, 06032015, rrrr, ssss, tttttttttt, 00:06:49" 1. is it possible to disable this auto added "double quotes (at the beginning and ending of each line)? 2. is it possible to set auto added quotes char to empty string? (like exporter.setParameter(JRCsvExporterParameter.FIELD_DELIMITER, ""); )
-
how do i enable txt export via webservices??? (and why is it not default on????)
-
also configured jndi connection, disabling the auto commit, does indeed what it supposed to do, leaving the TIMEZONE setting for a future report and that is of course not desirable. Although a test report runned fine under jndi. When i switched the datasource of an old report to jndi i got a com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection. So for now, i will wait with switching jndi.
-
We have multiple views that are using TIMEZONE 'variable' like this: CREATE VIEW vtoday ( DAY ) ASSELECT (NOW() at TIME ZONE (SELECT current_setting('TIMEZONE')))::DATE as DAY;[/code]
-
As some of you may have noticed, executing sql statements like this "SET LOCAL TimeZone='Pacific/Enderbury'; SELECT NOW() AT TIME ZONE (SELECT current_setting('TIMEZONE')) ;" is not possible. Rendering reporting of jasper almost useless accross multiple time zones and user queries (at least in our situation). As jdbc offers transaction processing by disabling the default set auto-commit. I guess applying this to jasperreports queryexecuter could solve this problem. Does any one have any information on what the best approach would be to implement this? Why didnt jasper developers implement it this way, in the first place? Is this not as easy as it looks like? Thanks
-
i guess, unbelievable, Maybe Jasper should get married to an international bride to order, maybe then this will get attention
-
If you set the report time zone the database is still not queried with that time zone! SELECT current_setting('TIMEZONE') does not output the same as REPORT_TIME_ZONE people have this problem for years, doesnt nobody at jasper get how this works???
-
Is this going to solve the issue? modify file apache-tomcatwebappsjasperserverWEB-INFclassesesapisecurity-config.properties: security.validation.sql.on=false
-
I have seen lots of posts of people requiring to run compound sql queries. Has some one already thought about creating a patch for the query executer / validator? net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:137
-
aalso solutions with creating stored procedures dont have my preference. Since you have to define return types, i can then start making a procedure for every report, that is not why i am using jasperserver
