MohanRao

Hello, I have a report created with the $P{LoggedInUser} parameter. I am using the type for this as 'com.jaspersoft.jasperserver.api.metadata.user.domain.User' and Default Value Expression as '(Object)$P{LoggedInUser}.getUsername()'. When I do like this, I am not able to compile the report because iReport can't find the 'com.jaspersoft.jasperserver.api.metadata.user.domain.User' class. But when I upload the same report in JasperServer and run it, I am not having any problem. So my doubt is, is there any way I can make it run with iReport? Can you please suggest me which files can I change and what are the changes I need to do? Thanks a lot, Mohan.

Hello, Is it possible to run two different user specific reports in a single report? If anyone had worked on it, please can you give a detailed description on how you did it? Thanks and Regards, Mohan.

Hello, Is it possible to run two different user specific reports in a single report? If anyone had worked on it, please can you give a detailed description on how you did it? Thanks and Regards, Mohan.

Hello, I am trying to show five different reports in a single page. I thought it could be done by using 'sub report' option. When I create five subreports and run, the reports are displayed overlapped on each other. Is there a way to get five reports displayed seperately using sub reports? Thanks, Mohan.

Hello, Is there any option of setting the 'results per page' option in iReport? If yes, please let me know. I could find the resPerPage in Pagination class. But could not get where to set the number of results per page. Please help me. Thanks, Mohan.

Hello, It is clear for me now, how authentication is done using ldap, in Jasper. But there is one thing I am not still satisfied with. I went through the docs and forums also, but I could not find answer for this one question. I have the users in my active directory like this: dn: cn=Mohan Rao, ou=Engineering, dc=sigmainfo, dc=net sAMAccountName: mohanrao (This is the name I use for logging into my sctive directory). When I created a user in Jasper with the name 'Mohan Rao' (as in cn), I could successfully login. But when I create a user 'mohanrao', I am not able to login. Is there a way I could create a user 'mohanrao' and login to Jasper with that name? Can any one tell me how to change the parameters in applicationContext-security.xml file in order to work like this? Thanks a lot, Mohan.

Hi Sherman, I am able to successfully authenticate Jasper to Active Directory through ldap authentication. But there are still some uncleared doubts. 1. In my AD, I have the users setup like this ... dn: cn=Mohan Rao, ou=Users, dc=myCompany, dc=local cn: Mohan Rao sAMAccountName: mohan (the name with which I login to AD) objectClass=User When I create the user 'mohan' in Jasper, it is not getting identified in AD. But when I create the user as 'Mohan Rao' in Jasper, then it is being identified and getting authenticated. So what ever name is given as 'cn' is being searched in AD. Right? So, if I want the username 'mohan' to get authenticated to AD, what changes do I need to do? I have tried with sAMAccountName={0} but still the same. Please give me some suggestion ... Thanks, Mohan

Hi, Please see the documentation available on <a href="http://www.acegisecurity.org">AcegiSecurity</a> This might help you. Even I am also having a problem. Mohan.

Hello, I am trying to get JasperServer authenticated to AD. From my system, I am able to access my user accounts in AD using ldap browser. But when I give the parameters for the LDAP authentication part in applica..-security.xml, I am still not able to get authenticated to AD. I am getting "Bad Credentials". I am using Windows XP Pro. Is there any to do with this? I made changes in the xml file accordingly. One doubt: I have created users for JI (external) without any passwords. Is it OK? Or do I need to set the passwords for the external users in the JIUser table? What value do I need to give in the place 'uid={0}'? THanks, Mohan

Hi, I am trying to integrate JasperIntelligence with JetSpeed (for SingleSignOn). Can anyone please give me sufficient information on this? Or please give me some link where I can find answer to the same type of question posted by some one else. Meanwhile I am on my way trying with this. Thanks a lot, Mohan.

Hi, In Jasper, I am trying to get the users authenticated through LDAP server. I have created a user in Active Directory. I have created the same user in Jasper (externally defined). I have made the following changes in my applicationContext-security.xml file: Uncommented the <ref local="ldapAuthenticationProvider"/> Commented the <ref local="daoAuthenticationProvider"/> And I have uncommented the LDAP related part. But still when I try to login with the username on LDAP, I am not able to get the user authenticated through LDAP server. This is the error I am getting: 350 WARN [LoggerListener] Authentication event AuthenticationFailureBadCredentialsEvent: user1_jasper; details: org.acegisecurity.ui.WebAuthenticationDetails@ffffc434: RemoteIpAddress: 192.168.20.72; SessionId: DA46214B569BE16A0FD90C3068992252; exception: Bad credentials Can anyone suggest me what are the additional things I need to do? Or if possible please send me the applicationContext-security file which was modified to work with LDAP. Waiting for a solution desperately .. thanks in advance, Mohan.

Hi, Is there any reference guide on the information for using JasperServer with LDAP? Or can anyone please give me a link where I can find the information about authenticating JasperServer through LDAP? Thanks a lot, Mohan.

Please ... I desperately need a solution for this

Hi, I have created a user in my LDAP server. I have created the same user in JasperServer also(defined as external). I have enabled the LDAP Authentication in the security xml file. I am not able to get the Jasperserver authenticated by LDAP. This is the error I am getting. Any ideas, please? Can anyone suggest me how can I change the applicationContext-security.xml? 16:59:57,960 INFO [ExpressionEvaluationUtils] Using JSP 2.0 ExpressionEvaluator 17:00:02,937 WARN [LoggerListener] Authentication event AuthenticationFailureBadCredentialsEvent: admin; details: org.acegisecurity.ui.WebAuthenticationDetails@166c8: RemoteIpAddress: 192.168.20.72; SessionId: 347F0D86236AAA21F6D558566FAC988B; exception: Bad credentials 17:00:02,937 WARN [LoggerListener] Authentication event AuthenticationFailureBadCredentialsEvent: admin; details: org.acegisecurity.ui.WebAuthenticationDetails@166c8: RemoteIpAddress: 192.168.20.72; SessionId: 347F0D86236AAA21F6D558566FAC988B; exception: Bad credentials 17:00:02,945 WARN [JSCommonController] There was a login error 17:00:16,539 WARN [LoggerListener] Authentication event AuthenticationFailureBadCredentialsEvent: user1_jasper; details: org.acegisecurity.ui.WebAuthenticationDetails@166c8: RemoteIpAddress: 192.168.20.72; SessionId: 347F0D86236AAA21F6D558566FAC988B; exception: Bad credentials 17:00:16,543 WARN [JSCommonController] There was a login error

Hi, Can anyone please let me know how do I modify the applicationContext-security.xml to get authenticated from LDAP server? Is it the only file we need to make the changes or do we need to change set of files? I am facing a problem. I am not able to make out what parts of the file I should comment. I have uncommented the LDAP part, and commented the few other parts of the same file. If anyone has worked with authentication with LDAP server, please can you give me details of how to make the changes in applicationContext-security.xml file? If possible I want to see the template of a file how you modified it. It is urgent. Please help me. Thanks a lot, Mohan.

Hi, I have a requirement of making jasperserver work with Active Directory. I am trying my best to find a solution. Posting this question to get the solution faster. If anyone has worked on jasperserver with Active Directory, please give me a detailed information on how to implement jasperserver with Active Directory. Meanwhile I will be trying from my side too. Thanks a lot, Mohan.

Hi, I am trying to login to JasperServer through JetSpeed. This is what I have done in SSO Management screen. 1. Created a user 'admin' in both JasperServer and JetSpeed portal (with same passwords) 2. In the JetSpeed portal, I entered the follwing: Site Name: JasperServer Site URL: http://localhost:<port>/jasperserver/j_acegi_security_check 3. Site Realm: 4. Field name for User ID: j_username 5. Field name For Passowrd value: j_password In the SSO details section, I entered the following: Portal Principal: the user I created in JetSpeed (admin) Remote Principal: the user I created in jasperserver (admin) Remote Credential: the password for the user 'admin' in jasperserver Then, I am trying to access http://localhost:<port>/jasperserver. I am getting again the login page. I am not able to bypass the login page of jasperserver. Can I do it? Is it possible? If so can anyone provide me sufficient information on what do I need to do to implement this feature Thanks in advance, Mohan.

Can anyone tell me what exactly is j_acegi_security_check? As of now, I could only understand that it is a security mechanism used for the web applications. But how do I find it? In the login page of JasperServer, there is "<form name='xxxxx' action='j_acegi_security_check'>" So I thought it is something like jsp or a servlet. But no where I am able to find that j_acegi_security_check. Can any one give me any idea about this? Thanks in advance, Mohan.

Hi, Is there any way I can pass the logged in user name to the report query at run-time? I have tried using $P{UserName} in a text field in the iReport, but when seen in the browser, it show null. I have tried the same thing with $P{LoggedInUser} also. But it fails (gives null). Thanks, Mohan.

Hello, I am trying to create users and roles in JasperServer. So far I am able to create users and assign them to one of ROLE_ADMINISTRATOR, ROLE_USER, ANONYMOUS_USER. When I try to create a new ROLE, it is being accepted. But when I assign any user to this new ROLE, it doesn't give access to the reports. I tried with it but failed. Do I need to do something more? Can anyone please help me in this regard? My question is: if I want to create a new role and assign any user to that role, what are the extra things I need to do? Thanks in advance, Mohan.

Hi I am trying to work on JasperIntelligence with JetSpeed2. I was just trying to by-pass the login page of jasperserver. I have the same users created on JetSpeed also. By logging with the same username in the JetSpeed, I should be able to enter into the report navigation screen of Jasper (which comes afer login). Can any one please give me some tips on this? Thanks in advance, Mohan.

Hi, In fact, it was my silly mistake, which I realized just after posting my question :-) In the mysql-ds.xml, in one place, I had not given the correct datasource name. When I realized this and changed it, it was working fine. Thanks for the help. Cheers, Mohan swood wrote: We use JBoss every day. When you say it doesn't work, you have to give more details. Stack traces, behavior etc. Sherman JasperSoft

Hi, Thanks a lot, but it is not working. I had made the necessary changes. Let me show what I did: This was my jboss-web.xml: <jboss-web> <resource-ref> <description>JasperServer Metadata</description> <res-ref-name>jdbc/jasperserver</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> <jndi-name>java:jasperserver</jndi-name> </resource-ref> <resource-ref> <description>SugarCRM example database</description> <res-ref-name>jdbc/sugarcrm</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> <jndi-name>java:foodmart</jndi-name> </resource-ref> <resource-ref> <description>Foodmart database</description> <res-ref-name>jdbc/foodmart</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> <jndi-name>java:sugarcrm</jndi-name> </resource-ref> </jboss-web> I have the web.xml of jasperserver. I have not changed it. This is my mysql-ds.xml: <datasources> <local-tx-datasource> <jndi-name>MysqlDSA</jndi-name> <connection-url>jdbc:mysql://localhost:3306/jasperserver</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>root</user-name> <password>dbadmin</password> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name> <!-- should only be used on drivers after 3.22.1 with "ping" support <valid-connection-checker-class-name> org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class- name> --> <!-- sql to call when connection is created <new-connection-sql>some arbitrary sql</new-connection-sql> --> <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql> --> <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources> Can you please spare some time to look at what I had done? I had renamed the jasperser to jasperserver.war. Also if I have to do any additional things, please let me know. Thanks a lot for the help, Mohan. Grazy Mos wrote: There is a sample of the syntax of the mysql-ds.xml file at jbosdir/docs/examples/jca/mysql-ds.xml Here is mine:<datasources> <local-tx-datasource> <jndi-name>MysqlDSA</jndi-name> <connection-url>jdbc:mysql://127.0.0.1:3306/jasperserver</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>root</user-name> <password>root</password> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name> <!-- should only be used on drivers after 3.22.1 with "ping" support <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name> --> <!-- sql to call when connection is created <new-connection-sql>some arbitrary sql</new-connection-sql> --> <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql> --> <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources> Make sure you put your mysql driver jar in the serverdefaultlib Then follow the install guide and create a jboss-web.xml here is a example of my jboss-web.xml: <jboss-web> <resource-ref> <description>JasperServer Metadata</description> <res-ref-name>jdbc/jasperserver</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> <jndi-name>java:/MysqlDSA</jndi-name> </resource-ref> </jboss-web> also dont forget to rename the jasperserver directory to jasperserver.war else jboss wont deploy it Niels,<br><br>Post edited by: Grazy Mos, at: 2006/11/21 07:40

Hi, I have installed JBoss-4.0.5.GA on my Windows XP machine. I was trying to deploy jasperserver on JBoss, but not able to do it. I have copied jasperserver to JBOSS_HOME/default/deploy/. I have created the mysql-ds.xml file. I just copied the contents of the context.xml of the apache-tomcat. Can anyone please give me a detailed information on what I have to do in order to run the JasperIntelligence on JBoss successfully. Kindly help with the syntax also. Thanks in advance, Mohan.

Hi, Thanks a lot. Drill through works fine now. I have one more question: I have created a report using JasperIntelligence. Without exporting that report to either html or pdf, can I save the report directly from JasperIntelligence browser to my local file system? Is that possible? If yes, please can you share with me? And may I know where that report is stored when created? Thank you, Mohan. catador wrote: Hello, You are using a Mondrian Connection?? for your olap view? because if u are using a xml/a connection, probably you can't sucessfully drillthrough. With Analisys Services doesn't work drillthrough. If u are using mondrian, by default you obtain descriptions of your dimensiones and the measure where you click the drillthrough arrow. i hope this helps you.