InfoPath 2010

Re: Infopath cascading filters

Hilary Stoupa — Thu, 09 Nov 2017 15:42:34 GMT

Screenshots can be attached under the Options tab in a reply. You can only attach one file per post - so you may want to combine all your screenshots in a single image, or make multiple posts. You emailed me stating you'd resolved this? If you still have an issue, just reply to this post.

Re: Infopath cascading filters

Preeti1309 — Thu, 09 Nov 2017 03:37:58 GMT

Hi Hilary,

Thanks for your advice. With you advice I was able to achieve the results but with not complete success. Let me give you a brief introduction about my SQL server table and form.

Table:

Problem1: On the selection of date previous date selection is not getting cleared. Shown in Image below

I have applied this rule to clear my dropdown list box.

Problem2: While clicking on View Report, I get this pop up which is confusing for the users.

Problem 3: While closing the form which is deployed on SharePoint I get this message to save the .xml form. I don't want this pop up, since this is a SQL server based form and I am never going to save this form.

Any suggestion would be appreciated.

Thanks & Regards,

Re: Infopath cascading filters

Hilary Stoupa — Mon, 06 Nov 2017 15:38:16 GMT

I think you may need to add a SQL view for this, and a secondary data connection. With a SQL view, you could have a column with just the date value - and then use that for your filter. Or, perhaps you can add another column to your table with that information?

Infopath cascading filters

Preeti1309 — Fri, 03 Nov 2017 03:00:39 GMT

Hi All, I have a InfoPath form 2010 based on SQL server database. In my table I have a column called Observation_Date.

My requirement is that when user opens the form first option he gets is a date picker for eg if user picks todays date 11-3-2017. then my next component should be a dropdown which shows all the Observation_dates for today with different time stamp which are there in the database (like 11-3-2017 02:00:00, 11-3-2017 03:23:44 so on) . Once user select date from this dropdown my repeating table should filter the data corresponding to this selected Observation_date.

Thanks & Regards,

Preeti