al_ryder

You'd need to create a custom theme resolver. Modify applicationContext-themes.xml Find and replace: <bean id="jsThemeResolver" class="com.jaspersoft.jasperserver.war.themes.MTThemeResolver"> with <bean id="jsThemeResolver" class="your custom resolver class"> You then create a mapping table (userid, themename) which you custom resolver accesses Your custom resolver should extend AbstractThemeResolver e.g. public class CustomThemeResolver extends AbstractThemeResolver {

Hi, can someone please confirm whether or not jasperserver can use secure smtp to talk to an email server. From the doco it seems to say that it can't. Just want confirmation. Thanks Al

Hi, I was looking through tracker and noticed item# 0004163: Change JasperServer license to Affero GPL v3. I was wondering if anyone can confirm this. As all the licensing I've seen on 3.7 still makes reference to GPL v3 or even GPL v2 !!! Thanks Alan

Hi, I have a report created in iReport which has 4 parameters defined. I have loaded this report to JasperServer and setup the input controls required (they are cascading input controls). As you would know when running the report it prompts the user to select the values required to run the report. What I really want to do it have the report run and display automatically based on a set of default parameter values. I can do this within iReport easy enough, HOWEVER, i really need the default values to be dynamic based on the LoggedInUsername. The Username is one of my parameters. Any help appreciated. Thanks Al

Hi, I was wondering how difficult it would be to upgrade the spring security libraries in JS 3.7 from spring security 2.0 to spring security 3.0? There's a SAML module in 3.0 that we're interested in using. Thanks Al

great thanks Lucian

Hi, Is the web service only in the Professional edition or also in the CE edition of 3.7 as I've just downloaded the CE edition and neither the samples directory nor the web services guide has any reference to a web services API for creating users. Thanks Alan

Hi, I was wondering if there was an easy way to bulk load users in jasper server 3.5 CE . I was hoping to use the web services API for it, but the API for users doesn't seem to exist? Thanks Al

thanks Lucian, we just did a work around. Checked to see if any data returned from SQL, if none then just populated the chart dataset with a default value.

Hi, I was wondering if there was a workaround for the fact that for some charts when the query associated with them returns null, the rendering of the chart dies. i.e. I have a report with a Area Chart and the whole report dies because the chart sometimes get passed null data: java.lang.IllegalArgumentException: Null 'dataset' argument. at org.jfree.data.general.DatasetUtilities.findStackedRangeBounds(DatasetUtilities.java:1364) at org.jfree.data.general.DatasetUtilities.findStackedRangeBounds(DatasetUtilities.java:1349) at org.jfree.chart.renderer.category.StackedAreaRenderer.findRangeBounds(StackedAreaRenderer.java:171) at org.jfree.chart.plot.CategoryPlot.getDataRange(CategoryPlot.java:3897) at org.jfree.chart.axis.NumberAxis.autoAdjustRange(NumberAxis.java:428) at org.jfree.chart.axis.NumberAxis.configure(NumberAxis.java:411) at org.jfree.chart.axis.Axis.setPlot(Axis.java:964) at org.jfree.chart.plot.CategoryPlot.(CategoryPlot.java:542) at org.jfree.chart.ChartFactory.createStackedAreaChart(ChartFactory.java:1185) Thanks Al Post Edited by al_ryder at 05/20/2010 00:59

Hi, I'm trying to use a variable in a sql query. I'm wondering if that's possible? For example to do something like: select * from stored_procedure1($V{parameter}); The reason I need a variable is that the 'parameter' variable's expression calls a user defined java function which generates some data. I've displayed the value of the variable using a textfield and it seems fine, but when I use it in a query it spits the dummy, looking at the database logs I can see that iReports is trying to pass the value "$V{parameter}" to the database instead of substituting the value of the variable. Thanks Al Post Edited by al_ryder at 05/10/2010 08:16

Thanks developerdude, I should probably have detailed the context of my question better. Basically we have a situation in which different jasper users belong to multiple departments. We have one report which shows financial reporting per department. We have an input control which displays a list of departments that the user is able to run the report for. So once the user selects the department, the viewReportFlow takes care of running this report. The thing is, there is a major security flaw with my approach as a user can stick a proxy in between the browser and the Jasper Server application and change the department code to whatever he/she wants. In order to enforce the client side validation rules I also need to revalidate them at the server side, so hence I want to put some code at the server side which validates that the current logged in user actually has access to the department code that he's asking to run the report for. Cheers Alan

Hi, I'm trying to figure out how to run some custom code before a report gets run. Specifically when a user clicks on a report with an input control, after the input control value is selected and before the report is actually run with that input control value; I want to do some server side validation of the input contol value before it's passed to whatever method runs the actual report. I was thinking about wiring up some kind of method interceptor via acegi, but is there already some kind of 'hook' into this method via an existing spring bean? Thanks Alan

Hi, Just saw that JasperReports Professional 3.6 is being released with flash chart support. I was wondering when that would make it's way onto the Jasper Server community edition ? Thanks Alan Post Edited by al_ryder at 09/21/2009 02:54

Hi, we're running jasper server over https and find that when we're in the Analysis screen and try to download the data as xls we're getting the following error message from the browser: "Internet Explorer was not able to open this Internet Site. The requested site is either unavailable or cannot be found". Note: this only happens in Internet Explorer and only when we run Jasper over https, we also have a valid ssl certificate for the site as well. Is there a workaround for this? Thanks Alan