Hi All, I am using SSRS 2008. I have one dataset that gives me the list of dates (without time stamp as i have removed the time stamp using cast in query). I have declared one parameter "ShipDate" and set the available values to dataset output (which doesn't have time stamp in it) . When I am previewing the report, the parameter dropdown is populated with date and time stamp. how to remove time stamp from the dropdown wherein the source dataset itself do not have time stamp with date. I changed the parameter type to text and tried but no luck. checked with datetime as well. Any help in this regard would be highly appreciated. Thanks, Nipendra Garg

Hello Nipendra, You can Right click on "ShipDate Field itself in design view>Select Properties>Select Number>Select Date>Change to the appropriate format... Kind Regards, WCC44

Hello WCC, Thanks for the reply.... My question was to remove time stamp from parameter dropdown which generates automatically when you preview the report. I can remove the time stamp on all other places except parameter dropdown as I am not getting any option to write expression or do something for parameter values. Any idea guy's. Thanks, Nipendra Garg

Hello Nipendra, In your parameter properties unselect Allow multiple values...Then in the left pane select Default Values>Specify Value>add for example 1/1/2010... Kind Regards, WCC44

Hi Wcc, But the parameter is multi value parameter (per requirement) and by default it should select all the values from dataset. In dataset the values are without the time stamp in it, but when it is showing the list of values in parameter dropdown, it is adding time stamp automatically and m not getting any option to change it or write an expression to remove time stamp. any idea ..? Thanks, Nipendra Garg

Hello Nipendra, Sorry I misunderstood you...Within the properties of your parameter, Change Data type to Interger>Select Available Values in left pane>Select Specify values radial button>Add>Examples: Label = 01/01/2010 Value = 1 Label = 01/13/2010 Value = 2 Label = 01/27/2010 Value = 3 etc... Then in your DataSet properties add your parameter name and parameter value... Parameter Name = ShipDate Parameter Value = [@ShipDate] Then select Filter in left pane Expression = =Fields!ShipDate.Value Operator = Value = [@Month] Kind Regards, WCC44

Hi Wcc, Thanks for your reply... But again, it seems you did not get my question correctly. Here are the details : I need to populate @ShipDate parameter dropdown with all available ship date values. If I manually specify the available values as you said above then all the values would be static only. lets say I specify 3 different ship date in available values then the dropdown would show 3 values. tomorrow if any new ship date comes, it should automatically appear in shipdate drop down, but it wont come because i specified available values manually. Because of that I have created one dataset with query "select distinct cast(shidate as date) from table" and it gives me all the shipdate available in my table. then I set this query result to available values in @ShipDate parameter dropdown so that dropdown will be populated with all available ship dates. my dataset result doesn't have time stamp in it. when i m setting dataset output as available value to @Shipdate, it is automatically adding time stamp in it. Hope now you get the exact idea. Thanks Nipendra Garg

Hello Nipendra, Have you also specified within your DataSet Where ShipDate IN (@ShipDate) Kind Regards, WCC44

Hello WCC There are two dataset , first to populate @shipdate parameter, that is select distinct cast(shidate as date) from table, which will give me all available ship dates. second is to display the details select * from table where ShipDate IN (@ShipDate). Thanks, Nipendra Garg

Finally I got the solution, it was a problem with the query, instead of using "cast" when I use convert function in the query, it did the tricks ! Thanks, Nipendra Garg