Timesheet Report

[ss028955]

Hi ,

We have just installed project server 2007.

I need to create a timesheet report which gives billable time and
nonbillable time forall the projects/tasks e.i. unverfied tasks, Projects and
Administrative Tasks.

Can some one help me.

thanks
ss028955

 

[Paul Conroy]

Have you checked out the Timesheet report in the SRS Project Report Pack ?

 

[ss028955]

SRS requires SQL 2005 server isn't it? We are currently running SQL 2000.

 

[ss028955]

Can some tell me where can I find Table relationship diagram and Table /
Field defination document ?.

Thanks in advance.
ss028955

 

[Gary L. Chefetz [MVP]]

SRS is available for both versions.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[ss028955]

Could you pls kindly tell me where I can find the SRS document for SQL 2000.
Regards
Ss028955

 

[Gary L. Chefetz [MVP]]

I'm not sure what you're looking for as that statement is rather vague. You
can generally find such documentation on TechNet or MSDN if you're a
developer. You can also find great documentation on individual websites and
blogs.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[ss028955]

Thanks Gary. I realised yesterday that SQL Server 2000 and SQL Server
Reporting Services 2005 is totally separate. Initially I thought SQL Server
Reporting Services 2005 will only run on SQL 2005 server.

I have now installed SQL business intelligence on my Client PC yesterday.
Ran the sample that was provided in Reporting Pack. Now I am trying to find a
document that explains how to publish the report on Project Server.

 

[ss028955]

Now I am having problem with deploy solution. When I try to deploy the sample
reports, it comes up with message below.

" A connection could not be made to the report server
http://mis-proj-dev2/ReportServer. "
Additional Information ..........


mis-proj-dev2 is the server where Project server is running. Can someone
help me please.

Thanks
ss028955

 

[Chak]

Now I am having problem with deploy solution. When I try to deploy the sample
reports, it comes up with message below.

" A connection could not be made to the report serverhttp://mis-proj-dev2/ReportServer. "
Additional Information ..........

mis-proj-dev2 is the server where Project server is running. Can someone
help me please.

Thanks
ss028955







- Show quoted text -

Hello,

It seems to be you have client environment to design and run the
report. To deploy the report, you should have Report Server running on
IIS.

You need to install Reporting Services on web server.

Thanks
Chak

 

[ss028955]

Thanks Chok,
I will install the services on web server and see if it works.

Cheers
ss028955

 

[Chak]

Thanks Chok,
I will install the services on web server and see if it works.

Cheers
ss028955







- Show quoted text -

Hello,

Please remember, you are installing Reporting Services on your SQL
Server machine and during the installation, you will configure to
setup Report Server site on IIS.

http://technet.microsoft.com/en-us/library/ms143736.aspx


Thanks
Chak