How to hide the plus/minus toggle icon?

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
>

How to hide specific rows in TABLE?

My report result has 100 lines of records (details) and I only want to
display the first 10 rows and hide the rest of them. How can I achieve
that?
Thanks,
KeithYou can set the visibilty property of the row based on the count of some
distinict item in the details being less than ten.
for example the expression for the visibiltiy property might read:
iif( Count( Fields!UniqueDetailItem.Value, "GroupNameIfNeeded" ) > 10,
True, False )
Hope this helps.
"Keith" wrote:
> My report result has 100 lines of records (details) and I only want to
> display the first 10 rows and hide the rest of them. How can I achieve
> that?
> Thanks,
> Keith
>|||Thanks Rand!
I tried with this expression something like:
=iif( Count( Fields!zzcusteu.Value) > 10, True, False )
But it still doesn't work. It just counted the total # of rows, if >10,
then hide all the rows (I want to the first 10 rows to be visible).
Any idea?
Thanks,
Keith|||Hi:
You can use this expression:
=iif( RowNumber( Nothing) > 10, True, False )
Since Count() return the total number of records, but RowNumber() return
the current row number
Kent
"Keith" wrote:
> Thanks Rand!
> I tried with this expression something like:
> =iif( Count( Fields!zzcusteu.Value) > 10, True, False )
> But it still doesn't work. It just counted the total # of rows, if >10,
> then hide all the rows (I want to the first 10 rows to be visible).
> Any idea?
> Thanks,
> Keith
>