Matrix 'Total' formatting

Hey All,
Maybe I have been looking in the wrong places for the last 2 hours but
can someone tell me how to add a borderstyle property to the 'subtotal'
row on a matrix. I can get it to work for the 'total' textbox itself
but not the entire row. I have even looked in the XML (which I never
miss with) and still cannot find anything. Please! Please! Someone help
me! This is for a client. Even if it cannot be done, let me know!!!!
Thanks in advance a billion times over,
KerrieJust click once on the row field then go to view and click properties
window. You can change the borderstyle there to solid. You can do that on
any column or row or just one field.
"Kerrie" <ksorrell@.cincom.com> wrote in message
news:1156788001.882559.169420@.75g2000cwc.googlegroups.com...
> Hey All,
> Maybe I have been looking in the wrong places for the last 2 hours but
> can someone tell me how to add a borderstyle property to the 'subtotal'
> row on a matrix. I can get it to work for the 'total' textbox itself
> but not the entire row. I have even looked in the XML (which I never
> miss with) and still cannot find anything. Please! Please! Someone help
> me! This is for a client. Even if it cannot be done, let me know!!!!
> Thanks in advance a billion times over,
> Kerrie
>|||Ben,
I have tried that and for some reason it will only do it for the Total
testbox, not the whole row. It is driving me nuts. I am not sure where
to go from here.
Thanks for your help though, it is greatly appreciated!
Thanks, Kerrie
Ben Watts wrote:
> Just click once on the row field then go to view and click properties
> window. You can change the borderstyle there to solid. You can do that on
> any column or row or just one field.
> "Kerrie" <ksorrell@.cincom.com> wrote in message
> news:1156788001.882559.169420@.75g2000cwc.googlegroups.com...
> > Hey All,
> >
> > Maybe I have been looking in the wrong places for the last 2 hours but
> > can someone tell me how to add a borderstyle property to the 'subtotal'
> > row on a matrix. I can get it to work for the 'total' textbox itself
> > but not the entire row. I have even looked in the XML (which I never
> > miss with) and still cannot find anything. Please! Please! Someone help
> > me! This is for a client. Even if it cannot be done, let me know!!!!
> >
> > Thanks in advance a billion times over,
> > Kerrie
> >|||You need to right-click on the little green triangle at the top right-hand
corner of the total textbox to get to the properties of the actual total.
HTH,
magendo_man
"Kerrie" wrote:
> Hey All,
> Maybe I have been looking in the wrong places for the last 2 hours but
> can someone tell me how to add a borderstyle property to the 'subtotal'
> row on a matrix. I can get it to work for the 'total' textbox itself
> but not the entire row. I have even looked in the XML (which I never
> miss with) and still cannot find anything. Please! Please! Someone help
> me! This is for a client. Even if it cannot be done, let me know!!!!
> Thanks in advance a billion times over,
> Kerrie
>|||YOU ARE THE GREATEST!!!!!!
THANK YOU! THANK YOU!
It worked!!!!!!
Thanks, Kerrie
magendo_man wrote:
> You need to right-click on the little green triangle at the top right-hand
> corner of the total textbox to get to the properties of the actual total.
> HTH,
> magendo_man
> "Kerrie" wrote:
> > Hey All,
> >
> > Maybe I have been looking in the wrong places for the last 2 hours but
> > can someone tell me how to add a borderstyle property to the 'subtotal'
> > row on a matrix. I can get it to work for the 'total' textbox itself
> > but not the entire row. I have even looked in the XML (which I never
> > miss with) and still cannot find anything. Please! Please! Someone help
> > me! This is for a client. Even if it cannot be done, let me know!!!!
> >
> > Thanks in advance a billion times over,
> > Kerrie
> >
> >

Matrix Conditional Formatting

I have a matrix and want to put a border on only one column. I have
this expression in the right and left borderstyle property:
=iif(First(Fields!desc.Value)="Sent Census","Solid","None")
So if the value column = "Sent Census" then I want the column to have a
left and right border. My problem is that if the data cell has a 0 in it, the
border doesn't appear. I know why, I'm just looking for a work around to
have the whole column bordered even if a 0 is placed in the data cell.
Thanks!Seems like as soon as I post a question, I figure out the answer:
=iif(ReportItems("desc").Value="Sent Census","Solid","None")
You reference the textbox, not the data. doh.
"Sharon" wrote:
> I have a matrix and want to put a border on only one column. I have
> this expression in the right and left borderstyle property:
> =iif(First(Fields!desc.Value)="Sent Census","Solid","None")
> So if the value column = "Sent Census" then I want the column to have a
> left and right border. My problem is that if the data cell has a 0 in it, the
> border doesn't appear. I know why, I'm just looking for a work around to
> have the whole column bordered even if a 0 is placed in the data cell.
> Thanks!
>