cjturner

I have installed JasperServer Community Ed., (v5.5.0a 64bit on WIn 2008), and my security people are complaining about vulnerabilities in Tomcat supplied. I downloaded Tomcat 8.0.8 and have attempted to run JasperServer in that, copying all of the configurations and files as needed. JasperServer fails on startup, with an error apparently in the ESAPI security module. Has anyone gotten JasperServer (5.5.0a) to run on Tomcat 8.0.8?

What you are getting here is "community" support. Support by the community is only as good as the community feels like doing. I have noticed that JS folks usually only step in (here) when there is an actual bug detected. Makes sense. They have bills to pay, too. I use CE for my customers, as their needs have yet to exceed those capabilities. However, I have a Pro license to (a) support JS; and (b) to get help when I need it and my customers are hot & bothered. When you pay, there is another interface, and JS are committed to levels of support as outlined on their sales page over on the dot-com site.

A few months later, it would appear that you are the only Fusion Maps guru in the community. Thanks for posting the answers you did find on your own.

OK, once I typed all this in, I decided to go back One More Time to see if the datasource was somehow not catching on, and that was the problem. I am not sure, but it seems that you cannot implicitly change the data source after you have published the first time.

Using PRO. (3.7.0.1, now 3.7.1) I wish to show some data using the Funnel Widget. I built a simple dashboard-size element and put the labels and values in by hand (no query, no datasource), and I got the prototype I wanted previewing in iReport. I built the report nearly like the SalesGuagesReport (in the title band only) in the FoodMart demo. When I pushed it to the server and ran it there, the server claimed "The report is Empty" and did not show anything. EDIT: I am prototyping...same problem with Dial; is there a way to get the server to show a "fixed" widget? NEXT, I created a table with the values in a single record, wrote a query, etc., and again it previewed correctly in iReport. Pushing to the server, I again got "Empty." Any hints as to what might be the issue? Am I missing a setting? Post Edited by cjturner at 10/08/2010 22:32

Is underlying DB MySQL? You can probably do (some variant of) this in your SQL query; Select AAA, BBB, IF(target_field IS NULL, '-',target_field) as My_version, CCC from ... The 'My_version' field is the one you would use in the report.

I am having similar problem with image and text. They overlap some, and the image does not show up _at_all_ in the html rendering of the report, but shows up fine in the PDF rendering. Text field is not 'opaque'. Anybody have experience with this?

You can do this via the Web Services interface (the same one that iReport uses). You can find documentation in JasperServer-Web-Services-Guide.pdf in the documentation zip, or you can see a sample interface in PHP and hack away. look for it in <jasperserver-install-dir>\samples\php-sample

I am trying to write a report that needs to change the actual query on the basis of a user parameter. I can get the functionality I seek with a stored procedure, but I don't want to use stored procedures for reports if I can avoid it. The actual query is much larger and more complex to maintain than the sample here. Is there a way to achieve this effect (dynamically re-write the nature of the SQL query ) in the report itself, so that the dba does not have to maintain stored procs for the reports? Code:CREATE PROCEDURE GetClosedorNotClosed` (IN myflag INTEGER)BEGIN if myflag=6 THEN select fld1, fld2, fld3 from items WHERE item_status<>2 ; else select fld1, fld2, fld3 from items WHERE item_status=myflag ; end if ;END $$

This is an available feature in JFreechart. See this site for some ideas: http://www.java2s.com/Code/Java/Chart/Chart2DBarChartWithTrendLine.htm

From your description, you are actually looking for Integrated Windows Authentication (MS/IIS definition). While similar to SSO, this is a bit different. How to do it might be beyond the scope of this forum. Assuming you are running under tomcat direct... This might be done in IIS/Tomcat using the Tomcat connector (lookup mod_jk at apache.org). It is essentially a redirector such that IIS will pass all of your tomcat requests to the tomcat instance. Your users will access JasperServer via IIS, where you will have IWA turned on. This will only authenticate, you will need to be creative to do authorization (roles).