Export to separated MS Excel files per group
We have a crystal report which contains only main report and it has Group1 and Group 2. The report currently has a page break each Group 1 but our end users requested to generate separated Excel file per Group1 instead of printing all the records in one single Excel file.
We are using Crystal Report 2011 and checked Export Report Option and Group Expert. However, we do not see the option for this change.. Could anyone provide us some advice? Thank you in advance!
Ludek Uher replied
There is no way to do this. There may be a 3rd party application that will do this (hint: google ken hamady), or you can possibly write an app using one of the CR SDKs to do it. But CR does not have anything like is "out of the box".
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow me on Twitter