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

Popular posts from this blog

javascript - jQuery: Add class depending on URL in the best way -

caching - How to check if a url path exists in the service worker cache -

Redirect to a HTTPS version using .htaccess -