David Wise's Sharepoint blog - All Comments

re: Connecting SQL Reporting Services to a SharePoint List

Jeff — Tue, 30 Jun 2009 19:10:02 GMT

Sorry there is a minor mistake in the code provided. Add the following Dim to the code:

Dim c As Integer

re: Connecting SQL Reporting Services to a SharePoint List

Jeff — Tue, 30 Jun 2009 19:06:47 GMT

Hello Joe and all,

Here is an updated code that will strip all special parsing characters for multi selection lookup.

Function GetNameFromSP(ByVal s As String) As String

Dim combStr As String

Dim array As String()

combStr = String.Empty

array = Split(s, ";#")

Console.WriteLine(array.Length)

For c = 1 To array.Length - 1 Step 2

combStr += array(c) + ", "

Return Left(combStr, combStr.Length - 2)

End Function

re: HowTo: Filter a View based on Workflow Status

Paul — Tue, 30 Jun 2009 18:45:48 GMT

Thanks for posting this! Saved me a lot of time.

re: Connecting SQL Reporting Services to a SharePoint List

Jeff — Mon, 29 Jun 2009 14:33:17 GMT

Hello Joe,

I am seeking the same thing. My lookup column has multiple lookup selections enabled and unfortuantely the provided code snippet only removes the first entry. Did you ever find a solution?

re: HowTo: Filter a View based on Workflow Status

ASharepointGirl — Thu, 25 Jun 2009 15:31:23 GMT

Awesome. Just what I was looking for.

re: A duplicate site ID ... error in Event Log after moving Content Databases.

Brian — Wed, 24 Jun 2009 12:35:23 GMT

Awesome! Works for me as well! I'm going to get my 300 bucks back from my MS support call!

re: Accessing SharePoint List Data as XML

Steve — Fri, 19 Jun 2009 18:19:04 GMT

I've added the RootFolder parameter to the url to get a subfolder so for example to get a folder or subfolder you can use the link

http://<portal>/<sites>/_vti_bin/owssvr.dll?Cmd=Display&List={GUID}&RootFolder=<url path to Folder or SubFolder>&XMLDATA=TRUE

also, if you want to query specific fields just add the Query=*, Query=<Field> parameter to the URL.

re: Accessing SharePoint List Data as XML

Micheal — Wed, 17 Jun 2009 17:44:07 GMT

I'm having the same issue as Sarah, Christophe, and Scott. I get nothing but a blank page for lists that have multiselect lookups. View Source shows nothing. Has anyone found a way to get this to work?

re: HowTo: Filter a View based on Workflow Status

Scott Rooke — Mon, 15 Jun 2009 18:12:13 GMT

David -

Have you seen the value of 8 show up recently? I can't seem to find out what 8 is = to. Do you have any thoughts?

Thanks!

Scott

re: #RENDER FAILED in View With Totals and Grouping

Anuradha — Wed, 10 Jun 2009 12:22:20 GMT

Thanks a lot.........this really worked

re: Accessing SharePoint List Data as XML

Zack — Thu, 04 Jun 2009 05:55:06 GMT

Does anyone know what features use XML as their transport layer in SharePoint and/or What APIs are provided by SharePoint for 3rd parties?

re: How to access the Embedded database used by Sharepoint

THC — Wed, 03 Jun 2009 09:24:43 GMT

Great POST !!!

re: Inside the SharePoint People Picker

If you need to override the SharePoint People Picker validation logic — Tue, 02 Jun 2009 23:45:28 GMT

visit natnael.squarespace.com/.../sharepoint-people-picker-override-validation-logic.html

re: Connecting SQL Reporting Services to a SharePoint List

Andrew — Tue, 02 Jun 2009 08:18:04 GMT

Your namespace attribute value in the method node should be enclosed in quotation marks.

What you've got is <Method Namespace=schemas.microsoft.com/.../soap

What your should have is <Method Namespace="schemas.microsoft.com/.../soap"

re: Connecting SQL Reporting Services to a SharePoint List

Subhasis — Mon, 01 Jun 2009 10:44:48 GMT

I also got the above error.My requirement is to get pivot table reports from multiple lists of same type.

Regards

Subhasis

re: A duplicate site ID ... error in Event Log after moving Content Databases.

Jotabs.br — Sat, 30 May 2009 15:45:08 GMT

Thanks a lot Vikram! it was really useful.

re: Connecting SQL Reporting Services to a SharePoint List

jahs — Fri, 29 May 2009 09:54:40 GMT

hi, thanks for those usefull informations

I'v got a problem when i'm entering the query

<Query>

<Method Namespace=schemas.microsoft.com/.../soap

Name="GetListItems"/>

<SoapAction>schemas.microsoft.com/.../soapGetListItems

</SoapAction>

</Query>

i'v got the error :

"The XmlDP query is invalid. (Microsoft.ReportingServices.DataExtensions)"

has anyone got the same error ? and how resolve it ?

thanks

re: #RENDER FAILED in View With Totals and Grouping

vikpri — Thu, 28 May 2009 17:27:03 GMT

Thanks...you saved my day!:-)

re: Connecting SQL Reporting Services to a SharePoint List

Jeckle — Wed, 27 May 2009 10:25:04 GMT

Hi,

Where can i download the community version of enesys? Even the previous version in their website required a product key.

re: A duplicate site ID ... error in Event Log after moving Content Databases.

Tim — Mon, 25 May 2009 07:48:18 GMT

Yep worked for me as well. Thanks for the posting.

re: #RENDER FAILED in View With Totals and Grouping

benrickles — Fri, 15 May 2009 17:08:41 GMT

The issue I was working with involved grouping by date on surveys. The user had removed the "View Response” from the "All Responses" view. Adding this back allowed the list to display grouping collapsed by default.

re: SharePoint Dev Tip - Restart the Timer

Ollie — Thu, 14 May 2009 13:49:02 GMT

thanks

re: Connecting SQL Reporting Services to a SharePoint List

Andhem — Mon, 11 May 2009 16:03:59 GMT

This worked well for single lists, and small amounts of data. But if you are trying to join multiple lists together, you should look at this posting:

ezra.auerbach.co.il/.../reporting-on-sharepoint-data-using-the-sharepoint-content-database

re: One .Master to Rule Them All (Two, actually)

Jayasmita — Mon, 11 May 2009 10:29:03 GMT

Same problem here. This application.master works fine for administration pages in the top level site. But when I go to subsites, the administration pages (i.e. _layouts pages) are again taking the master page as the default one (i.e. application.master).

So how to achieve a single custom application.master across the sites?

re: One .Master to Rule Them All (Two, actually)

peter — Sat, 09 May 2009 01:51:49 GMT

Hello:

I am having the same error as James did in the past.

----------------------------------------------------------------------------------

File Not Found. at Microsoft.SharePoint.ApplicationRuntime.SPRequestModuleData.GetWebPartPageData(HttpContext context, String path, Boolean throwIfFileNotFound)

at Microsoft.SharePoint.ApplicationRuntime.SPVirtualFile.GetVirtualPathProviderCacheKey(String virtualPath)

at Microsoft.SharePoint.ApplicationRuntime.SPVirtualPathProvider.GetCacheKey(String virtualPath)

at Microsoft.SharePoint.Publishing.Internal.CmsVirtualPathProvider.GetCacheKey(String virtualPath)

at System.Web.Hosting.VirtualPathProvider.GetCacheKey(VirtualPath virtualPath)

at System.Web.Compilation.BuildManager.GetCacheKeyFromVirtualPath(VirtualPath virtualPath, Boolean& keyFromVPP)

at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath)

at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile)

at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile)

at System.Web.Compilation.BuildManager.GetVPathBuildResult(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile)

at System.Web.UI.MasterPage.CreateMaster(TemplateControl owner, HttpContext context, VirtualPath masterPageFile, IDictionary contentTemplateCollection)

at System.Web.UI.Page.get_Master()

at System.Web.UI.Page.ApplyMasterPage()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Troubleshoot issues with Windows SharePoint Services.

---------------------------------------------------------------------------------------------

This error does not happen on the main site collection myportalsite/.../default.aspx. But my web application has about 20 other site collections in addition to the mail site collection. The error happened on all other site collections.

myportalsite/.../default.aspx.

"_catalogs/masterpage/MyApplication.master";

works fine for the main site collection, but not working for other site collections within the same application.

I have tried to use "/sites/IT/_catalogs/masterpage/MyApplication.master";

but it is still not working

Any suggestions?

Thanks in advance,