Toggle ? in RS2005

  • Hi all,

    I hope someone can help me because I need a little bit, well a lot of help but that is in different areas.

    I am trying to do a drilldown report but only on certain doccodes....

    Example, in Visibilty Property, I have set up so that the Hidden = TRUE and toggled on DOCCODE. It works just like it is suppose to. Now I want to take it a step farther where it only toggles on the DOCCODE = 'PINV' (that is the only DOCCODE to have the extra data).

    Is there a way to do that, there is not a "expression" builder in the toggle dropdown? Is this something I can do with custom code? Does anyone have any other work arounds or know where I can read an article or something?

    Any help would be greatly appreciated!

    Thanks in advance, Kerrie

  • Nevermind All,

    I found the answer!

    "I setup a conditional display of the drill-down icon on a table report

    similar to your situation.  Here's what I did:

    1)     Make sure that drill-down is enabled by setting the Hidden value

    of the Visibility property for the row to True, and also setting a

    toggle field in the ToggleItem property.

    2)     Insert a new column to the left of the drill-down field on the

    report and set the column size to 0.25in (you'll need at least .15in

    to fully display the icon).

    3)     In the textbox where you'll display drill-down icon, set the

    Hidden value of the Visibility property using an in-line IF statement

    to test for your logic.  I tested against a data field being null, but

    you would test for a parameter condition.

    My example:     =IIF(Fields!InvoiceLineItemDetail.Value Is Nothing,

    True, False)

    Your example:   =IIF(Parameters!UserHasPermission.Value = "Yes", True,

    False)

    Does this help you?

    BTW - this tip is mentioned on a Reporting Services Monthly Newsletter

    at http://www.reportarchitex.com"

    Hope this helps someone!

    Thanks, Kerrie

  • Kerrie,

    Thanks for sharing!  I'd yet to come up with a solution for this.

    Mike

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply