formatting using style sheet

can style sheet classes be implemented in report parameter section?
How to include stylesheet files?
Let me know how to do it?
ThanksVV wrote:
> can style sheet classes be implemented in report parameter section?
> How to include stylesheet files?
> Let me know how to do it?
> Thanks
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm

Formatting Date/Time

What do I have to use to Format my date/time fiels so that they will not include the both the date and the time? I imported the db's and reports from access and anything date/time shows both. The VBA functions I know are powerless to fix this.

So:
Format(fields!DateField, 'hh:mm') ?
Format(fields!DateField, 'ddmmyyy') ?

What are the equivalents? Yes, I read the manual. Still not obvious to me.

- Thanks in advance.

Format is the VB.NET Format function (see e.g. http://msdn2.microsoft.com/en-us/library/59bz1f0h(vs.80).aspx). The following expression should work for you (note: you have to use double quotes not single quotes for the format string):
=Format(Fields!DateField.Value, "hh:mm")

Additional information about datetime format strings is available here:
* http://msdn.microsoft.com/library/en-us/cpguide/html/cpconcustomdatetimeformatstrings.asp
* http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcondatetimeformatstrings.asp

-- Robert

|||Thank you Robert. This works in my .rdl reports. I also want to apply Format to a Parameter which uses a query. I tried to code Format into my SQL as I would with VBA/Jet SQL and it's not working. How can I apply Format to my SQL output or Parameters?|||

Please check the TSQL documentation on the Cast and Convert functions:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp

-- Robert

Formatting a Subscription Comment

I have looked everywhere for an answer for this one, so if it's out there and I've missed it, sorry.

I want to include a list of instructions with a report that I am sending out to a list of subscribers (not Data Driven, each is an individual subscription). It seems no matter how I enter the text in the Comments box, the body of the email comes out as a continuous stream of text with no line breaks, which is difficult for the recipients to read.

Is there a way to embed line breaks as a minimum, but preferrably additional formatting, in a subscription comment?

Thanks

Trevor

Trevor,

Did anyone answer this? I have the same question.

Thanks.

MC

Formatting a Subscription Comment

I have looked everywhere for an answer for this one, so if it's out there and I've missed it, sorry.

I want to include a list of instructions with a report that I am sending out to a list of subscribers (not Data Driven, each is an individual subscription). It seems no matter how I enter the text in the Comments box, the body of the email comes out as a continuous stream of text with no line breaks, which is difficult for the recipients to read.

Is there a way to embed line breaks as a minimum, but preferrably additional formatting, in a subscription comment?

Thanks

Trevor

Trevor,

Did anyone answer this? I have the same question.

Thanks.

MC

Format Currency - values include NaN

Hi, my report includes a calculated column which I wish to display as
currency.
Unfortunately, some of the calculated values are non-numeric. My report
shows these values as 'NaN'. I would like to display something a bit more
meaningful to the user such as '-'. Is there a way of doing this?Nic wrote:
> I would like to display
> something a bit more meaningful to the user such as '-'. Is there a
> way of doing this?
Write a piece of custom-code like this:
Function CheckValue(value as object) as object
If isnumeric(value) Then
Return FormatCurreny(value)
Else
Return "This is no numeric value"
End If
End Function
and put an expression in the field like:
=code.CheckValue(Fields!MyField.Value)
Maybe you have to play with field-property..i assumed "Standard"
regards
Frank
www.xax.de|||Frank,
Thanks for the information. However, I tried the function you suggested and
the isnumeric function appears to return true for those values which are NaN.
In any case, my report still contains NaN values, which have not been
replaced by the 'This is no numeric value' message. I know that the function
is being used, and I can change what is displayed by changing what is
returned when the isnumeric function is evaluated as true.
Any suggestions?
"Frank Matthiesen" wrote:
> Nic wrote:
> > I would like to display
> > something a bit more meaningful to the user such as '-'. Is there a
> > way of doing this?
> Write a piece of custom-code like this:
> Function CheckValue(value as object) as object
> If isnumeric(value) Then
> Return FormatCurreny(value)
> Else
> Return "This is no numeric value"
> End If
> End Function
> and put an expression in the field like:
> =code.CheckValue(Fields!MyField.Value)
> Maybe you have to play with field-property..i assumed "Standard"
> regards
> Frank
> www.xax.de
>
>
>|||Hi,
I have done a bit more investigation, and have come up with the following,
which seems to work. I would dearly like to know whether this can be
simplified, Franks suggestion seems neater, but I cannot get it to work - any
ideas why?
Function CheckValue(value as object) as object
If IsNum(value) Then
Return FormatCurrency(value)
Else
Return "-"
End If
End Function
Function IsNum(value as object) as boolean
Try
Decimal.Parse(value)
Return True
Catch
Return False
End Try
End Function
"Nic" wrote:
> Frank,
> Thanks for the information. However, I tried the function you suggested and
> the isnumeric function appears to return true for those values which are NaN.
> In any case, my report still contains NaN values, which have not been
> replaced by the 'This is no numeric value' message. I know that the function
> is being used, and I can change what is displayed by changing what is
> returned when the isnumeric function is evaluated as true.
> Any suggestions?
> "Frank Matthiesen" wrote:
> > Nic wrote:
> >
> > > I would like to display
> > > something a bit more meaningful to the user such as '-'. Is there a
> > > way of doing this?
> >
> > Write a piece of custom-code like this:
> >
> > Function CheckValue(value as object) as object
> > If isnumeric(value) Then
> > Return FormatCurreny(value)
> > Else
> > Return "This is no numeric value"
> > End If
> > End Function
> >
> > and put an expression in the field like:
> > =code.CheckValue(Fields!MyField.Value)
> >
> > Maybe you have to play with field-property..i assumed "Standard"
> >
> > regards
> >
> > Frank
> > www.xax.de
> >
> >
> >
> >
> >

Format currency - include commas to separate per 1000 multiples?

I'm using F to format currency (UK sterling) to 2 decimal places. Is it
possible to include commas to separate 1000 multiples - e.g. 5,000,000
--
FionaDMThis article should help http://msdn2.microsoft.com/en-us/library/0c899ak8(VS.80).aspx
Put something like this in the Layout / Properties / Format box (I'm
using the US Dollar sign - you would put the UK pound sign in the
appropriate place instead):
$#,##0.00;($#,##0.00);Zero
If the value were 10000 you would see: $10,000.00
If the value were .5 you would see: $0.50
If the value were -500.05 you would see: ($500.05)
If the value were 0 you would see: Zero
- C
On Oct 3, 8:07 am, FionaDM <Fion...@.discussions.microsoft.com> wrote:
> I'm using F to format currency (UK sterling) to 2 decimal places. Is it
> possible to include commas to separate 1000 multiples - e.g. 5,000,000
> --
> FionaDM|||Perfect!
--
FionaDM
"Cindy Parker" wrote:
> This article should help http://msdn2.microsoft.com/en-us/library/0c899ak8(VS.80).aspx
> Put something like this in the Layout / Properties / Format box (I'm
> using the US Dollar sign - you would put the UK pound sign in the
> appropriate place instead):
> $#,##0.00;($#,##0.00);Zero
> If the value were 10000 you would see: $10,000.00
> If the value were .5 you would see: $0.50
> If the value were -500.05 you would see: ($500.05)
> If the value were 0 you would see: Zero
> - C
> On Oct 3, 8:07 am, FionaDM <Fion...@.discussions.microsoft.com> wrote:
> > I'm using F to format currency (UK sterling) to 2 decimal places. Is it
> > possible to include commas to separate 1000 multiples - e.g. 5,000,000
> > --
> > FionaDM
>
>