Hi, I have a tablix with subtotals at each level in the header and footer of each group. I know how to toggle the header textback to Hidden when expanding that group, but it then leaves a jagged appearance to he whole report. If I leave it the way it is,
I have subtotals in both the header and the footer.
What I'd like to do is to blank out the subtotal text in the header when expanded so only the footer is showing the subtotal, thereby retaining the header's textbox's color, borders, etc. and generally eliminating the jagged-looking right edge of the tablix.
I've tried accessing the Hidden property of the matching footer subtotal without success. I've even tried counting rows in the text-color expression of the header, but to no avail.
Does anybody have any ideas on how to toggle the subtotal text in the header without creating a gaping empty space in that cell? I'd like to write something like, =iif(ReportItems!sumFtrCustomerHours.Hidden,Sum(Fields!Hours.Value), "") but ReportItems only
have one one property - Value.
My first question might be, "Is it possible to make hidden a textbox in a row without leaving a gaping hole (and exposing the report background?
Both the row and the textbox have the same background color, and I'd assumed that making the textbox hidded would expose the background color of the row, but not so.
Okay, let' try it a different way. I have a toggle-able group in a tablix with a header, detail and footer. The last column of each group presents the same subtotal in both the header and footer, and the report starts out with the group collapsed, and the
total for that group of course displays in the header.
The idea is that I want the subtotal to show in the header when collapsed, but when expanded, I want the subtotal to show in only the footer (not the header), thereby reducing visual confusion, redundancy and clutter. The Report background is green and the
header & footer (and all textboxes) are gold.
Not that anybody's following this, but I came up with a workaround. The problem in short is that when I toggle a header subtotal textbox to hidden and a footer subtotal textbox to not hidden, the header "textbox" pokes a hole in my nice rectangular grid
to expose the background - looks like hell, unless everything is the same color as the background.
My solution was to wrap each textbox very carefully in a rectangle of the same color and just leave the rectangle alone; it behaves as expected now. It's too bad that the row color behind a textbox disappears when the textbox is toggled to hidden, but oh
well. Now my subtotals appropriately toggle from header to footer when the group is toggled, without leaving my grid looking like a poorly-carved jack-o-lantern.
I still don't know how to grab the properties of another element, i.e., whether it's hidden or not, but if possible, I'll figure it out.
Not sure if this helps and if this is too late, when you using values of another report element to set visibility of that element, I consider when the data loads first, so I used a Parameter, and set this Parameter in the codes where you bind the datasource,
that is approach I probably would take.
Remember to click “Mark as Answer” on the post, if it helps you
iusr machine...
0 Points
5 Posts
Toggle value based on visibility of another textbox
Jan 24, 2010 03:02 PM|LINK
Hi, I have a tablix with subtotals at each level in the header and footer of each group. I know how to toggle the header textback to Hidden when expanding that group, but it then leaves a jagged appearance to he whole report. If I leave it the way it is, I have subtotals in both the header and the footer.
What I'd like to do is to blank out the subtotal text in the header when expanded so only the footer is showing the subtotal, thereby retaining the header's textbox's color, borders, etc. and generally eliminating the jagged-looking right edge of the tablix.
I've tried accessing the Hidden property of the matching footer subtotal without success. I've even tried counting rows in the text-color expression of the header, but to no avail.
Does anybody have any ideas on how to toggle the subtotal text in the header without creating a gaping empty space in that cell? I'd like to write something like, =iif(ReportItems!sumFtrCustomerHours.Hidden,Sum(Fields!Hours.Value), "") but ReportItems only have one one property - Value.
TIA,
-George
iusr machine...
0 Points
5 Posts
Re: Toggle value based on visibility of another textbox
Feb 02, 2010 03:17 PM|LINK
Ok, maybe I wasn't clear or provided too much.
My first question might be, "Is it possible to make hidden a textbox in a row without leaving a gaping hole (and exposing the report background?
Both the row and the textbox have the same background color, and I'd assumed that making the textbox hidded would expose the background color of the row, but not so.
TIA,
-George
iusr machine...
0 Points
5 Posts
Re: Toggle value based on visibility of another textbox
Feb 12, 2010 06:45 PM|LINK
Okay, let' try it a different way. I have a toggle-able group in a tablix with a header, detail and footer. The last column of each group presents the same subtotal in both the header and footer, and the report starts out with the group collapsed, and the total for that group of course displays in the header.
The idea is that I want the subtotal to show in the header when collapsed, but when expanded, I want the subtotal to show in only the footer (not the header), thereby reducing visual confusion, redundancy and clutter. The Report background is green and the header & footer (and all textboxes) are gold.
How can I accomplish this?
-George
iusr machine...
0 Points
5 Posts
Re: Toggle value based on visibility of another textbox
Feb 22, 2010 12:23 PM|LINK
Not that anybody's following this, but I came up with a workaround. The problem in short is that when I toggle a header subtotal textbox to hidden and a footer subtotal textbox to not hidden, the header "textbox" pokes a hole in my nice rectangular grid to expose the background - looks like hell, unless everything is the same color as the background.
My solution was to wrap each textbox very carefully in a rectangle of the same color and just leave the rectangle alone; it behaves as expected now. It's too bad that the row color behind a textbox disappears when the textbox is toggled to hidden, but oh well. Now my subtotals appropriately toggle from header to footer when the group is toggled, without leaving my grid looking like a poorly-carved jack-o-lantern.
I still don't know how to grab the properties of another element, i.e., whether it's hidden or not, but if possible, I'll figure it out.
-George
den2005
Participant
875 Points
477 Posts
Re: Toggle value based on visibility of another textbox
Feb 23, 2010 08:45 AM|LINK
Hi george,
Not sure if this helps and if this is too late, when you using values of another report element to set visibility of that element, I consider when the data loads first, so I used a Parameter, and set this Parameter in the codes where you bind the datasource, that is approach I probably would take.