I assume you have no version control at your workplace? If not, I strongly suggest you implement it, as it will solve issues like this in a flash.

As for restoring...

I'm not sure why you have SUM's in your current expression, as the sample data you've provided is a single line. Therefore you're summing a single number, which always results...

You haven't accidentally changed your configuration at all have you? Each configuration will have a different TargetServerURL, so if you changed from Release to Debug, for example, you may not...

When entering the credentials, are you using a Windows Login? If so, you'll need to ensure that you tick the box that states you're using that (See screen below from...

Duplicate, Responded on other topic: http://www.sqlservercentral.com/Forums/Topic1787217-150-1.aspx

This is because SSRS, by default, doesn't export CSV's in unicode, but in ASCII.

You'll need to locate Report Services Configuration file, and then amend/add the render type. For example, on...

You can do this, yes, but the two domains will need to have trust between each other, so that you can authenticate still.

Access the SSRS portal, and hover over the...

I correct my previous post, but repasted:

=IIf(DateDiff("d",Fields!LastDiffBackupDate.Value, Today()) < 2,"Green", IIf(Fields!LastDiffBackupDate.Value is Nothing,"Transparent","Red"))

The less <2 is from...

You're almost there, but not quite. You have nest the iif's, so it would become:

=IIf(DateDiff("d",Fields!LastDiffBackupDate.Value, Today()) < 2,"Green", IIf(Fields!LastDiffBackupDate.Value is Nothing,"Transparent","Red"))

Phil Parkin (5/11/2016)

---

Thom A (5/11/2016)

---

Will the columns always be the same amount, for example Columns A through to J? If so, you can set the sheet name to;

[Sheet1$A2:J] This will...

Will the columns always be the same amount, for example Columns A through to J? If so, you can set the sheet name to;

[Sheet1$A2:J] This will make SSIS select all...

sindhupavani123 50704 (5/10/2016)

---

Hi Thom,

Thanks for your reply!

But my question is not averaging on a single column, if I understand it correct,

The data in report is something like this

IDSeller ...

Add a total's row to you table. You can do this by right clicking one of the cells with your data in and clicking Add Total. SSRS will automatically add...

Are the number actually integers or do they have some decimal places? If might be worth...