mlopez_1

You can use a textfield -> Properties -> Text Field -> Pattern to format timestamps
Regards

I make a trick and works very well.
Use in Dataset and Query Dialog
<queryString language="plsql">
  <![CDATA[{call my_procedure(some_input)}]]>
 </queryString>
With this we force to execute the stored procedure for filling temporary table first of all when opening the Report Unit.
Make sure that 'When no data type' report property is set to "No Data Section'.
After this, insert a table component in 'No Data' section. Table must have a Dataset, where you will put your temporary table's sql query and recreate its fields in this component.
Regards,
 
Mariano

Errors alway log at $JASPERSERVER_HOME/apache-tomcat/logs/catalina.out, NOT jasperserver.log
Mariano

Yes, you are right.
Then, the only thing i know to do is this:
WHERE id_org IN $P{PARAMETER_LIST}[/code]And use PARAMETER_LIST as java.util.List and its Default Value Expression as:
$P{ID_ORGANISATION}.equals("123") ? Arrays.asList("1231","1232","1233","1234") : Arrays.asList($P{ID_ORGANISATION})[/code]This should work.
Mariano

Hi Sid, there are two approach for what you want to do.
First, include the resource as a Report Unit local resource, Second, create a Repository Resource and use it inside Report Unit as a link of these resource.
In both cases you have to reference the resource with "repo: resource_or_link_name".
I use the second approach but both are goods.
Take a look at https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v621/understanding-repo-syntax
And see: repo: used without a path
Mariano

This a Tomcat issue.
You must configure $JASPERSERVER_DIR/apache-tomcat/webapps/jasperserver/WEB-INF/web.xml:
<session-config>
        <!-- Default to 20 minute session timeouts -->
        <session-timeout>60</session-timeout>
 </session-config>
And restat the server.
Mariano

Only if you make a scriptlet that returns a List after making the query.
Mariano

You must look at:
org.postgresql.util.PSQLException: ERROR: function public.dblink(unknown, unknown) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts.
This your problem.
Mariano

If I understood, you only have to duplicate textfields that you need.
Mariano

Go to input control folder locations with jaspersever application and right click, select permissions and be sure that ROLE_USER has read only permission.
Mariano

For me is much more easier using:
$X{IN, <column_name>, <parameter_name>}
$X{NOTIN, <column_name>, <parameter_name>}
$X{BETWEEN, <column_name>, <left_parameter_name>, <right_parameter_name>}
..
..
If parameter values are null, translate it to always true value and doesn't affect to query.
Mariano

Take a look at http://community.jaspersoft.com/wiki/using-ssl-certificate-jaspersoft-studio-55
Works for currents JSS
Mariano

Take a look at:
http://community.jaspersoft.com/jasperreports-server/issues/8251
 
Regards

This is a bug, upgrade to 6.2.1
Mariano

Using something like this:
Arrays.asList("VALUE1","VALUE2",.....)

Solved!!!!. Follow this steps:
- Export eclipse preferences
- Rename folder workspace
- Create folder workspace with the same name as renamed one
- Copy all projects from old folder workspace to new folder workspace
- Open JSS
- Import preferences
- Import projects
- Create new Data Adapters like before were.
- Create new JasperReports Server Connections like before were.
Regards,
Mariano

When the borders is not showed you can use 'Bring to front' what is not showed.
 
Regards