Creating BIRT reports using queries that taking dates

Sudhi

HI,

I want to create a report using BIRT. In the report parameter i will select month and year.After selecting this fields,i want to pass employee id and date (1 to end of month)
for getting the result.Here for each employee i want to pass 1- end of month dates.

And also in output also i want to display like

EMPLOYEE_ID 1 2 3 .............................31
456

---

>X X X................................X

Pls tell me how to achieve that
Sudheesh

mwilliams

Hi Sudheesh,

Are your month and year columns separate? Or do you need to combine the month and year parameters to pass to your database?