visual studio 2013 - the hidden expression for table contains an error: Object variable or with block variable not set -
i trying hide ssrs column based on reportserverurl. if on site hidden if on site b shown. expression using in column visibility property. =iif(globals!reportserverurl.indexof("devrxanalytics") >= 0, false, true)
the problem works once deployed either sharepoint site, when try view in visual studio under preview, following error:
the hidden expression table contains error: object variable or block variable not set
not big deal since works on site how resolve may view report in preview mode?
try this:
=iif(isnothing(globals!reportserverurl) or globals!reportserverurl.indexof("devrxanalytics") >= 0, false, true)
this expression performs following logic, if reportserverurl
global variable null (report generated visual studio) or reportserverurl
contains devrxanalytics
, don't hide column.
let me know if helps you.
Comments
Post a Comment