reporting services - SSRS Format to display as percent -

reporting services - SSRS Format to display as percent -

i've gone through quite few examples on here , apologize if i'm asking repeat question, far can tell, not.

i have ssrs study made shows gross sales aspects of our sales departments. broken down, in row, "cost, gross profit, gross turn a profit %, order count, total sales." columns aspects of our sales. web sales, phone sales, etc....

in tablix can format text box display results numbers, can see, have percentage , count in there. don't know how format within context of original text box format. know have shows under there number already, how handle getting percentage show percentage , count show count?

for example, percentages show as, "$0.35" , various other numbers follow form. count's appear currency too.

i've used illustration found on here, "=iif ( me.value = floor ( me.value ) , "0%" , "0.00%" )," did create showed in column, "0.00%" new ssrs , have been cramming consistently past 2 weeks, cannot find help on this. give thanks in advance can offer.

update: =iif(fields!lvs_web.value=0.00, "0%", format(fields!lvs_web.value, "p"))

that worked... degree, percent.... thinking else here don't know how else goes in, i've not 1 time seen word else.

update 2: thing i've noticed in statement, says, "=0.00, "0%"," doesn't apply. i've set there because i'm new , needed argument involved. took 0% , changed n under status number < .99, hopeing grab of decimals fell below value of 1. like, "$.23", later became 23.45%, that, don't udnerstand made else, "n," instead of number. why that? doesn't create else, "p?"

i'm losing damned mind.

there fact info beingness pulled stored procedure, don't know much quite yet, assigned simple tasks ever stepping stool learning. don't know query was, couldn't edit if wanted to. can done look formatting look broad, mixed results using greater or less than, , it's not wisest thing utilize since these numbers not set in stone. day done, i've made very little progress, had lunch. success.

so provided own reply problem, , works. me. tried help me , did help well. appreciate effort strangers set out each other.

i've had new problem develop, need display time relative info beingness pulled. can set in there , today's date, if pulling info feb, may little off-put current date. i'll figured out soon, if can help in meantime, appreciate it.

a standard principle separate info display, utilize value property store info in native info type , utilize format property display how want. rather utilize look formatting value property such =format(fields.somefield.value, "0.00%") leave value =fields!somefield.value , set format property p2.

this of import when exporting study excel because if have right info type info export excel right info type. if utilize format function export text, making sorting , formula not work properly.

the easiest thing command formatting utilize standard numeric formats. click on cell or range of cells want have format , set format property. format specifier letter followed optional digit precision (number of decimal places). useful ones are:

c currency 2 decimal places (by default)

n4 number 4 decimal places

p0 percentage no decimal places

click on link above total list. format number cells numbers , percents percents - don't need seek create 1 format string fit every cell.

these standard numeric formats respect regional settings. should set report's language property =user!language utilize user's regional settings rather study server's.

reporting-services formatting report ssrs-2008-r2