CODEWITHSUNDEEP
excelreporting-services
Ugur
Ugur

Reputation: 31

Reporting Services - Export Data to Excel In Only One Sheet

I'm using SSRS 2005. In my report, I'm getting data to a table with paging(use with grouping). It's ok. But when I export data to Excel file, RS divide data within multiple sheet.

How can I get data in only one sheet while exporting to Excel?

Upvotes: 3

Views: 7810

Answers (5)

Jayvin
Jayvin

Reputation: 56

This works for me:

=IIF(Globals!RenderFormat.Name = "EXCELOPENXML", True, IIF(RowNumber(Nothing) mod 30=0,False,True))

It does page break after 30 rows and disables page breaks when report is getting exported to Excel!

Upvotes: 0

Ceylan B.
Ceylan B.

Reputation: 572

If you want to do paging with using page breaks and also want to disable paging on excel, follow these steps;

  1. Go to Tablix Member properties
  2. PageBreak -> BreakLocation : End

  3. PageBreak -> Disabled : =IIF(Globals!RenderFormat.Name="EXCELOPENXML",True, IIF(rownumber(nothing) mod 50=0, false, true))

    enter image description here

Upvotes: 2

Santosh
Santosh

Reputation: 31

Write the following expression to disable the page-break during export to excel :- 

IIF(Globals!RenderFormat.Name = "EXCEL",TRUE,FALSE)

Upvotes: 3

David Robbins
David Robbins

Reputation: 10046

You may want to check out Aspose, a commercial rendering extension engine for SSRS. We've used it for exporting reports to Word with Korean characters and it works great. They provide good support as well.

Upvotes: 0

Peter Radocchia
Peter Radocchia

Reputation: 11007

It can't be done. Remove the page breaks, or live with it.

Upvotes: 0

Related Questions