csalerno
asked on
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.E
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.E
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.