How to hide the plus/minus toggle icon? -- sql server reporting services

sql server reporting services : How to hide the plus/minus toggle icon?

C17
12/18/2005 9:02:57 PM

Hi,

I have matrix details shown or hidden by toggling visibility based upon a
field. Works great, except that I want to hide the plus/minus icon from the
user. (Whether or not the detail is visible is based upon a report
parameter, in case you were wondering. Some users are privileged and can
see detail, others can't.)

Anyone know how to do this???

Thanks,

C17

MattA
12/19/2005 11:47:32 AM

C17,

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 www.reportarchitex.com

Matt A

C17
12/21/2005 3:33:06 PM

Very clever! I think it will work. Thanks Matt!

--c17

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn