dynamic parameter passing

[salishs]

Hi ,

I also has the problem with dynamic parameter passing ,ok iwill explain

i want to get the data of a month so my query will be

select * from fruit where month(shiftdate)=10;

this will give me the needed result ,ok but if any date in that month eg:sundays are holidays so that day will be no data and also that date also missing i want that date also as in the date column ad the remain as 0.00,so i written a pgm in java to get alla the dates in a month and pass to the quey(not in report)as

select * from fruit where shiftdate=2009-10-04;

this is sunday so i get the output as sunday 0.0 0.0 in my java pgm but how can i pass the dates dynamically or is there any option other than this .I'm using ireport 3.0.0

 

Please help me