sql - visibility of Data in SSRS -


this follow on question:

insert data in ssrs table in query

i added in table manually data , created report in ssrs:

enter image description here

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