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

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........