The issue you're facing is that subtracting dates returns a timespan, not an int or a date. As you have discovered, the format function doesn't work with timespans.

You could investigate...

That's it....

SELECT

[Catalog].Name,

Report_OID, LastRunTime, SubscriptionID

FROM Subscriptions inner join [Catalog] on

Report_OID = ItemID

WHERE InactiveFlags = 0

Looks like, match subscription report_oid with catalog.itemid? I'm off to a meeting....let me know if you get...I'll play around with it also

Try:

=formatdatetime(Fields!TimeFrom.Value) & " - " & formatdatetime(Fields!TimeTo.Value)

You may have to play with the optional 'type' parameter to get it just right....

Are you getting an error?

IsEmpty doesn't check for null...

from BOL:

Dealing with Empty Values in MDX Statements and Cubes

In Multidimensional Expressions (MDX) statements, you can look for empty values and then perform certain calculations on...

I think this will answer your question:

http://msdn.microsoft.com/en-us/library/ms155391(SQL.90).aspx

Maybe this helps:

My Subscriptions Page

Use the My Subscriptions page to view all of your subscriptions in one place. From this page, you can access and modify or delete any subscription...

Would duplicates affect your query? In other words does "support" include duplicate items?

Very nice.

I believe BIDS is included with SSRS. That maybe all you need.

Make sure you are adjusting the "Body" layout size of the report. You may also consider shrinking the table or matrix padding. I've had good luck eliminating blank...

Found this...looks like this feature will be enabled in the next version?

http://www.windows-tech.info/15/c68d1bb05874fdca.php

You can create a simple report based on that query...It's nice to get an idea of your report services utilization.........

If you run the raw sql output, does it show the duplicates? You may need to share your select statement with us....