renssak

Hi - sorry for my late answer an thank you for your answer. I hoped there would be a solution via SQL. To step through the jrxml files by script currently is not possible, because we still use the old iReport to edit the reports. Perhaps, when we have migrates to JSS, I can build a script which steps though all jrxml-files to get the used queries - or better to get the used view-names in the queries. But this would be difficult, if there is more than one view used.

Hi all, I'm looking for a way to get all the SQL quelies of all Jasper reports in the repository. Is there a possibility? I haven't found anything yet ...... My problem is that I currently have around 100 database views that were originally created for Jasper reports. A large part is no longer required and should be deleted from the database. Unfortunatelly I have no overview of which views are still used in reports. Thanks in advance. I am currentyl using Jasper Reports Server Version 6.4.2 (Commercial Version) with Oracle for the Jasper-repository. Regards Martin

I fount out again, how it works. Unfortunatelly it is very time consuming. When you have created a project JSS creates for every report you have loaded from the server a project-local copy on the filesystem. But there is no chance to load all of the reports at one time. The reason why I need this is that I now can create a script which takes all of the report names (out of the filename) and the SQL-tables / views (out of the content of the jrxml-files) for documentation.

Create JasperSoft-Studio-project with reports from server Hi all, currently I am using iReport 4.0 to manage my reports but would like to switch to JasperSoft Studio 6.2 when I will upgrade the server from 5.5 to 6.2 In JSS it is possible to work in projects and after finished working on a report to load it to the server. I would like to rebuild the server-struncture into several projects. My question is: How do I get the about 300 reports form the server to the projects which will be in the filesystem. I didn´t find any export-from-server-into-project-funktion in JSS. I hope you could help me - thank you in advance. Regards Martin

Thanks hozawa, but in jiresource I can see the reportname. What I am looking for is the database view or tablename I am using in the report query. If I can find the whole query in thejasperserver database this would help me, too. Martin

Hi all, is it possible to list all views / tables which are used in all jasper-reports? We currently have no documentation, which report uses which table or view and I want to set up a report for this. Regards Martin

Hi all, I try to customize a pie-chart report I built in iReport and found here: http://stackoverflow.com/questions/34758179/different-color-for-item-label-in-pie-chart-jasper#comment57268347_34758179 how to change the colours of the labels into section colour. Unfortunatelly this doesn´t work in my report. I hope, you can halp me. The report I built has an piechart with PieChart_Customizer defined in the Report customizing class. The class is an javascript I built. It works like I want to - except the colours of the label. The changes I found in stackoverflow I made in jfreechart-1.0.19sourceorgjfreechartplotPiePlot.java , built the jar file and then built the customizing-class with this customized jfreechart. I hope you could help me to change the label-colours from fixed colour to section-colour. We are using Jasper-server 5.5.0 professional, but I don´t have access to the server - only to jasper repository via the GUI. Thank you in advance Martin

After I got the right server-certificate it runs with the following command on my windows workstation: "<jasper_home>Jaspersoft Studio-5.6.1.finalfeaturesjre.win32.win32.x86_64.feature_1.7.0.u67jrebinkeytool" -import -keystore "<jasper_home>Jaspersoft Studio-5.6.1.finalfeaturesjre.win32.win32.x86_64.feature_1.7.0.u67jrelibsecuritycacerts" -alias JaspersoftStudio -file "<jasper_home>Jaspersoft Studio-5.6.1.finalcertifckate<cert-name>.crt" -storepass changeit Regards Martin

Hi all, I would like to anable plain-text export for scheduled reports and changed WEB-INFflowsviewReportBeans.xml as shown here in the last section: https://community.jaspersoft.com/wiki/how-enable-plain-text-exporter-reportadhoc-view-or-configure-list-existing-exporters Unfortunatelly TXT still isn´t shown in the Output-Options --> Formats when I create a new schedule. Is there anything other to configure, to export TXT-files? Regards Martin

Hi Massimo, thanks for yor answer, but the links I knew before. Is it right, that I have to create a keyfile on my local machine and put this file into the Studio on the same machine? For example I tried to create the key with: keytool -genkey -alias tomcat -keyalg RSA and to import it with: keytool -import -keystore "<jasper_home>Jaspersoft Studio-5.6.1.finalfeaturesjre.win32.win32.x86_64.feature_1.7.0.u67jrelibsecuritycacerts" -file c:Usersusername.keystore Then I got the reply Keytool-Error: java.lang.Exception: Input is no X.509-certificate Or do I have to create the key on my local machine and import it on the jasper-server? Regards Martin

Hi all, I hope, you could help me. I want to use JasperSoft Studio 5.6.2 instead of iReport which I currently use. Jasperserver is 5.5.0 Professional. With iReport I can connect to the server with the following properties without any problems: ID: Jasper-Server 5.5 - 01_ORGANIZATION_NAME Server-URL: https://<IP-address>/jasperserver/services/repository Organization: ORGANIZATION_NAME username & password In Jaspersoft-Studio I use the same connection-parameters and get a javax.net.ssl.SSLHandshakeException Could anybody explain me, how to install the nessecary cert files on server and client. Thank you in advance. Regards Martin

Hi atmaling, did you find a solution to hide these columns only for normal users? Martin

Hi mastanraosegu, Thanks for your answer. I have tried this (see attachment): Then I don´t get any email - right, but the reports are only saved in the repository, when they are not blank. I would like to save the blank reports in the repository, too.

Hi all, when I check the "Skip email for empty reports"-option in Jasper 3.7, the report will not be sent out by email when it is empty but the empty report will be saved in the repository. In Japser 5.5 the empty reports aren´t saved in the repository, too when I check the "Skip email for empty reports"-option. Is there any way to save empty reports in the repository but don´t send it out by email? Regards Martin

Hi all, I am migrating from Jasper 3.7 to Jasper 5.5.0 On the old system I had to enter the company´s signature in every schedule I want to send out by email. Is there a possibility to configure a standard signature for all emails I will send out? Thank you in advance for your answers. Regards Martin