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 |
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
 Posted - 2008-07-21 : 00:59:43
|
| We have some reports which are only meant to be exported to excel (ie not displayed on the screen or printed). Is it possible to have a report paramter or a url query param which will cause the report to open straight to an excel export rather than displaying the report? |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-21 : 01:00:34
|
| The reports are being called from an ASP.net app using the report viewer. |
 |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-21 : 01:15:30
|
| Another related question - is there some run-time variable which knows/indicates whether the report is being exported or displayed on-screen? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-21 : 06:36:46
|
quote:
Originally posted by dexter.knudson
We have some reports which are only meant to be exported to excel (ie not displayed on the screen or printed). Is it possible to have a report paramter or a url query param which will cause the report to open straight to an excel export rather than displaying the report?
Yup. just append rs:Format=Excel to report url to render it as excel. |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
|
|
|
|
|
Excel format parameter