Tirupathi Mangalarapu

Sometimes we want to format Date time field to different formats or we want to write some arithmetic expressions that need to be written in many other reports. Writing the expressions or manually copying them from other reports will suit the purpose, but we can efficiently solve this by using user-defined expressions in Jaspersoft studio. HowLet’s look at a simple example report Cherry Title Landscape report that uses sugarcrm orders table to bring date that contains ordered,orderdate,shippeddate,shipname,shipcity and shipregion as shown below: As you can see the orderdate and shippeddate give all the details including the timestamp. We want to format the date so that it can only display the date in a certain format. The simple way to do this is to use double click on the element and that brings the expression editor and use per se new SimpleDateFormat("MM/dd/yyyy").format($F{orderdate})" The output is as shown below: Ok. Let’s do that for other elements too like Shippeddate. You can simply copy-paste the same expression as mentioned above or use the recent expression tab and you can see the expression and simply replace orderdate to shippeddate. Easy Right! Note: Recent expressions are cleared when the studio is closed. If you want to re-use the expressions the place to save them is in the Expression Editor as shown in the following screenshots: If you add them to the Expression Editor then those values are persistent and they appear under user Defined Expressions as shown in the below screenshot: This is the simplest of the examples and you can create more complex expressions or use cases. You can change the field name once the expression is added to the expression editor. Hope this helps!

See this for applicable versions and further info: https://community.jaspersoft.com/project/tibco-jaspersoft-connectors/resources On version 7.5 and later, this Connector is already included in the product and does not require a separate download. Prerequisite (only up to version 7.2): download TIBCO Jaspersoft® Connectors Software from TIBCO’s eDelivery website. Open Jaspersoft Studio and create a new Data Adapter: Give some arbitrary name to the connection: 'Autonomous REST Connector-Data Adapter' In the JDBC Driver Section, use the following class name: “tibcosoftware.jdbc.autorest.AutoRESTDriver” Add the TIautorest-6.x to the Driver Classpath as shown below: Just to keep this KBA simple and clean, I created a REST endpoint that returns the countries and states data as shown in below screenshot: The next step would be to build the REST file syntax. I have used a very simple country extraction from the REST point. This can get complex, Please refer to progress documentation for more advanced use cases. Here is the link to the documentation: https://docs.progress.com/bundle/datadirect-autonomous-rest-connector-jdbc-60/page/Setting-up-the-driver.html Here are the contents of my REST file: {"countries" : { "#path" : "http://localhost:90/response.json countries", "country" : { "#type". : "VarChar(20)", "#virtual" : true, "#eq". : "Country" } }}[/code]Save the file to the computer disk and now, you can reference this in the JDBC connection string URL: “jdbc:tibcosoftware:autorest:Config=C:TempMyRest.rest;SchemaMap=C:temp;TransactionMode=ignore;RefreshSchema=true” Also note: The driver is using no authentication. The driver does support Basic, HTTP header, URL, OAuth 2.0 and custom authentication. Please refer to progress documentation for more information. Finally, The Data Adapter will be as shown below: If everything is configured properly and when you click on “Test” you should see a “Successful” message. After this the steps are the same, you would create a jrxml file and read the contents from the source in this case it’s the REST end point using the Progress Autonomous connector. Note: We strongly recommend customers using this Autonomous REST Connector as this is officially supported by TIBCO Jaspersoft. Whereas the Web Service data source is a community only project and it not officially supported by TIBCO Jaspersoft. myrest.rest response.json autonomusrestconnector-dataadapter.xml

WhyThis article is for someone who has developed some custom code or classes and you deployed them to TIBCO JasperReports® Server and they like to get detail logging information when troubleshooting those custom modules. HistoryYou can set log settings to any of the following log levels: INFO, ERROR, WARNING, and DEBUG for all the out of the box classes listed under server settings. But if you've added custom codeclasses then you would need to manually configure the class name in the log settings on the JasperReports® Server to enable detail logging (INFO, ERROR, WARNING, and DEBUG). HowHere is an example scenario: I used the OAuth custom authentication provider for which I built the jar file and dropped the jar file(along with dependencies and the configuration file) into the WEB-INF/lib directory and building the custom authentication provider is beyond the scope of this KBA. Now to enable logging for custom classes, log in to JasperReports Server with user credentials that have access to Server Settings (/jasperserver-pro/log_settings.html) As shown below: At the bottom of the right of the page, you see a free text field where you can enter the class name into the free text input field. So you need to get the class name of the custom class, which in this case is: package.calssname: “com.jaspersoft.jasperserver.ps.OAuth. OAuthPreAuthenticationFilter”[/code]Add this value into the free text field and choose "DEBUG"(you can select any of the log levels: ERROR, WARN, INFO or DEBUG). An entry will be created into the log settings as shown below: Now, when we the server hits the module, then we can see debug entries in the Jaspersoft log file as shown below in the screenshot: Note: Please ensure that you disable debug logging after troubleshooting so that it will not add more overhead to the server performance. Go to Restore Defaults section, select the class, and click on delete:

Prerequisites:TIBCO Jaspersoft® Studio installed on your machine. TIBCO Spotfire® Server setup and one information link are already created on the Spotfire® Server. For more information on how to create information links please, refer to Spotfire Documentation here. Steps:Open Jaspersoft Studio 7.3.1 Under Repository tab Create New Data Adapter > TIBCO Spotfire Information Link > Next Give a Descriptive name on the URL: Provide Spotfire Server information in this format: http://[hostname]:[portnumber]/spotfire/[/code]Also, provide username and password and choose version “Spotfire 7” First, click on Test Connection. Once the test is successful, click on the browse button and select an information link that you wish to bring into Jaspersoft A screenshot for your reference below: Click ok And Click Finish.Once the data source is created in the Adapters, you should be able to create Jasper report using this information link as any other data sources. Note: This article only tested with Basic Authentication on Spotfire Server. Spotfire Version 10.x.x and Jaspersoft Studio version 7.3.1 References:https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v720/look-tibco-spotfire-information-links-0

WhyFew of Jaspersoft customers asked whether there a way to controllimit the number of sessions a user can log in for some particular business requirement. HistoryThere was a KBA written for an older version of the TIBCO JasperReports® Server. That wiki is outdated. Please refer to this KBA and free feel to extend and use as per your business needs. This wiki is relevant for JasperReports® Server version 7.1 (I did not test in 6.4.x versions of JasperReports Server). How Follow the steps listed below: Copy the jar file to /WEB-INF/lib (see attachment) Add concurrencyFilter to the filter chain (/** chain) in applicationContext-security-web.xml after the encryptionFilter position. <bean id="concurrencyFilter" class="org.springframework.security.web.session.ConcurrentSessionFilter"> <property name="sessionRegistry" ref="sessionRegistry" /> <property name="expiredUrl" value="/login.html?error=1" /></bean>[/code]Add sessionManagemenetFilter to the filter chain (/** chain) in applicationContext-security-web.xml after the JIAuthenticationSynchronizer position <bean id="sessionManagementFilter" class="org.springframework.security.web.session.SessionManagementFilter"> <constructor-arg name="securityContextRepository" ref="httpSessionSecurityContextRepository" /> <constructor-arg name="sessionStrategy" ref="sas" /> <property name="invalidSessionStrategy"> <bean class="org.springframework.security.web.session.SimpleRedirectInvalidSessionStrategy"> <constructor-arg name="invalidSessionUrl" value="/login.html" /> </bean> </property></bean>[/code]Add this bean too <bean id="httpSessionSecurityContextRepository" class="org.springframework.security.web.context.HttpSessionSecurityContextRepository"/>[/code]comment out the bean with id "sas" <!-- <bean id="sas" class="com.jaspersoft.jasperserver.war.JSSessionFixationProtectionStrategy"> <property name="migrateSessionAttributes" value="true" /> </bean> -->[/code]and replace it as shown below: <bean id="sas" class="com.jaspersoft.jasperserver.cs.concurrent.session.JRSConcurrentSessionControlStrategy"> <constructor-arg name="sessionRegistry" ref="sessionRegistry" /> <property name="maximumSessions" value="1" /> <property name="exceptionIfMaximumExceeded" value="true" /></bean>[/code]Restart JasperReports Server. Note:Please note the URLs configured on these beans can be changed to something other than the login page and that exceptions that get thrown to the login page will all display invalid credentials as there is no way of handling or showing individual exception details on the login page. It is possible to send users to other pages or add pages to the jasperserver instance for these URLs but that is beyond the scope of this document. Also, note that if a session is not logged out explicitly or if the user closes the browser then the user needs to wait until that session times out or he explicitly logs out to log in again. So, please be very cautious and do thorough testing before implementing this as is. concurrent_session_control_for_jrs_7.1.zip

How can we show parameters for the report or Ad hoc view in the report itself?Many customers ask the question: “How can we show parameters for the report or Ad hoc view in the report itself?” and recently one of our solutions consultant engineer came up with this POC project for a prospect and I thought this would be very helpful for all Jaspersoft customers. Please follow the steps listed below to display report parameters for each resource type Charts, Crosstabs and Tabular data in reports and ad hoc views. As this was a POC for another customer, this is not fully tested. Note: Please ensure that you have done thorough testing before publishing this to production. Download and install the "adhocparams-0.0.2-SNAPSHOT.jar" file. You need to download the Jar file attached to this Wiki. Installation: After download, extract the jar file and drop adhocparams-0.0.2-SNAPSHOT.jar file into the Tomcat/webapps/jasperserver-pro/WEB-INF/lib/ and restart the Tomcat Application server. And, then login to Jasper server and import downloaded exportTemplate.Zip file Importing "exportTemplate.zip" into Jasper Reports Server: Usage, when you want to create a report from an Adhoc View, use the template /public/templates/ShowParameters: This template works for Tables, Crosstabs and Charts. The only behavior you might run into is that when you have filters with many values inside, the Chart, Table, and Crosstab could be starting in Page 2. As you see on the screenshot, the parameters values do not cover the entire page because it is predefined to be printed on a document: Hope this helps some customers! exporttemplate.zip adhocparams-0.0.2-snapshot.jar