More servicesWindows Live™
HomeHotmailSpacesOneCare
 
MSN
Sign in
 
 
Spaces home  Shawn's Work SpaceProfileFriendsFilesMore Tools Explore the Spaces community

Shawn's Work Space

tips and tricks for SharePoint, Reporting Services, .NET, etc...

Blog
November 13

SharePoint, DOCTYPE, and master pages

SharePoint by default does not support taking IE out of quirks mode.  This is discussed in a great blog entry by Heather Solomon.  Not enforcing a dtd through the DOCTYPE element in the default.master (for example
DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"  "http://www.w3.org/TR/html4/loose.dtd")
Caused me a lot of problems since Height 100% is not honored.  Specifically the Reporting Services Add-in for Sharepoint is reliant on the height=100% property of tables.  It was necessary for me to include the doctype then.  This created some other issues in that it broke some of the other scripts in sharepoint.  This is because when ie is in quirks mode document.body is the root document element but when the DOCTYPE is applied, document.documentElement becomes the root element.  Alot of these discoveries can be made using script debugging in IE
 
Here's a sample of a script i had to change in IE55UP.js....
 
function MSOLayout_GetRealOffset(StartingObject,OffsetType, EndParent)
{
 var realValue=0;
 if(!EndParent) EndParent=document.documentElement;
 if(EndParent==null){
     EndParent = document.body;
 }
 for (var currentObject=StartingObject; currentObject !=EndParent && currentObject !=document.documentElement && currentObject !=document.body; currentObject=currentObject.offsetParent)
 {
  realValue+=eval('currentObject.offset'+OffsetType)
 }
 return realValue;
} 
5:10 PM | Add a comment | Read comments (1) | Send a message | Permalink | View trackbacks (0)

Quick Guide on how to install Reporting Services on its own server/cluster in Sharepoint Integration Mode without using Kerberos

  1. Install SQL Server 2005 - Reporting Services Only
  2. Install SQL Server Service Pack 2
  3. Install Sharepoint (as WFE)- SKU (Enterprise Edition, Standard,etc..) has to match the other SKUs in the farm
  4. Run the Sharepoint Server Configuration (do not add central admin unless you want to) - Not sure if this step is needed but can't hurt
  5. Install the reporting services add-in for sharepoint
  6. Run the Reporting Services Configuration Utility [start-->all programs-->microsoft sql server-->configuration-->reporting services configuration]
  7. Create the ReportServer Virtual Directory (ReportServer) preferably
  8. ReportServer AppPool and Reporting Services Windows Service should both be a domain account
  9. Create the Database (create the database in Sharepoint integration mode) -
  10. (Here's the Trick) - the Website that contains the report server vdir attempts to negotiate authentication by default.  This is not needed if you are not configuring kerberos. 
  11. To fix this if you do not intend to use kerberos, open a command prompt, cd to c:\inetpub\adminscripts\
  12. First check to see if there is an authentication provider run cscript "adsutil.vbs get w3svc/{WebSiteId}/root/NTAuthenticationProvider" ({WebSiteId} being the id for the website containing the RS Vdir), this should return [The parameter "NTAuthenticationProviders" is not set at this node.]
  13. Then run [cscript adsutil.vbs set w3svc/1/root/NTAuthenticationProviders "NTLM"]
  14. This should return [NTAuthenticationProviders       : (STRING) "NTLM"]
  15. Next go to Sharepoint central administration and enable the reporting services feature and then configure the rest of reporting services within application management.  Be sure to set the authentication method to Trusted Account. 
  16. For more information on this see - http://blogs.msdn.com/sharepoint/attachment/4194088.ashx
3:59 PM | Add a comment | Send a message | Permalink | View trackbacks (0)
October 19

Reporting Services: Images with Transparent Backgrounds

If you've been trying to put a transparent image into reporting services and have not been able to make the background transparent i share your pain.  Luckily i found a solution. 

1. Place a rectangle where you would place the image

2. Place the image inside the rectangle

3. That's actually it.  Simple and not straightforward at all.  Can't wait for CSS support in Katmai!

3:29 PM | Add a comment | Send a message | Permalink | View trackbacks (0)
View more entries
 

Profile

Shawn

View spaceSend a message
Occupation:
Technology Consultant
Location:
Denver
I'm a consultant for Microsoft Consulting Services specializing in SharePoint and BI Products. I've been with Microsoft since 03/2006.

The opinions expressed herein are my own personal opinions and do not represent my employer's views in anyway.
View profile details

Files

Public folders

Folders shared with the world

Xbox Live GamerCard
feldrocker
Xbox Live GamerCard
Rep:
Reputation:Reputation:Reputation:Reputation:Reputation:
Score:
3860
Zone:
Recreation
Call of Duty 4Geometry Wars Evolved²NINJA GAIDEN 2FIFA 08Geometry Wars Evolved