reporting services - How to map a single SSRS parameter to multiple parameters of a stored procedure -

i have stored procedure in mysql contain 2 date parameters(@fromdate,@todate). see here requirement is, in ssrs display 1 date parameter in preview tab. when click date display date only. how can achieve scenario? can explain briefly?

regards, samba

if pass single date presume "between" parameter, 0 rows.

instead, try this:

1. add date parameter ssrs report. we'll call "c"
2. set "fromdate" parameter "hidden", , set default value =parameters!c.value
3. set "todate" paramter "hidden", , set default value =dateadd("d",1, parameters!c.value) (adjust time added needed)

this should allow user see "c" parameter, while populating target parameters in useful way.