[JdbcQueryExecuterFactory not found error iReport in ubuntu]

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.

[Pulling data from a year ago]

:)

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.

[Dynamically generate sheet names in excel output]

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

[dashed line between secions]

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

[CrossTab two column groups]

Hi

Can you please provide a spread sheet workup of what you need?

This way we could understand your requirement better.

 

Thanks,

micky

[Printing the first record in a group instance to print in group footer.]

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

[Cross Tab Grand Totals]

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.

[data ( rows ) in subreport is repeating]

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 :)

 

[Error in subreport while trying to access temp table created by SP in the main report]

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.

[Different Excel Sheets using Group Expression]

Thanks Jeff,

I tried that out with Subreports never tried with Group Expressions.

Will give it a shot.

Thanks again,

micky.

[Different Excel Sheets using Group Expression]

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

[Adding a group]

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

[Wrong/No Data in the output while using vpn connetion]

Kidly ask me if you need any specific clarification on this

Post Edited by mickyrox at 03/17/2011 03:49

[Wrong/No Data in the output while using vpn connetion]

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.

[Replace GLN number field with Company Name]

LOL!! Thanks. Happy to help.

 

- ur friendly neighborhood bot micky :-P

[Replace GLN number field with Company Name]

Please try this.

HTH,

micky

Code:

($F{GLN} == "123456") ? "Company1" : ($F{GLN} == "789012") ? "Company2" : ($F{GLN} == "210987") ? "Company3" : ($F{GLN} == "654321") ? "Company4" : $F{GLN}

[Replace GLN number field with Company Name]

great to know ^^, You too.

[Replace GLN number field with Company Name]

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 ;)

[Replace GLN number field with Company Name]

This code could go into your text field expression.

HTH

Micky

 

 

Code:

($F{GLN} == 1234567) ? "Company1" : ""

[How can I create sum variable in iReport 3.7.3]

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

[Report to recognize band at run time]

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.

[format date parameter]

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

[format date parameter]

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})

[Sub Report Return Variables]

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

[Padding within a text field]

Awkay found it!

 

just right click the element and select "Padding and Borders"

 

Thanks again!