hozawa
-
Posts
5,224 -
Joined
-
Last visited
Community Answers
-
hozawa's post in Reports works in Studio, but not on Server was marked as the answer
> Caused by: java.net.ConnectException: Connection refused (Connection refused) at
This seems to suggest there's a problem with connecting to your postgresql from JasperReports Server. Have you tried testing the data source from JasperReports Server to make sure the connection is good. In the Data Source page, select "Test Connection".
https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v71/jdbc-data-sources
-
hozawa's post in Deployment at customer site was marked as the answer
If you are looking on using community version, your option is to use Jaspersoft Studio to design reports and to upload the design file to JasperReports Server to view the report on the web.
If you have looking on using the commercial version, JasperReports Server offers a tool to design simple reports from web browsers.
Both options have permission features.
Whether to let customers design and upload reports or not depends on your policy rather than on feature of the software.
-
hozawa's post in Report user name? was marked as the answer
If you really mean Jaspersoft Studio, the no.
If you are generating a report from JasperReports Server, then it is possible to display the logged in user name of the person generating the report.
-
hozawa's post in Create report was marked as the answer
Go through Jaspersoft Studio documentation on how to create reports with JasperReports.
https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v71/creating-simple-report-0
-
hozawa's post in Jasperreport+jsp+sql like % problem was marked as the answer
What are you doing with while(rs.next())?
Instead of trying to read result set in your program, your jrxml should have "name" and "yourad" fields (not parameters but fields).
Delete the following lines.
while(rs.next()) { parameters.put("name",rs.getString("name")); parameters.put("youad",rs.getString("youad"));[/code]
-
hozawa's post in Licensing question regarding Jasper Studio was marked as the answer
Jaspersoft Studio comes in 2 versions; commercial and community. Commercial version is under a proprietary license but the community version is under EPL. There's some other projects bundling and distributing the community version already.
-
hozawa's post in Split Report in multiple PDF was marked as the answer
No unless you create different reports from the beginning.
-
hozawa's post in I've created html page with using some jquery plugin - i want to include it in my jasper report was marked as the answer
Including html page with jquery scripts in JasperReports is not possible.
-
hozawa's post in Paragraph Indents in HTML was marked as the answer
It's because HTML skips all leading spaces. Instead of uisng Idents use Borders - Padding
-
hozawa's post in Parameter Prompts not working after I added a Table was marked as the answer
Jaspersoft Studio defaults to using the last parameter values. To get the Input Parameter prompt back, click on the show input parameter icon at the top right corner.
https://community.jaspersoft.com/questions/821583/solved-jaspersoft-studio-parameter
-
hozawa's post in PostScript Exporter? was marked as the answer
Finished customizing JasperReports library to support PostScript exporter.
-
hozawa's post in Creating a table in jasper report was marked as the answer
Just place Text Fields for each fields into the Detail band as you want them (with 3 rows). Just want "Item-Item Long Description" and "Inco Term Location" fields to span several columns in the first row.
Then, place borders on each field.
-
hozawa's post in How to get Post Script file format from Jaspersoft REST API? was marked as the answer
Not by default. I had the same requirement because I needed to print out to a postscript printer.
Check the following thread in stackoverflow to convert pdf to ps.
https://stackoverflow.com/questions/19224063/how-to-create-ps-file-from-pdf-file-using-java
-
hozawa's post in [Solved] java.lang.ClassNotFoundException: org.apache.commons.digester.Digester was marked as the answer
JasperReports is using commons-digester v2.1 instead of version 3
<dependency org="commons-digester" name="commons-digester" rev="2.1"/>
-
hozawa's post in Separate PDFs for each report group element was marked as the answer
https://stackoverflow.com/questions/12688778/increase-tomcat-memory-settingsJasperReports only output 1 pdf per report. You'll have to create your own program that uses JasperReports library to do that.
I've done what you've asked before several times so I'm definitely sure that it's possible if you build your own program.
-
hozawa's post in How can I put the Title band below Page Header band? was marked as the answer
Instead of moving the bands for the first page, set the content of the title band to have the content of the page header.
Title band is only printed once.
https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v630/understanding-bands
-
hozawa's post in Subreport is printing multiple times, how to fix it? was marked as the answer
Check that the subreport isn't placed in the detail band.
-
hozawa's post in Using Visualize.js in Jaspersoft Community Edition was marked as the answer
I think that's against the license so NO.
-
hozawa's post in Getting Finnish Language Support in JasperReports Server was marked as the answer
There's some .properties files under webappsjasperserverWEB-INFbundles
Just copy files without the language (e.g. AttributeBundle.properties) and change the file name to end with "_fi.txt".
You'll need to translate text after "=" in each row
You'll then need to convert the text file you just translated to use unicode escape sequence.
Check the following documentation:
https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v60/localization
-
hozawa's post in Problem with cells in Excel report was marked as the answer
Try setting the following property to "false" in your report.
net.sf.jasperreports.export.xls.collapse.row.span
-
hozawa's post in Highcharts.xsd not loading was marked as the answer
I think Highcharts is only available in commercial versions of JasperReports. Check if you are using commercial versions of both Jaspersoft Studio. Note that Jaspersoft Studio will automatically switch to disable commercial features if license is not entered within 30 days after installation.
-
hozawa's post in how to create CSV data source setup in jasper server was marked as the answer
Have you seen the following thread?
https://community.jaspersoft.com/questions/802580/how-create-excel-data-source-jasperreports-server
-
hozawa's post in How to publish custom functions from Jasper Studio to the Jasper Server was marked as the answer
Take a look at this question. You need to export your custom function as jar file and uploading the jar file to JasperReports Server.
https://community.jaspersoft.com/questions/1038286/reports-jasper-server-no-longer-see-custom-functions-jar-resource
-
hozawa's post in I want to create 2 csv files from one action event "(on submit button) from jasper reports was marked as the answer
Don't know what the problem is. Can't you just create a method to generate csv file and call it twice in 1 submit action?
-
hozawa's post in when running scriptlet on jasperserver get "Unsupported major.minor version 51.0" error was marked as the answer
Jasperserver 3.5.1 is too old. Try versioning it up to at least 6.2.x