iReport and parameters

[EricWiz]

Hey all,

 

I am evaluating iReports right now and this platform is foreign to me. I am familiar with Crystal Reports and M$ Report Services for 2000.

 

I have what I assume is a basic question. How do I utilize a parameter in an SQL statement? For example,

if I have a statement like:

Select * from orders

and I want to constrain by date:

select * from orders where dt >= (date) and dt <= (date)

How do I do it?

 

I have looked around and it does not seem to me to be clear. I would like to allow my customers to customize their reports based on parameters.

 

If someone could provide a simple example it would be greatly appreciated!

 

Thanks,

Eric

[edxerx]

im new to ireport too, just been digging it for 2 weeks :laugh:

 

anyway on the parameter thing in ireport MENU->VIEW->PARAMETER

 

add one parameter

 

here's an example on what u should fill

 

----------------------------------

Parameter Name : ReportDate

Parameter Class Type : java.lang.date

Default Value Expression : "" (this is a default value if it's not given during run time)

Is for prompting : YES

----------------------------------

 

Then in your sql just use something like this

 

SELECT * FROM table WHERE field=$P{ReportDate};

 

 

hope this helps

:)

[EricWiz]

Yup! That works :)

Thanks edxerx..

 

I also noticed that you can then use a parameter with the same name in the JasperReports server and you get the prompt on the page when you call up the report.

 

Ok... So far so good....

 

My next two things to tackle I think will be expressions and charts.

 

Whoohoo!

 

E

[pjain]

Hello All,

I am very new to Jaspersoft as well.

Is there a way to set a default value expression for Parameter Class Type: java.lang.date.

I tried "Jan 1, 2008" and "2008-01-01" but both values erred out as "can not cast string to date".

Please help!

Thanks

 

[CaptnTony]

will have to do something like new java.lang.date(....) as the default value expression I think.

[pjain]

Thank you CaptnTony!

Your suggestion worked!

I set the default date for Jan 1, 2008 and it worked.

new java.util.Date(20080101)

 

Thank you again!

 

Puneet

[pjain]

correction!

The format for default date value expression worked as

new java.util.Date(new GregorianCalendar(2008, 0, 1)).getTime().getTime())

 

Thanks

pjain

[mdahlman]

pjain's expression looks OK (and he tested it, so it must be valid).

 

But you may find these formats easier to use:
new java.util.Date()  // defaults to the current date
new SimpleDateFormat("yyyy-MM-dd").parse("2008-01-01")  // See SimpleDateFormat docs for lots of other possibilities

 

Regards,
Matt

[javaiiispl]

 can anyone help me how to pass date value from java to ireport(jasper).....

[kolaitis]

In your calling form..

 

Map reportParameters = new HashMap();

reportParameters.put("DATE", super.getDate("selected_Date"));

 

In iReport, assign parameter : DATE , class Type : java.util.Date

 

In iReport Query :

Where yourDataBaseFile.DateField = $P{DATE}