April 20, 2006 at 2:17 pm
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
April 21, 2006 at 5:46 am
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
April 21, 2006 at 9:54 am
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