General

Re: Filter repeating table on value outside of table - get error.

shniggens — Tue, 14 Feb 2012 16:15:13 GMT

2010 SP 1.

Re: Filter repeating table on value outside of table - get error.

Hilary Stoupa — Tue, 14 Feb 2012 16:00:50 GMT

Oh. My. Gosh. Thanks for posting this - I honestly thought that had to be some crazy coincidence. Can you tell me your version of SharePoint 2010 (any service packs or hotfixes installed)? I want to report this as a bug.

Re: Filter repeating table on value outside of table - get error.

shniggens — Tue, 14 Feb 2012 15:35:57 GMT

That looks like it is indeed the problem. I have a seperate test form that has the same table and rules. When I add a calculated value above the table, the form will no longer publish. This is good to know.

I worked around it by adding a text box to filter with (conditional formatting) and setting the text box with button click instead of default value.

Re: Filter repeating table on value outside of table - get error.

Hilary Stoupa — Mon, 13 Feb 2012 22:12:15 GMT

Is your SharePoint server running SP1?

I know I've seen this before - I removed the filters from my table, so don't know of a resolution for you, but one blog I found (thank goodness for Google translate) suggested he was able to resolve the issue when he moved his calculated value controls below his repeating table controls in his view. I certainly hope that didn't actually cause the issue, but it's kind of interesting.

Oh, and MSDN has this post on the ShP boards - but no conclusive answer.

Re: Filter repeating table on value outside of table - get error.

shniggens — Mon, 13 Feb 2012 21:03:40 GMT

Here's what the ULS viewer gives me -

System.NullReferenceException: Object reference not set to an instance of an object.

at Microsoft.Office.InfoPath.Server.SolutionLifetime.Filters.<>c__DisplayClass2.<CreateDependentNodeList>b__0(BaseControl match)

at System.Collections.Generic.List`1.Find(Predicate`1 match)

at Microsoft.Office.InfoPath.Server.SolutionLifetime.Filters.CreateDependentNodeList(BaseControl control, String expressionString)

at Microsoft.Office.InfoPath.Server.SolutionLifetime.Filters.AnnotateView(Solution solution, View view)

at Microsoft.Office.InfoPath.Server.Converter.SolutionConverter.ConvertView(Solution solution, ConverterDocument converterDocument)

at Microsoft.Office.InfoPath.Server.Converter.SolutionConverter.ConvertSolution(Solution solution)

at Microsoft.Office.InfoPath.Server.SolutionLifetime.Solution.<>c__DisplayClass2.<ConstructFromXsnFile>b__0()

at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)

at Microsoft.Office.Server.Diagnostics.ULS.SendWatsonOnExceptionTag(UInt32 tagID, ULSCatBase categoryID, String output, Boolean fRethrowException, TryBlock tryBlock, CatchBlock catchBlock, FinallyBlock finallyBlock)

at Microsoft.Office.InfoPath.Server.SolutionLifetime.Solution.ConstructFromXsnFile(ConversionContext context, SolutionCabinet solutionCabinet, SolutionIdentity solutionId)

at Microsoft.Office.InfoPath.Server.Converter.ConversionAppDomain.OperationRunner.ExecuteConversion(ConversionContext& context, SolutionCabinet solutionCabinet, SolutionIdentity solutionId, Boolean executeVerification)

at Microsoft.Office.InfoPath.Server.Converter.ConversionAppDomain.ExecuteInRemote(ConversionContext context, AppDomain domain, SolutionCabinet solutionCabinet, SolutionIdentity solutionId)

at Microsoft.Office.InfoPath.Server.Converter.ConversionAppDomain.<>c__DisplayClass4.<TryRunConversion>b__0()

at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)

at Microsoft.Office.InfoPath.Server.Converter.ConversionAppDomain.TryRunConversion(ConversionContext context, SolutionCabinet solutionCabinet, SolutionIdentity solutionId, Byte[] solutionData, WspSolutionInfo wspSolution)

at Microsoft.Office.InfoPath.Server.Converter.ConversionAppDomain.RunConversion(ConversionContext context, SolutionCabinet solutionCabinet, SolutionIdentity solutionId)

at Microsoft.Office.InfoPath.Server.Util.InstalledSolutions.<>c__DisplayClass7.<VerifyUnpackedSolution>b__6()

at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)

at Microsoft.Office.InfoPath.Server.Util.InstalledSolutions.VerifyUnpackedSolution(SolutionCabinet solutionCabinet, String originalFileName, ConversionContext context, ConverterLog& outputConverterLog, Byte[]& outputConvertedData)

at Microsoft.Office.InfoPath.Server.Util.InstalledSolutions.VerifySolution(String absoluteLocalPath, ConversionContext context, ConverterLog& converterLog, Byte[]& convertedData)

at Microsoft.Office.InfoPath.Server.Administration.FormTemplateCollection.VerifyFormTemplateInternal(String solutionPath, ConverterLog& converterLog)

at Microsoft.Office.InfoPath.Server.Administration.FormTemplateCollection.TryUpgradeFormTemplate(String solutionPath, UpgradeType upgradeType, ConverterLog& converterLog)

at Microsoft.Office.InfoPath.Server.Administration.FormTemplateCollection.UpgradeFormTemplate(String solutionPath, UpgradeType upgradeType)

at Microsoft.Office.InfoPath.Server.ApplicationPages.UploadFormTemplatePage.<>c__DisplayClass1.<ButtonOkClick>b__0(String sourceName)

at Microsoft.Office.InfoPath.Server.ApplicationPages.UploadFormTemplatePage.HandleFiles(HandleFile fileHandler)

at Microsoft.Office.InfoPath.Server.ApplicationPages.UploadFormTemplatePage.ButtonOkClick(Object sender, EventArgs e)

at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

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

Re: Filter repeating table on value outside of table - get error.

Hilary Stoupa — Mon, 13 Feb 2012 20:43:25 GMT

Can you check the SharePoint logs for additional information?

Re: Filter repeating table on value outside of table - get error.

shniggens — Mon, 13 Feb 2012 20:23:38 GMT

It's a browser form.

The reason I would like to filter instead of format is -

The filter or condition is based off of a drop-down outside of the table in the form. The users choose the drop-down, click a button, a table is copied over, and the only rows that are shown are rows that have a field that matches the drop-down.

The problem is, with conditionall formatting, the table is formatted every time that drop-down changes, which causes a performance issue. With the filtering, the filter isn't applied until after the table copies over, making it more seamless.

Re: Filter repeating table on value outside of table - get error.

Hilary Stoupa — Mon, 13 Feb 2012 19:51:02 GMT

Is this a browser or a filler form?

I don't use filters on repeating tables usually, as I've had troubles with them in IPFS - I also find that it is not easy to readily see when a table has a filter, whereas conditional formatting shows up in the Rules task pane.

Filter repeating table on value outside of table - get error.

shniggens — Fri, 10 Feb 2012 20:43:33 GMT

I am trying to filter my repeating table to show only items which field matches the value of a field outside of the table. When I try to publish it, I get an "Object not set to an instance of an object" error.

However, if I applly conditional formatting to do the same exact thing, I don't get any error.

Any suggestions?