One page per month..pleaseeee helpppppp

[Angel123456789]

Guys,
I have a report now that takes parameters and employeedid,month,year as parameters and returns a simple report.Now I want to change the report to take paramters employeeid,begmonth,endmonth,begyear and endyear.Now i want the report to create one page for each month
below is teh stored procedure that I using currently and it calls another stored procedure that take year and month paramters...
We cannot use cursors in our organization... Please help how to accomplish this
thanks
StoredprocedureMAIN
Select Employeedid ,IMonth ,Iyear ,Salary,caseid From Employees

Where Caseid=@caseid
and Iyear<@begyear
and Iyear>=@endyear
and IMONTH=<@begmonth
and Imonth>=@EndMonth


Exec SpCalculatevalues
/*this is the stored proc i am calling from procedure
/*As you can see it only take in a single value
/*above I changed it to give a range..Can
/*I call this stored procedure multiple times with month year value
/* we are phohibited from using cursors in our organization
@caseid=@caseid
,@IMonth=@IMonth
,@IYear=@IYear

 

[Auguy]

No expert here, not sure I understand what you need, but this sounds more like a selection problem than a reporting problem. Once you get the selection correct, you should be able to group on the year and month with a page break for your report. Maybe someone else can help with the selection process.

Auguy
Northwest Ohio