Display percentage % field and format -- sql server reporting services

sql server reporting services : Display percentage % field and format

danniliao NO[at]SPAM yahoo.com
8/23/2004 11:56:05 AM

Hi,

In the group footer I want to show:

Total store with ABC systems is: 33% of Total stores

33% is a calculated field.

The expression for this is:
"Total store with ABC systems is: " & =Fields!A1.Value/Fields!B1.Value
& " of Total stores"
I merged 3 cells and put this expression is in one text box, this
output would be:
summary 0.33333333333 of Total stores

So I split the cell into three:
in first cell: Total store with ABC systems is:

in second cell: =Fields!A1.Value/Fields!B1.Value (format set to p0)

in third cell: of Total stores

but the width of percentage field is limited by the table column, so
the 33% would be either too far from the first cell or from the third
cell.

What can I do to concatenate them into one line without too much
space?

Thanks in advance.

Ravi Mumulla (Microsoft)
8/23/2004 1:04:51 PM

Try this: ="Percentage is " &
Format((Fields!A1.Value/Fields!B1.Value)/100.0, "p") & " of Total stores"

--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view]

bmurtha
8/23/2004 6:37:03 PM

Or you could leave out the /100.0 and go to
Properties => Format => enter p2 for percent with a matissa of 2 places.

Bryan

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn