[API call to list all reports in a particular folder in Jasperserver]

Url to find reports under a particular folder

https://domain.org/jasperserver/rest/resources/pathtofolder?type=reportUnit&recursive=1

[Jasperserver Static encryption]

Hi All,

To prevent logging of user password in tomcat logs we would like to enable static encryption in jasper by setting the dynamic encryption to false (security-config.properties file in /jasper-home/apache-tomcat/webapps/jasperserver/WEB-INF/classes/esapi) .we don't want to change the configurations in  server.xml file configs as it removes complete log information and doesn't make sense of log definition. we used the below url to generate the encrypted key for user passwords

https://domain.com/jasperserver/encrypt.html

Any Idea on how to get the encryption key for a string entered?

[API call to list all reports in a particular folder in Jasperserver]

Hi All,

Is there any way to list all the reports in Jaspersver using rest API.I'm working on something like this but the below one is not working.Any help is appreciated

https://domain.org/jasperserver/rest/resources/Operations?Type=reportUnit&recursive=1

[Jasperserver server Tomcat Logs are showing user passwords]

Thanks reportdev for response

[Jasperserver server Tomcat Logs are showing user passwords]

Hi All,

When a user pushes report from Jasperstudio to Jasperserver we will able to see the password of the user who pushes the report into server in Tomcat Logs.Is there any way we can encrypt the password in Jaspersoft studio?

 

 

[Changing the resource id of a report]

Update the postgres database table to change the resource name "public.jiresource"

[How do I limit the number of records that will show up in a report?]

If you are using oracle you can use fetch first 40 rows only clause at the end of the query;

If SQL Server TOP 40 clause

If MYSQL limit 40 clause

 

[Need help with main report with a subreport- v6.3.0]

In the subreport connection expression, you can use $P{REPORT_CONNECTION} 

and the above mentioned connection string in Data source expression.I don't think you don't need to create this $P{subConn}

[Is there a way to give bulk users access to a group of users?( Something similar to command manager in Microstrategy Tool)]

You can create roles for certain group of users if you are uisng jasperserver and give permissions to reports or folders based on roles.

[How do I limit the number of records that will show up in a report?]

If you are using oracle you can use fetch first 40 rows only clause at the end of the query;

If SQL Server TOP 40 clause

If MYSQL limit 40 clause

[Jasperserver Continuous Integration with Python scripts/Java]

@hozawa.No we haven't .any documentation you know regarding that?

[Reports slow after js-import]

Do you have dev and test instances on same servers?

[Subreport not updating in reports on the server]

I'm not sure this may be the reason I assume there is an old subreport. jasper file in the server and each and every report is still using the old .jasper file to fill the data.

[Cascade input control showing only one row instead of multiple rows]

If possible can you paste the queries for both the controls?

[Pass a value from MAIN report to a parameter in SUBREPORT]

Click on the subreport element in the main report and on the right side you will edit parameters button .select that and map the values you want to pass it from the main report to the subreport.

[Jasperserver Continuous Integration with Python scripts/Java]

Hi All,

 

Our Team is looking for solutions to build CI/CD system for jasperserver where developer commits the code into git and the newly made code changes should get through to jasperserver through python/java scripts. I'm interested if anyone built this system and some insights from them.

 

Thanks

[Extra space in excel cell when exported from jaspereports]

I'm facing the issue in jasperreports when exported to excel it is creating extra space in a cell.It is working as expected for PDF as shown in picture.But when exported to excel it is creating extra space due to property stretch with overflow=true (I need to use this one as it helps for PDF exporting).I used the property net.sf.jasperreports.export.xls.column.width =1000 for the last element to increase the width while exported to excel .it helped to get the result but the extra space is created as show in picutre.Please let me the properties I need to use for this kind of situation.

The properties I used to entire report are

    <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/>
    <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/>
    <property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/>
    <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
    <property name="net.sf.jasperreports.export.xls.ignore.graphics" value="false"/>
    <property name="net.sf.jasperreports.page.break.no.pagination" value="apply"/>
    <property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="false"/>
    <property name="net.sf.jasperreports.print.keep.full.text" value="true"/>
    <property name="net.sf.jasperreports.exports.xls.font.size.fix.enabled" value="false"/>

 

The properties for particular last element

<property name="net.sf.jasperreports.export.xls.auto.fit.row" value="false"/>
                    <property name="net.sf.jasperreports.export.xls.column.width" value="1000"/>
                    <property name="net.sf.jasperreports.export.xls.wrap.text" value="true"/>

For the detail band elemets I used position Type=float

strecth type = elementgroup heigh

Looking for possible solution to remove extra space in cell

PDF export

Excel Export

 

Thanks

[Import Reports from old version deleting existing reports]

Hi,

I'm trying to import some files from Jasperserver CE 5.0 to Jasperserver EE 6.3.0 through buildtomatic/js-export.sh feature where I'm controlling which files to export through JS-EXPORT --uris /foldername and trying to import the exported zip file using js-import --input-zip output,zip.Here the issue it is deleting all the reports in 6.3.0 and replaced by 5.0 reports.How can control import where it should not delete the  existing reports.

 

Thanks

 

[Export Reports to multiple pdf - possible?]

@hozawa can you please explain how you achieved this and is there any sample code?