Post New Web Links

Issue in Infopath 2007 browser form - cascading dropdown using owssvr.dll filter view

Posted By: Posted Date: August 26, 2010 Points: 0 Category :SharePoint

Referring the below link, I created a cascading dropdown. The parent dropdown has sharepoint list as datasource and the child dropdown has xml datasource that points to owssvr.dll filter view. The cascading drop down works fine in preview but throws error after publishing as admin approved form - "form cannot run the specified query" exception when trying to execute xml datasource i.e., when a value is selected in parent dropdown. The security is 'Full Trust". In the event viewer the error message states "401 unauthorised" for the user a/c. the xml data source is an approved udcx file and in central admin, have enabled cross domain for infopath service. I have tried different solution provided in tech forums but issue still exists. Not sure whether Im missing something. Can someone guide me in fixing this issue?

Link Reffered:

http://www.bizsupportonline.net/browserforms/filter-cascade-drop-down-infopath-sharepoint-browser-form-owssvr-dll.htm

http://www.sharepoint-tips.com/2007/01/infopath-form-services-implementing.html

View Complete Post

More Related Resource Links

Infopath 2007 print view in browser enabled form with Print button

Hi i create a print view brower enabled form in Infopath 2007 with header and footer. In Infopath works fine. Margin was ok, header and footter to. But then i try to print this browser the margin, header and footer it changes to default setting of browser ? I try also create a print button in form with VS 2008 code, but method :

this.print(); not working.

It is possible to print the "print view" in browser as the same like in Infopath 2007? Does anyone have the code how to create a print button in C# on browser enabled form?

Filter Infopath Form View issue

Hi every body I want to Filter Infopath Form view based on the Document Library Name , or url . for example i have two document library : users and Moderators . I need if user open the form in users document library , the form opens with Users View and if user opens the form in Moderators document lib the form open with the Moderator view . what should i do ? I tried to insert a text box in my form and set it's default value to use sharepointlisturl function. but i think the sharepointlisturl function only use when the form hosted from the lists , not document libraries. when my form hosted from document library the text box is empty. i don't know what to do !

Deploying InfoPath 2007 form to WSS 3.0 as browser enabled

Please Help! I've created an Infopath form and wanted to deploy the form as browser enabled to WSS 3.0? What are the different options I can do this? If i cannot use a form then i would like to create a custom list with all the form fields but the user should be able to enter information in the list and he should see only the information related to him. I don't want to give access of the whole list to each and every user. Only the administrator should be able to see the whole list. The form was actually a user access request form.

Any help and suggestions is appreciated.

Thanks

Infopath 2007 not printing footer in browser print view

I have added a footer to the print view of a browser enabled form and it is not printing when printing the form. The footer is relatively sinmple, however when I click on print view on the browser form and use print preview, I cannot see the footer at all. I have set bottom margins to auto, however I am using an image in my header and therefore have a section at the top of each page where my page top margin is set to 0 and the margins lie within the bounds of the section at .25". The footer that is not displaying in print preview in the form is as follows;"Quote Number: &{/my:myFields/my:sqnumber&} &b&pof&P&b &b &{/my:myFields/my:group28/my:sqdate&}Revision: &{xdFormatting:FormatString("/my:myFields/my:sqquoterevision","number","numDigits:0;negativeOrder:1;")&} &b Prepared For: &{/my:myFields/my:sqclientname&}"The page setup in IE listed page number and url info when using print preview and I have set them to none because my footer is in the form. Please help, this is frustrating!

Infopath 2010 Browser Based Form Vs Infopath 2010 Filler Based Form Issue

I have created a detailed infopath form that is connecting to multiple sharepoint lists, some of which contain thousands of rows and dozens of columns. To tailor for the data load i have enabled the form to only pull in data as needed and on some of the lists i have created 5 or 6 data connections to the same list, each only looking at a certain set of data, and as you make your way through the form selecting your options, the data is pulled in. If i preview this form from within Infopath or if i launch it using Infopath filler this works great, the data is pulled through in under a second. However if i then publish the form to the browser and launch it through the browser, it now takes roughly 30 seconds to pull in the data. My question is therefore this, Is there something i can do to speed up the way the data is pulled in when launched through the browser? are there transport protocols i can alter or something like that? maybe config in central admin or infopath config? any help would be gratefully appreciated as if i can not get the form to pull the data in fast through the browser then the whole project is a waste of time as my management team will never go for the solution if it is slow and will get slower as more data is added. thanks

Infopath 2010 Browser Based Form Vs Infopath 2010 Filler Based Form Issue

Infopath 2007 cascading dropdown through coding

Hi,

Can anyone suggest me the Infopath cascading dropdowns. I need to create one form ...it will have 3 dropdown and based on the users selection in the first dropdown 2nd dropdown should display only one item (out of 3 standard items..users dhould see only one item int he dropdown). based on the user's selection wrd dropdown should show 2 items (out of 5 standard items....users should see some items only based ont he first dropdwons selected value). Can anyone one suggest how to accomplish this?. Thanks in advance to all.

infopath form default view issue

hi,

i'm having some issue with my form views.

i have 3 views for my form. 1 for the fill in, 1 for approving and the last one to be submitted to the database

i have set the fill in form as initiator. and the approver view as default but when the 3rd user wants to open the form to submit the form to the database it does not open the form with the view for submitter. it keeps opening the approver view.

and if i set the approver view to default it opens the approver view, if i set the fill in view to default it open the fill in view.

how can i fix this. can i only create 2 views for 1 form?

Provision an InfoPath form template in a content type, with "view in browser" option

Hi all.

I've to provision an InfoPath form template in SharePoint 2010 within a content type, and my form must be open in a browser.

The provision of the .xsn file and of the content type goes well, but my form always open in the client and not in the browser. Instead, if i publish my form from InfoPath 2010 using the "Publish" option and i select to publish my form within a content type, everything goes well. I can see the form in the browser.

Here is my code.

Module

<?xml version="1.0" encoding="utf-8"?>

</Module>

</Elements>

ContentType

<?xml version="1.0" encoding="utf-8"?>

<ContentType ID="0x0101

Filter Form Library View using promoted columns from InfoPath

Hi
I have a form that requires two levels of approval. This is published to a form library on SharePoint 2007. I only want users to see their own forms as there are monetary values involved. I can achieve this using the view filter “Created by” & “Modified by” = [Me], however the line approvers can only see the forms after they have interacted with them. Once the next person in the workflow edits, they cannot see the form.

I have tried using columns I promoted where I have stored the username of the approvers and using the [Me] filter, I get a “Filter value is not a valid text string”. I created two more calculated columns in SharePoint making them equal to my InfoPath fields, and I still get the same error.

Can anyone tell me how I can set a filter so that these line managers can at all times see any forms that have required their approval?

Many thanks in advance.

InfoPath 2007 browser form problem in SPS2010

Hello,

i've one issue with an InfoPath browser form in SharePoint 2010 struggling with it for 2 days now.

I have an InfoPath 2007 browser form with PeoplePicker controls in it and custom code for XMLChangedEventHandler assigned to the PeoplePicker.

Below this Control i have a repeating table with a simple rule: "If the DisplayName is empty, don't show this section."
So if somebody picks up a user, normally the section should be enabled and visible to the user.

But for some reason this is not happening, but when i save the form and reopen it again, then the section is visible.
Opening the Form in Preview (F5) Filler Mode the section gets also enabled correctly. After uploading via Central Admin meaning in the browser not.

I also tried in the Browser tab setting the "Always" postback option to all relevant fields but still not working.

I also put code into the ChangedEvent Handler, when somebody adds a user with the PeoplePicker, then it puts a comment to a field for testing purposes.
This is also not happening by runtime, instead when i reopen the Form, then i can see the comment.

I increased also the Number of Postbacks in Forms Services in the Central Administration without success.
Can anybody help or had the same problem???

Q: How to print out background color in InfoPath 2007 browser form under MOSS form service?

Hi InfoPath experts,

I am trying to print out a custom InfoPath 2007 browser form using "Print View" function offered by MOSS Form Service. It seems like the all background color formats has been stripped out when printed out. Interestingly, only font colors are remain the same in printed-out.
Is there a way to fix this issue? I know you can change the settings: http://office.microsoft.com/en-gb/infopath-help/print-background-colors-and-pictures-HP001095710.aspx , but it only applies for InfoPath Client Form, not browser-based Form!

Any help are appreciated!
-Rick

Users who do not have permissions to access InfoPath 2007 web based form can view the form if someon

I have a SharePoint Form Library with an InfoPath form published to the form as the default template. The form library has several forms in it that have line item permissions. This is supposed to restrict who can view the form. If the user who has had their permissions removed navigates to the form through SharePoint the form does not display (this is expected behavior). However if the user is provided a link to the URL for the form then the can view the InfoPath form.

Here is an example of the link: http://moss.companyname.com/test/_layouts/FormServer.aspx?XmlLocation=/test/InfoPath%20Test/system2009-10-23T12_23_13.xml&Source=http%3A%2F%2Fmoss%2Ecompanyname%2Ecom%2Ftest%2FInfoPath%2520Test%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1

In addition I tried to put the forms into a folder and restirct the permissions on the folder, but the restricted users can still view the form.

When I removed the users permission to the form library then they got an error message.

I also tested this with a SharePoint list item and restricted permissions and this did not allow the user to view the item.

An

Infopath browser form - Digital Signature resized in print view

Hi,

I have an Infopath browser based form that I have a digital sig on. When the user signs it (Valid Signature - Signed by) the font size is small and is acceptable for use in the form. Howvever, when I go to "Print View" it resizes to a larger font. I do not want this as I am trying to fit the form to one page. I altered the font in the signing section in the Print View in Infopath to no avail. Looking at the Manifest file, I cannot locate the code where it determines the font size. Anyone have any ideas?

Thanks,
Aaron

Unable to get AD profile information using InfoPath form in Sharepoint 2007 browser mode

I have followed the threads on this but haven't been able to resolve the issue with any of the suggestions provided. I need to get the user's first and last name from their profile. I created an InfoPath form using the "Get current user without writing code" blog directions I ran across here, using the standard userprofileservice.asmx service. Everything works fine so long as I don't use the SharePoint browser option. Then I get the error:

An error occurred accessing a data source.
An entry has been added to the Windows event log of the server.

Log ID:5566

I have attacked this from every angle I can think of:

IE, Design checker - OK, SSP account, my account have AD read access, no problems getting to the site collection, as stated before, runs fine if I don't use the browser option

Converted the connection to a udcx stored in the same site as the form library - tried both converted and unconverted connection - same problem, removed the connection altogether, everything works fine (but, of course, no profile info), works under InfoPath using either connection

Set form with Domain trust

Published it to a form library, also tried admin approved with full trust and signed - same problem

Ran locally on SharePoint server and remotely - same problem

InfoPath 2007: Designing Form Templates With The New Features Of InfoPath

InfoPath 2007 is an XML forms designer and editor, and a fully featured and integrated member of the Office family. This article takes a sneak peek at some of its new features.

Scott Roberts and Hagen Green

MSDN Magazine August 2006

Attachment upload error on browser based InfoPath form

Hello,

I am having an interesting problem with browser based InfoPath forms in SharePoint 2007. For some reason the file attachment control is not working any more. It was working fine in July, but now it will not allow file attachments over a few kb. I tried a 34KB file and I get the error below, a 2KB file works fine.

Unable to connect to SQL Server session database. The connection string (server='SPDB', database='SharedServices1_DB') was returned by an instance of the IPartitionResolver type 'Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'.   at System.Web.SessionState.SqlSessionStateStore.ThrowSqlConnectionException(SqlConnection conn, Exception e)
   at System.Web.SessionState.SqlSessionStateStore.HandleInsertException(SqlConnection conn, Exception e, Boolean newItem, String id)
   at System.Web.SessionState.SqlSessionStateStore.SetAndReleaseItemExclusive(HttpContext context, String id, SessionStateStoreData item, Object lockId, Boolean newItem)
   at System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs)
   at System.Web.HttpApplication.SyncEven


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All