zakuruchi

I can only think of 3 objects that would require execute only permission in this case : The data source, the JRXML file itself, and the folder where the report is residing. Since the user can run reports in the same folder, perhaps check permission for the report data source or the JRXML file itself?

Hi, You can use the same datasource for multiple tables. You can just use different query/dataset for each table but from the same connection for example.

Hi, It's possible that the line is due to the subreport giving lines when blank record. This can be configured in the subreport properties. I think it's called isRemoveLineWhenBlank. You would need to set it to 'true'.

Hi, It sounds like your subreport is put inside the master report detail band. A report's detail band is rendered for each record in the data source that was passed to the report. If you put a subreport in the master report detail band, it will be repeated for each record in the master's data source. If you want the subreport to appear only once, try putting it in the title or summary band instead of the master report detail band.

Hi, On previous version of JasperReports server dashboard designer, we can add a 'print view' control. How do we add a similar function on Jasper Reports Server 6.0 dashboard designer? Thank you.

CURL from PHP doesn't include any trusted certificate by default. This would mean that as long as you dont tell it which certificates to trust, any https connection it makes will be untrusted, and thus, stopped. The command setopt CURLOPT_SSL_VERIFYPEER false above basically tells curl to not verify certificates for HTTPS requests. If you dont want to bypass CA verification like you did, you can set up a certificate folder somewhere on your server to determine the trusted certificates and have your php.ini refer that folder. You can set up a certificate folder by steps like below : 1. Download a root certificate bundle from the curl website http://curl.haxx.se/docs/caextract.html. If the https site you're connecting uses other certificate, you can download it using a web browser as per the 'proper fix' in the link you gave above. 2, Then set a path to the file on the server in your php.ini file, e.g. on Windows: curl.cainfo=c:apachecacertcacert.pem

The error is usually due to parameters not set up correctly or of the wrong type. You can check the parametres in your query for Ship.id and ensure it's in the correct format (should be something like 'where ship.id = $P{param name}' without quotes).

Here's a step by step that should help : http://community.jaspersoft.com/wiki/connecting-ireport-oracle-datasource In your case, the URL on step 6 should be something like this : jdbc:oracle:thin:@10.11.13.103:1522:dev

The report is Empty is usually due to the dataousrce. Is the datasource in the server set up correctly? You may want to test that first.

Firstly, can you confirm if you can connect to the JasperServer from a web browser. The reason i'm asking is because the error message you posted seems to show that you can't access the server through the web browser. Does the error happen when you enter the URL for jasperserver, or after you login on the login page? This might or might not be related to why you can't upload the report.

Unfortunately you can't do this with ad hoc view. You either view it as chart or as data, but not both. An alternative you can use is to make a copy of your ad hoc view, save one as a chart and one as crosstab, then put both of them in one dashboard.

Hi, I'm currently trying out JasperServer 6.0 and when trying to create a dashboard, I can't find the standard controls like in 5.5. One that I'm specifically looking for is "Print View". Can somebody point me out where it's hiding in the new version? This might be a silly question, but I can't find it :) Alternatively, if somehow it's not available in version 6.0, how do you print a dashboard directly to printer from the server? Thank you.