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 12»»

Exporting to excel Expand / Collapse
Author
Message
Posted Monday, July 23, 2012 2:56 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 12:48 PM
Points: 135, Visits: 286
How do I get my report to filter data by tabs when it is exported to excel?
Post #1334093
Posted Tuesday, July 24, 2012 3:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 8, 2014 1:45 AM
Points: 5,221, Visits: 5,120
You would need to insert a page break in the report, that way when it renders to excel it will but what ever is between the page brakes in a new workbook.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1334322
Posted Wednesday, July 25, 2012 7:29 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 12:48 PM
Points: 135, Visits: 286
How do I add the page breaks?
Post #1335098
Posted Wednesday, July 25, 2012 7:33 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 12:48 PM
Points: 135, Visits: 286
I found it here thanks http://technet.microsoft.com/en-us/library/dd207058(v=sql.105)
Post #1335105
Posted Wednesday, July 25, 2012 3:04 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 12:48 PM
Points: 135, Visits: 286
Now i am trying to get the tab name of each work sheet to display the name of the group for the page break. Any ideas?
Post #1335444
Posted Thursday, July 26, 2012 7:23 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 11:56 AM
Points: 317, Visits: 1,529
SSRS 2005 doesn't appear to have a way to name excel worksheets.

SSRS 2008 R2 can name Excel worksheets when a report is exported -- see Robert Bruckner's blog post:
http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx



Post #1335828
Posted Thursday, July 26, 2012 7:58 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 12:48 PM
Points: 135, Visits: 286
Thanks. I found the way to name the worksheet tabs by setting the page break expression.

The problem now is is the column headers do not show on each page although i have the tablix property for column headers to repeat across each page in report builder 3.0. Any ideas?
Post #1335856
Posted Friday, July 27, 2012 10:36 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:57 AM
Points: 2,112, Visits: 3,712
jdbrown239 (7/26/2012)
Thanks. I found the way to name the worksheet tabs by setting the page break expression.

The problem now is is the column headers do not show on each page although i have the tablix property for column headers to repeat across each page in report builder 3.0. Any ideas?


Ran into that myself today - there's instructions here
Not exactly obvious!
Post #1336643
Posted Monday, July 30, 2012 7:50 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 12:48 PM
Points: 135, Visits: 286
Thanks for the tip. When I changed the 'Repeat on each page' for the static column I got this error when I tried to preview the report.

The tablix 'Tablix1' has an invalid TablixMember. All TablixMember elements in a TablixColumnHierarchy must have the RepeatOnNewPage property set to false.
Post #1337242
Posted Wednesday, August 1, 2012 10:56 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:57 AM
Points: 2,112, Visits: 3,712
Yeah, I did the same!
It's actually the Row Group you need to set it on.
Think the KeepWithGroup option needs to be set too for it to work.
Post #1338682
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse