czupet

I don't know what you mean by length Here are the properties of the Sub-Report

I have a report with a sub report, the subreport displays a small letter, but some of the contents are getting cut off. The same report looks fine in iReports 5.1 and 5.5, but contents get cut off when I run it on the server 5.0. What can I do to fix this? Thank You

Thank You, I am already using ROLEs, but I wish the security worked like Windows file system. For instance in Windows you don't have to have read access to the root folder and still allow read access to one or more subfolders Thank you for your answer it really helps.

I am trying to apply security to reports in JasperReports server. For example I have the following 2 Users and the following folders Reports- Folder1 Folder2 Fikder3 To my understanding if I want User1 to have read access to Folder1 and Folder2 I have to grant read access to Reports folder for User1 and then remove read access to Folder3 And for User2 I would add read accesss to Reports folder and remove read access to Folder1 and Folder3. Is there an eaiser / better way of doing this? Is there anyway I can avoid removing read access from folders and just add read access to folders i need? Because if you have 20 or 30 folders under Reports and you want a user to have access only to one report you would have to add read access to Reports folder and remove read access to all of the rest of the folders. There has to be a better way! Thank You Peter

I have found this info http://community.jaspersoft.com/wiki/repository-resource-permission

I am using JasperReports 5.1 Server with default setting, using Postgresql database. My question is can anybody point me to documentation on how to open this database so I can look at the data inside this database, what's the userd and password, what file has the connection string? I need to change security in bunch of folders/reports and I was just wondering if it would be easier to go into the database and change the settings in the database directly instead of using the Web interface which is kind of slow. Thank You Peter

I am using iReports 5.1: In CrystalReports you can add a filter to exclude records by Sum like this: Sum ({Amount}, {ZipCode}) > 0.00 How can I accomplish the same in Jasper Reports? For example if I have a Zip code and I do a sum by Last Name in the Zip code group and I only want to display Zip Codes that have sum > 0 for example ZipCode: 12345 Family1 Sum 10 Family2 Sum 0 Family 3 Sum 100 (I want to display all of them) ZipCode: 98765 Family1 Sum 0 I don't want to display this Zip Code or anything under the Zip Code. Thank You Peter

Same results it does not work, I think the problem is the Page Header is processed first and the variable does not get updated until it hits the Group section and by that time it's too late the variable is already displayed.

I tried that, but it did not make any difference

I am using iReport Designer 5.1.0. I have a report when I have to display a variable with a value from the Report Group Header in the Page Header section. The problem is the value in this variable does not change until Report Group Header displays. so the Page Header displays the value of this variable from the previous Report Group Header change. How can I display a variable in the Page Header with the value in the curent Report Group Header variable? Thank You Peter

I am using Access database and jdbc I have no problem when I am using 2 or less inner joins, but when I add a third Inner join I get Error:java.sql.SQLException:General error Is there anything I can do to fix this problem? Thank You Peter. Here's my query: SELECT `Table1`.`MembershipID`, `Table1`.`Mailing Name`, `Table1`.`InformalSalutation`, `Table1`.`Tag_name`, `Table1`.`LastName`, `Table1`.`FamGroupID`, `Table1`.`Status`, `Table1`.`Address_3`, `Table1`.`Address_1`, `Table1`.`Address_2`, `Zip`.`State`, `Zip`.`City`, `Zip`.`Zip`, `Table2`.`Date`, `Table2`.`Amount`, `Table2`.`CheckNo`, `Table3`.`COA ID`, `Table3`.`Description`, `Table2`.`PledgeID`, `Table1`.`SendNoMail`FROM `Table1` `Table1` INNER JOIN `Zip` `Zip` ON `Table1`.`ZipID` = `Zip`.`ID` INNER JOIN `Table2` `Table2` ON `Table1`.`DioUniqueID` = `Table2`.`Family_DUID` INNER JOIN `Chart of Accounts` `Table3` ON `Table2`.`AccountID` = `Table3`.`COA ID`WHERE `Table1`.`Status` = TRUE AND `Table1`.`FamGroupID` = 2 AND `Table1`.`SendNoMail` = FALSE

But how do you create the dynamic connection to the database? for example: I have 2 DSNs in my ODBC manager both for Access Database 1) DB1234 - It's pointing to C:Databases12345.MDB 2) DB5678 - It's poiting to C:Databases5678.MDB Both databases have the same table names and same layout I have 1 report and I want a user to run the report get a prompt for the number and if user enters 1234 the report will use DB1234 DSN and if user enters 5678 the report will use DB5678 DSN. Is this possible ?

I have MS Access database report and several dozen MS Access databases, each Database is named like 1234,5678, 4444, all the same layout. I don't what to copy and maintain the same report for each database, is there a way to create one report and have user enter a number as a parameter and then dynamically create a connection to the database in the report? Thank You Peter

Here's the correct syntax if anyone is interested. SELECT ContactsTable.`RecordID`, ContactsTable.`ScanType`, ContactsTable.`MillNumber`, ContactsTable.`MachineNumber`, ContactsTable.`Contact` FROM (`ContactsTable` ContactsTable INNER JOIN `ContactsTable` i ON ContactsTable.`RecordID` = i.`RecordID`) INNER JOIN `ContactsTable` o ON ContactsTable.`RecordID` = o.`RecordID`

I am using iReport 5.1.0 and ODBC for MS ACCESS database But I am getting the following error when I inner join more then 1 table. Does anyone know how to fix this probelm? Thank you Peter Here's my error: Error filling print... Error preparing statement for executing the report query : SELECT i.`RecordID` AS ContactsTable_RecordID, i.`ScanType` AS ContactsTable_ScanType, i.`MillNumber` AS ContactsTable_MillNumber, i.`MachineNumber` AS ContactsTable_MachineNumber, i.`ContactNumber` AS ContactsTable_ContactNumber, i.`Contact` AS ContactsTable_Contact FROM ContactsTable i inner join ContactsTable o on i.RecordID = o.RecordID inner join ContactsTable i on i.RecordID = t.RecordID net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query : SELECT i.`RecordID` AS ContactsTable_RecordID, i.`ScanType` AS ContactsTable_ScanType, i.`MillNumber` AS ContactsTable_MillNumber, i.`MachineNumber` AS ContactsTable_MachineNumber, i.`ContactNumber` AS ContactsTable_ContactNumber, i.`Contact` AS ContactsTable_Contact FROM ContactsTable i inner join ContactsTable o on i.RecordID = o.RecordID inner join ContactsTable i on i.RecordID = t.RecordID at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:377) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:196) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1087) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:668) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1258) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'i.RecordID = o.RecordID inner join ContactsTable i on i.RecordID = t.RecordID'. at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6956) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113) at sun.jdbc.odbc.JdbcOdbc.SQLPrepare(JdbcOdbc.java:4829) at sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:475) at sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:443) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:267) ... 13 more Print not filled. Try to use an EmptyDataSource...