Hai
Iam using sql server reporting services 2005. I need to export report to excel in a single worksheet not in multiple. currently it splits and shows three work sheet after export in excel format (iam using subreports combination)
wait for your precious suggestion
Regards
Senthil
Explicit page breaks on objects will create new worksheets when rendering to Excel. The only way to prevent multiple worksheet tabs in Excel is to remove the page breaks.
-Chris
No comments:
Post a Comment