Querystring paramters can be added to a XmlListViewWebpart and the data can be filtered based on them, however when using date parameters, the format of date in querystring is often confusing. The correct date format is yyyy-MM-dd. More details in the following two blogs
https://stackoverflow.com/questions/1655664/sharepoint-list-view-datetime-in-the-query-string/29235326#29235326
https://social.technet.microsoft.com/Forums/en-US/92271aa4-6582-4ea5-a10f-deaf02d2b62c/filtering-the-list-view-by-passing-date-parameters-using-sharepoint-desginer-2010?forum=sharepointcustomizationprevious
There is also a custom webpart available on codeproject which creates a custom menu button to export only filtered list view webpart data to excel
http://www.codeproject.com/Articles/400720/SharePoint-2010-Export-Selected-Items-to-Excel
https://stackoverflow.com/questions/1655664/sharepoint-list-view-datetime-in-the-query-string/29235326#29235326
https://social.technet.microsoft.com/Forums/en-US/92271aa4-6582-4ea5-a10f-deaf02d2b62c/filtering-the-list-view-by-passing-date-parameters-using-sharepoint-desginer-2010?forum=sharepointcustomizationprevious
There is also a custom webpart available on codeproject which creates a custom menu button to export only filtered list view webpart data to excel
http://www.codeproject.com/Articles/400720/SharePoint-2010-Export-Selected-Items-to-Excel
No comments:
Post a Comment