InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 01:20:59 GMT20http://www.sqlservercentral.com/Forums/Topic1427775-1633-1.aspx[size="3"][font="Times New Roman"]Hi All,I am working on ssrs reporting when I Export result data into Excel Sheet then Sr No is mismatching i.e. I want to know is there standared setting in design mode where i can set certain attributes to avoid Excel sheet Row mismatch. Ex Row 4, 6 is just overlap. My below data is correct but what i need is i want all data in SR No. manner i.e. from 1 to n... Below is my excel output where Row no 4 and 6 is overlapped which i dont want1 3/7/2013 2 ABC CLI 3 Despatches From:- 1/1/2013 To 2/13/2013 5 MARKET WISE, PART WISE, SEGMENT WISE REPORT 7 YEARWISE DATA MARKET NAME PART 8 2013 1000 North America HA12 9 2013 1000 North America HA12 10 2013 1000 North America HA12 11 2013 1000 North America HA12 12 2013 1000 North America HA12 Thanks & Regards,Bhushan[/font][/size]Wed, 06 Mar 2013 23:00:42 GMTbhushan_juare