Formattting numbers

I would like to format the number 12345 into 12,345. How can I achieve this?

in C#:
int num = 1234567890;
String numFormatted = num.ToString("#,#");

Check out this documentation for more specifics on number formatting:

http://msdn2.microsoft.com/en-us/library/0c899ak8(VS.71).aspx

|||

I would like to acheive this in reporting services.

|||

I found out. I can make it using the format tab in properties of the textbox

Formatting/CR in Report Manager Report Description

Is there any way to format or add a CR to the report description in report manager?

Thanks!

BobP

I'm afraid there is no way of doing this.|||

Ya know... I knew you were going to say that...

Thanks!

Formatting the numerical output

Hi All,

I need to control the output format of a request on "int" columns. For instance, if the "select" returns me a "0" (zero), I would like it to be return with 4 digit = "0000" because this results is then append to some other to built a phone-like number : +33 2121-0000-1544.
In that case, "0" is not equal to "0000"

My ASP request is in attach.

THX.

Fabrice.I found a solution ... Thank's anyway ;)

Formatting the date on report

Reporting Services 2005 (SQL Server 2005 CTP V 9.00.1187.00)

I have a date field and I want to format it on a report like:

January 9, 2006

Seems to me that should be pretty simple. But I can't find the correct format code. If I look at the textbox properties and go to the format tab, there is an option for Date, but there are only 3 choices:

1/9/2006 9:47 AM

Monday, January 9, 2006

1/9/2006

If I choose custom I found that Y gives me:

January 2006

and M gives me:

January 09

This is rather frustrating. I'm sure I could modify my source SQL to get each part of the date and past it together, but I would think a good reporting tool would give me the option on how to format the date, so I don't have to always modify the SQL. I've searched for help on the different format options and I can't find any.

Any help would be very much appreciated.

Thanks.

Well, I finally figured it out, with the help of some obscure posting on another forum. I now use format:

MMMM dd"," yyyy

interesting that you have to use MMMM, not mmmm and you have to use yyyy, not YYYY.

Now I could not find this anywhere in the documentation. I'm sure it must be there, but where? Does anybody know? I'm sure I'm going to have other formatting issues and I really don't want to have to search through forum postings on the internet to find crumbs of clues to figure out things that I think should be easily found in the products documentation. I'm sure it's me. It's gotta be right in front of me, or I did something wrong when installing and I don't have the correct documentation. (but then why can't I find it at MSDN?)

|||

You can find documentation about these custom .NET format strings (e.g. MMMM and yyyy) on MSDN: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomdatetimeformatstrings.asp

-- Robert

|||Thanks!

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 text in crystal reports

hi,
is it possible to format the size, font, color of the text displayed in the report?just right click on that text and click format text :sql

Formatting text

I need to format a text in a text box to show a text field truncated.
In other terms, I must show only 40 characters of a very long string.
Do I use the statement "format"?
How can I solve this issue?
Many thanksI would do it in the SQL statement. As in left(fieldname, 40)
Richard
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:2550C968-0324-4FC8-A50D-67645F99C4BD@.microsoft.com...
>I need to format a text in a text box to show a text field truncated.
> In other terms, I must show only 40 characters of a very long string.
> Do I use the statement "format"?
> How can I solve this issue?
> Many thanks|||Or in the report itself:
Field => expression => LEFT(strVariable, 40)|||OK! Many thanks
"Vyv" wrote:
> Or in the report itself:
> Field => expression => LEFT(strVariable, 40)
>

Formatting spoils when export to HTML Format

I have problem here. when I overlap two or more tables one on other and
export to PDF, it works fine. But when exported to HTML, it doesn't hold the
absolute position and renders tables sequentially.
Thanks,
JigneshThe same thing happens when you overlap charts. Charts render as images,
and are placed side-by-side in HTML rather than overlapping. I presume this
is because the HTML code required to overlap these items (charts, images,
tables), especially while maintaining appropriate transparency, would be
very complex, fragile and browser-specific.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jignesh Nakrani" <Jignesh Nakrani@.discussions.microsoft.com> wrote in
message news:068CD644-4EFF-40A6-B2D7-E86205EFC331@.microsoft.com...
>I have problem here. when I overlap two or more tables one on other and
> export to PDF, it works fine. But when exported to HTML, it doesn't hold
> the
> absolute position and renders tables sequentially.
> Thanks,
> Jignesh|||Jeff,
Thanks for the reply. Hope something comes up with the solution.
"Jeff A. Stucker" wrote:
> The same thing happens when you overlap charts. Charts render as images,
> and are placed side-by-side in HTML rather than overlapping. I presume this
> is because the HTML code required to overlap these items (charts, images,
> tables), especially while maintaining appropriate transparency, would be
> very complex, fragile and browser-specific.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Jignesh Nakrani" <Jignesh Nakrani@.discussions.microsoft.com> wrote in
> message news:068CD644-4EFF-40A6-B2D7-E86205EFC331@.microsoft.com...
> >I have problem here. when I overlap two or more tables one on other and
> > export to PDF, it works fine. But when exported to HTML, it doesn't hold
> > the
> > absolute position and renders tables sequentially.
> >
> > Thanks,
> > Jignesh
>
>

Formatting RS to look like invoice

hi!,
Can we use RS to format the report to look like an invoice?
The areas I have been having problems is defining the table with the invoice
items to always stay the same size regardless of the number of lines it
prints. I was using a table embedded in the report to print this with borders
on the table.
How do I get this to a fixed length column or let it page break with headers
and footers defining number of fixed lines for the body of the report. Are
there any samples of invoices either, Microsoft or anyone else has done?
Ranjit CharlesHi Ranjit,
You can control the number of rows in your report by:
1) add a group to table, and set grouping with
"=Ceiling(RowNumber(Nothing)/30)" try 30 or whatever number fits into
your spacing
2) turn off group header and footer
3) set PageBreakAtEnd for group
HTH
Matt A
www.reportarchitex.com

Formatting Reports

I have created a report but I want to format it and put in headers and a bit of colour to it.
Does anyone know how I can do this.
Thanks,
macca

This is easy thing in reporting service read those tutorila to know how they are great ones on msdn

http://msdn2.microsoft.com/en-us/library/ms170623.aspx

http://msdn2.microsoft.com/en-us/library/ms170246.aspx

Formatting report parameters?

Hi,
I have 5 report parameters to show in a report. I want to properly align the
controls(list boxes, text boxes) of parameters. How do we format the report
parameters in SQL Server 2005 Reporting Services using Report Designer tool?
Thanks in advance!
Regards,
VenkatOn Nov 6, 7:14 am, "Venky Dosap" <ven...@.translogicsys.com> wrote:
> Hi,
> I have 5 report parameters to show in a report. I want to properly align the
> controls(list boxes, text boxes) of parameters. How do we format the report
> parameters in SQL Server 2005 Reporting Services using Report Designer tool?
> Thanks in advance!
> Regards,
> Venkat
As far as I know, the best control you can get over this is to order
them differently in the Report Parameters' list (via Layout view >>
Report drop-down list >> Report Parameters...) by selecting the up/
down arrows on the left. Unfortunately, there is not much more in the
way of layout customization available. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Formatting question

Hi All, I must be overlooking something obvious, but I could reallt use some
guidance.
I can't find or figure out how to format a string in my report. The
datacolumn is just a string containing numbers like 123456789 and I need to
display it in the report as 123-45-6789 .
From the books on-line I figured I should set the format property of the
textbox to ###-##-#### but that does not seem to work. Can someone please
point me in the right direction?
Thanks
Ed###-##-#### works fine - and i get the right result.
Make sure you select the Custom option button , not the standard one.
and make sure you have a "=" in the value box.
"Ed Richard" wrote:
> Hi All, I must be overlooking something obvious, but I could reallt use some
> guidance.
> I can't find or figure out how to format a string in my report. The
> datacolumn is just a string containing numbers like 123456789 and I need to
> display it in the report as 123-45-6789 .
> From the books on-line I figured I should set the format property of the
> textbox to ###-##-#### but that does not seem to work. Can someone please
> point me in the right direction?
> Thanks
> Ed
>
>|||Ed,
You need to convert the string to a number.
Try =CDec("12345678") in the value then ###-##-### in the format
property.
Chris
Ramani wrote:
> ###-##-#### works fine - and i get the right result.
> Make sure you select the Custom option button , not the standard one.
> and make sure you have a "=" in the value box.
> "Ed Richard" wrote:
> > Hi All, I must be overlooking something obvious, but I could reallt
> > use some guidance.
> >
> > I can't find or figure out how to format a string in my report. The
> > datacolumn is just a string containing numbers like 123456789 and I
> > need to display it in the report as 123-45-6789 .
> > From the books on-line I figured I should set the format property
> > of the textbox to ###-##-#### but that does not seem to work. Can
> > someone please point me in the right direction?
> >
> > Thanks
> > Ed
> >
> >
> >|||That was it Chris, thanks very much!
Ed
"Chris McGuigan" <chris.mcguigan@.zycko.com> wrote in message
news:OMk8dCXgFHA.2444@.tk2msftngp13.phx.gbl...
> Ed,
> You need to convert the string to a number.
> Try =CDec("12345678") in the value then ###-##-### in the format
> property.
> Chris
>
> Ramani wrote:
>> ###-##-#### works fine - and i get the right result.
>> Make sure you select the Custom option button , not the standard one.
>> and make sure you have a "=" in the value box.
>> "Ed Richard" wrote:
>> > Hi All, I must be overlooking something obvious, but I could reallt
>> > use some guidance.
>> >
>> > I can't find or figure out how to format a string in my report. The
>> > datacolumn is just a string containing numbers like 123456789 and I
>> > need to display it in the report as 123-45-6789 .
>> > From the books on-line I figured I should set the format property
>> > of the textbox to ###-##-#### but that does not seem to work. Can
>> > someone please point me in the right direction?
>> >
>> > Thanks
>> > Ed
>> >
>> >
>> >
>

Formatting Problem

Hi,

I'm trying to format the output of a report and can't seem to figure out how use the Matrix control to get what I want. Currently, I have it formatted as:

General Information <-- Head
Tag Number Line Size Line Schedule <-- Information

Service P&ID No. Tightness Requirements

Line No. Area Classification Location

Process Data
Fluid Specific Gravity

Transmitter Spec.
Mounting Type

NEMA Rating Power Supplied Analog Outputs

Ideally I'd like to have it formatted as:

General Information <-- Header centered
Tag Number Line Size Line Schedule

Service P&ID No. Tightness Requirements

Line No. Area Classification Location
__ <-- Divider Line between sections

Process Data
Fluid Specific Gravity
__

Transmitter Spec.
Mounting Type

NEMA Rating Power Supplied Analog Outputs

Any ideas or suggestions would be greatly appreciated. This shouldn't be THIS hard to do.

Thanks,

John.

It'll be a lot clearer to understand if you make up your examples in Excel and then just copy paste that into your post.|||

Adam,

Thanks for taking an interest. Ok, here's what's going on: I'm trying to render information where I have multiple (unknown at design time) Catagories which have multiple Attributes (also unknown at design time). The relationship is One Catagory, Many Attributes.

I'm using a Matrix control because it seems to be the Control to use? If it's not, let me know. What I'd like ideally is to: Add a Line to separate the different Catagories (i.e. General Information, Process Data, etc.), and center the Catagory title. Currently I'm forcing the Matrix to wrap at 3 by setting a property in the List Control's "Edit Details Group..." property to: =Ceiling(RowNumber(Nothing)/3). If you have any ideas on how to solve this through the designer, please let me know.

Here's an example of the data as it's currently being rendered:

General Information

Service

P&ID No.

Tightness Requirements

Tag Number

Line Size

Line Schedule

Line No.

Area Classification

Location

Process Data

Fluid

Specific Gravity

Transmitter Spec.

Mounting Type

Model No.

Support Materials

Accuracy

NEMA Rating

Power Supplied

Analog Outputs

Local Display

Operating Range

Dead Weight

Output Signal

Conduit Connection

Live Weight

Gross Weight

Manufacturer

Weigh Cell Data

Mounting

Temperature Compensation

Power Supplied

|||

On a side note, I've tried adding a Line control to the List, but it renders on every line. I also have no way to detect when the last line of a Catagory is being rendered. I've tried every way I can think of using the tool, but it's just not working for me.

TIA,

John.

|||I would suggest placing the matrix inside a list control. Group the list control by category which will result in a separate matrix being rendered per category. You can then place the category in a textbox above the matrix and also inside the list and center it.|||

Adam,

Mad thanks, that did the trick!!

John.

Formatting PDF (portrait vs. landscape)

When calling a report, in the URL i'm using rs:Format=PDF to render the
report directly to PDF. I'd like the PDF to automatically format the report
in landscape mode.
Is this possible?
Thanks,
BrianFound my answer in the archives.
Thanks.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:euQ%23WDrXEHA.2940@.TK2MSFTNGP09.phx.gbl...
> When calling a report, in the URL i'm using rs:Format=PDF to render the
> report directly to PDF. I'd like the PDF to automatically format the
report
> in landscape mode.
> Is this possible?
> Thanks,
> Brian
>

Formatting partial text

Is it possible to bold a part of the text in the expression? For example, In Crystal, all I have to do is hightlight a word and format it anyway I like and leave the rest of the paragraph alone. So far, I can only use ucase("test"). I need something like bold("test") to work.
ThanksNot in the current release.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Le Toan" <Le Toan@.discussions.microsoft.com> wrote in message
news:B05D245D-BCEC-4EBF-8DBA-AC5240288BA3@.microsoft.com...
> Is it possible to bold a part of the text in the expression? For example,
In Crystal, all I have to do is hightlight a word and format it anyway I
like and leave the rest of the paragraph alone. So far, I can only use
ucase("test"). I need something like bold("test") to work.
> Thanks

Formatting part of a text box

hey all,

does anyone know of a way to format part of a text box in sql reporting services 2005? i am creating a form letter and need to concatenate static text with a column and need just the column value to be bold. like this:

"This letter is confirmation that Acme Agency has been chosen..."

my expression to build this is:

="This letter is confirmation that " + Fields!agency_name.Value + " has been chosen..."

Is there a way to apply formatting just to Fields!agency_name.Value ?

thanks!

jen

Sorry, this is currently not supported.

-- Robert

|||Unable to format individual words within a text is avoiding us to totally move from Business Objects and Crystal Reports to SSRS. Is there a workaround or is it expected in a future release?

Thanks,

Jeroen van der Wal
BI Consultant

|||

It is on the list for a future release. You might want to check out related threads on the SSRS 2008 forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

-- Robert

Formatting part of a text box

hey all,

does anyone know of a way to format part of a text box in sql reporting services 2005? i am creating a form letter and need to concatenate static text with a column and need just the column value to be bold. like this:

"This letter is confirmation that Acme Agency has been chosen..."

my expression to build this is:

="This letter is confirmation that " + Fields!agency_name.Value + " has been chosen..."

Is there a way to apply formatting just to Fields!agency_name.Value ?

thanks!

jen

Sorry, this is currently not supported.

-- Robert

|||Unable to format individual words within a text is avoiding us to totally move from Business Objects and Crystal Reports to SSRS. Is there a workaround or is it expected in a future release?

Thanks,

Jeroen van der Wal
BI Consultant

|||

It is on the list for a future release. You might want to check out related threads on the SSRS 2008 forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

-- Robert

Formatting part of a text box

hey all,

does anyone know of a way to format part of a text box in sql reporting services 2005? i am creating a form letter and need to concatenate static text with a column and need just the column value to be bold. like this:

"This letter is confirmation that Acme Agency has been chosen..."

my expression to build this is:

="This letter is confirmation that " + Fields!agency_name.Value + " has been chosen..."

Is there a way to apply formatting just to Fields!agency_name.Value ?

thanks!

jen

Sorry, this is currently not supported.

-- Robert

|||Unable to format individual words within a text is avoiding us to totally move from Business Objects and Crystal Reports to SSRS. Is there a workaround or is it expected in a future release?

Thanks,

Jeroen van der Wal
BI Consultant

|||

It is on the list for a future release. You might want to check out related threads on the SSRS 2008 forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

-- Robert

sql

Formatting Parameter Values

I want to enter part of a parameter value as an expression similar to
formatting a global fields e.g. Format(Globals.ExecutionTime, "D").
My parameter is returning XXXX 2006, but I only want the year part of
the parameter passed to the expression.
Can this be done.?If it's a date, then =Datepart(DateInterval.Year, Parameters!myParm.Value)
or you could do the following:
=DatePart(DateInterval.Year,
DateTime.Parse(Parameters!myParam.Value.ToString()))
You could also do this:
=Parameters!myParam.Value.ToString().SubString(4,4) /* assuming 0-based
strings */
"Andy" <andy.williams1971@.ntlworld.com> wrote in message
news:1152626782.474747.226720@.35g2000cwc.googlegroups.com...
>I want to enter part of a parameter value as an expression similar to
> formatting a global fields e.g. Format(Globals.ExecutionTime, "D").
> My parameter is returning XXXX 2006, but I only want the year part of
> the parameter passed to the expression.
> Can this be done.?
>|||This worked a treat!
Thanks
Tim Dot NoSpam wrote:
> If it's a date, then =Datepart(DateInterval.Year, Parameters!myParm.Value)
> or you could do the following:
> =DatePart(DateInterval.Year,
> DateTime.Parse(Parameters!myParam.Value.ToString()))
> You could also do this:
> =Parameters!myParam.Value.ToString().SubString(4,4) /* assuming 0-based
> strings */
> "Andy" <andy.williams1971@.ntlworld.com> wrote in message
> news:1152626782.474747.226720@.35g2000cwc.googlegroups.com...
> >I want to enter part of a parameter value as an expression similar to
> > formatting a global fields e.g. Format(Globals.ExecutionTime, "D").
> >
> > My parameter is returning XXXX 2006, but I only want the year part of
> > the parameter passed to the expression.
> >
> > Can this be done.?
> >|||No worries. Remember that [almost] whatever you can do in VB.NET, you can
do in RS...
-Tim
"Andy" <andy.williams1971@.ntlworld.com> wrote in message
news:1152630530.714237.206660@.h48g2000cwc.googlegroups.com...
> This worked a treat!
> Thanks
>
> Tim Dot NoSpam wrote:
>> If it's a date, then =Datepart(DateInterval.Year,
>> Parameters!myParm.Value)
>> or you could do the following:
>> =DatePart(DateInterval.Year,
>> DateTime.Parse(Parameters!myParam.Value.ToString()))
>> You could also do this:
>> =Parameters!myParam.Value.ToString().SubString(4,4) /* assuming 0-based
>> strings */
>> "Andy" <andy.williams1971@.ntlworld.com> wrote in message
>> news:1152626782.474747.226720@.35g2000cwc.googlegroups.com...
>> >I want to enter part of a parameter value as an expression similar to
>> > formatting a global fields e.g. Format(Globals.ExecutionTime, "D").
>> >
>> > My parameter is returning XXXX 2006, but I only want the year part of
>> > the parameter passed to the expression.
>> >
>> > Can this be done.?
>> >
>

FOrmatting Paramater Dates

More Begin and End dates, I have the following
=Parameters!BEG.Value &" through "& Parameters!END.Value
Its giving me date + time. How can I format this to remove the time?Try this one
=FormatDateTime(Parameters!BEG.Value,2) & " through " &
FormatDateTime(Parameters!BEG.Value,2)
--
Do you really need to print that email?
"BLAW" wrote:
> More Begin and End dates, I have the following
> =&" through "& Parameters!END.Value
> Its giving me date + time. How can I format this to remove the time?
>|||that did it, thanks!