jasperrocks

Url to find reports under a particular folder https://domain.org/jasperserver/rest/resources/pathtofolder?type=reportUnit&recursive=1

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?

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

Thanks reportdev for response

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?

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

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

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}

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

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

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

Do you have dev and test instances on same servers?

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.

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

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.