Conditonally suppress detail rows based on toggleitem and record value

• Dom Horton

  SSCrazy

  Points: 2202

  More actions

  September 7, 2009 at 4:22 am

  #385317

  Hello,

  I have a details section of a table that has each rows visibility controlled by a toggleitem.

  The initial state is suppressed to provide an 'overview' style report with the option of 'drilling' down into the details if necessary.

  The problem is that some detail rows return no data (the nature of the underlying data) and I'm wanting to suppress the resulting white space.

  Not sure how to go about it....

  so to recap, if toggleitem is set for collapse then no detail records shown.

  if toggleitem is set for expand and detail row has data then show else suppress

  basically, can the value of the toggleitem collapse/expand property be used programmatically in this manner or is there a better way to go about this?

  (SQL Server 2005)

  thanks,

  dom