sam1000

Hi Ky22ho, you need to use a Chart customizer and customize the X-Axis to get the interval.

I figured out the problem. The existing mechanism works fine with v5.5. The issue was that the Input controls associated with the report did not have the right permissions set. Once I gave the correct roles access to the input controls in the repo it came up fine.

Our external authentication in v5.0.1 is implemented in the following way: - Our External app passes a token with the Jasper URL, this is intercepted by our SSO filter which checks for the token, if present it performs a callback to the app to validate the token and recieves the user profile from the external app. If the user does not already exist in Jasper an externally defined user is created with a new UsernamePasswordAuthenticationToken and the Authentication is set in the Spring Security Context after which the login state is set. In v5.5 this no longer works. Jasper says there is a new "bean API" that replaces direct calls to the Spring security API but I can't seem to find any straightforward documentation that is relevant to my case. I looked at the Authentication cookbook but the info there is not of much use.. I'm not really looking for CAS authentication or external DB authentication. I'm looking for some high level APIs to create a new user and be able to set the session authentication state similar to what I was doing using the Spring APIs.

I can export resources into a zip just fine but when I try to use js-import to import those resources into another repo i'm getting messages that those resources already exist although they infact do not (I cannot see them in the repository navigator!!!). I have verified (and re-verified several times) the target database settings in build_confdefaultjs.jdbc.properties file that it is pointing to the repo that needs to be written to but it just will not do the import. Is there something I am missing here? Is any other file that is used to obtain the database settings to? The syntax I am using is: js-import --input-zip c:jasper_reports.zip with js.jdbc.properties set to point to the database that is receiving the import... The entire set of resources is just bypassed with the message "already exists, importing permissions only", I cannot see any of these resources in the target repo. I know that js-import is using the database settings from js.jdbc.properties because I changed the URL to point to a non-existent database and I got exceptions. I am absolutely positive I am using the right database URL corresponding to the target jasper server. I am just dumbfounded as to what the issue can be. Alternatively, is there a way to import directly through the UI, that will allow me to bypass the whole utility (which does not seem to be working!)

Figured out the problem... in my multi-axis chart one of the charts was using just the $F{DATE} expression hence the repeated categories!!

For now I modified my query to return the appropriate category expression in concatenated form but it would've been nice to be able to have a "Tick label expression" so that the tick label value can be different from the actual category expression used for grouping.

Deleted

I have what should be a simple problem. I have a stacked bar chart and my category expression is $F{DATE} and that works just fine. I also have a customizer that prints only every 3rd tick label. This also works just fine. However, when displaying the tick label I want to concatenate the rownumber to the category expression in the form DATE + {N} where N is the count, for example the first bar should be 20130910 {1}, second should be 20130911 {2} etc. Changing the category expression to $F{DATE} + " {" + $F{ROWNUM} + "}" results in some really strange behavior (ROWNUM is explicity selected in my query). What I get is two sets of categories repeated one after the other, one with just the date and one with the concatenated values. In addition the first set of values is processed and spaced out by the customizer while the second set of values is not. Any ideas of what exactly is going on? In my customizer I am geting the domainAxis of the categoryPlot, iterating through the categories and setting the tick label paint to while for all but the 3rd values. In addition if you look at the values with the concatenation of the { } you will see that they are all the values in the first set EACH repeated 4 times which is really bizzare. This stacked bar chart has 2 series and I have set the category expression of both to the same thing - $F{DATE} + " {" + $F{ROWNUM} + "}" Attached images: cap1 - original chart cap2 - after the category expression is set to $F{DATE} + " {" + $F{ROWNUM} + "}"

What is the remote Maven repo URL for Jasperreports server 5.x? I'm looking for the repo that has the BINARIES generated during the build so that I can build a dependent project without having to build Jasperreports first.

I just spoke to someone at Jaspersoft and they told me that JasperReports server v5.0.1 is officially scheduled for release only in March earliest but could be until May 2013. However, I see links for trial editions of 5.0.1 available for download on the site. I am totally confused!! Can someone clarify this? Also, does 5.0 support Oracle? I read somewhere on this site that 5.0 does not support Oracle which I found rather strange. We are currently using 4.5 and looking at upgrading to 5.0.1 Thanks!

I figured this out :) I ran the DDLs in the jasperserver-pro directory and it added the missing tables for the pro version. Thanks!

I am brand new to JasperReports and i'm trying to get Jasper Pro up and running but having a ton of difficulty. I am able to build and deploy jasperserver-pro.war to Tomcat but the application will not start. Interestingly I can deploy and run the base version (non-Pro) just fine. The first problem I had was that the "js-ant create-load-all-dbs-ce" errored out with a missing tasks.properties error. I had to edit the db-common.xml file to manually add the advanced-sql and select-sql taskdefs in there to get it to work. Not sure why I had to manually fix it so it would run??? The second problem is that I get a messsage "Hibernate DataAccessException ERROR: relation jidashboard does not exist" during application startup. I am using PostgreSQL and I created the schema (53 tables) using "js-ant create-load-all-dbs-ce". The databases created were Foodmart (41 tables), jasperserver (53 tables) and sugarcrm (80 tables). There are a bunch of tables starting with "ji" in the jasperserver schema but jidashboard is not one of them. What am I missing here? Thanks for any help, I appreciate it!