Sunday, November 9, 2008

Export spread sheet option in MOSS 2007

Hi all,
Last week i had a small requirement in my project, where i need to enable "Export spread sheet" to Sharepoint Viewers group(Usually users in Viewers group will not have access to use "Export to spread sheet" option) of the sharepoint site.
To accomplish this, I have decided to create a simple web part page where in i will drag and drop the list in the web part page and add another Content Editor Web part.
Now, Modify the content editor webpart to create the html link with the following url.

http://servername/Sitename/([Subsitename]/)_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=[ListGUID]&View=[ViewGUID]&CacheControl=1

Save the changes, your job is done :-)

WSS/MOSS + There are no products affected by this package installed on this system

Hey guys,
If any of you recieve an error "There are no products affected by this package installed on this system" while installing MOSS/WSS updates. Make sure you have downloaded the appropriate windows version update from Microsoft site.
Eg: I was getting the error "There are no products affected by this package installed on this system" when I tried to install wssv3sp1-kb936988-x64-fullfile-en-us.exe, instead i have to download and install wssv3sp1-kb936988-x86-fullfile-en-us.exe for my system configuration..
Hope this helps
Happy programming :-)