473,803 Members | 3,899 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Reporting Services - Page Breaks

Hi,
I have developed a report with Page Breaks based on Group in SQL Server
Reporting Services 2000. This report works fine in SQL Reporting Services
showing Page Breaks for different groups.

When i export this report to excel it renders the Page Break as different
Excel WorkSheet. I want to render the report as a single Excel WorkSheet is
the possible?

Thanks!
Prasad

Nov 30 '07 #1
1 7186
On Dec 1, 2:20 am, Prasad Patil
<PrasadPa...@di scussions.micro soft.comwrote:
Hi,
I have developed a report with Page Breaks based on Group in SQL ServerReporting Services2000. This report works fine in SQLReportingSer vices
showing Page Breaks for different groups.

When i export this report to excel it renders the Page Break as different
Excel WorkSheet. I want to render the report as a single Excel WorkSheet is
the possible?

Thanks!
Prasad
hi Prasad

you might want to have a look at this link

http://msdn2.microsoft.com/en-us/lib...01(VS.80).aspx

Hope it helps
cheers
Dianne
Dec 4 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2007
by: Chris | last post by:
Greetings all, I'm hoping someone can recommend a web-based reporting software. My database is currently in MS Access, but could be ported to SQL Server if necessary. Would prefer a broswer independent tool with no plug-in requirements. Would also prefer it to be compatible with existing ASP code (rather than ASP.NET). We don't need on-the-fly query creation, but do want pre-formated quality layouts including headers, footers and...
3
1984
by: Mohammad S Khan | last post by:
I am currently doing some research on reporting features provided / compatible with dotnet features. Our current application has excel reprots that are emailed both with an without scheduling through a web front end that uses coldfusion as well as asp. There are custom vb compnents that generate the data as well as stored procs on a sql 2k servers that produce the data. The requirement is for excel reports and pdf reports, web viewing if...
8
2755
by: Woody Splawn | last post by:
I am asking this question here because I asked this question in the Reporting Services Newsgroup and did not get an answer. Does anyone know if Reporting Services is intended to work in a client/Server or Local machine environment? Based on what I have seen my guess is yes but that is a guess. In some materal it talks about it running on a web server but my supposition is that this does not necessarily mean that it would not make for a...
1
1300
by: LeAnne | last post by:
I've got SQL Server 2000 Developer edition. Now, where can i get the SQL Server 2000 Reporting Serives from for Win XP Pro?? I can't seem to find a link or any page where I could download this or buy this from. I just need a developer edition of SQL 2000 Reporting Services for Windows XP Pro.
0
435
by: rmk | last post by:
How can I get the 2000 and 2005 versions of SQL Server Reporting Services both working on my development laptop ????? I have ASP.NET 1.1 and 2.0 installed on my laptop. I have Visual Studio 2003 and 2005 installed on my laptop. I have my default website configured for ASP.NET 2.0. I have the developer edition of SQL Server 2000 installed on my laptop as
3
1226
by: joeB545 | last post by:
I am an Access developer considering using vb.net 2005 to develop a database application. What options are available for creating reports in vb.net 2005 in the various versions, such as Stardard and Professional? Also, are there third party controls available? -- joe B
3
2903
by: Blasting Cap | last post by:
I'm using VS 2005, SQL 2005 reporting services. SQL reporting services is working, and I have it both on my local computer, as well as on a server. I've created a report in the SQL Business Intelligence development studio that works in that environment. I've uploaded the same report to both the Reporting services on my local computer as well as the server, and can log in to them and run the
0
2597
by: banani | last post by:
Hi Experts, I have couple of questions.. 1) Does anybody know if Reporting Services 2008 will support Rich Text control so that it will interpret html tags? 2) Any idea when Reporting Services 2008 is going to be released? 3) We are using Reporting Services 2005..We have a Matrix report... The problem is the width of the table or the columns do not grow to fit the page. Since the number of the columns is dynamic if it has 2 cols I...
0
9700
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10310
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10292
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10068
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6841
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5498
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4275
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3796
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2970
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.