| Groups | Blog | Home |
sql server reporting services : Change Subtotal background color.
I created a Matrix report with subtotals.
It would be easier to read if the subtotals were shaded. How do I shade the subtotal box. Not the lable box. I can see the box labled totals and it is shaded it is the real total box that I need to shade. Thank you
Scott,
Using the inscope() function with the names of the matrix rows you are able to tell when the row is a subtotal or not, then place the iif function in the background color and sometimes the font color. If you need more help I can find my code example. Last contract have to dig it up. Reeves [quoted text, click to view] "Scott Burke" wrote:
> I created a Matrix report with subtotals. > > It would be easier to read if the subtotals were shaded. > > How do I shade the subtotal box. Not the lable box. > > I can see the box labled totals and it is shaded it is the real total box > that I need to shade. > > Thank you
Thanks for your time. However, Visual Sudioes has an error and shut down.
now the report I was working on is gone.......... I will try your suggestion when I rebuild the report Thanks again. Scott Burke [quoted text, click to view] "Reeves Smith" wrote:
> Scott, > > Using the inscope() function with the names of the matrix rows you are able > to tell when the row is a subtotal or not, then place the iif function in the > background color and sometimes the font color. > > If you need more help I can find my code example. Last contract have to dig > it up. > > Reeves > > > "Scott Burke" wrote: > > > I created a Matrix report with subtotals. > > > > It would be easier to read if the subtotals were shaded. > > > > How do I shade the subtotal box. Not the lable box. > > > > I can see the box labled totals and it is shaded it is the real total box > > that I need to shade. > > > > Thank you
On May 31, 8:38 am, Scott Burke <ScottBu...@discussions.microsoft.com>
[quoted text, click to view] wrote: > Thanks for your time. However, Visual Sudioes has an error and shut down. > now the report I was working on is gone.......... > > I will try your suggestion when I rebuild the report > Thanks again. > Scott Burke > > "Reeves Smith" wrote: > > Scott, > > > Using the inscope() function with the names of the matrix rows you are able > > to tell when the row is a subtotal or not, then place the iif function in the > > background color and sometimes the font color. > > > If you need more help I can find my code example. Last contract have to dig > > it up. > > > Reeves > > > "Scott Burke" wrote: > > > > I created a Matrix report with subtotals. > > > > It would be easier to read if the subtotals were shaded. > > > > How do I shade the subtotal box. Not the lable box. > > > > I can see the box labled totals and it is shaded it is the real total box > > > that I need to shade. > > > > Thank you > > > Scott Burke Also, you could try an expression similar to this in the background color property: =iif(Fields!FieldName.Value Like "subtotal*", "Yellow", "White") Where FieldName can be from an adjacent cell. Hope this helps. Regards, Enrique Martinez Sr. Software Consultant
Hi EMartinez,
I tried that but it did not work. I tried the expression : =iif(Fields!textbox6.Value = 'Total','lightgrey','transparent') The box next to it is named "textbox6" with a value of "Fields!magazinename.value" The errror is "out of scope". I am trying to referance the box name or the contents in the box? Scott Burke [quoted text, click to view] "EMartinez" wrote:
> On May 31, 8:38 am, Scott Burke <ScottBu...@discussions.microsoft.com> > wrote: > > Thanks for your time. However, Visual Sudioes has an error and shut down. > > now the report I was working on is gone.......... > > > > I will try your suggestion when I rebuild the report > > Thanks again. > > Scott Burke > > > > "Reeves Smith" wrote: > > > Scott, > > > > > Using the inscope() function with the names of the matrix rows you are able > > > to tell when the row is a subtotal or not, then place the iif function in the > > > background color and sometimes the font color. > > > > > If you need more help I can find my code example. Last contract have to dig > > > it up. > > > > > Reeves > > > > > "Scott Burke" wrote: > > > > > > I created a Matrix report with subtotals. > > > > > > It would be easier to read if the subtotals were shaded. > > > > > > How do I shade the subtotal box. Not the lable box. > > > > > > I can see the box labled totals and it is shaded it is the real total box > > > > that I need to shade. > > > > > > Thank you > > > > Scott Burke > > > Also, you could try an expression similar to this in the background > color property: > =iif(Fields!FieldName.Value Like "subtotal*", "Yellow", "White") > Where FieldName can be from an adjacent cell. > Hope this helps. > > Regards, > > Enrique Martinez > Sr. Software Consultant >
OK. I found the answear. Please try NOT to laught too loud. It will hurt
my feelings. On the totals box there is an arrow in the upper right corner. If you click on the arrow you will get the properties of the total box itself. Click anywhere else in the box adn you get the properties of the subtotal label box. Have fun over the weekend. Scott Burke [quoted text, click to view] "EMartinez" wrote:
> On May 31, 8:38 am, Scott Burke <ScottBu...@discussions.microsoft.com> > wrote: > > Thanks for your time. However, Visual Sudioes has an error and shut down. > > now the report I was working on is gone.......... > > > > I will try your suggestion when I rebuild the report > > Thanks again. > > Scott Burke > > > > "Reeves Smith" wrote: > > > Scott, > > > > > Using the inscope() function with the names of the matrix rows you are able > > > to tell when the row is a subtotal or not, then place the iif function in the > > > background color and sometimes the font color. > > > > > If you need more help I can find my code example. Last contract have to dig > > > it up. > > > > > Reeves > > > > > "Scott Burke" wrote: > > > > > > I created a Matrix report with subtotals. > > > > > > It would be easier to read if the subtotals were shaded. > > > > > > How do I shade the subtotal box. Not the lable box. > > > > > > I can see the box labled totals and it is shaded it is the real total box > > > > that I need to shade. > > > > > > Thank you > > > > Scott Burke > > > Also, you could try an expression similar to this in the background > color property: > =iif(Fields!FieldName.Value Like "subtotal*", "Yellow", "White") > Where FieldName can be from an adjacent cell. > Hope this helps. > > Regards, > > Enrique Martinez > Sr. Software Consultant >
Scott,
I'm not laughing as I did not even know that existed, thanks for the find. Reeves [quoted text, click to view] "Scott Burke" wrote:
> OK. I found the answear. Please try NOT to laught too loud. It will hurt > my feelings. > > On the totals box there is an arrow in the upper right corner. If you click > on the arrow you will get the properties of the total box itself. Click > anywhere else in the box adn you get the properties of the subtotal label box. > > Have fun over the weekend. > > Scott Burke > > "EMartinez" wrote: > > > On May 31, 8:38 am, Scott Burke <ScottBu...@discussions.microsoft.com> > > wrote: > > > Thanks for your time. However, Visual Sudioes has an error and shut down. > > > now the report I was working on is gone.......... > > > > > > I will try your suggestion when I rebuild the report > > > Thanks again. > > > Scott Burke > > > > > > "Reeves Smith" wrote: > > > > Scott, > > > > > > > Using the inscope() function with the names of the matrix rows you are able > > > > to tell when the row is a subtotal or not, then place the iif function in the > > > > background color and sometimes the font color. > > > > > > > If you need more help I can find my code example. Last contract have to dig > > > > it up. > > > > > > > Reeves > > > > > > > "Scott Burke" wrote: > > > > > > > > I created a Matrix report with subtotals. > > > > > > > > It would be easier to read if the subtotals were shaded. > > > > > > > > How do I shade the subtotal box. Not the lable box. > > > > > > > > I can see the box labled totals and it is shaded it is the real total box > > > > > that I need to shade. > > > > > > > > Thank you > > > > > Scott Burke > > > > > > Also, you could try an expression similar to this in the background > > color property: > > =iif(Fields!FieldName.Value Like "subtotal*", "Yellow", "White") > > Where FieldName can be from an adjacent cell. > > Hope this helps. > > > > Regards, > > > > Enrique Martinez > > Sr. Software Consultant > >
On Jun 1, 1:59 pm, Scott Burke <ScottBu...@discussions.microsoft.com>
[quoted text, click to view] wrote: > OK. I found the answear. Please try NOT to laught too loud. It will hurt > my feelings. > > On the totals box there is an arrow in the upper right corner. If you click > on the arrow you will get the properties of the total box itself. Click > anywhere else in the box adn you get the properties of the subtotal label box. > > Have fun over the weekend. > > Scott Burke > > "EMartinez" wrote: > > On May 31, 8:38 am, Scott Burke <ScottBu...@discussions.microsoft.com> > > wrote: > > > Thanks for your time. However, Visual Sudioes has an error and shut down. > > > now the report I was working on is gone.......... > > > > I will try your suggestion when I rebuild the report > > > Thanks again. > > > Scott Burke > > > > "Reeves Smith" wrote: > > > > Scott, > > > > > Using the inscope() function with the names of the matrix rows you are able > > > > to tell when the row is a subtotal or not, then place the iif function in the > > > > background color and sometimes the font color. > > > > > If you need more help I can find my code example. Last contract have to dig > > > > it up. > > > > > Reeves > > > > > "Scott Burke" wrote: > > > > > > I created a Matrix report with subtotals. > > > > > > It would be easier to read if the subtotals were shaded. > > > > > > How do I shade the subtotal box. Not the lable box. > > > > > > I can see the box labled totals and it is shaded it is the real total box > > > > > that I need to shade. > > > > > > Thank you > > > > > Scott Burke > > > Also, you could try an expression similar to this in the background > > color property: > > =iif(Fields!FieldName.Value Like "subtotal*", "Yellow", "White") > > Where FieldName can be from an adjacent cell. > > Hope this helps. > > > Regards, > > > Enrique Martinez > > Sr. Software Consultant Glad you solved the problem. Let me know if I can be of greater assistance. Regards, Enrique Martinez Sr. Software Consultant
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |