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...

Here's what fixed my problem: property name="userDn" value="ldapuser@ldapserver.com" see the attached file and search for ldapuser

No need to apologize, I don't not mean to sound offended. I was just saying I did not know what I was doing and needed a lot more detail help.

Here's what fixed my problem: property name="userDn" value="ldapuser@ldapserver.com" see the attached file and search for ldapuser

Here's what fixed my problem: Replace '{' with less then sign and replace '}' with '/' and greater sign - this editor does not work with greater and less then signs {property name="userDn" value="ldapuser@ldapserver.com" } {bean id="ldapContextSource" class="org.springframework.security.ldap.DefaultSpringSecurityContextSource"> {constructor-arg value="ldap://ldapserver:389/CN=Users,DC=mycompany,DC=com" } {property name="userDn" value="ldapuser@ldapserver.com" } {property name="password" value="ldappassword" } {property name="referral" value="follow">{/property> {/bean>

I am having the same issue with JapserReports 5.0 Can you re-post the file again, it's no longer attached to the post? Thank You

I am getting the same error message. Have you found an answer to this problem? Does anybody else have a solution to this problem? Thank You

I appreciate all of you help I really do, and I know it really hard to help someone if they are no providing enough info, kind of like "my car does not work - fix it", but you are telling me is "if you fix your car correctly it will run". I do not know what values are not correct, there are no error messages or log messages that tell me something is wrong, I do not know what to change, that's why I am here, because I need help. I know I have wrong values, but I don't know which ones are wrong or what they should be.

Where is that file located ?

Where is that file located ?

Thank you for your help, but I am still stuggling. Here's my jasperserver.log file I am not sure what this means! 2013-03-15 10:32:09,669 INFO DefaultSpringSecurityContextSource,Thread-1:56 - URL 'ldap://mydomain.com:389/dc=mydomain,dc=users,dc=com', root DN is 'dc=mydomain,dc=users,dc=com'2013-03-15 10:32:09,669 INFO DefaultSpringSecurityContextSource,Thread-1:56 - URL 'ldap://mydomain.com:389/dc=mydomain,dc=users,dc=com', root DN is 'dc=mydomain,dc=users,dc=com'2013-03-15 10:32:09,731 INFO DefaultLdapAuthoritiesPopulator,Thread-1:242 - groupSearchBase is empty. Searches will be performed from the context source base2013-03-15 10:32:09,731 INFO DefaultLdapAuthoritiesPopulator,Thread-1:242 - groupSearchBase is empty. Searches will be performed from the context source base2013-03-15 10:32:29,532 DEBUG FilterBasedLdapUserSearch,http-8090-2:109 - Searching for user 'someuser', with user search [ searchFilter: '(&(sAMAccountName={0})(&((objectclass=user))))', searchBase: 'OU=users', scope: subtree, searchTimeLimit: 0, derefLinkFlag: true ]2013-03-15 10:32:29,532 DEBUG FilterBasedLdapUserSearch,http-8090-2:109 - Searching for user 'someuser', with user search [ searchFilter: '(&(sAMAccountName={0})(&((objectclass=user))))', searchBase: 'OU=users', scope: subtree, searchTimeLimit: 0, derefLinkFlag: true ]