laloca

Are there any news on the cascading parameters feature? Can't wait to try it out! B) Cheers, Susanne

Are there any news on the cascading parameters feature? Can't wait to try it out! B) Cheers, Susanne

Hi there, I'd like to hide "resource" directories like datasources, datatypes, images from my users home directory. If I change the permissions for directory "datasources" for ROLE_USER to no_access (which hides the directory) my users can't run a single report (Access denied). Is there a solution for this behaviour? Is it possible to hide these directories from users? These directories appear to be empty to the users and therefore useless. Any comments are welcome! Cheers, Susanne

Hi, Thank you all for your useful tips. After some investigations and learnings in calculating dates in Java (im not really what you would call an experiences Java developer) I realized that I can't summarize the following as a default expression: Code: Calendar now = Calendar.getInstance(); now.add(Calendar.MONTH, -1); now.set(Calendar.DAY_OF_MONTH, 1); return new Date(now.getTime().getTime()); After some help of a colleague we packed the date calculations in a java class and deployed it as a jar-file it on the report server. Now I'm calling these methods as default expressions. It works perfect!! Better with JS that with iReports! If I could make a suggestion for a useful feature I would opt for a single value input control which can have a select statement to calculate a default value. Thank you very much for your great work!! Kind regards, Susanne

Hi, Thank you all for your useful tips. After some investigations and learnings in calculating dates in Java (im not really what you would call an experienced Java developer) I realized that I can't summarize the following as a default expression: Code: Calendar now = Calendar.getInstance(); now.add(Calendar.MONTH, -1); now.set(Calendar.DAY_OF_MONTH, 1); return new Date(now.getTime().getTime()); After some help of a colleague we packed the date calculations in a java class and deployed it as a jar-file it on the report server. Now I'm calling these methods as default expressions. It works perfect!! Better with JS that with iReports! If I could make a suggestion for a useful feature I would opt for a single value input control which can have a select statement to calculate a default value. Thank you very much for your great work!! Kind regards, Susanne Post edited by: laloca, at: 2007/08/02 12:47

Thank you for your quick response. Unfortunately it's not the solution I'm looking (or hoping) for. I wish Jasper or the Jasperserver could calculate the default date lines by themselves depending on the actual date. The parameters should propose the date lines of last month eg. 1/6/2007 ($P{date_from}) and 30/6/2007 ($P{date_to}). It's quite boring to open the calendar, scroll back to last month, set the 1st day of this month, switch to the date_to parameter and do the same for the last day of last month. The parameters should be filled automatically when the user calls the report - so he only needs to start the report generation. In some rare cases the user wants to change these parameters, but in 99 % they want to filter to last month. Kind regards, Susanne

Hi, Is there a possiblity to calculate a default value for a date parameter? I'm using JasperServer 2.0 and iReports 2.0 with an Oracle database. In SQL I would use SELECT last_day(add_months(SYSDATE,-2)) + 1 FROM dual to calculate the first day of the last month. I could code it in the SQL statememt but our users need to define their own date lines sometimes. Nevertheless the default use is to filter the data by last month and the first and last day of last month should be proposed in the according parameter fields. Any ideas? Thank you very much in advance :-) Susanne

Are there any news concerning this issue? I'm facing the same problem here. Report is called via URL with 2 parameters: http://srv-lx-2:7070/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/Statusreports/XXX/XXX_Report&CONTRACT=XXX&SUBCONTRACT=YYYY[/code]After clicking on the link jasperserver asks the user to login. After entering the credentials I get an error msg: <snip>...in state 'checkForParams' of flow 'viewReportFlow' -- action execution attributes were 'map[[empty]]...</snip>[/code]Clicking on "Home" the user can browse the repository and call the report manually without problems. Both input controls are definied in the same directory as the report. Users have read-privileges for this report, the directory has no permissions set. Any comments are welcome! Thank you!

Hi, I'm trying to make a crosstab report with iReports 1.2.8 but I don't know where to start. How do I insert a crosstab section in a new report? In your demo report it looks similar to a subreport, but how do I create it from scratch? I tried to copy the crosstab section in my .jrxml File - then I was able to use the crosstab editor, I tried to change the crosstab fields to my usage, but get an error after compilation: Code: net.sf.jasperreports.engine.JRRuntimeException:ÂErrorÂincrementingÂcrosstabÂdataset <snip> PrintÂnotÂfilled.ÂTryÂtoÂuseÂanÂEmptyDataSource...! Where do I define a crosstab data source? I can only use them in the cross tab properties...? All other inquiries in this forum asking for a crosstab tutorial or further documentation were not answered. Is this feature really that sophisticated ...? :dry: Can anyone help me? Thanks a lot! susanne

Hi, I'm trying to make a crosstab report with iReports 1.2.8 but I don't know where to start. How do I insert a crosstab section in a new report? In your demo report it looks similar to a subreport, but how do I create it from scratch? I tried to copy the crosstab section in my .jrxml File - then I was able to use the crosstab editor, I tried to change the crosstab fields to my usage, but get an error after compilation: Code: net.sf.jasperreports.engine.JRRuntimeException:ÂErrorÂincrementingÂcrosstabÂdataset <snip> PrintÂnotÂfilled.ÂTryÂtoÂuseÂanÂEmptyDataSource...! Where do I define a crosstab data source? I can only use them in the cross tab properties...? All other inquiries in this forum asking for a crosstab tutorial or further documentation were not answered. Is this feature really that sophisticated ...? :dry: Can anyone help me? Thanks a lot! susanne