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
Post a Comment