So this isn't exactly what we talked about, but it's a simple design.  I'm wondering if this would work.  The concept is to have all of the sub-reports visible based...

If I can get some time later or tomorrow, I'll create an .rdl file for you to show you what I'm talking about.

It doesn't need to be in a data region 😉

Maybe I'm not understanding (wouldn't be the first time) 😉  Let's say we have a report with 3 sub-reports.  The 3 sub-reports are always technically there, they just aren't always...

Could you put a formula in the title to show a value based on sub-report visibility?  Something like, "if sub-report 1 visible then title 1,...if sub-report N visible then title...

Hi.  I'm having a hard time understanding what you are asking.  Perhaps others are too.

Hi Karen,

How are you displaying and hiding sub reports?  Are you toggling the visibility properties?  In other words, when a user clicks on a link for a sub-report,...

Hi Mike,

I personally would increase integrity checks for all databases to daily if possible and add restore validation.  By restore validation I mean automating the recovery of every...

Like Phil said, the script is fine on SQL Server 2016. I wonder if you are stepping though the "blocks" of the script and getting the error because your variables...

good job.  glad you got it figured out!

You should look into that.  It's just an option on the parameter.  Really easy to set and it may solve your problem.  If you are calling a stored procedure and...

What if you didn't hide the sub-report?  Instead, what if you passed in the PIN to the sub-report as a parameter.  Then, within the sub-report you set the visibility on...