Export crystal report to Excel Data Only through program

Question

Hi All,

 

You know in crystal report, we can export the report to excel data only mode. I just want to know, how i can achieve this through C# program. I am developing a windows form application using .net 3.5. Please assist me. I searched and tried several blog postings, but didn't work. I think using Crystal decision there's possibility of doing this, but couldn't find a good article. If you could please post any links or sample code snippets.

 

Basically what i am trying to do here is load .rpt file from a physical path and then set locate database connections and pass some parameters then generate the report to a physical folder again with Excel Data only mode.

 

Appreciate you valuable help on this..... 

 

Thanks,

Charith