nealhudson

Any thoughts on this Lucian?

I'm trying to add a hyperlink to a cell in my crosstab. When I try to drag the report from the JS Plugin to my crosstab cell, I get the following message: "Drag your Report Unit over a linkable element, such as a text field, image or chart." The crosstab cell is a text field so I'm a bit confused by the message.

Hi there, I have a crosstab report which is showing a blank in a couple of cells rather than a zero. If you look at the attached report - other cells where no information is retrieved are showing zero, but 2 cells are showing blank [file name=report-bfc3422391ea42df77f22c3e3b5f2fff.pdf size=2492]

Hi again Lucian I just tried this with my report, I have set up the parameter not to be mandatory. When I click the hyperlink to go from the master report to the detail report, I get the following error: net.sf.jasperreports.engine.JRRuntimeException: Multi parameters cannot contain null values. The child report contains 2 parameters - the first is the collection, the 2nd is a Date. I'm filling the Date but not the collection.

Thanks Lucian - that will solve my issue Regards Neal

Hi there, I have a report which contains a java.util.Collection as an input parameter. I then use this in the SQL Query using the $X{IN, field, parameter} operation. On JasperServer, I have set up a Multi-Select query input control which displays a list of possible values. Behind this there is a query to retrieve the info from the database. I now want to use this report as a drill-down from another report, i.e. embed a hyperlink in the parent report. I would like in this instance for the multi-select input to be populated with ALL the values in the database. I was thinking there would be some way of either setting up a subdataset in the parent or the child, entering the query in here to retrieve the list of values, and either sending it as the parameter in the hyperlink in the parent report, or using it as the default value in the child report. What is the best way to go about doing this? Thanks Neal

Hi there I'm trying to pass in a range of values into a report, and using this parameter in the WHERE clause of my SQL statement using the 'IN' operator, e.g. SELECT * FROM table WHERE value IN ($P{in_param}) When I run this in my query browser for a range of values it works fine. When I run this the same thing in iReports it only retrieves records for the first value in the list. Any idea what the problem is? Also - how can I view the actual SQL that iReports runs?

Thanks Lucian - where do I get the plugin? Post edited by: nealhudson, at: 2007/11/13 13:15

Hi Is it possible to get the .jrxml of the Employees sample report that comes with JasperServer? I'm looking to get a sample .jrxml that does drill down type hyperlinks Thanks

Ok I finally have seemed to be able to get the subtotals/totals to work now - thanks to the help from skalle! However, I'm now having a problem working with those in the footer bands. I have created a report where I the subtotal is returned in minutes, and the correct value is available in the band (in the example it's displayed on the left). I have set up another couple of variable - 1 to give the time in minutes as hours, and the other to give it in minutes past the hour. So for example 187 minutes will be 3 hours, 7 minutes. In the example that I have attached, in the first project footer the value in minutes is 120. However my variables display the value as null. (to get a clear example, select 1st October 2007 as from and to dates) Could someone please explain how to work with the subtotal value in a band? Thanks [file name=calc_problem.zip size=22520]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/calc_problem.zip[/file] Post edited by: nealhudson, at: 2007/10/16 12:53

I received a mail this morning from somebody having the same problem, so I thought I'd resurrect this thread and provide the example arianhojat was looking for. I've attached a .zip file, containing a very basic subreport/report combination, and the 2 sql scripts needed to create the tables that the reports are based on. To recreate a simple example of the problem, enter the 1st October as the from and to date for the report. Thanks [file name=sample-2019c9c9ea8200d655f492229924651e.zip size=21749]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/sample-2019c9c9ea8200d655f492229924651e.zip[/file]

Hi - I'm using iReports and would just like to know what exactly is achievable with it? I have an idea for a report, that's looking at time spent for a User on projects for a given date range. So if you enter from Monday 1st October 2007, to Friday 5th , it will show the list of projects in rows, and the list of dates along the top. Is this achievable? (If so, where could I look for an example?)

I've got a number of minutes field that I'm splitting up into 2 fields - 1 for hours and 1 for minutes. In the minutes field I'd like to display a leading zero for values under 10, e.g. 0 minutes to display as 00. The variable expression I'm using to calculate the number of minutes is: new java.lang.Long(($F{Time}.longValue() % 60)) If I was to create another field to format this - say a string, how would I go about setting up the formatting?

Hi I have a report that has 2 java.util.Date parameters. When creating the report on JasperServer, I added 2 input controls, of type Date/Time. Is there any way to default the time on these? e.g. if there is a start and an end Date/Time, when the Users clicks the calendar icon on the start date I'd like it to default the time to 00:00, and the end date time to 23:59.

Is there anything else I need to do to get the email to send?