locked
Is there a function that can determine whether a toggle switch has been clicked or not? RRS feed

  • Question

  • Hi folks,

    I have a report where the preview looks like this....

    FieldA   count

    +ABC      3

    +DEF       2

    +GHI       4

    Lets say the user clicks ont + sign for DEF....

    After it expands I want 3 more header to appear that will look like this....

    +ABC       3

    -DEF         2        FIELDC          FIELDD              FIELDE

                              John               Det                   Mich

                              Steve             Chi                    Ill

    +GHI    4

    Can this be done?  Is there some function tat will determine if the +/- toggle is equal to + or -?  Or am I making this too difficult?  Can it be done more simply?

    Thanks in advance!

     

     

     

     

    Monday, January 10, 2011 6:40 PM

Answers

All replies

  • Hey Jim,

     

    Try setting the Visibility to 'False' and the Toggle Item to FieldA for all the text boxes (Don't include the Column Headers) that you want to hide. You won't be able to hide the column headers as they will be out of the scope of the Row Group items. In this instance, and it looks as though you already have done this, place the column names in the Group Header, this way when you expand a Row Group you'll see column headers and the data that they contain.

    When you preview the report you should get exactly what you are looking for.

     

    Monday, January 10, 2011 8:07 PM
  • Thanks Luke,

    Tried it,  no luck,  any other suggestions?

     

    Thanks

    Jim

     

    Tuesday, January 11, 2011 9:56 PM
  • Hi,

     

    Could you post an example to explain the meaning of "determine if the +/- toggle is equal to + or -"? General, you can use adjacent group to achieve your purpose. Such as:

    <ParentGroup>

    <AdjacentGroupA>

    <Details>

    <AdjacentGroupB>

     

    ParentGroup, AdjacentGroupA, and AdjacentGroupB are all group by "FieldA", and then set AdjacentGroupA and AdjacentGroupB take ParentGroup as toggle item, but set the visibility of one of both to show and another to hide.

     

    You can download this report file as an example, and then modify the data source to SQL Server 2005/2008/R2 instance to preview the report:

    http://cid-854fa6d2b7d88cc7.office.live.com/self.aspx/Work/Isthereafunctionthat.rdl

     

    Here is a similar thread you can refer to:

    http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/ce386353-4bcf-4ed7-bfab-84f8615da86c

     

    Thanks,

    Albert Ye

    • Marked as answer by Challen Fu Tuesday, January 18, 2011 11:44 AM
    Thursday, January 13, 2011 6:35 AM