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 |
|
JStandard
Starting Member
3 Posts |
 Posted - 2006-04-10 : 17:50:14
|
| Greetings,I have a Report with a Table Object in it that is tied to a particulardataset ( a query). I have a date parameter for the query, so the user canview the dataset over different periods.If a user runs the report and the query returns no rows, the report willsimply show a the headers/footers and no data in the detail section. This isfine, but when I export the report to Excel, it removes the header/footerfrom the export and simple exports nothing.The Question: Is there any way I can I set the report to show the headersand footers of the empty table when I export the report to Excel?Thanks kindly,- Jeff |
|
|
|
|
|
Tables with 0 Detail Rows Do not Export to Excel