Export SSRS to Microsoft Excel without any headers

1055875 pts.
Tags:
Microsoft Excel
SSRS
I have a SSRS report that I need to export to Microsoft Excel. But here's the kicker - my header that's on the first page of the report has to be removed from Excel. How can I do that?

Answer Wiki

Thanks. We'll let you know when a new response is added.

As a solution I removed the default header and added a rectangle with textboxes for the heading information. I gave this new rectangle a ‘Add page break after’ option. The screenoutput gives headerinfo on the first page and data on the following pages. When exporting to excel it gives the new header on the first sheet and de clean data on the second sheet. This works for us.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Check out the older post from the forum here.
    It may answer your question 

    92,960 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: