db2907

Hi there Is there a way to check who has created a Report in Jasper Reporting? We are using the free version, but all that we can see are some dates related with the creation and modification of a report. Regards

Hi there. I'm facing this annoying problem in Jasper. I have created a report based on a postgresql function. When I watch the preview I do not have any problem with the results. However, when I publish the report and try to executing I'm getting this error: I've checked on internet for a possible solution, so far this is the only thing that I have found with a similar problem: https://community.jaspersoft.com/questions/814793/report-execution-fails-due-read-only-transaction-mode However adding the property to Url does not work, or I'm not so sure if I have to write it in this way: jdbc:postgresql://server:5432/data_base?defaultReadOnly="false" In Jasper what else can I do?. I only can query the function, and require any change in it is an HUGE burocratic issue. JasperStudio 6.3.0 Regards.

Hi there Hi wonder if it is possible to create a dblink connection using parameter in Jasper. Something like this: SELECT *FROM ( SELECT * FROM dblink('dbname=db port=5432 host=dbhost user=dbuser password=dbpassword','SELECT column_1, column_2, date_in FROM table t WHERE t.date_in >= $P{start_date}') as check_table(column_1 integer, column_2 text, date_in date) ) as b order by checkout_number [/code]Using de $P{start_date} parameter as an internal filter to improve the performance of my query. I have made some test and looked for some approaches, but so far anything haven't t worked. Anyone has any idea about how to reach this, or this is definitly not allowed? Regards

Hi there I need to publish a report based on a sql query (mysql) that I am not allowed to modify. The user has decided to use a column as a filter for the report. This column has multiple value options: concatenated results (value1,value2,value3) , single values or can even be null. I have created a multi selected query and a string parameter: select a.*from (sql_query) as awhereCASE WHEN $P(parameter) IS NULL THEN TRUE ELSE a.find_in_set($P(parameter), a.filter_column)[/code]However I am not getting any result. Im I doing something wrong, something is missing.... I would appreciate any answer you can give me. Regards.

Hi there Recently I've been trying to implement this option in my report in order to schedule it. However when I try to control null values in my date column, the report seems not to work correctly given that actually I am getting registers with this value in null. I have tested this option in the $X expression but it does not work: WHERE $X{LESS; COALESCE(column_date,'2100-01-01'); date_parameter} Is there anything else that I could try? Regards.

Hi there I have a report that right now only has one filter. This report is consult by multiple persons inside the company. It can not be modified. However this report is useful to other employees if I apply an extra filter based on another column. I wonder if it is possible to create a parameter with a specific value that does not affect the results that the report provides, but at the same time use it in the schedule option to set the values that some specific employees requiere, and send by mail the report each one of them need. The idea is to make invisible the input control associated for the users but visible for the parameter section in the schedule option. Until now I have not reach this solution. Is it possible to do something like that? Regards.

Hi there, I am trying to create a Report in Jasper Studio that uses a SP of a mysql database. When I see the result present in Workbench, this is different to the one present in Jasper's preview. The store procedure receives 2 dates and one integer as inputs. I have tried with different formats in Workbench for the value of the dates: '2016-01-01 00:00:00' '20160101' 20160101 And I am getting the same results with all of them. However in Jasper the result is another. In this report I am using parameters, and even when I have changed the type of value (Integer, String). I can not make it to coincide with workbench. As you can see, the value for Att1 is missing. The thing is that I can not see the definition of the SP because of a permission issues. I just wonder what can I do to fix this. I think this is related with the fields of type Date. Regards.

Hi, thanks for your answer. The server has the same version. And the message that I've got is the same you can see in this forum: http://community.jaspersoft.com/questions/822634/issues-connecting-jaspersoft-studio-jasperreports-server Regards.

hi there I am facing this problem with the connection between JasperStudio 6.0.1 and JasperServer. When I perform a test of the connection I have not problems, but after few seconds I am getting the error message that you can see in the picture. I have try all the possible solution that I have seen in this forum: http://community.jaspersoft.com//questions/818979/connection-jasperstudio-52-ce-jasperserver-52-ce http://community.jaspersoft.com/questions/822634/issues-connecting-jaspersoft-studio-jasperreports-server But so far nothing seems to be useful. What can be wrong?. Regards.