[java.util.Collection as parameter for sql function]

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}.

 

 

 

[WARN JRJdbcQueryExecuter]

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!!

[Need help on dd-Mon-yyyy- Jasper studio]

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!!

[JasperReports Server - Add subreports]

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!

 

[Hide/Print Detail Band]

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!!