Sorting / Hiding information of a Crystal report after being exported to Excel

Dear Experts,

I've created a report in Crystal Reports. For each sub report, I would like to create some sort of a formula field, that when the report is being exported to Excel, users will be able to create a filter to sort or even hide information that isn't relevant.

What will be the most efficient way to do that?

Thanks!
nahumbaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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:
There is no way within Crystal to do that.

Crystal will export what is being displayed.

mlmcc
nahumbaAuthor Commented:
There must be a workaround for this? I read on some web site that that export to Excel can be customized, is this true? Anyway I don't have a clue how to do that?
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
You can create your own application to export the report and then manipulate the resulting excel file.

Alternatively, consider a 3rd-party tool as a solution (for a list of such tools, see http://www.kenhamady.com/bookmarks.html).  With my Visual CUT software, you can use the following command line argument to turn on the Auto Filter behavior within exported excel files:
The command line argument structure is as follows:
& "XLS_AutoFilter:True"

Cheers,
- Ido

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
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Corrected text:

You can create your own application to export the report and then manipulate the resulting excel file.

Alternatively, consider a 3rd-party tool as a solution (for a list of such tools, see http://www.kenhamady.com/bookmarks.html).  With my Visual CUT software, you can use the following command line argument to turn on the Auto Filter behavior within exported excel files:
... "XLS_AutoFilter:True"

Cheers,
- Ido
mlmccCommented:
Glad i could help

mlmcc
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
.NET Programming

From novice to tech pro — start learning today.