majst2005

I have a report that has several groups on it. For one of the groups, I want to show the group footer on a new page. I have tried adding a "break" element to the band, and this works well for the most part. There are occasions when the page break will actually insert a blank page between the last detail row and the group footer. This is not ideal, as now there are random blank pages in the report. It also doesn't seem to work when the dataset is small. I don't see any options available that will start the group footer on a new page. Does anyone know how to do this?

When viewing an ad hoc report in JRS, only the first 36 pages are being returned. By default, the input controls are all set to "is one of", with the "NONE" option selected to bring back everything that the view/domain finds. If I switch the filters to "ALL" while viewing the report, all pages (approx. 1500) are returned. Since this report is used against several sets of data, is there a way to display all the data on the report while having the input controls set to "NONE"? This is a default tomcat/postgreSQL installation on a 64-bit, Windows 7 machine, connecting to an Oracle 11gR2 database using the TIBCO Oracle driver. Thanks in advance.

How did you overcome this? Thanks, Brian

In JasperReports Server v5.1 I am not able to see any table structure in the domain designer when connecting to an Oracle database. The reports that are built from the domains still work though. If I open an existing domain imported from a previous version, I recieve the invalid objects message, which then lists every field in the selected tables when I click on Show Affected Resources. When I create a domain from scratch, and select the schema I want to use, all the tables appear in the list, but when I click the plus to expand the table, no columns are shown. This is only affecting the one dataset. If I select a different schema, I can access all of the tables fine, unless the tables overlap (In this case I selected an older jasper schema and could use all of the tables except for the QRTZ% tables which are also contained in the aforementioned dataset). When using the same dataset, but on SQL Server, everything works as it should. This is only affecting the one dataset on an Oracle db no matter what the schema name (we have multiple schemas with the same table structure). I am using JasperReports Server 5.1, on tomcat, installed with the windows installer using default settings.

I found this article http://community.jaspersoft.com/wiki/multiple-datasources-ireport-lists-tables-and-subreports that details how to use a seperate data source for a list or table element. This works great in iReport, however, when I load the report into the server repository and run the report in iReport, I recieve the following error: java.lang.Exception: 1 - Error evaluating expression : Source text : $P{connection} at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403) at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320) at com.jaspersoft.ireport.jasperserver.ReportRunner.run(ReportRunner.java:70) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) $P{connection} is the parameter I am using to insert the new connection. When I placed the report in the repository, I set up an input control with a single select list of values, with the value being the connection string.

This worked, thanks!!!

When I try to install JasperServer 5.0.1 WAR Archive, into Oracle 11.1.0 and JBOSS 5.1.0, I recieve the following error: BUILD FAILEDC:UsersbsmithDesktopProjectsJasperReports Serverjasperreports-server-5.0.1-binbuildomaticbindb-common.xml:871: The following error occurred while executing this line:C:UsersbsmithDesktopProjectsJasperReports Serverjasperreports-server-5.0.1-binbuildomaticbinimport-export.xml:264: The following error occurred while executing this line:C:UsersbsmithDesktopProjectsJasperReports Serverjasperreports-server-5.0.1-binbuildomaticbinimport-export.xml:158: java.io.IOException: Cannot run program "C:Program FilesJavajdk1.6.0_30jrebinjava.exe": CreateProcess error=206, The filename or extension is too long Any idea on to fix this?

Apparently it is a version issue. The ability to pass fields of the main report to parameters of the subreport broke somewhere between 3.7.1 and 4.1.3

I am trying to pass a field in the main report to a parameter in the subreport so I can limit the subreport query based on the field value. The query I am using in the main report has a nvl in the where clause, which works fine for bringing back the field values, but when I try to pass them to the parameter it is sending null. The query in the main report is "SELECT customer_number FROM customer_table WHERE customer_number like nvl($P{customer_number}, '%')" The subreport should then use the customer number to bring back information about that specific customer. This is not happening because "null" is being passed instead of the customer number.