By no means elegant and I have not tested this with any other data than what you have provided but it does give you the expected results based on what...

I have had a quick look at this and need to ask:

Your desired output

YYY Ret1 35

YYY 25

Where and...

=format(Globals!ExecutionTime,"MMM dd,yyyy - HH:mm tt")

That should do the trick

A quick search of google threw up this:

http://support.microsoft.com/kb/913384

Have you tried this? If so, could you detail what you have tried please?

This is normal behaviour. I have just tried this and removed the sum, what you get is basically the first value it comes across in the dataset.

However,...

Only way I can think of is:

Assign the dataset in question to a tablix.

Set Row Group to Flag2 field.

Filter the tablix on the value you want to see (SD)

Put in...

examples below:

=First(Fields!AField.Value, "DataSet3")

=Sum(Fields!ANotherField.Value, "DataSet3")

looking at your expression though I honestly don't think you can get that to work as you asking it to take an average if something equals SD...

Do you by chance have a grouping set up on the tablix?

Are the parameters for the report pre-filled? If so, the queries which support those how are they performing?

the above question aside, based on what you asked for the following appears to work

=format(int(ReportItems!MyDecimalTotal.Value) + int(round(reportitems!MyDecimalTotal.value mod int(reportitems!MyDecimalTotal.value),2)*100)/60,"000") + " hours " + format(round((ReportItems!MyDecimalTotal.Value - int(ReportItems!MyDecimalTotal.Value))*100,0) mod 60,"00") +...

How is this stored in your DB? Are hours and minutes separate columns as there may be an issue with summing up values in this way?

free_mascot (3/20/2014)

---

SQL Agent job if you cancelled than it will show as cancelled only. If it failed it will show as failure. Now if you would like to have cancelled...

We do it this way with no problems:

Have an ftp program sitting on the server somewhere (we use psftp)

Have a script task script out the FTP commands we want to...

having a quick look I can't see how your update queries will work but that said:

If there is more than one entry in Table 1 how do we identify what...

Actually this way seems to work also

DECLARE @Client_Domains TABLE

(

Client_VndName NVARCHAR(100) ,

Client_Type NVARCHAR(100) ,

...