Dynamic parameter for begin and end date


hi, have stored procedure returns 3 items, id, begindate , enddate.  on report have 3 parameter 1 id, , 2 dates.  want select id , in data begin , end date id date parameters.

it working when form loads becouse of default value of id parameter but when select different id not change value of data parameters.

any idea why?

thank again.

 select id, begindate,  enddate
 where id = (@id)
 and begindate = (@begindate)
 and enddate = (@enddate)
 
 if have multi selection use in
 
  select id, begindate,  enddate
 where id in (@id)
 and begindate in (@begindate)
 and enddate in (@enddate)
you can reference this 


SQL Server  >  SQL Server Reporting Services, Power View



Comments

Popular posts from this blog

SQL Server PSProvider SQL Server Authentication

BIT Version

How to calculate the delta size while diffing the files in TeamFoundationServer ?