Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to get SSRS Reports data in Excel Sheet Sequentially..? Expand / Collapse
Author
Message
Posted Wednesday, March 06, 2013 11:00 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, October 28, 2013 2:48 AM
Points: 64, Visits: 367
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 want

1 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
Post #1427775
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse