Peñarandix85
-
Posts
5 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by Peñarandix85
-
java.util.Collection as parameter for sql function
Peñarandix85 replied to erik.dittert's topic in Products
Don't know if this could be helpfull but when i use java.util.collection i specify the parameter this way: select * from table where $X{IN, columName, ParamName} I know it is in a where clause but apart of that it doesnt use the expression $P{param}. -
Hi everybody, everytime i execute one of my reports jasperserver.logs prints this error message: WARN JRJdbcQueryExecuter,pool-4-thread-95:144 - The supplied java.sql.Connection object is null what i dont understand is why it writes this when there's no jdbc connection anywhere in this report. and Im not connecting to any database or defined any query. Thanks!!
-
Good morning, In one of my reports i got date field as 10-09-2017 08:19:00 when executing the query but when i print it in jasper studio i use DATEFORMAT($F{date},"dd/MM/yyyy kk:mm") inside the text field. Take a look here: https://community.jaspersoft.com/wiki/date-and-time-patterns Hope this helps!!
-
1. Publish main report and subreports in jasperServer 2. JasperStudio - open main report - from palette add subreport - select a report file (dialog box) - select custom expression as: "repo:/folder1/folder2/subreportname_files/main_jrxml" where folder1 and folder2 are directories previously created on your jasperreports server. 3. JasperStudio - Click subreport from main report - properties - subreport option . Where: - expression should be the same you added in step 2 - Connection expression should be $P{REPORT_CONNECTION} This is the way i use subreports and it works, at least with version 6.4. You can also try specifying in step 2 the option "select a resource from jasperReports server. Hope this helps!
-
Good morning, on the detail band options i have used $F{field}.equals("field"). Im displaying a table using parameters. When i select the parameter (as a filter, named "field) from the panel it prints the detail band not when i dont select any or any different. Im not sure what you specifically need but what i have displayed in detail band is a pic. Hope this helps!!
