[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 233
  • Last Modified:

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!
0
nahumba
Asked:
nahumba
  • 2
  • 2
2 Solutions
 
mlmccCommented:
There is no way within Crystal to do that.

Crystal will export what is being displayed.

mlmcc
0
 
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?
0
 
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
0
 
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
0
 
mlmccCommented:
Glad i could help

mlmcc
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now