[Subreport contents getting cut off on the right side]

I don't know what you mean by length

Here are the properties of the Sub-Report

 

[Subreport contents getting cut off on the right side]

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

 

[JasperReports Server Security]

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.

[JasperReports Server Security]

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

[JasperReports Server database]

I have found this info

http://community.jaspersoft.com/wiki/repository-resource-permission

[JasperReports Server database]

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

[Exclude Group and sub groups from printing]

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

[Group Value in Page Header]

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.

 

 

[Group Value in Page Header]

I tried that, but it did not make any difference

 

 

 

 

[Group Value in Page Header]

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

[Multiple Inner Joins]

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

 

[Dynamic Database Connection]

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 ?

 

 

[Dynamic Database Connection]

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

[Inner Join more then 1 table with MS ACCESS database]

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`

[Inner Join more then 1 table with MS ACCESS database]

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

[AuthenticationFailureBadCredentialsEvent when using LdapAuthenticationProvider]

 Here's what fixed my problem:
property name="userDn" value="ldapuser@ldapserver.com"

see the attached file and search for ldapuser

[How To Configure JasperReports 5.0 to use LDAP]

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.

[How To Configure JasperReports 5.0 to use LDAP]

Here's what fixed my problem:
property name="userDn" value="ldapuser@ldapserver.com"

see the attached file and search for ldapuser

 

[ldap in 5.0]

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>   

 

 

[Anyone have JasperServer 4.5 Community Edition authenticating with Windows 2008 R2 Active Directory?]

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

[AuthenticationFailureBadCredentialsEvent when using LdapAuthenticationProvider]

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

[How To Configure JasperReports 5.0 to use LDAP]

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.

[How To Configure JasperReports 5.0 to use LDAP]

Where is that file located ?

[How To Configure JasperReports 5.0 to use LDAP]

Where is that file located ?

[How To Configure JasperReports 5.0 to use LDAP]

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 base

2013-03-15 10:32:09,731  INFO DefaultLdapAuthoritiesPopulator,Thread-1:242 - groupSearchBase is empty. Searches will be performed from the context source base

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 ]

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 ]