Wrox Programmer Forums
|
Reporting Services SQL Server Reporting Services. Please specify which version.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Reporting Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 15th, 2006, 09:00 PM
Registered User
 
Join Date: Oct 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Export to excel

hi, i have one question. when i export my data to excel, it shows the data in a lot of sheets. if i just want the data shows in one sheet, what should i do? can anyone reply me? thanks!

 
Old November 20th, 2006, 08:42 PM
Registered User
 
Join Date: Nov 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I use this method to display Two tables in Two different Sheets of Excel. Do you have Two tables/matrix in your report. If you have Two items and you changed it's property "PageBreakAtStart/PageBreakAtEnd" to flase, It doesn't display in different sheets. I hope it may help you.

Ramsk






Similar Threads
Thread Thread Starter Forum Replies Last Post
Export Excel abdou Classic ASP Basics 6 February 18th, 2007 09:18 PM
export to excel roy_mm Reporting Services 0 September 2nd, 2006 11:53 PM
Export to Excel using C# lily611 Crystal Reports 2 July 23rd, 2006 10:23 AM
excel export msrnivas Classic ASP Components 0 June 9th, 2004 10:15 PM
excel export msrnivas .NET Web Services 1 March 29th, 2004 03:21 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.