Newbie Questions

Re: Binding a Infopath textbox with filtered value

ravi_kadri — Tue, 20 Jan 2009 05:32:09 GMT

Hi Swathi:

I followed exactly your method and the issue is Infopath doesnt filters. It looks like, i am missing infopath not able to find the filter values.

Anyways, i modified the webservice return as a string value and now Infopath is happy with it.

Thank you very much

Thanks Anuma too....:)

Have a great day!

Ravi

Re: Binding a Infopath textbox with filtered value

swathip — Mon, 19 Jan 2009 14:13:56 GMT

Hi,

Try the following steps.

1. Go to text box properties.

2. Click on fx button.

3. Click on Insert field or group. Select ‘DeductionAmnt' from the secondary source.

4. Click Filter data. And click Add button.

5. Select ‘CodeDesc' in the first drop down, is equal to in the second drop down, and enter ‘Pension Join Service' text in the third drop down.

6. Click ok until all the windows gets closed.

Note: If you want to change the filter value, then its better to store that value in a field and while filtering compare with that value.

Re: Binding a Infopath textbox with filtered value

Anuma — Mon, 19 Jan 2009 12:51:18 GMT

Did you added receive data connection to get the data from db?

If you already added the data connection for db, then it will be displayed. Send me your xsn for better idea.

Re: Binding a Infopath textbox with filtered value

ravi_kadri — Mon, 19 Jan 2009 12:28:32 GMT

Hi:

My data is coming from Database as a Dataset and it is not showing up roworder(in the InfoPath). I double checked and it is not showing up in the InfoPath. I am still stuck. :(

Ravi

Re: Binding a Infopath textbox with filtered value

Anuma — Mon, 19 Jan 2009 12:12:57 GMT

Select a Field or Group option in first dropdown. and select Row Order from secondary xml list.

Re: Binding a Infopath textbox with filtered value

ravi_kadri — Mon, 19 Jan 2009 12:09:35 GMT

Hi:

Thanks for your help. But, I am stuck at point 7.

I am not able see "rowOrder" in the filter dropdown box. Is I am missing anything? I am not able see the rowOrder.

Can you please help me in this?

Ravi

Re: Binding a Infopath textbox with filtered value

Anuma — Mon, 19 Jan 2009 10:54:31 GMT

Hi,

Can you follow the below steps:

Double click on the text box.
Click on “fx” button under the default value.
Click on “Insert Field or Group” button.
Select your secondary xml name from Data source dropdown.
Select “DeductionAmnt” field.
Click on the “Filter data” button and click on “Add” button.
Select “rowOrder” from first dropdown.
Select “is Equal to” from second dropdown.
Enter “2” number in the third dropdown.
Click on ok until close all windows.

Re: Binding a Infopath textbox with filtered value

ravi_kadri — Mon, 19 Jan 2009 10:42:30 GMT

Hi:

It would be great if you can you explain me this in bit detail? I am still not able to filter.

Thank you very much!

Ravi

Re: Binding a Infopath textbox with filtered value

Anuma — Mon, 19 Jan 2009 06:32:47 GMT

Hi,

Add following function to the Text box.

"DeductionAmnt[@rowOrder = 2]"

rowOrder --> msdata:rowOrder

Binding a Infopath textbox with filtered value

ravi_kadri — Mon, 19 Jan 2009 06:24:54 GMT

Hi:

I have a dataset with the flowing format. Is there any way to bind a infopath textbox with a filtered value? Say example. I want to bind ‘Pension Join Service amount to a textbox. <NewDataSet xmlns=""><Table diffgr:id="Table1" msdata:rowOrder="0"> <CodeDesc>Pension Services</CodeDesc> <DeductionAmnt>220</DeductionAmnt> </Table> Table diffgr:id="Table2" msdata:rowOrder="1"> <CodeDesc>Pension Assumed</CodeDesc> <DeductionAmnt>220</DeductionAmnt> </Table> <Table diffgr:id="Table3" msdata:rowOrder="2"> <CodeDesc>Pension Join Service</CodeDesc> <DeductionAmnt>220</DeductionAmnt> </Table><Table diffgr:id="Table4" msdata:rowOrder="3"> <CodeDesc>Pension Instocmmut</CodeDesc> <DeductionAmnt>220</DeductionAmnt> </Table> <Table diffgr:id="Table5" msdata:rowOrder="4"> <CodeDesc>Pension Loan</CodeDesc> <DeductionAmnt>220</DeductionAmnt> </Table> </NewDataSet>

Thanks!

Ravi