Date parameter

[artis1990]

Hi,

I am really new to iReports, kind of thrown into deep water. I have this report that summaries all the activites from previous dates (parameter). I've been asked to split it into two reports to summary all the activites from morning and afternoon shifts separately. What would be the best way to do so? What I need is to this:

(select count(update_qty) "23"

  from inventory_transaction

  where code = 'Repack'

  and from_loc_id like 'PACK%'

  and dstamp between to_date($P{date},'DD-MON-YY') and to_date($P{date},'DD-MON-YY')+1)

 

show only the results from 6am till 2pm instead of the whole day. 

[hozawa]

iReports is now depreciated. The new designer tool is Jaspersoft Studio.

You may be able to do what you need by using Relative Date Parameters in Jaspersoft Studio.

http://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v630/using-parameters-queries