Hi,

I'm new to project server 2007. I'm trying to develop a connector
between project server 2007 and .NET application.

I need to retrieve unsubimitted time sheet of all the resource for
each projects.

The results should be similar to a table with each table corresponding
to a project. The table should show the name and email id of the
resource who haven't submitted time sheet.

It would be a great help if someone could guide me on this topic

Thanks,
Arun G

Hi Arun,

You would probably have better luck submitting this request to 
microsoft.public.project.developer

To try to partially answer your question, you need to determine what 
criteria you are using to determine which resources are missing timesheet 
for a specific project.  Is it for example a resource that is on the project 
team (i.e. resource sheet) or is it a resource who had planned work for that 
particular timesheet period.

You could then create some SQL queries in SRS to generate a report.  Or you 
could create as Stored Procedure and have it scheduled so that it sends out 
individual reminders to the resources.

Thanks,
Jonathan Sofer

"Arun G" <bloggergopal@gmail.com> wrote in message 
news:a723e01c-9dd7-44cb-bd93-5bc4c6dcd81a@u34g2000yqu.googlegroups.com...
> Hi,
>
> I'm new to project server 2007. I'm trying to develop a connector
> between project server 2007 and .NET application.
>
> I need to retrieve unsubimitted time sheet of all the resource for
> each projects.
>
> The results should be similar to a table with each table corresponding
> to a project. The table should show the name and email id of the
> resource who haven't submitted time sheet.
>
> It would be a great help if someone could guide me on this topic
>
> Thanks,
> Arun G