I have 50 columns and 2000 rows for a report.It worked fine with 50 columns.

But when i tried to add 51st column which has length>8000 characters, Report preview getting failed.

Thanks...

Ya i tried that option also. I think Report gives huge amount of records.That is why it is giving error.

Is it may be the problem.

How many columns and rows are...

Hii all..!!

Actually dbo.person structure is

SNo | Name | Age |

and Structure of dbo.Person_exclusion is

| Name_Similar |

My aim is : To Exclude all the names from dbo.person...