We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SSRS report exports to excel file

johnnyaction
johnnyaction asked
on
Medium Priority
1,315 Views
Last Modified: 2012-05-11
Is there anyway when I export my report to excel from Report Manager to a directory on our intranet that I can have the column headers repeat on every page? I also need the column widths to auto size to fit the width of the column data. CAN THIS BE DONE?
Comment
Watch Question

CERTIFIED EXPERT

Commented:
I Googled on
excel autofit ssrs
and I'm afraid there is no way to do the autofit. You'll have to determine the optimal size of the columns in the report. I know that's difficult because the length of the data will change. If the data is just a table you could use something different than SSRS to create the Excel sheet. For example create a button on the sheet that pulls in the data directly from SQL Server and then autfits the columns.

About saving to the intranet. You'll get a Windows "Save As" dialog. If there is no way to save to the Intranet folder from Windows, than it also can't be done from Report Manager. You'll have to save it first, and then upload it to the Intranet.
You could create a script that runs on the server and saves the report as Excel in the right folder. If your intranet is IIS this isn't too difficult.
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
FYI, I used the script task in the SSIS package

Author

Commented:
thanks
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.