Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / September 2004

Tip: Looking for answers? Try searching our database.

How to allow the user to choose a range of rows?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve - 21 Sep 2004 20:53 GMT
I have a form that grabs data from a single table.  I want to allow the user
to put in a date and have data for all rows that exceed that date be
returned.  The table (of course) has a matching Date field.

This seems like a simple request...is it?  Am i missing something simple?
Thanks for your help!
Greg Collins [MVP] - 21 Sep 2004 23:29 GMT
If you are using SQL or Access, this answer probably isn't for you -- or it might be...

If you are using XML storage, you probably want to place a Filter on your repeating table that only shows rows within the date range specified. You may also want to include an "OR USER_DATE EQUALS BLANK" which will allow for all table rows to show if a date has not been specified.

Signature

Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com

I have a form that grabs data from a single table.  I want to allow the user
to put in a date and have data for all rows that exceed that date be
returned.  The table (of course) has a matching Date field.

This seems like a simple request...is it?  Am i missing something simple?
Thanks for your help!
Steve - 22 Sep 2004 14:14 GMT
Thanks for your reply.  I am not being clear and am learning as I go here,
and I have actually 2 related questions.

Consider a calendar table with 2000 rows...one row for each day...about 3
years back and 2 years in the future.
The first field is the date (never mind the time, but it can be 00:00:00)

1.  If i 'apply a filter' to 'display' only certain rows ...say, after
today's date...do all the 5000 rows return from the server and INFOPATH just
displays the 'future' rows?  (IF so, then we are not letting the SQL Server
do its work, and are using far more bandwidth than needed.)

2.  Regardless of the answer to the above...I have a form with a "Query"
section and a 'Data' Section where the data is returned into a 'repeating
table'.  I have the 'Date' field in both.  I have applied a filter wherein
the 'data' date field is set to be >= 'query' date field.  However, when
testing the form in Preview...the data is returned only for items where the
date EQUALS the value in the Query section of the form.

Has anyone else seen this behaviour...or what am i doing wrong?

Thanks in advance for your help.

If you are using SQL or Access, this answer probably isn't for you -- or it
might be...

If you are using XML storage, you probably want to place a Filter on your
repeating table that only shows rows within the date range specified. You
may also want to include an "OR USER_DATE EQUALS BLANK" which will allow for
all table rows to show if a date has not been specified.

Signature

Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com

I have a form that grabs data from a single table.  I want to allow the user
to put in a date and have data for all rows that exceed that date be
returned.  The table (of course) has a matching Date field.

This seems like a simple request...is it?  Am i missing something simple?
Thanks for your help!
Steve - 23 Sep 2004 18:17 GMT
I have found the solution in Roger Jennings' fine book: "Introducing
Microsoft INfopath 2003".

See his page 258 for details...but in short... you have to "add a field" in
the Data Source task pane.  Once I added this field "datafilter"...i was
able to compare the repeating table rows to this field and get the results i
was looking for.

Thanks for your earlier input.

If you are using SQL or Access, this answer probably isn't for you -- or it
might be...

If you are using XML storage, you probably want to place a Filter on your
repeating table that only shows rows within the date range specified. You
may also want to include an "OR USER_DATE EQUALS BLANK" which will allow for
all table rows to show if a date has not been specified.

Signature

Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com

I have a form that grabs data from a single table.  I want to allow the user
to put in a date and have data for all rows that exceed that date be
returned.  The table (of course) has a matching Date field.

This seems like a simple request...is it?  Am i missing something simple?
Thanks for your help!
Greg Collins [MVP] - 23 Sep 2004 19:01 GMT
Great! Glad you were able to resolve it!

Signature

Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com

I have found the solution in Roger Jennings' fine book: "Introducing
Microsoft INfopath 2003".

See his page 258 for details...but in short... you have to "add a field" in
the Data Source task pane.  Once I added this field "datafilter"...i was
able to compare the repeating table rows to this field and get the results i
was looking for.

Thanks for your earlier input.

If you are using SQL or Access, this answer probably isn't for you -- or it
might be...

If you are using XML storage, you probably want to place a Filter on your
repeating table that only shows rows within the date range specified. You
may also want to include an "OR USER_DATE EQUALS BLANK" which will allow for
all table rows to show if a date has not been specified.

Signature

Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com

"Steve" <sschneider@grassusa.com> wrote in message
news:ufnkzSBoEHA.3412@TK2MSFTNGP10.phx.gbl...
I have a form that grabs data from a single table.  I want to allow the user
to put in a date and have data for all rows that exceed that date be
returned.  The table (of course) has a matching Date field.

This seems like a simple request...is it?  Am i missing something simple?
Thanks for your help!

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.