Project accounting report problems

I've been trying to create a project accounting report whereby for each
project, I can see the project broken down into cost category classes and
then cost categories. For each class (rollup of the categories) and category,
the report should display the budgeted hours, budgeted fees, actual hours and
actual fees. The report should be able to be constrained by a start and end
date for the actuals. I am using Dynamics GP as the data source. I was
wondering if anyone can describe the approach I should take as I've run into
numerous problems so far, primarily with trying to get a date filter working
with the timesheet information that comprises the actuals. Thanks for the
help.I have found it easiest to first create a stored procedure that returns the
data you want to display in the report. It can have a start date and end date
parameter in it that can constrain the result set with a simple "between" sql
statement in the query.
Once you have the sproc as you like it, creating a report around it is much
simpler.
"Zack" wrote:
> I've been trying to create a project accounting report whereby for each
> project, I can see the project broken down into cost category classes and
> then cost categories. For each class (rollup of the categories) and category,
> the report should display the budgeted hours, budgeted fees, actual hours and
> actual fees. The report should be able to be constrained by a start and end
> date for the actuals. I am using Dynamics GP as the data source. I was
> wondering if anyone can describe the approach I should take as I've run into
> numerous problems so far, primarily with trying to get a date filter working
> with the timesheet information that comprises the actuals. Thanks for the
> help.