I have an RDL report (built with Report Builder 3.0 SQL Server 2012) that has tables which are visible based on expression. When I chose Run, they are appropriately hidden or visible. However, when I chose print or take to pdf, all tablix are printed, even if they are invisible in the run version. This happens when I use =IIF(CountRows()<1 AND Globals!RenderFormat.IsInteractive, TRUE, FALSE).
Using =IIF(CountRows()<1 AND Globals!RenderFormat.IsInteractive, FALSE, TRUE) does keep it from being printed or showing up in a pdf; however, on the computer screen, the tablix is visible.
Is there a way to have the preview be the same as the pring