Hi, I'm implementing a Custom SharePoint List on SSRS. My goal is to set a StartDate and EndDate Parameter to only show fields that fall between the set Parameters. The DataSources and DataSets are already configured. I tried adding Parameters already, but when I run the Report and enter the Parameter Value, it spits out all the values instead of adhering to the Parameters that I set. I've referred to the following links already: http://msdn.microsoft.com/en-us/library/ee633650.aspx http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/db129405-f9c5-4651-beaf-d26258fd5531/ http://sharepointmagazine.net/articles/writing-caml-queries-for-retrieving-list-items-from-a-sharepoint-list http://knol.google.com/k/andy-pellew/ssrs-adding-parameters-in-query-designer/v4b5tu39zysj/29 I've looked everywhere online for help (found nothing) and am now at my wit's end. To me, this simple problem should be solved within 30 minutes, but I've now taken days to figure out and still havent solved my problem.

Hi McDerface, From your information, I get your meaning, you want to pass StartDate and EndDate Parameter to only show fields' records that fall between the setted Parameters, to this requirement, I think there are two ways to pass the parameter: 1. Pass the Parameter to XML query for accessing the web service through the SharePoint SSRS data interface, please make sure the parameter's value is correct format, you can refer to this Step by Step: Consuming SharePoint 2010 Lists Data in the SSRS 2008 R2 Reports 2. You could also achieve this in report level, just add two filters to dataset or data region, please note: the type of parameter and datafield in sharepoint list dataset is same, otherwise, it will exist a type conflict, you will receive blank page when execute the report. For more information about How to: Add a Filter (Reporting Services), please see: http://msdn.microsoft.com/en-us/library/ms156270.aspx Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.