Crystal Reports\SSRS reporting output to Excel

Is there a way to redirect the output, for either or both of the above reporting, to Excel?
I want to be able to output the data before all of the formatting is performed by these two reporting methods. I know Crystal has a method called "CrystalDecisions.Shared.ExporttoExcell" but I can't find any examples on it.
csalernoAsked:
Who is Participating?
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.

mlmccCommented:
I know Crystal can export to Excel and other formats.  As far as I know SSRS can also.

Here is an example of running a report passing it a dataset
http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx

The follow on to that article shows how to export reports in code
http://www.emoreau.com/Entries/Articles/2006/10/Crystal-Reports--Part-II.aspx

mlmcc
0
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
What's the point of using either of those reporting tools if you don't take advantage of the formatting?  Why not just create a SQL query straight out of the database and save it to .csv?
0
csalernoAuthor Commented:
mlmcc,
thanks for the link. It appears that this method will export the report to Excel as if the user selected the option from the UI. I'm looking specifically for a method to export to Excel before all of the report row grouping are applied so I can capture the complete line data instead of the grouping breaks.
0
vastoCommented:
As @rhinok mentioned, you do not need reporting tool. Just create the SQL and run it from excel. If you don't know how to create the SQL you can copy it from the report then go to Excel and  use it. There are also 3rd party tools that can do this for you, but the model will not change  - you will need the SQL because this is what is retrieveing the data from the database
0
csalernoAuthor Commented:
I found what I needed on the Crystal Report side using the ExportFormatType of "CrystalDecisions.Shared.ExportFormatType.ExcelRecord". I'm able to direct the output to a file out on the file system.

My preference is to use the ".ExportToStream(CrystalDecisions.Shared.ExportFormatType.ExcelRecord)" method to direct into the Active worksheet as an Addin. Anyone have any examples of how to use the resulting MemoryStream from this method into an Active worksheet?
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
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
Crystal Reports

From novice to tech pro — start learning today.