mickyrox

Hi Everyone, I just installed iReports on my ubuntu OS. Everything is working fine by strangely i'm getting this error in the report query section when i say read fields. Error:net.sf.jasperreports.engine.JRException: Class com.jaspersoft.commons.util.JSControlledJdbcQueryExecuterFactory not found please help micky.

:) Depends on a lot of factors like.. How much data you have in there or how efficient your sql/sp is. I have some reports which run for over an hour. HTH, micky.

Hi, I'm using these properties to control my sheet names and force every new page of my output to a new sheet within the workbook. Property name: net.sf.jasperreports.export.xls.one.page.per.sheet Property value: true Property name: net.sf.jasperreports.export.xls.sheet.names.all property in my jrxml and Property value: Whatever 1/Whatever 2/Whatever 3/ Right now i'm grouping by a field in the report and my excel output has a seperate sheet for each group instance. I'm looking into having the excel sheet name as my field. Can you suggest how i could accomplish this? Appreciate your response, micky

cbarlow3 Wrote: Well, now you have me curious what method you used to solve the problem...inquring minds from the future want to know as well. I was going to suggest that the easiest way is to drag the line from the palette to where you want it in the design pane, position and size it (either by right clicking, using the formatting tools window, setting the properties, or visually dragging it around...so many chocies), and then go into the Properties pane under "Graphic Properties", select the "Pen" property and set the Line width, Line Style, and Line color to the values you want. Specifically, there are line styles that can create a solid line, a double line, a dashed line, and a dotted line. Carl Helped me, Thanks a bunch, micky

Hi Can you please provide a spread sheet workup of what you need? This way we could understand your requirement better. Thanks, micky

HI people, Jasper by default prints the last check in a group instance when the field is printed in the group footer. Is there a way to print the first check in a group instance? For instance Data in the db: Data in database Birth Date Name City Sex Employed 01/01/2011 Allen NY F NO 02/01/2011 Boris NY M MAYBE 03/01/2011 Carter NY M YES If we group by City in Jasper and print all the fields in the group footer What i get is: 03/01/2011 Carter NY M YES What i need is: 01/01/2011 Allen NY F NO Please ask me if you have any clarifications to make on my requirements. Thanks a bunch in advance, micky

Can anyone show me how we could print totals for each instance of a row group in a cross tab and then finally print grand totals(i.e. sum of all the measures). TIA, micky.

Hi icemanc, When you put your subreport element in the detail band, it iterates and repeats itself according to the query used in your main report. When you put your subreport element in the summary band, the main report calls the subreport only once. This should be the issue. Hope this helps, micky :)

Hi guys, I created a report which uses cross tabs in the subreports. One main report having 2 subreports. The Stored Procedure in the Main report creates a temporary table in the database. This temporary table has to be accessed by the SPs in the subreports. But when i try to run the report i'm getting an error as below: Caused by: net.sf.jasperreports.engine.JRException: Unable to get next record. Caused by: java.sql.SQLException: Could not open database table (informix.employees_header_data_temp). Caused by: java.sql.SQLException: ISAM error: non-exclusive access. Can anyone please let me know whats going on? This is reall blocking all development. Thanks, micky.

Thanks Jeff, I tried that out with Subreports never tried with Group Expressions. Will give it a shot. Thanks again, micky.

Hi Guys, I need to make a report where, by using the Report Group i want to break up each iteration of the group into one separate sheet in the excel output. I used subreports to do this earlier but now i need to do it using Groups. Please let me know if you need help in deciphering my problem. Thanks in advance, micky

You can find it by right clicking on the report title in the report inspector(top left of the report unit). HTH, micky Post Edited by mickyrox at 03/28/2011 04:04

Kidly ask me if you need any specific clarification on this Post Edited by mickyrox at 03/17/2011 03:49

Hi, I connect to a Linux DB via a secured vpn. All the reports were running well with correct data in the output. Lately after upgrading to iReport 4.0.1 i have been having issues with the data. When i design a report, it gets compiled without any problem, but when i run the report to see the preview, i get a blank page with a popup saying "This document has no pages". In other casees with simple queries i get a preview but the results set has wrong numbers; for example if the count of the records for the colomn "employees" in the Database is 100, i get something like 34 in the output when i run a report with this query: Select count(employee) from table1 Even falling back to previous versions of iReort doesn't help. If anyone has had any experience of this kind please help me out. Thanks In Advance, micky.

LOL!! Thanks. Happy to help. - ur friendly neighborhood bot micky :-P

Please try this. HTH, micky Code:($F{GLN} == "123456") ? "Company1" : ($F{GLN} == "789012") ? "Company2" : ($F{GLN} == "210987") ? "Company3" : ($F{GLN} == "654321") ? "Company4" : $F{GLN}

great to know ^^, You too.

its a simple if condition with syntax: ( <condition> ? exp1(true) : exp2(false) ). It should work if your expression class and everything else is right (as your field $F{GLN} might be an integrer, please make sure the expression class for your Text Field is "java.lang.String"). I couild help more if i have a look at your jrxml. micky ;)

This code could go into your text field expression. HTH Micky Code:($F{GLN} == 1234567) ? "Company1" : ""

Hi As you want this field at the bottom of the Report, the Summary band would be the most ideal place. Just drag the field you want into the summary band(Your field has to be numeric) A dialog box opens up promting you what kind of value you want to display. Select "The result of an aggreage function" - Sum. iReport automatically creates your variable for you and displays it in the Summary. OR you can manually create a new Variable and set its Variable Expression: $F{YourFieldName}, its Calculation: Sum, Reset Type: Report and Class: java.math.BigDecimal, but why do it when there's an easier way?? :) hth, michael

Hi I need to display the page footer in the summary band but shouldn't display the page header. I'm looking at changing the Print When Expression for the Page header not to print in the Summary . Something like : $P{isSummary}.equals("Yes") Lets say the parameter isSummary resets to "Yes" when the Summary band starts. Is there anyway the report can recognize its in the Summary band, when the Summary starts. Please ask if you need to be more clarified on my issue Thanks in advance, Michael.

Yes that is what i got from "displaying the parameter as part of the report title " Glad to know thats what your looking for. Post Edited by mickyrox at 10/01/2010 12:23

If i'm not wrong in understanding your requirement, you can use this code within your title. hth micky Code:new SimpleDateFormat("dd/MM/yyyy").format($P{YourDateParameter})

HI all,/tools/fckeditor/editor/images/smiley/msn/teeth_smile.gif I'm having issues returning subreport variables to the main report. Somehow when i want to add a return value in the Sub Report element properties, i'm able to see only the Subreport's system variables but not variables created in the subreport by me. Can you guide me as to where i'm going wrong. Cheers!! michael. Post Edited by mickyrox at 09/24/2010 05:58

Awkay found it! just right click the element and select "Padding and Borders" Thanks again!