How to get SSRS Reports data in Excel Sheet Sequentially..?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Development » How to get SSRS Reports data in Excel Sheet...

How to get SSRS Reports data in Excel Sheet Sequentially..?

Rate Topic

Display Mode

Topic Options

Author

Message

bhushan_juare

Posted Wednesday, March 06, 2013 11:00 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:14 AM
Points: 62, Visits: 358

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 »

Permissions