swood_1

You have to somehow define the printer at the operating system level so the Java Printing Service can access it.

Jaspersoft generates reports and visualizations from data. What are you looking to achieve? What data?What output?To whom/what?The community versions of the Jaspersoft platform are based on creating reports in Jaspersoft Studio, a desktop report designer. https://community.jaspersoft.com/project/jaspersoft-studio Reports can be deployed into JasperReports Server for consumption and scheduled distribution. https://community.jaspersoft.com/project/jasperreports-server JasperReports Server can be deployed anywhere, including AWS. https://www.jaspersoft.com/aws-reporting https://community.jaspersoft.com/download https://community.jaspersoft.com/documentation The commercial versions add higher level data access ("domains"), ad hoc visualizations and dashboards created through the browser. and embedded analytics https://www.jaspersoft.com/download https://www.jaspersoft.com/quick-start

Have you looked at the JasperReports Samples? They are available as a project in Studio. New > Project... > JasperReports Samples The "FirstJasper" report has an image in it. Also http://jasperreports.sourceforge.net/sample.reference/images/index.html#images

For a crosstab, the entire data set is read, but only the cells for calculation are held in memory. I think this is sort of what you meant by a "header data set". Memory problems come with crosstabs with large numbers of cells: # rows X # columns X # measures. http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.crosstab.bucket.measure.limit can be set to limit the number of cells for a crosstab and try avoid out of memory issues. The way around this would be to have some off-heap cache for crosstab contents.

OK - XLSX as a data source in Studio is messy. The XLS/XLSX data adapter editor will show you the columns it detects in the file, and appears to do some guessing about whther the first row is the column labels. But it will not automatically set the "Skip the first line" checkbox. You have to set it yourself. If you don't set the Skip first line and have column names, you will get an exception as it tries to parse the column name as a NUMERIC cell even if you have the column type in the report as String. In the stack trace, you will see at some point: Caused by: java.text.ParseException: Unparseable number: "Price (USD)" at java.text.NumberFormat.parse(NumberFormat.java:385) The Number and Date formats in the data adapter did not seem to have any effect on the parsing. When you use your XLSX data adapter in a report, the Read Fields process in the Dataset and Query Dialog returns all columns as String. If you have columns in the file are NUMERIC in Excel, but have a String field type in the the field definition in the report, you will get: net.sf.jasperreports.engine.JRException: Unable to get value for Excel field "Price (USD)" of class java.lang.String. ... Caused by: java.lang.IllegalStateException: Cannot get a STRING value from a NUMERIC cell at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:1093) So set the data type of NUMERIC columns to be a java.lang.Float, Integer, Double, BigDecimal, Short or Long in the report field definition. Dates in the file also are treated as NUMERIC during the data parsing, so you will get the same exceptions as above if you leave a XLS Date column as with a field type of String. Set their field type in the report to be java.util.Date. So: Always manually set the "Skip the first line" checkbox in the XLSX data adapter.Set the field type of any numeric column in the XLSX to be a Java numeric.Set the field type of any data column in the XLSX to be a Java Date.

It is jasperserver-pro, not jasper-pro. Don't know why you are getting that exception, but there are likely to be problems with using the Community version of Jaspersoft Studio against a commercial version of JasperReports Server. You should use a commercial version of Studio. Also there is a better way to get a JasperReports Server "sandbox": https://www.jaspersoft.com/jaspersoft-live-trial Spin one of those up for 3 days. Sherman

It is hard to debug this from your description and code, but it looks like the problem is in your code. addMbrProcessDetailList.add(rr9JPPD); is being called for each list and does not appear to be reinitialized for each loop iteration, so the data source continues to grow. Try moving the: List<RR9JPProcessDetail> addMbrProcessDetailList inside the if: if(rr9JPPD.getMierpfList().size()>0) {

During the fill process, expressions can reference any Java that is on the classpath. Class/package imports can be added in the JRXML. Scriptlet JARs can have additional methods attached to them and you can refer to them in expressions via $P{REPORT_SCRIPTLET}.method(arg1, arg2,...)

No. The fill process accesses the data and creates a JasperPrint object, which is a Java representation of the generated content. Exports to final output types - HTML, PDF, Excel, CSV, etc - use the JasperPrint.

You can create report templates via Java. http://jasperreports.sourceforge.net/sample.reference/noxmldesign/index.html#noxmldesign You can also start with a base template and then programmatically update it to your specific requirements. http://jasperreports.sourceforge.net/sample.reference/alterdesign/index.html#alterdesign Or are you talking about generating reports in bulk? Use the REST APIs of JasperReports Server. https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v720/reports-service https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v720/jobs-service Or write your own process to run reports and deal with the output.

Connection reset by peer is a network issue. Something is wrong in the connection between Studio and your Oracle database. I don't see how the parameters would have any effect on the database connection. Can you share the JDBC URL (anonymized) and the JRXML so we can see some details?

Put a PrintWhenExpression on the Group band.

What did the server logs indicate? Look in the Tomcat and JasperReports Server logs.

You also did not set a ContentType header for xls, but did for PDF.

The TIBCO JDBC drivers are from Progress. In general, we have found these as good or better (performance, flexibility, stability...) than the vendors' drivers. The Jaspersoft team tests and certifies all these drivers for use with the commercial versions, and does not certify the individual vendors' drivers. The TIBCO drivers only be used in the commerical Jaspersoft products, as they are controlled by Jaspersoft license keys.

This is CA's DX APM. What data source type are you using to connect to DX APM? I see there are REST APIs. If there is a JDBC connector that implements the JDBC API fully, you can use domains and therefore ad hoc views. If there is no JDBC, you can create JasperReports in Studio. Once you have a JasperReport, you can then create a Topic to use a flat result set in ad hoc views. Sherman

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-ultimate-guide/v720/repository-http-api https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v720/reports-service

Nothing new with domains via REST between 7.1 and 7.2. The structure of domains in REST is described here: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v720/working-domains#top To create a domain via REST, you add the main domain "resource" https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v720/resources-service#Creating_a_Resource https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v720/resource-descriptors#Domain And then add the schema, security and translation files: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v720/working-file-resources#Uploading_File_Resources If you want to create the domain with all its parts in one pass, use the POST method with multipart requests described under https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v720/resources-service#Creating_a_Resource This is what is happening with the JasperReports Server Java REST Client: https://github.com/sgwood63/jrs-rest-java-client#uploading-semanticlayerdatasource

No. The JasperPrint object does not have the concept of detail bands etc - it is focused on page content.

Look at using a Scriptlet. There are beforeDetailEval and afterDetailEval methods.

Were you getting a 502 Connection Refused HTTP response? That usually indicates a proxy or load balancer problem. Assuming you are using AWS, check whether your load balancer has available instances and the security groups are allowing access to the JasperReports Server instances/

Try setting the Evaluation Time of the Text Field to be Page.

Could it be a difference in the deployed fonts? Do the reports look correct in Studio?

See "Set custom size in pixels" https://community.jaspersoft.com/documentation/tibco-jasperreports-server-user-guide/v720/dashboard-properties

Try Ignore Pagination. This will work fine with Excel output and produce multiple pages for doc types like PDF and Word. Also look at using crosstabs, which can wrap nicely down a page.