drueter_1
-
Posts
4 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by drueter_1
-
Any luck with running Server 5.5 with a reverse-proxy? I'm having the same issue. I was able to disable CSRF checking...which allows Server to work for viewing information and running reports...but anything involving writing to the serer (publishing reports, administering users, etc.) fails.
-
I am new to JasperReports Server (but am an experienced software professional). I need to quickly get up to speed on a few Jaspersoft Server points. Is there a JasperReports Server (Community Edition) expert or guru that could spend about an hour with me on Skype? I am able to pay or show my gratitude in some other way. Specifically I need to: Make JasperReports Server work with a reverse-proxy (NGINX or other). I am having problems with this even when I disable CSRF support.Create a role to allow publishing of reports to a specific folder from Jaspersoft Studio that does not require ROLE_ADMINISTRATOR to be granted to the userOptionally: Get JasperReports Server running on CentOS. I have it installed and running...but am unable to access...possibly related to #1 above (I have JasperReports Server running on Windows however.)Any takers? I will be happy to write up what I learn on the Wiki so that other users will benefit.
-
I am running JasperServer 5.5 Community Edition. I can publish reports from Jaspersoft Studio if the specified user is a member of ROLE_ADMINISTRATOR. I have created a new role ROLE_TESTPUBLISH and would like to enable users that are a member of this role to publish reports, but not be able to administer the server. It seems that if a user is not a member of ROLE_ADMINISTRATOR that Jaspersoft Studios cannot connect to JasperServer at all--even if the specified user has Read and Write rights to the desired library folder. What rights are needed to connect to JasperServer from Jaspersoft Studio? Is there a way to set up a user that can publish reports from Jaspersoft Studio, but that cannot administer the server?
-
Getting Started with Jaspersoft Studio and Microsoft SQL Server
drueter_1 posted an entry in Getting Started
drueter_1 posted an entry in Getting Started
Jaspersoft Studio can easily be used to create reports based on data in a MS SQL Server database. Jaspersoft Studio comes with a bundled TIBCO SQL Server JDBC driver but the following steps are instructions for using a native SQL Server driver. Before proceeding, check the "Jaspersoft Supported Platforms Guide" of the relevant JasperReports Server version for the supported versions of MS SQL Server. For JasperReports Server 8.2.0, the supported database versions are MS SQL Server 2016, 2017, 2019. Make sure you have a reasonably current version of Java installed. ( http://www.java.com )Download and install the JDBC driver for MSSQL ( http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx ) . Check the driver compatibility at Microsoft JDBC Driver for SQL Server support matrixIn Jaspersoft Studio, navigate to "Repository Explorer" and "Data Adapters"Select "Create Data Adapter"Select "Database JDBC Connection"Select "MS SQLServer (2005-2012)(com.microsoft.sqlserver.jdbc.SQLServerDriver)" for the JDBC DriverEnter "jdbc:sqlserver://MySQLServerAddress:1433;databaseName=MyDatabase" for the JDBC UrlEnter SQL username and passwordOn "Driver Classpath" tab click "Add" and enter the location of the installed JDBC driver from step 2. Example: "C:Program FilesMicrosoft JDBC Driver 4.0 for SQL Serversqljdbc_4.0enusqljdbc4.jar"Click "Test" to test the connection. Once the connection is tested successfully, click "Finish"Create ReportClick on "Project Explorer" tab and then right-click on "MyReports", then New, "Jasper Report"Enter a File name for the report, then click NextSelect the Data Adapter that you created aboveEnter a query, then click Next, such as:SELECT *FROMmyOrders aJOIN myOrderDetails b ONa.OrderID = b.OrderID;[/code]Follow remaining screens on the new report wizardDrag and drop fields from the Outline pane onto the Main Report paneClick on "Preview"Note that calling stored procedures using standard EXEC myProcedure syntax works just fine in the query, as does including multiple statements (assuming each statement is terminated by a semicolon). All statements are executed against the same SQL connection.
