SQL Server Performance

Change ToggleItem Expand/Collapse Icon for one report only

Discussion in 'SQL Server 2005 Reporting Services' started by Ismailc, Nov 17, 2008.

  1. Ismailc New Member

    Hi,
    I would like to know if it is possible to change an Toggleitem Expand/Collapse icon for one report only.
    Regards
  2. satya Moderator


    I think if you want to make the expand/collapse function unavailable when the detail row is blank, try the following expression on the visibility property of the detail row.
    =iif(rownumber(<scoap>)=0,false,true)
    <scope> is the name of a grouping or data region that the detail rows belong to.

    If you have more questions, please let me know.
    Thanks.


    Report Abuse
  3. Ismailc New Member

    Thank You - I kind of worked it in my qry.
    And grouped so that i don't have blanks - i wish I had this early, it would have saved me so much time and stress.
    Regards

Share This Page