jacobhorbulyk

Have you restarted the JasperServer Service? (That is necissary in order for Jasper Server to see the .jar files that you copied over).

So for the URL the Host name part of the URL is either an ip address or a DNS name that maps to an ip address. For example: jdbc:sqlserver://MORSZYNSKA.com;databaseName=Morszynska_dane or jdbc:sqlserver://123.45.67.89;databaseName=Morszynska_dane I used com.microsoft.sqlserver.jdbc.SQLServerDriver with success. With me a WAR distribution was not necissary, the Windows GUI installation was fine. Make sure you put the .jar file in the appropreate directory (C:\Program Files (x86)\jasperreports-server-cp-4.0.0\apache-tomcat\lib) or whatever is most appropreate and then restart jasper server. I don't believe that JasperServer supports DB's without passwords so you may have to put on a dummy password in order to connect. If you need more in detail messages as to why your connection fails, you can download iReport and if you build the same connection in there, you can get more in depth error messages.

So I change the line in the jasperserver-servlet.xml file to: <value>ROLE_USER|redirect:/flow.html?_flowId=viewReportFlow&reportUnit=/Two_Tables</value> and then upon restarting jasper server I get the following error: org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 122 in XML document from ServletContext resource [/WEB-INF/jasperserver-servlet.xml] is invalid; nested exception is org.xml.sax.SAXParseException: The reference to entity "reportUnit" must end with the ';' delimiter.Any suggestions?

So it's not clear to me why a user has to have ROLE_USER assigned to their profile in order to view the repository but assigning ROLE_USER to my new user (in addition to my new role) does grant them access to the repository.

With regards to this post: http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=45586 How would I go about finding the URI?

I believe that I may be missing something obvious here but if I create a new role, assign read permissions to the root directory for the new role and then create a user, assign that user to the new role and then login as that user, I am denied access to the repository. What step have I forgotten?

Would you be able to tell me which file those settings would be in? I would assume it to be a .properties file somewhere in the jasper server install folder.

Hi, I'm wondering if a report contains multiple queries to a database whether or not these queries are done sequentially or in parallel. Can anyone advise me on jasper's inner workings or otherwise tell me if this is a customisable setting? Thanks

Hi all, Is it possible for a user to be redirected to a specific report after login as opposed to entering their login credentials and then being redirected to the repository by default? Is this a feature that is avaialbe in the professional versions or is it just something that has yet to be concieved? Thanks

If you have a server available, you can install JasperServer on the server and JasperServer can act as a report viewer where you can upload reports and then have them run and be displayed in a web browser. This does however require a server and isn't what you are looking for exactly.

I have a database through a database connection that contains multiple tables. If I have users that are unexperienced with SQL and would prefer to use the more visual SQL designer, how can they graphically select which tables to pull data from? The SQL designer window seems to provide a list of columns with checkboxes though it seems to lack the ability to provide a similar list with the tables. Any insight or help would be appreciated.

Might I ask which installation guide this is?

I'm trying to connect Jasper server to a MS SQL server express database via the SQL server JDBC driver and jasper server is complaining that the connection fails. However, I know the JDBC driver is working as java code begining: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); Connection conn = DriverManager.getConnection("jdbc:sqlserver://<my_ip_address>;Instance=SQL2008;databaseName=TEST;user=NewLogin;password=<my_password>"); can successfully perform SQL statements (with <my_ip_address> and <my_password> being substituted for the appropreate values. I have entered: Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver URL: jdbc:sqlserver://<my_ip_address>;Instance=SQL2008;databaseName=TEST;user=NewLogin;password=<my_password> User Name: NewLogin Password: <my password> Can anyone offer assistance as to why this might be failing or a further method to troubleshoot the connection failed message? Thank you in advance for any assistance that can be provided.

I'm new to Jasperserver and i am trying to add a data source to the server. I am adding the data source through a JDBC-CSV driver to connect to some data stored in csv files located on the machine. On the Add Data Source Window I am prompted for a Driver, URL as well as a User name and password. I know the driver and URL information, however what User name/password combination is jasperserver looking for? Edit: To clarify what I mean, if I can access the database in Java with the simple command: Connection con= DriverManage.getConnection(<url>); where I don't need a username/password, how can I make this connection in JasperServer when the User name field is required? Post Edited by jacobhorbulyk at 02/18/2011 18:25