Formatting within a Textbox possible?

Hi all.
Have been coming accross this same issue more and more. I am needed to take
in some HTML and print it in a TextBox so that we can render a PDF with
custom formatting.
Up until now, I've written some custom code that replaces known HTML tags
with ascii characters or line breaks, etc. But now I am required to recognize
the BOLD and ITALICS properties of fonts. As far as I know, its imposible to
set the format of text within a textbox (in line), without setting the entire
object's format. Is that correct?
The only thing I've come up with is the idea to create X amount of textboxes
that are split up and used to dynamically change formats of text. This sounds
like a huge thing to try and achieve, and I'm not sure it would even work.
Anyone have ideas, or work arounds? There is no ASCII within a fontset that
represtents the bold version that I could use?
Any idea if RS 2005 will support inline formatting like this?
Thanks,
AndreThe Program Manager for Reporting services has said this is high on the list
of needs for Reporting Services, but this did not make it into SQL 2005, but
will be in the following release...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Arkiliknam" <Arkiliknam@.discussions.microsoft.com> wrote in message
news:8287446E-E4DD-4F90-B08D-DCEE258F9872@.microsoft.com...
> Hi all.
> Have been coming accross this same issue more and more. I am needed to
> take
> in some HTML and print it in a TextBox so that we can render a PDF with
> custom formatting.
> Up until now, I've written some custom code that replaces known HTML tags
> with ascii characters or line breaks, etc. But now I am required to
> recognize
> the BOLD and ITALICS properties of fonts. As far as I know, its imposible
> to
> set the format of text within a textbox (in line), without setting the
> entire
> object's format. Is that correct?
> The only thing I've come up with is the idea to create X amount of
> textboxes
> that are split up and used to dynamically change formats of text. This
> sounds
> like a huge thing to try and achieve, and I'm not sure it would even work.
> Anyone have ideas, or work arounds? There is no ASCII within a fontset
> that
> represtents the bold version that I could use?
> Any idea if RS 2005 will support inline formatting like this?
> Thanks,
> Andre|||Hi Wayne, thanks for the update, however do you know if it's possible or who
should be contacted in order to try to get this pushed up...possibly a
hotfix, this is something that is used in a number of reports if not all and
the workaround that was suggested above use to work prior to SP2 which
removes leading spaces therefore does not allow you to line up your "manually
formatted text" correctly. Any help in this matter is greatly appreciated.
"Wayne Snyder" wrote:
> The Program Manager for Reporting services has said this is high on the list
> of needs for Reporting Services, but this did not make it into SQL 2005, but
> will be in the following release...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Arkiliknam" <Arkiliknam@.discussions.microsoft.com> wrote in message
> news:8287446E-E4DD-4F90-B08D-DCEE258F9872@.microsoft.com...
> > Hi all.
> >
> > Have been coming accross this same issue more and more. I am needed to
> > take
> > in some HTML and print it in a TextBox so that we can render a PDF with
> > custom formatting.
> >
> > Up until now, I've written some custom code that replaces known HTML tags
> > with ascii characters or line breaks, etc. But now I am required to
> > recognize
> > the BOLD and ITALICS properties of fonts. As far as I know, its imposible
> > to
> > set the format of text within a textbox (in line), without setting the
> > entire
> > object's format. Is that correct?
> >
> > The only thing I've come up with is the idea to create X amount of
> > textboxes
> > that are split up and used to dynamically change formats of text. This
> > sounds
> > like a huge thing to try and achieve, and I'm not sure it would even work.
> >
> > Anyone have ideas, or work arounds? There is no ASCII within a fontset
> > that
> > represtents the bold version that I could use?
> >
> > Any idea if RS 2005 will support inline formatting like this?
> >
> > Thanks,
> > Andre
>
>|||Greetings. I have the same issue. Our developers came accross a utility that
they run within their .Net code that strips off the tags but that is not what
I need. For example, the results is one big paragraph after it strips off all
<br>, etc... Is your custom code available for our use? Thanks.
Dave.Sundell@.Fiserv.Com
"Arkiliknam" wrote:
> Hi all.
> Have been coming accross this same issue more and more. I am needed to take
> in some HTML and print it in a TextBox so that we can render a PDF with
> custom formatting.
> Up until now, I've written some custom code that replaces known HTML tags
> with ascii characters or line breaks, etc. But now I am required to recognize
> the BOLD and ITALICS properties of fonts. As far as I know, its imposible to
> set the format of text within a textbox (in line), without setting the entire
> object's format. Is that correct?
> The only thing I've come up with is the idea to create X amount of textboxes
> that are split up and used to dynamically change formats of text. This sounds
> like a huge thing to try and achieve, and I'm not sure it would even work.
> Anyone have ideas, or work arounds? There is no ASCII within a fontset that
> represtents the bold version that I could use?
> Any idea if RS 2005 will support inline formatting like this?
> Thanks,
> Andre|||all my custom code does is StringReplace on a set of predefined things... and
then strips all remaining html out... nothing fancy
"Dave Sundell" wrote:
> Greetings. I have the same issue. Our developers came accross a utility that
> they run within their .Net code that strips off the tags but that is not what
> I need. For example, the results is one big paragraph after it strips off all
> <br>, etc... Is your custom code available for our use? Thanks.
> Dave.Sundell@.Fiserv.Com
> "Arkiliknam" wrote:
> > Hi all.
> >
> > Have been coming accross this same issue more and more. I am needed to take
> > in some HTML and print it in a TextBox so that we can render a PDF with
> > custom formatting.
> >
> > Up until now, I've written some custom code that replaces known HTML tags
> > with ascii characters or line breaks, etc. But now I am required to recognize
> > the BOLD and ITALICS properties of fonts. As far as I know, its imposible to
> > set the format of text within a textbox (in line), without setting the entire
> > object's format. Is that correct?
> >
> > The only thing I've come up with is the idea to create X amount of textboxes
> > that are split up and used to dynamically change formats of text. This sounds
> > like a huge thing to try and achieve, and I'm not sure it would even work.
> >
> > Anyone have ideas, or work arounds? There is no ASCII within a fontset that
> > represtents the bold version that I could use?
> >
> > Any idea if RS 2005 will support inline formatting like this?
> >
> > Thanks,
> > Andre|||I started the same thing. I am currently working on the List tags.
Thanks.
"Arkiliknam" wrote:
> Hi all.
> Have been coming accross this same issue more and more. I am needed to take
> in some HTML and print it in a TextBox so that we can render a PDF with
> custom formatting.
> Up until now, I've written some custom code that replaces known HTML tags
> with ascii characters or line breaks, etc. But now I am required to recognize
> the BOLD and ITALICS properties of fonts. As far as I know, its imposible to
> set the format of text within a textbox (in line), without setting the entire
> object's format. Is that correct?
> The only thing I've come up with is the idea to create X amount of textboxes
> that are split up and used to dynamically change formats of text. This sounds
> like a huge thing to try and achieve, and I'm not sure it would even work.
> Anyone have ideas, or work arounds? There is no ASCII within a fontset that
> represtents the bold version that I could use?
> Any idea if RS 2005 will support inline formatting like this?
> Thanks,
> Andresql

formatting textboxes

I am rendering a report in VS 2003 and I need to know:
1) If it's possible to combine two different text formats in one textbox?
Sample database field = Notes.description
I want to be able to manually add the word "Notes: " (which I want to be
bold) in front of the data that's in the Notes.description field (which I
want to be normal) and appear as one group of text. I tried {="Notes: " +
Fields!Description.Value} but the format applies to the entire box. The only
way I have found to work around this is to have two side by side textboxes.
Is this possible to do without the side by side textboxes? Sometimes the
text in the Notes.description field will be long, and if the textboxes are
side by side, I won't get the text to appear as though it is "wrapping"
around the "Notes:" textbox.
2) Also, when I do need to use the side by side textboxes, is it possible
to dynamically move the position of the second textbox according to the
growth and shrinkage of the first? I would like for the text in the second
box to always come immediately after the text in the first box, no matter how
long or short the leading textbox is.
Please advise if you can.
Thanks.Like you, I tried to apply different formats to text within a textbox.
I even tried embeding html code to change the format and the code and
text would show. I concluded it just can't be done.
As for q-2, dynamicly changing the textbox postion may be possible in
a list but not in tables or matrix.
Mark
On Fri, 5 May 2006 14:51:02 -0700, dataGirl
<dataGirl@.discussions.microsoft.com> wrote:
>I am rendering a report in VS 2003 and I need to know:
>1) If it's possible to combine two different text formats in one textbox?
>Sample database field = Notes.description
>I want to be able to manually add the word "Notes: " (which I want to be
>bold) in front of the data that's in the Notes.description field (which I
>want to be normal) and appear as one group of text. I tried {="Notes: " +
>Fields!Description.Value} but the format applies to the entire box. The only
>way I have found to work around this is to have two side by side textboxes.
>Is this possible to do without the side by side textboxes? Sometimes the
>text in the Notes.description field will be long, and if the textboxes are
>side by side, I won't get the text to appear as though it is "wrapping"
>around the "Notes:" textbox.
>2) Also, when I do need to use the side by side textboxes, is it possible
>to dynamically move the position of the second textbox according to the
>growth and shrinkage of the first? I would like for the text in the second
>box to always come immediately after the text in the first box, no matter how
>long or short the leading textbox is.
>Please advise if you can.
>Thanks.
>
>

formatting textbox output

I have a report whcih displays information about a servers hardware
configuration. Unfortunatley the vendors application whcih collects and
stores this information, add spcaing between vaules in the form of [-] and
[+].
I'd like to remove this in the final rendering of the report for display
purposes.
see sample output:
ComputerSystem Name[-]ADM-EX01[+]SystemType[-]X86-based
PC[+]Manufacturer[-]Compaq[+]Model[-]ProLiant ML350
G3[+]Domain[-]MARBLEHEAD[+]DomainRole[-]Member
Server[+]NumberOfProcessors[-]2[+]TotalPhysicalMemory[-]2,146,979,840
Anyone have any ideas?
Much appreciated,
RCITGUYUse expression and Replace function. Remember, you can use VB in expressions.
Victor
"RCITGuy" wrote:
> I have a report whcih displays information about a servers hardware
> configuration. Unfortunatley the vendors application whcih collects and
> stores this information, add spcaing between vaules in the form of [-] and
> [+].
> I'd like to remove this in the final rendering of the report for display
> purposes.
> see sample output:
> ComputerSystem Name[-]ADM-EX01[+]SystemType[-]X86-based
> PC[+]Manufacturer[-]Compaq[+]Model[-]ProLiant ML350
> G3[+]Domain[-]MARBLEHEAD[+]DomainRole[-]Member
> Server[+]NumberOfProcessors[-]2[+]TotalPhysicalMemory[-]2,146,979,840
> Anyone have any ideas?
> Much appreciated,
> RCITGUY

Formatting text in Textbox

Is it possible to format one word in a text box to the color blue and another word in the SAME textbox to the color red?

Hello,

Sorry, but formatting is applied to the whole textbox. You can't format text differently within the same textbox.

Jarret

Formatting output from a SQL table

I have used a Winform textbox to enter the following data into a nvarchar field:

1. Choice number one

2. Choice number two

3 Choice number three

etc.

How do I print out the nvarchar field to look like the above? Can I do this in Reporting Services or something else? Thanks.

why can't you? have you tried?

doesn't sound difficult.

|||You could use the ReportViewer control in your application, create a report in local mode and use a datatable as the data source for the local report.sql

Formatting NoRows text

Hi,
I'm using a subreport that displays a NoRows message. Is there any way to
format it so that the NoRows message/textbox is different from the normal
subreport (i.e. big and red and ugly so people will notice that their data is
incomplete). Is there a NoRows=True property or something that I can
reference from the font colour expressions?
- DebThe NoRows property derives its style properties from the Subreport report
item.
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"DTimmins" <DTimmins@.discussions.microsoft.com> wrote in message
news:E8E0B589-6BAA-41F7-8C7A-20F752FB4B5C@.microsoft.com...
> Hi,
> I'm using a subreport that displays a NoRows message. Is there any way to
> format it so that the NoRows message/textbox is different from the normal
> subreport (i.e. big and red and ugly so people will notice that their data
> is
> incomplete). Is there a NoRows=True property or something that I can
> reference from the font colour expressions?
> - Deb

Formatting a textbox

I need to format a phone number parameter the user enters. Currently
when I print the parameter entered it displays like this ##########. I
want to format it to look like ###-###-####. Does anyone have any
ideas for making it look like that?E,
RS has a Custom Formatting built in where you can type in ###-###-####
for the Format.
But for phone Numbers the DB probably returns it as a string. You must
first convert it to a Number... a LONG in this case.
So go to report Properties go to Custom Code and put this in there:
Public Function convertToIntegerNow(tempVar2 As String)
convertToIntegerNow= CLng(tempVar2)
End Function
in the cell type in
=Code.convertToIntegerNow(Fields!Phone_Field_name.Value)
Then right click on the cell go to properties, change the format of the
cell to ###-###-####
Hope this helps
regards,
Stas K.

Formatting a string from the code

I have a textbox that displays the amout of free disk space in megabytes.
I'm working on converting it to gigabytes and if it's less that one gig, I
want to display the string "Critical" bold and in red. Can this be done?
Thanks.This can certainly be done. Where do you want to display the text
'Critical'? If you have another textbox you would use an expression to
determine the value of that checkbox. for example if you were getting the
value from a dataset you would have a similar code to the following in the
expression editor:
=IIf(Fields!Number_Of_Megs < 1024,"","Critical")
Hope this helps
"chalexan" wrote:
> I have a textbox that displays the amout of free disk space in megabytes.
> I'm working on converting it to gigabytes and if it's less that one gig, I
> want to display the string "Critical" bold and in red. Can this be done?
> Thanks.|||Bret or anyone else,
Thanks for the reply. Any suggestions on changing the font's color to red
if it's critical and making it bold?
--Chad|||You will have to do this from the report designer. You can select the
textbox that the text is in and go to the textbox properties. (right click
and properties) From here you can select the format for this text box... A
nice feature is using the Expression Editor to select the font color. This
will allow you to use an IIF() statement to have the font red or black. You
can allow do this with the font weight.
Example of formatting font color in expression editor: (you would put this
in the format expression for the font-color in the designer)
=IIf(Fields!Number_Of_Megs < 1024,"black","red")
"chalexan" wrote:
> Bret or anyone else,
> Thanks for the reply. Any suggestions on changing the font's color to red
> if it's critical and making it bold?
> --Chad|||Bret,
Wow! I thought that the "IIf(" was a typo. That functionality can be very
useful. Thank you so much for explaining that to me.
--Chad

Formatting a portion of a String in a TextBox

I have a report that shows a string containing "wildcard" values. I
would like to be able to change the formatting (Bold, Italicized, Red)
for the wildcard values within the string. I've been examining the
conditional formatting functionality, but it seems only to apply to the
whole textbox value not a portion of it.
Has anyone tackled this before?
TIA,
EricI had similar issue when combining string and number field and solved it with
Format function:
=Fields!industry.Value & " (" & Format(Fields!marketPct.Value, "#0.0%") & ")"
You can probably something similar for color.
"Ferd Biffle" wrote:
> I have a report that shows a string containing "wildcard" values. I
> would like to be able to change the formatting (Bold, Italicized, Red)
> for the wildcard values within the string. I've been examining the
> conditional formatting functionality, but it seems only to apply to the
> whole textbox value not a portion of it.
> Has anyone tackled this before?
> TIA,
> Eric
>

formatting

I have a textbox on a report containing a number I want formatted in
scientific notation. When I bring up the properties of the textbox, there
is a formatting option. I select number and am given a choice of
1.234123e+003. This works great, but I really don't want to show that many
number in the format. I would rather have the number something sensible,
say 1.23e+03. It looks like the custom format option might give the ability
to format the number this way, but I can't find any examples on how to use
it.
Any ideas?
Thanks.They're listed in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp?frame=true.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Leon Chuck Gosslin" <powerb@.inel.gov> wrote in message
news:ekCx1oveEHA.2916@.TK2MSFTNGP12.phx.gbl...
> I have a textbox on a report containing a number I want formatted in
> scientific notation. When I bring up the properties of the textbox, there
> is a formatting option. I select number and am given a choice of
> 1.234123e+003. This works great, but I really don't want to show that
many
> number in the format. I would rather have the number something sensible,
> say 1.23e+03. It looks like the custom format option might give the
ability
> to format the number this way, but I can't find any examples on how to use
> it.
>
> Any ideas?
>
> Thanks.
>
>|||Thanks, man...I owe you a cold beer...
Leon.
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:%23YUg5wveEHA.3200@.TK2MSFTNGP09.phx.gbl...
> They're listed in
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp?frame=true.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Leon Chuck Gosslin" <powerb@.inel.gov> wrote in message
> news:ekCx1oveEHA.2916@.TK2MSFTNGP12.phx.gbl...
> > I have a textbox on a report containing a number I want formatted in
> > scientific notation. When I bring up the properties of the textbox,
there
> > is a formatting option. I select number and am given a choice of
> > 1.234123e+003. This works great, but I really don't want to show that
> many
> > number in the format. I would rather have the number something
sensible,
> > say 1.23e+03. It looks like the custom format option might give the
> ability
> > to format the number this way, but I can't find any examples on how to
use
> > it.
> >
> >
> >
> > Any ideas?
> >
> >
> >
> > Thanks.
> >
> >
> >
> >
>

Format(Now(), "yyyymm") shows minutes instead of months?

Just ran into a strange error.
I want to see what year and month it is today, like 200411 for November,
2004. I've added a textbox to show this, and set the value to
="Month: " & Format(Now(), "yyyymmmm")
For some reason, this shows 200430, because the time is 09.30 on my
computer. I've tried with m, mm, mmm and mmmm, and it just shows the
minutes. Why?
I tried using VBA!Now() but then I get an error saying "VBA is not
declared". Where do I need to declare it?
Running VS.NET 2003 with the Report Designer installed. The Report Server is
Ent. edition, and it shows the same error when I upload the report.
Any help appreciated!
Kaisa M. LindahlTry "yyyyMMMM".
A really good page for all .NET format code is:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconformattingtypes.asp
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:ePUM8bjxEHA.1392@.tk2msftngp13.phx.gbl...
> Just ran into a strange error.
> I want to see what year and month it is today, like 200411 for November,
> 2004. I've added a textbox to show this, and set the value to
> ="Month: " & Format(Now(), "yyyymmmm")
> For some reason, this shows 200430, because the time is 09.30 on my
> computer. I've tried with m, mm, mmm and mmmm, and it just shows the
> minutes. Why?
> I tried using VBA!Now() but then I get an error saying "VBA is not
> declared". Where do I need to declare it?
> Running VS.NET 2003 with the Report Designer installed. The Report Server
is
> Ent. edition, and it shows the same error when I upload the report.
> Any help appreciated!
>
> Kaisa M. Lindahl
>|||USE Format(Now(), "yyyyMM")
"Kaisa M. Lindahl" wrote:
> Just ran into a strange error.
> I want to see what year and month it is today, like 200411 for November,
> 2004. I've added a textbox to show this, and set the value to
> ="Month: " & Format(Now(), "yyyymmmm")
> For some reason, this shows 200430, because the time is 09.30 on my
> computer. I've tried with m, mm, mmm and mmmm, and it just shows the
> minutes. Why?
> I tried using VBA!Now() but then I get an error saying "VBA is not
> declared". Where do I need to declare it?
> Running VS.NET 2003 with the Report Designer installed. The Report Server is
> Ent. edition, and it shows the same error when I upload the report.
> Any help appreciated!
>
> Kaisa M. Lindahl
>
>|||Using MM instead of mm|||Tried this, and it works.
Thanks to all who answered. And for the url too.
Kaisa
"David Hughes" <spamfree@.freespam.com> wrote in message
news:uFg6$NkxEHA.1400@.TK2MSFTNGP11.phx.gbl...
> Try "yyyyMMMM".
> A really good page for all .NET format code is:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconformattingtypes.asp
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> news:ePUM8bjxEHA.1392@.tk2msftngp13.phx.gbl...
> > Just ran into a strange error.
> > I want to see what year and month it is today, like 200411 for November,
> > 2004. I've added a textbox to show this, and set the value to
> > ="Month: " & Format(Now(), "yyyymmmm")
> >
> > For some reason, this shows 200430, because the time is 09.30 on my
> > computer. I've tried with m, mm, mmm and mmmm, and it just shows the
> > minutes. Why?
> >
> > I tried using VBA!Now() but then I get an error saying "VBA is not
> > declared". Where do I need to declare it?
> >
> > Running VS.NET 2003 with the Report Designer installed. The Report
Server
> is
> > Ent. edition, and it shows the same error when I upload the report.
> >
> > Any help appreciated!
> >
> >
> >
> > Kaisa M. Lindahl
> >
> >
>

Format textBox in reporting services

Hi,
I have a problem with formattting a textbox field.I have field comes from
database and it is too long .I want to format this paragraph in a text box.I
want some space between rows and give justify property . NOw rows are so
closed and paragraph is too near to left.I must format this paragraph but
how? If you can help me, I will be plased.Thanks for your interest.On Nov 20, 1:25 pm, Reporting Services de Text Box a format
<ReportingServicesdeTextBoxafor...@.discussions.microsoft.com> wrote:
> Hi,
> I have a problem with formattting a textbox field.I have field comes from
> database and it is too long .I want to format this paragraph in a text box.I
> want some space between rows and give justify property . NOw rows are so
> closed and paragraph is too near to left.I must format this paragraph but
> how? If you can help me, I will be plased.Thanks for your interest.
The best way to accommodate this is to use a table control instead of
a textbox control. You could split the string into multiple records
prior to getting it into the report. Of course, the table control
should give some basic formatting options by default. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Format Textbox as HTML?

I am pulling some stuff from sharepoint and the text is formated as
html. Is it possible to have the textbox interpret this?This is not supported in the current release (but is on our future features
wishlist).
If you're really ambitious, you could post-process the rendered HTML to
convert < to < and > to >, thereby simulating support for this in the
HTML renderer. But that won't work for other renderers (PDF might
technically be possible to postprocess, but it would be a lot of work).
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Braden" <bluesv650@.hotmail.com> wrote in message
news:400eb9cb.0407090935.3f735bf2@.posting.google.com...
> I am pulling some stuff from sharepoint and the text is formated as
> html. Is it possible to have the textbox interpret this?

Format Substring in Textbox

I have a textbox that's several lines in height. I want to put several lines
of text in one textbox to get single spacing. I don't want to use multiple
textboxes, as I have to push multiple textboxes so close together it looks
like a mess.
In the first line below, I actually need the static text "Caller" to be bold
and underlined. I can't even get bold to work using this approach. Any
suggestions on how to get the word "Caller" to be bold and underlined,
leaving the rest as normal text?
=Format("Caller", Style.Bold)
& controlchars.Newline
& Fields!Salutation.Value
& " " & Fields!FirstName.Value
& " " & Fields!LastName.Value & controlchars.Newline
& Fields!EStreetNumber.Value & " " & Fields!EStreet.Value
Thanks,
--
RandyHello Randy,
Thank you for your posting!
Unfortunatly, the format will apply on the whole textbox control. You could
not make the first line have different style with other lines.
One workaround of this issue is to use some third-party RichText control
instead of the textbox control.
Please note Microsoft is providing this information as a convenience to
you. Microsoft cannot make any representations regarding the quality,
safety, or suitability of any software or information found there.
Also, you could send your feedback to the product team.
http://connect.microsoft.com/SQLServer
Hope this information will be helpful and thank you for your understanding!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Format string

Hii
can somebody please tell me what format string i should use to bring 3
digits after decimal in any textbox.
thanx in advanceformat(Field!Number.Value,"0.000")
"Techotsav" wrote:
> Hii
> can somebody please tell me what format string i should use to bring 3
> digits after decimal in any textbox.
> thanx in advance
>|||many many thanks (sorry didnt get ur label), i placed =format("0.000")
in formatstring textbox n bang, it works!

Format Question (Currency)

I know that you can set a textbox to be of format Currency, but how
can I set the text of a textbox equal to a string that has formatted
strings within it?
What I mean is, lets say that I am getting back 2 values: MyFieldA and
MyFieldB, which are both floats (say 12.3123 and 43.2234). I want to
make the text "MyFieldA - MyFieldB", where both are formatted as
currency, so it would look like "$12.31 - $43.22".
Is there a way, with in the section where I specify
Fields!MyFieldA.Value to do something like
Fields!MyFieldA.Value.Format("C") or something like that? anyone
know?Chris,
Maybe something like this:
=(String.Format("{$###,##0.00}"),Fields!MyFieldA.Value) & " - " &
(String.Format("{$###,##0.00}"),Fields!MyFieldB.Value)
I had thought about using cdec, but I don't think that works in RS.
I'm pretty new to the RS world, so I don't know it this will help but
it doesn't hurt to try. Good Luck.
Jonathan
cmay@.walshgroup.com (Chris) wrote in message news:<44f6e099.0410261338.3f991c5@.posting.google.com>...
> I know that you can set a textbox to be of format Currency, but how
> can I set the text of a textbox equal to a string that has formatted
> strings within it?
> What I mean is, lets say that I am getting back 2 values: MyFieldA and
> MyFieldB, which are both floats (say 12.3123 and 43.2234). I want to
> make the text "MyFieldA - MyFieldB", where both are formatted as
> currency, so it would look like "$12.31 - $43.22".
> Is there a way, with in the section where I specify
> Fields!MyFieldA.Value to do something like
> Fields!MyFieldA.Value.Format("C") or something like that? anyone
> know?

Format money MS SQL field data as number with commas and no decimals

If I pull a value from a MSSQL field with is defined as money, how can I get it to display in a textbox with commas and NO decimals?

87000.0000 = 87,000

I can currently remove the decimals like below but is there a way to add the commas as well?

decRevenue = drMyData("Revenue")

txtRevenue.Text = decRevenue.ToString("f0")

It current shows "87000".

http://msdn2.microsoft.com/en-us/library/dwhawy9k(VS.80).aspx

Format Masking for creating leading periods

Is there an elegant way to fill the empty space leading a textbox in a table with periods, similar to a table of contents effect?

When I do not allow the textbox to grow and just append a long string of periods it looks fine in my report preview, but after I deploy everything appended after the primary field in that text box is missing?

My report has a lot of data to the right but it is collapsible so the fields to the left are a good distance away. This is why I am trying to include light visual aids that assist lining up data values. I am not stuck on the leading period idea but it seems the least cluttered.

AaronBump...
Does anyone have any solutions for masking fields?|||

Hello Aaron,

Can you try something like this in your field's expression:

=StrDup(25 - len(Fields!FIELD1.Value), ".") & Fields!FIELD1.Value

The 25 in my example would have to be higher than the maximum number of characters in your FIELD1 field. This will fill the rest of space (up to 25 characters) on the left of the field with period's, it should be adjusted to fill the rest of your textbox.

Hope this helps.

Jarret

Format expression returned a data type that is not valid

Hi,
I'm new on Reporting Services 2005 and would apreciate your help.
I'm trying to format a textbox in a matrix report to present an ABS value.
I've tried several formulas but I'm getting this warning :
"The Format expression used in textbox â'SALDO_PERIODOâ' returned a data type
that is not valid."
The textbox value is Sum(Fields!SALDO_PERIODO.Value and the format formula
I'm using is =Abs(Sum(Fields!SALDO_PERIODO.Value, "SALDOS"))
Thanks,
--
NSThe format code property has to evaluate to a string. Also, the format code
property uses .NET formatcode string. Please check MSDN for details:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconstandardnumericformatstrings.asp
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nuno Santos" <NunoSantos@.discussions.microsoft.com> wrote in message
news:E6AC8CC1-61A1-4418-9982-691755C7C550@.microsoft.com...
> Hi,
> I'm new on Reporting Services 2005 and would apreciate your help.
> I'm trying to format a textbox in a matrix report to present an ABS value.
> I've tried several formulas but I'm getting this warning :
> "The Format expression used in textbox 'SALDO_PERIODO' returned a data
> type
> that is not valid."
> The textbox value is Sum(Fields!SALDO_PERIODO.Value and the format formula
> I'm using is =Abs(Sum(Fields!SALDO_PERIODO.Value, "SALDOS"))
> Thanks,
> --
> NS