Project Web Access 2007 Training Part III – Time sheet Approval Part


Here is the second part of PWA Training for Project Server 2007.  In this training I have shown how project managers can approve time sheet submitted by the resources in Project Web access 2007.

Project Managers Time sheet approval

http://cid-a8677d5751e6b4da.skydrive.live.com/self.aspx/Public/3%20-%20Project%20Manager%20Apprving%20Timesheets.avi

September 27

del.icio.us Tags: Project Web Access 2007 Training, PWA 2007, EPM 2007 Training Material, Project Server 2007 Upgrade

Technorati Tags: Project Web Access 2007 Training, PWA 2007, Time sheet Approval, Approval EPM 2007 Training Material, Project Server 2007 Upgrade

Project Web Access 2007 Training Part II


Here is the second part of PWA Training for Project Server 2007.  In this training I have provided an overview of how to enter and submit time sheet in Project Web access 2007 for approval.

Project Web Access 2007 Team Members Training

http://cid-a8677d5751e6b4da.skydrive.live.com/self.aspx/Public/2%20-%20Team%20Members%20Training%20Timesheets.part1.rar

http://cid-a8677d5751e6b4da.skydrive.live.com/self.aspx/Public/2%20-%20Team%20Members%20Training%20Timesheets.part2.rar

Note: Both files needed to be downloaded for the training.

I will post more soon.

Jerry

Microsoft Project Web Access Training – Part I


As we are currently in process of implementing Microsoft Project Server 2007 in our company.  I have to provide training to over 100 people who are working in different departments.  Training all these people individually could be a very painful job.  So I decided to go for an Innovation.  I decided to create CBT (Computer based training’s) for Microsoft Project Web Access 2007. 

This is the first part of the training.  This involves creating Activities and projects in Microsoft Project Web Access 2007.  These video can be downloaded from the links below.

Note: These files are two part RAR format which will convert to 1 AVI Format file.

http://cid-a8677d5751e6b4da.skydrive.live.com/self.aspx/Public/1%20-%20Creating%20Project%20in%20Project%20Server%202007.part1.rar

Update

http://cid-a8677d5751e6b4da.skydrive.live.com/self.aspx/Public/1%20-%20Creating%20Project%20in%20Project%20Server%202007.part2.rar

I have tried my best to be as simple as possible.  But incase there are problem please feel free to contact.  Comments are welcome.

I will post more soon.

Jerry

del.icio.us Tags: Project Web Access 2007 Trainnig, PWA 2007, Creating Activities in Project Server 2007, EPM 2007 Training Material, Project Server 2007

Querying WSS Lookup Columns with CAML


PointBridge Weblogs > Blogs > Matt’s Blog > Posts > Querying WSS Lookup Columns with CAML

I spent way too long yesterday trying to get a CAML query that would allow me to query on a lookup field and figured I’d share.
<rant>
First, one thing I find very annoying about SharePoint is that if you have an invalid query, the call to the GetItems() method returns all rows. What?? How ’bout a friendly exception that I have an invalid query??
</rant>
So here was the solution: the CAML query should be formatted with a type attribute of Lookup in the Value tag and the text of that element should be the same value that you’d see in the SharePoint UI.
For example:
<Where>
    <Eq>
        <FieldRef Name="GiftsForMom" />
        <Value Type="Lookup">Flowers</Value>
    </Eq>
</Where>

Looking at it now, this is reasonably straightforward. However, it didn’t click in my development-damaged brain, as the value you see in a lookup field when you inspect it in the debugger is something like 4;#Gift Types.

http://thorprojects.com/blog/archive/2007/02/23/643.aspx

When constructing CAML queries you must use internal names by this wonderful exception:

Exception caught Microsoft.SharePoint.SPException: One or more field types are not installed properly. Go to the list settings page to delete these fields. —>
 System.Runtime.InteropServices.COMException (0x81020014): One or more field types are not installed properly. Go to the list settings page to delete these fields.

MOSS Integration with SQL 2005 Reporting Services – Common Problems


Few days back I was trying to install MOSS Add-In for SQL Server Reporting Services. The number of links below can show the problem that I have faced. Its very simple to install the add-in but configuration is not easy. Do read the installation and configuration guide before installing it on your server.

MOSS Add-in for Reporting Services Download (Important)

http://download.microsoft.com/download/f/d/c/fdcb3a53-0cb1-4e67-a1b6-45b89b3c59cf/SharePointRS.msi

Microsoft SQL Server Reporting Services – Installation and Configuration Guide for SharePoint Integration Mode (Important)

From looking at the comment stream for the "Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007" blog entry that was posted back in February, I can see that some people are still having difficulty installing and configuring SSRS in "SharePoint Integration Mode." Fortunately for you, Raju Sakthivel, an architect in the Microsoft Consulting Services group, has taken the time and effort to perfect and then document the whole process in the attached installation/configuration guide (3.5 MB in Word 2007 format). I hope that you will find it useful. Please leave a comment if you have any additional questions or issues.

SSRS and SharePoint make a powerful combination! If you have implemented an innovative or value add solution with the combo, please leave a comment with a description of what you’ve done.

Introduction to SQL Server Reporting Services

http://www.simple-talk.com/sql/sql-server-2005/business-intelligence-in-sql-server-2005,-part-1/

http://www.simple-talk.com/author/dejan-sarka/

SQL Server Recovery

http://blog.bpsnw.com/2007/09/my-steps-to-recovery.html

Report Builder and Forms Authenticaton in SQL Server Reporting Services 2005

http://blogs.msdn.com/bimusings/archive/2005/11/29/497848.aspx

Publishing Reporting Services reports to MOSS

http://blogs.msdn.com/bimusings/archive/2007/01/16/publishing-reporting-services-reports-to-moss.aspx

Today! (Cleaning up Reporting Services SharePoint Add-In Setup Problems)

http://blogs.msdn.com/bwelcker/archive/2006/11/09/today-cleaning-up-reporting-services-sharepoint-add-in-setup-problems.aspx

Direct Reports (Brian Welcker’s Weblog) : Reporting Services

http://blogs.msdn.com/bwelcker/rss_tag_Reporting+Services.xml

Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-wss-3-0-and-moss-2007.aspx

http://blogs.msdn.com/sharepoint/archive/2007/08/02/microsoft-sql-server-reporting-services-installation-and-configuration-guide-for-sharepoint-integration-mode.aspx?CommentPosted=true

BI Whitepaper SQL Server Business Intelligence

http://download.microsoft.com/download/c/5/9/c5955aa6-97e4-4b30-9b15-3d37e2be82e7/SQL%20Server%202005%20and%20Office2007%20Business%20Intelligence%20Whitepaper%20Jan312007.docx

Readme for Microsoft SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

 

http://download.microsoft.com/download/f/d/c/fdcb3a53-0cb1-4e67-a1b6-45b89b3c59cf/readme_rsaddin.htm

SQL Reporting Services, Cannot create a connection to data source login failed for user ‘null’

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21495110.html

Help with setting up Reporting Services

http://forums.asp.net/p/1061289/1530295.aspx

how can associated ‘sa’ with a trusted SQL Server connection in sql server 2005?

http://forums.asp.net/p/939856/1221882.aspx

how can associated ‘sa’ with a trusted SQL Server connection in sql server 2005?

Configuring Reporting Service Add-in for sharepoint – HTTP status 401: Unauthorized.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1379070&SiteID=1

Help!! "The report server has encountered a configuration error…….."

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=150192&SiteID=1

Report deployment error in SharePoint Integration mode

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1609891&SiteID=1

IIS 6 MMC problem with ReportServer and ASP.NET configuration

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=250225&SiteID=1

Error "Connection Could not be made to the report server" when attempting deployment

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=335663&SiteID=1

Reporting Services and SharePoint 2007 install

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=588158&SiteID=1

Sharepoint integration – User cannot be found??

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1483741&SiteID=17

rsAccessDenied when accessing Report Server

http://microsoft-databases.hostweb.com/TopicMessages/microsoft.public.sqlserver.reportingsvcs/604168/1/Default.aspx

Cannot use ‘partitionResolver’ unless the mode is ‘StateServer’ or ‘SQLServer’ on server running SharePoint 2007

http://rfinn.spaces.live.com/blog/cns!4E19D0E183DFC38B!180.entry

You receive an "HTTP Error 401.1 – Unauthorized: Access is denied due to invalid credentials" error message when you try to access a Web site that is part of an IIS 6.0 application pool

http://support.microsoft.com/kb/871179

Error message when you try to modify or to delete an alternate access mapping in Windows SharePoint Services 3.0: "An update conflict has occurred, and you must re-try this action"

http://support.microsoft.com/kb/939308

How to use Trusted Connection when SQL server and web Server are on two separate machines.

http://weblogs.asp.net/achang/archive/2004/04/15/113866.aspx

Reporting Services Trouble Shooting SQL Server Books online

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