How to display a time span of seconds in hh:mm:ss format in Reporting Services

reporting-servicesssrs-2008time

In MS Reporting Services 2008, I have a field that is a duration stored as seconds. Is there a slick way to get it into hh:mm:ss format in a group section of the report?

Best Answer

If you just want to display it, convert in an expression for the Value of the textbox:

=Format(DateAdd("s", Fields!MySecondsField.Value, "00:00:00"), "HH:mm:ss")

If you want to do calculations on it, convert the seconds to a DateTime in your dataset. Using SQL:

SELECT DATEADD(ss, MySecondsField, '1900-01-01') AS SecondsAsDateTime
FROM TimeTable

In Linq this would be something like:

var qry = from Q in t.TimeList
    select new
    {
        SecondsAsDateTime = DateTime.Today.AddSeconds(Q.MySecondsField) 
    };

Then you can just format it as a normal DateTime.

Related Solutions

Python – How to get the current time in Python

Use:

>>> import datetime
>>> datetime.datetime.now()
datetime.datetime(2009, 1, 6, 15, 8, 24, 78915)

>>> print(datetime.datetime.now())
2009-01-06 15:08:24.789150

And just the time:

>>> datetime.datetime.now().time()
datetime.time(15, 8, 24, 78915)

>>> print(datetime.datetime.now().time())
15:08:24.789150

See the documentation for more information.

To save typing, you can import the datetime object from the datetime module:

>>> from datetime import datetime

Then remove the leading datetime. from all of the above.

Conditional Formatting in SQL Reporting Services 2008

Use the FontWeight property of the field, and set it to an expression like this:

=iif(Fields!YourTestField.Value="Y","Bold","Default")

You can find FontWeight in the properties pane for the report item, or under Font -> Style -> Bold in the properties dialog (right click -> properties). Use the f(x) button to edit the formula.

Best Answer

Related Solutions

Python – How to get the current time in Python

Conditional Formatting in SQL Reporting Services 2008

Related Topic