I've gone through quite a few examples on here and I apologize if I'm asking a repeat question, as far as I can tell, I am not.
Chapter 23 Exam Questions. The expected frequency of homozygous dominant individuals in the population; p = the frequency of the dominant allele (A); thus p2 represents the frequency of homozygous dominant individuals (AA: p × p = p2). In a large population of bonobos, the frequency of the recessive allele is initially 0.1. The interview was carried out by the television talk show host Maurizio Costanzo, who would also be exposed as a member of P2. Gelli said he was in favour of rewriting the Italian constitution towards a Gaullist presidential system.
I have an SSRS report made that shows gross sales for certain aspects of our sales departments. They are broken down, in row, by 'cost, gross profit, gross profit %, order count, total sales.' The columns are the aspects of our sales. Web sales, phone sales, etc....
In the tablix I can format a text box to display the results as numbers, but as you can see, I have also Percentage and Count in there. I don't know how to format those within the context of the original text box format. So I know I have everything that shows under there as a number already, but how do I handle getting the percentage to show as a percentage and the count to show as a count?
For example, all the percentages currently show as, '$0.35' and various other numbers that follow that form. The count's currently appear as currency too.
I've used an example I found on here, '=Iif ( Me.Value = Floor ( Me.Value ) , '0%' , '0.00%' ),' but all that did was make everything that showed up in that column, '0.00%' I am fairly new to SSRS and have been cramming consistently for the past two weeks, but I just cannot find help on this. Thank you in advance for anything you can offer.
Update:
=IIF(Fields!LVS_Web.Value=0.00, '0%', format(Fields!LVS_Web.Value, 'P'))
That worked... to a degree, but now everything is a percent.... thinking ELSE here but I don't know how ELSE goes in, I've not once seen the word ELSE.
Update 2: The thing that I've noticed is that in the statement, where it says, '=0.00, '0%',' that doesn't even really apply. I've just put that there because I'm new to this and I just needed an argument involved. I took the 0% and changed it to N under the condition that the number was < .99, hopeing I would just catch all of the decimals that fell below the value of 1. Like, '$.23', which later became 23.45%, so I COULD do that, but what I don't udnerstand is it made everything else, 'N,' instead of a number. Why is that? It doesn't make everything else, 'P?'
I'm losing my damned mind.
There is also the fact that this is information being pulled from a stored procedure, I don't really know too much about those quite yet, I get assigned simple tasks ever so often as a stepping stool for learning. I don't really know what the query was, but I couldn't edit it if I wanted to. This can be done with expression formatting but my expression is too broad, but I get mixed results using Greater or Less than, and it's probably not the wisest thing to use since these numbers are not set in stone. My day is almost done, I've made very very little progress, but I had a good lunch. So success.
So I provided my own answer for this problem, and it works. Thanks me. Thanks to all the tried to help me and did help as well. I appreciate the effort strangers will put out for each other.
I've had a new problem develop, I need to display a time relative to the data being pulled. I can put NOW in there and get today's date, but if someone is pulling information from FEB, they may be a little off-put by the current date. I'll probably get this figured out soon, but if anyone can help in the meantime, I would appreciate it.
HinarfHinarf
4 Answers
A standard principle is to separate data from display, so use the
Value
property to store the data in its native data type and use the Format
property to display it how you want. So rather than use an expression formatting the Value
property such as =Format(Fields.SomeField.Value, '0.00%')
leave the Value
as =Fields!SomeField.Value
and set the Format
property to P2
.This is especially important when exporting your report to Excel because if you have the right data type for your data it will export to Excel as the right data type. If you use the
Format
function it will export as text, making sorting and formula not work properly. The easiest thing to do to control the formatting is use the standard numeric formats. Click on the cell or range of cells that you want to have a certain format and set the
Format
property. They are a format specifier letter followed by an optional digit for precision (number of decimal places). Some useful ones are:C
Currency with 2 decimal places (by default)N4
Number with 4 decimal placesP0
Percentage with no decimal placesClick on the link above for the full list. Format the number cells as numbers and the percents as percents - you don't need to try to make one format string fit every cell.
These standard numeric formats also respect regional settings. You should set your report's
Language
property to =User!Language
to use the user's regional settings rather than the report server's.Chris LattaChris Latta
This is what saved me and did what I wanted. There is another error, but it's my bosses fault, so now I get to laugh at him. Thanks everyone.
HinarfHinarf
If the number is already * 100 eg. 9.5 should be shown as 9.5% then use the format:
9.5 -> 9.5%
0.34 -> 0.34%
This way you can use the standard number formatting and just add the % to the end. The escapes the %, preventing the *100 in formatting (which would make 9.5 show 950%.).
Donald WebbDonald Webb
Source:
This is simple to use,
Percent of (the sum of line item totals for the current scope)/(the sum of line item totals for the dataset).This value is formatted using FormatPercent specifying one decimal place.
RAPRAP
Not the answer you're looking for? Browse other questions tagged reporting-servicesformattingreportssrs-2008-r2 or ask your own question.
Green Profits covers two tightly connected topics, environmental management systems (EMS) and pollution prevention (P2), in a single volume. Authored by an environmental engineer and an economist/planner, Green Profits shows how to implement an EMS, especially ISO 14001, so that it leads to profitable pollution prevention innovations, and how to identify and implement pollution prevention measures in a sound strategic business framework. Green Profits provides the knowledge and tools for enterprise managers to achieve the benefits of both EMS and P2, and to do so in ways that fit in with existing management systems in their enterprises. Environmental management systems are planned and organized ways for an enterprise to manage its interactions with the environment, in particular those interactions that consume resources, degrade the environment, and create human health risk. Part I of Green Profits provides a thorough and practical understanding of the elements of EMSs in general and ISO 14001 in particular, tools and techniques for implementing an EMS and achieving ISO 14001 certification, and help with getting the implementation process started. Pollution prevention involves replacing process technologies that generate pollution with those that do not or that do so much less. It focuses on improving production processes to minimize waste rather than treating effluents or emissions, which add to costs. Part II of Green Profits provides tools such as step-by-step guides to conducting a P2 audit and energy and material balances for identifying P2 opportunities in an enterprise; examples of P2 practices in specific industry sectors; and a set of tools for assessing potential P2 investments from a bottom-line point of view. With this New Handbook -- · Bring your facility into compliance · Improve your corporate image · Reduce your company's environmental liabilities · Identify and save millions of dollars from pollution prevention projects This New Handbook Includes -- · A step-by-step approach to implementing ISO 14001 · A step-by-step approach to implementing Pollution Prevention · Contains nearly 100 useful charts and tables used by the experts in establishing environmental action plans, gap analyses, establishing an Environmental Management System · Contains dozens of useful charts and calculation methods with examples for evaluating the costs and savings to your company in implementing Pollution Prevention · Dozens of industry-specific case studies that you can learn and profit from · Shows you in stepwise fashion how project financing principles and environmental cost accounting methods, when coupled with EMS can save your company money This New Handbook is unique because unlike other volumes that separately cover Environmental Management Systems and Pollution Prevention, you have it all in one single volume, written by Experts that are Practitioners.