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.
Who is Participating?
csalernoConnect With a Mentor Author 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?
mlmccConnect With a Mentor Commented:
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

The follow on to that article shows how to export reports in code

Kurt ReinhardtConnect With a Mentor Sr. 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?
csalernoAuthor Commented:
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.
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.