Archive for June, 2008

 

My struggle with Browser enabled InfoPath Form connection to ‘UserProfileService’ Web Service

 
Overview I faced a silly error when trying to use data connection in a Browser-enabled InfoPath Form to connect to MOSS built-in ‘UserProfileService’ web service in order to retrieve the display name (Preferred Name) of the logged in user. It works great without any error when I preview the form in InfoPath. However, I [...]

Continue reading

 
 

Deploy old SQL Reporting Services Reports to SharePoint Site

 
Overview In my previous post, I discussed about how to setup SharePoint Integrated SQL Server Reporting Services (RS). Now that I have the Integrated RS ready, I can deploy the reports to the SharePoint site. But wait, how can I deploy a Pre-SP2 RS report to SharePoint site? Below shows the steps I used. [...]

Continue reading

 
 

Guides on setting up SharePoint integrated SQL Server Reporting Services

 
Overview This is going to be a long post, in this post I am trying to describe how I setup Integrated SQL Server Reporting Services on a Standalone SharePoint Server. According to my understanding, these steps can be applied to SharePoint Services too. Software Configuration SQL Server 2005 [...]

Continue reading

 
 

Problems in deploying / debugging SQL Report Server Project: Permissions granted to user ‘domain\username’ are insufficient (rsAccessDenied)

 
Overview I came across an issue that the project created from "Report Server Project Wizard" Template in Visual Studio did not deploy successfully and the "permissions granted to user ‘domain\username’ are insufficient for …. (rsAccessDenied)" error was shown. Finally I was able to get it done by restoring the IIS ‘ReportServer’ [...]

Continue reading

 
 

Set the Start Up display Form in Access 2007

 
Overview In my previous blog showing How to convert Access 2007 App into Runtime Mode, I discuss how to convert Application to Runtime Mode. However, you need to specify a Start-Up Form so that the Runtime Application have something to show when started. Reference Change Access 2007 database options for your application [...]

Continue reading

 
 

Convert application to Runtime Mode in Access 2007

 
Overview Access Forms let you create a user-friendly interface to end-user, it can also restrict what your users can view/modify. However user can still modify your table directly if your application is not run in Runtime Mode. Below shows the steps to convert your Access 2007 application to runtime before you put it to [...]

Continue reading

 
 

Customizing Web Parts Outlook with XSL Editor

 
Overview Out-of-the-box web parts in MOSS is very useful in development. However some of their looking might not fit your needs. However, the looking and style of web parts can be customized by editing the XSL(Extensible Stylesheet Language) file. Steps Navigate to the Page containing the Web part you [...]

Continue reading

 
 

Embed SQL DB connection ID & password into BDC Definition File

 
Overview (From MSDN: BDC Overview) Business Data Catalog (BDC) is a new business integration feature in Microsoft Office SharePoint Server 2007, it enables Office SharePoint Server 2007 to surface business data from back-end server applications without any coding. Business Data Catalog provides built-in support for displaying data from databases and Web services. That [...]

Continue reading