changing textbox expression based on column value

Please forgive what I'm sure is a novice question but I've only been
playing around with Reporting Svcs for a few days.
I have a report that's rendered from a stored procedure (no prob there
- works quite nicely). One of the grouping variables, Type, has values
such as "SS_F", "SS_P" and the like.
Naturally what I'd like to do is assign meaningful labels to these
values. Since there are only a few of them and they're static for the
report - that is, the same 4 values (well, up to 4 .. perhaps only 2 or
3 in any given run) would be returned on any run of the stored proc.
Where do I do that' Or do I need to make the assignments in code? If
so, how do I get there? And before suggesting that I do them in the
sp, I can't - it's not mine to touch :)
Thanks so much for any help!
-Steve LordYou would put in a nested iif statement. RS 2005 books online didn't have an
index listing for that but you could search on the phrase conditional
formatting
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Steve L" <slord@.circlesofcare.org> wrote in message
news:1141419699.794514.9160@.e56g2000cwe.googlegroups.com...
> Please forgive what I'm sure is a novice question but I've only been
> playing around with Reporting Svcs for a few days.
> I have a report that's rendered from a stored procedure (no prob there
> - works quite nicely). One of the grouping variables, Type, has values
> such as "SS_F", "SS_P" and the like.
> Naturally what I'd like to do is assign meaningful labels to these
> values. Since there are only a few of them and they're static for the
> report - that is, the same 4 values (well, up to 4 .. perhaps only 2 or
> 3 in any given run) would be returned on any run of the stored proc.
> Where do I do that' Or do I need to make the assignments in code? If
> so, how do I get there? And before suggesting that I do them in the
> sp, I can't - it's not mine to touch :)
> Thanks so much for any help!
> -Steve Lord
>|||Here's what I had for changing the image used in a report:
=Switch(Fields!PDPType.Value="Bug", "http://localhost/images/bug.gif",
Fields!PDPType.Value="Customization Request",
"http://localhost/images/customization.gif", Fields!PDPType.Value="New
Feature/Enhancement", "http://localhost/images/enhancement.gif",
Fields!PDPType.Value="Script Request", "http://localhost/images/script.gif",
Fields!PDPType.Value="Support Request", http://localhost/images/support.GIF)
Should work for a text field too, I think. Sorry if I'm not understanding
your original question, though, or if you run into another snag. I'm rather
a newbie at the RS stuff myself.
Clint
"Steve L" <slord@.circlesofcare.org> wrote in message
news:1141419699.794514.9160@.e56g2000cwe.googlegroups.com...
> Please forgive what I'm sure is a novice question but I've only been
> playing around with Reporting Svcs for a few days.
> I have a report that's rendered from a stored procedure (no prob there
> - works quite nicely). One of the grouping variables, Type, has values
> such as "SS_F", "SS_P" and the like.
> Naturally what I'd like to do is assign meaningful labels to these
> values. Since there are only a few of them and they're static for the
> report - that is, the same 4 values (well, up to 4 .. perhaps only 2 or
> 3 in any given run) would be returned on any run of the stored proc.
> Where do I do that' Or do I need to make the assignments in code? If
> so, how do I get there? And before suggesting that I do them in the
> sp, I can't - it's not mine to touch :)
> Thanks so much for any help!
> -Steve Lord
>

Changing FONTS within a TEXTBOX

This is a multi-part message in MIME format.
--=_NextPart_000_0029_01C5AD3C.9F1602B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Does anyone know a way of changing fonts within a textbox in either = rs2000 or rs2005? I am trying to use bolding for part of the string
(ex: You owe $500.00, you must pay immediately)
Thanks,
Dennis
--=_NextPart_000_0029_01C5AD3C.9F1602B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Does anyone know a way of changing = fonts within a textbox in either rs2000 or rs2005? I am trying to use bolding for = part of the string

(ex: You owe = $500.00, you must pay immediately)

Thanks,

Dennis
--=_NextPart_000_0029_01C5AD3C.9F1602B0--ON THE PROPERTIES TAB ENTER =IIF( Sum(Fields!TOTAL.Value) =500,"Bold","Normal") INTO THE FONTWEIGHT
"Denny" wrote:
> Does anyone know a way of changing fonts within a textbox in either rs2000 or rs2005? I am trying to use bolding for part of the string
> (ex: You owe $500.00, you must pay immediately)
> Thanks,
> Dennis|||Thanks for the quick response, but I think that I didn't make my problem
clear. What I meant was that I wanted to make only part of the string bold,
the rest normal. In my example I wanted only "$500.00" bold, and "You owe"
and "you must pay immediately" normal.
So I would have mixed fonts within the same textbox.
"EsWallace" <EsWallace@.discussions.microsoft.com> wrote in message
news:7797B1B3-F551-40F3-BB53-FE2F510B263F@.microsoft.com...
> ON THE PROPERTIES TAB ENTER =IIF( Sum(Fields!TOTAL.Value) => 500,"Bold","Normal") INTO THE FONTWEIGHT
> "Denny" wrote:
>> Does anyone know a way of changing fonts within a textbox in either
>> rs2000 or rs2005? I am trying to use bolding for part of the string
>> (ex: You owe $500.00, you must pay immediately)
>> Thanks,
>> Dennis|||I have always wanted to do that too :( but never figured it out. and I even
tried having like 3 text boxes look like one text box after it rendered but
could never get it to look pretty :)
sorry i could not help
"Denny" wrote:
> Thanks for the quick response, but I think that I didn't make my problem
> clear. What I meant was that I wanted to make only part of the string bold,
> the rest normal. In my example I wanted only "$500.00" bold, and "You owe"
> and "you must pay immediately" normal.
> So I would have mixed fonts within the same textbox.
>
> "EsWallace" <EsWallace@.discussions.microsoft.com> wrote in message
> news:7797B1B3-F551-40F3-BB53-FE2F510B263F@.microsoft.com...
> > ON THE PROPERTIES TAB ENTER =IIF( Sum(Fields!TOTAL.Value) => > 500,"Bold","Normal") INTO THE FONTWEIGHT
> >
> > "Denny" wrote:
> >
> >> Does anyone know a way of changing fonts within a textbox in either
> >> rs2000 or rs2005? I am trying to use bolding for part of the string
> >>
> >> (ex: You owe $500.00, you must pay immediately)
> >>
> >> Thanks,
> >>
> >> Dennis
>
>|||This capability does not exist.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Denny" <denny@.news.com> wrote in message
news:%23I2Tb3XrFHA.1236@.TK2MSFTNGP10.phx.gbl...
> Thanks for the quick response, but I think that I didn't make my problem
> clear. What I meant was that I wanted to make only part of the string
> bold, the rest normal. In my example I wanted only "$500.00" bold, and
> "You owe" and "you must pay immediately" normal.
> So I would have mixed fonts within the same textbox.
>
> "EsWallace" <EsWallace@.discussions.microsoft.com> wrote in message
> news:7797B1B3-F551-40F3-BB53-FE2F510B263F@.microsoft.com...
>> ON THE PROPERTIES TAB ENTER =IIF( Sum(Fields!TOTAL.Value) =>> 500,"Bold","Normal") INTO THE FONTWEIGHT
>> "Denny" wrote:
>> Does anyone know a way of changing fonts within a textbox in either
>> rs2000 or rs2005? I am trying to use bolding for part of the string
>> (ex: You owe $500.00, you must pay immediately)
>> Thanks,
>> Dennis
>

Changing default font

Hi,
is there a way to change the default font settings? currently every textbox
comes in Arial 10pt. i need that whenever i drag a textbox it comes Arial
8pt, for every report.If you find a way PLEASE post it here.
Mike Kruchten
"Kazar" <kazar@.kazar.kaz> wrote in message
news:OqpJLqJoEHA.3224@.tk2msftngp13.phx.gbl...
> Hi,
> is there a way to change the default font settings? currently every
textbox
> comes in Arial 10pt. i need that whenever i drag a textbox it comes Arial
> 8pt, for every report.
>|||still no idea :(
I wonder if its even possible... if not, it would be nice to have this
feature in the next version..
"Mike Kruchten" <mkruchten@.fsisolutions.com> wrote in message
news:OAXZvDLoEHA.3712@.TK2MSFTNGP15.phx.gbl...
> If you find a way PLEASE post it here.
> Mike Kruchten
> "Kazar" <kazar@.kazar.kaz> wrote in message
> news:OqpJLqJoEHA.3224@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > is there a way to change the default font settings? currently every
> textbox
> > comes in Arial 10pt. i need that whenever i drag a textbox it comes
Arial
> > 8pt, for every report.
> >
> >
>