This is a new feature of SSRS 2008. Check out - http://msdn.microsoft.com/en-us/library/ms143200.aspx

There are two ways to get around this -

1. Ask users to Click "Last Page" button(From 'report...

Yes , the issue seems to be resolved, but in a crude way.

First of all in the example i stated, we need to change format file like this - ...

I guess yes, collation is SQL_Latin1_General_CP1_CI_AS which is database default.

I'll explain the current situation.

This is my table ->

CREATE TABLE [dbo].[Emp](

[EmpID] [int] NOT NULL,

[EmpName] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

) ON [PRIMARY]

This...