Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hxm88311
Starting Member
2 Posts |
 Posted - 2008-07-10 : 16:14:24
|
| Hi, I'm very new to SQL Report Services. Currently, I'm using the SQL Business Intelligence Development Studio. I'm trying to export reports to excel with Report Viewer. Is Report Viewer a separate software that I need to purchase?Another question is, if I export the report to excel, will the exported data retain the same formatting and structure when put into excel?Thank you!Shell |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-10 : 21:31:47
|
| You don't need to use Report Viewer separately unless you want to call your reports from an application (eg web or winforms).You should be able to export to excel from within the Business Intelligence Dev Studio. When you want users to see your reports, you "Deploy" them or "Upload" them to a Report Server. An excel export changes the data slightly. It removes pagination (ie no page footers & headers) & it creates some additional rows to cater for any objects you have on your page besides tables. Other than that it's quite similar. |
 |
|
|
|
|
|
Report Viewer