I am creating a report that I want to be able to show late shipments. All of the fields I am working with are datetime fields. I want to be able to highlight, change the font color, or add a field that will show the user which items were late. So if my ShipDate was greater than my PromiseDate I want it flagged some way. Because these are currently datetime fields, I may get some showing flagged as being late when the shipdate was the same date as the promisedate because of the time field.
I will then want to sum these fields up some how to come up with an on time percentage.
What is the easiest way for me to do this? Is it easier to enter this in the sql query or do it in an expression under the field properties?
I'm using Visual Studio 2012