Page Breaks Need help

I am trying to prepare report in SSRS 2k8 (25000+ recrds) and export it to the EXCEL.
I want this all records in one sheet in EXCEL as output. how could  I acheive this?

Any thoughts are welcome.

health & happiness
parpaa
parpaaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ajn_auCommented:
0
parpaaAuthor Commented:
I was trying to prepare a report which is 2300+ (500000 records) pages in SSRS designer. now am planning to export to EXCEL.
When am trying to do this, it gets failed.

I understand the reason behind it, may be because the excel fails to create new sheets. may be am wrong.

Please help me to achieve
0
parpaaAuthor Commented:
Thanks in advance
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
parpaaAuthor Commented:
I found the soln.
thnx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.