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,
C17C17,
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|||Very clever! I think it will work. Thanks Matt!
--c17
"MattA" <mattarabas@.gmail.com> wrote in message
news:1135021652.747713.223160@.g14g2000cwa.googlegroups.com...
> 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
>
Sunday, February 19, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment