Jump to content
Changes to the Jaspersoft community edition download ×

Date parameter


artis1990

Recommended Posts

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. 
Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...