I made one report in SSRS 2008 in which getting data from one SharePoint List.

three parameters in report :

Country

StartDate

EndDate

I am using query which I created with CAML.

query is running well and data is coming correctly if I run this on Query designer.

and date format must be YYYY-MM-DD.

but when I try to run through on run time then the date control is showing format dd/mm/yyyy.

I change the regional settings of windows and SharePoint site to English(United States). and when I select date control it is also putting date in format like "YYYY-MM-DD'. and in that format report is working well in Query designer view.

But on run time still it is not working.

from two days I am stuck.

Use this expression

=Format(Parameters!YourDate.Value,"yyyy-MM-dd")
		

Thanks a lot my friend.

I tried before but it was not working before because I was using below format:

=Format(Parameters!YourDate.Value,"YYYY-MM-DD")

• Edited by John.Eddie Thursday, August 27, 2015 10:01 AM

One parameter is country names in drop down list. which are hard coded.

Now I put "All' in the country drop down.

Please let me know if users want to see the data for all countries and select all . sow how it will show all countries data.