this follow on question:
insert data in ssrs table in query
i added in table manually data , created report in ssrs:
part of query:
union select * (values (cast('2016-07-25 00:00:00.000' date),71.9,'team a','nacht',73.0, 'm101', '',0.0), (cast('2016-07-25 00:00:00.000' date),71.9,'team b','früh',71.0, 'm105', '',84.5) ) extradata([datum],[oeetag],[team],[schicht],[oeeteam],[name],[product],[systemoee])
the problem manual data displays in every table. how can set visibility? diplays manual data on 25.07.2016. used in query parameters: @startdatetime , @enddatetime
in visibility settings tried expression:
=iif(parameters!startdatetime.value="2016-07-25 00:00:00.000", false, iif(parameters!enddatetime.value="2016-07-25 00:00:00.000", false, true))
but not working.
select * from( select * (values (cast('2016-07-25 00:00:00.000' date),71.9,'team a','nacht',73.0, 'm101', '',0.0), (cast('2016-07-25 00:00:00.000' date),71.9,'team b','früh',71.0, 'm105', '',84.5) ) extradata([datum],[oeetag],[team],[schicht],[oeeteam],[name],[product],[systemoee]) ) source datum = @startdate
this not complete solution let filter on datum column based on parameter.
Comments
Post a Comment