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.

Programmatically Set Sever Timeout Using AMO Classes and Objects

Using DSO object model, We use to Specify the Server Timeout for 4 hours as follows:

oServer.Timeout = 14400

But using the AMO Classes and Objects, How will I set the Server timeout programmatically?

Many Thanks

Subhash Subramanyam

hello Subhash,

i think you can specify the Timeout property in connection string. I.e. something like this:

Server server = new Server();

server.Connect("Data Source=localhost; Timeout=14400;");

// do something

server.Disconnect();

(there is also a Timeout property on DataSource object - though that one affects data source connection i think).

hope this helps,

|||

Hi Mary,

Thanks for the reply, I got what I was looking for.