title: In SSRS is there a way to make a Row Group expand based on parameter value?
body: <p>I've got a table with 5 columns, the first 3 of which allow the user to drill down through the levels of detail. Each of these columns (Region, Country &amp; Office) has an associated Parameter so the user can select the geographic region for their report. Each parameter allows the selection of multiple values.</p>
  
  <p>If the user selects 1 Region, 1 Country and 1 Office it's not exactly ideal for them to then have to expand each selection. Is there an expression I can enter somewhere to state that if only 1 value is entered in a parameter then that data set will automatically show as expanded?
  This is in SSRS 2008 R2 if that makes any difference. </p>