Nope, I understood that the columns were varchars, hence the StrToTimeSpan function. What I didn't get was that the totals would be summing of the various time units rather...

SSRS doesn't really have a native timespan type. You can achieve your goal using custom functions though. I came up with this so far.

Function StrToTimeSpan(a As String) As...

I believe that last piece of advice would relate to the .NET ReportViewer control and isn't related to the ReportManager.

I also do not believe you are allowed to use a...

Test.png? Does that have transparency in it? Try saving the image as a gif (you can keep transparency in gifs, I used Gimp).

I didn't spot that, I've had...

Hi Kazmerelda,

There are two ways of approaching this (excluding doing it in the datasource).

You can use the Lookup function, which essentially works like an Excel vlookup against the dataset. ...

I don't believe ODBC Source in SSIS allows parameter mapping. You can dynamically create the SQL command using the expression editor on the [ODBC Source].[SqlCommand] property of the Data...

Do these databases get generated new or overwritten or something?

If they don't, could you not create a standard named view in each database that your package can read?

Hi Kaz,

Unfortunately there aren't any easy ways of doing this in purely in SSRS, the best way is to do the calculation in the data source.

Are you using a...

I set up a client to use Mandrill before. The issue was that SSRS cannot be set up to use basic authentication to connect to a mail server. ...

I mostly work with multidimensional but since no one else has answered. From an OLAP standpoint your design is absolutely correct, do not think about changing it or mixing...

That doesn't make sense based on how you are parsing it. You are adding the slashes in yourself. If the output of your expression is 2016/02/11 09:56:15 then...

What is the format of the date (ReceivedOn) before you parse it?

To the best of my knowledge this is not possible via Email subscriptions. Only File Share delivery allows you to set the file name.

Are you on Enterprise Edition? If so this would be a job for Data Driven subscriptions.

Bit of a tricky one. An idea might be to use the ReportFolder global as the parameter value to determine the country it is running for from the folder...