Sharepoint Designer 2007 Custom Page can't filter by date drop down
Here's my problem:
I have some custom lists, each with a 'date only' field in SharePoint 2007. I need to build a custom page to pull the data together in a table of sorts. The catch is that I need to be able to filter by date.
Thing is, I can't seem to use the ASP dropdownlist control... as the fields don't seem to match up. they may appear to be identical, but apparently they are not.
How does one handle these date issues???
I have some custom lists, each with a 'date only' field in SharePoint 2007. I need to build a custom page to pull the data together in a table of sorts. The catch is that I need to be able to filter by date.
Thing is, I can't seem to use the ASP dropdownlist control... as the fields don't seem to match up. they may appear to be identical, but apparently they are not.
How does one handle these date issues???
ASKER
My problem is that I'm basically trying to build a grid of data... due to reasons I won't get into, I've got 4 lists of data. The common things to all 4 list are Department and Date. Unfortunately, you will not have an entry for each dept on a a given day... so I need to use some sort of date picker to pick the filter date.
My problem arises from the fact that despite the fact that it's a date only field, if you try to filter by, say, a dropdownlist bound to the dates column of one of the lists, it won't return any data IN THE SAME LIST YOU PULLED THE DATES from. It's like something happens to the date once it is reference from somewhere outside the actual data view. It works just fine for Department, but not date.
I've tried using a calculated column to format the date as a text string, and have had no luck from that at all. I've also tried to use a custom workflow to do a formatted text field containing the date I need, in both lists, and still no luck.
Date comparisons seem to be broken!
For what it's worth, I've been able to do this using InfoPath, but unfortunately we don't have forms server, and I cannot rely on the end using having InfoPath on their machine.
My problem arises from the fact that despite the fact that it's a date only field, if you try to filter by, say, a dropdownlist bound to the dates column of one of the lists, it won't return any data IN THE SAME LIST YOU PULLED THE DATES from. It's like something happens to the date once it is reference from somewhere outside the actual data view. It works just fine for Department, but not date.
I've tried using a calculated column to format the date as a text string, and have had no luck from that at all. I've also tried to use a custom workflow to do a formatted text field containing the date I need, in both lists, and still no luck.
Date comparisons seem to be broken!
For what it's worth, I've been able to do this using InfoPath, but unfortunately we don't have forms server, and I cannot rely on the end using having InfoPath on their machine.
i still recommend that you look at DVWP. it is meant to merge or link multiple lists together and display them in a list / grid view.
ASKER
Ok, I've looked at DVWP... and I simply cannot accomplish my rendering goals with this.
So... to revisit: I need to know how to use a date picker OR a dropdownlist control to present the user with an ability to select a date, and to correctly reference that date to filter data. I can get a dropdownlist to work with text or numeric fields, but not dates. Anybody know how to do this?
So... to revisit: I need to know how to use a date picker OR a dropdownlist control to present the user with an ability to select a date, and to correctly reference that date to filter data. I can get a dropdownlist to work with text or numeric fields, but not dates. Anybody know how to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Complexity of data rendering needs prevented the data view web part with filtering enabled from providing the best solution to this problem.
http://www.lcbridge.nl/vision/2009/dvwp.htm
your sources are sharepoint lists...
and you'll want to look at the section called "Working with Related/Linked Data Sources" if you have more than one list to bring into the DVWP.
there's a subsection to the section called "Creating a Data View" that talks about Filtering options.