need to add an auto_filter

[sandeep0000]

i tried this in the crystal enterprise forum, but didnt get a response

i am using crystal xi


i have a crystal report that is scheduled in crystal enterpise to run every month and export to excel. is there away i can have it , that the excel spreadsheet has an auto_filter on each column that has data?

 

[Turkbear]

Hi,
What would the auto_filter do?

Wouldn't that be set in Excxel, not Crystal?




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[sandeep0000]

yes it would be, but how can i set it up in excel so it imports to the excel spreadsheet and keep the auto filter

 

[sandeep0000]

well when i export the file to a excel file that i have setup with filters , it over writes the file and the filters are gone

 

[Turkbear]

Hi,
The base question was, what does the auto_filter do?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[sandeep0000]

the auto_filter gives the user of the report to filter just the values they want to see

so for instance if there is worker # the person can click on the filter tab and chose only the worker # he wants

 

[Madawc]

It might be simpler to do the selection in Crystal, using parameters. Then export each option as Excel.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[IdoMillet]

I think it's possible via an application that does the exporting of the Crystal report to excel. If I have time, I'll test and let you know...

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[sandeep0000]

if you could test it and let me know what applicaton. that would be great

 

[sandeep0000]

anyone have other suggestions?

 

[IdoMillet]

I just created a proof of concept test in my Visual CUT software and this works very nicely. I should have it implemented fully by tomorrow. You can check to see if other 3rd-party tools provide this functionality by reviewing the applications listed at:

http://www.kenhamady.com/bookmarks.html

You can develop the same functionality within your own application by using the excel object model. Look for the AutoFilter method...

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[sandeep0000]

would the excel object model be in crystal or excel?

 

[IdoMillet]

In excel. The application takes care of exporting the report (using the Crystal runtime components) and then (before emailing or simply saving the resulting excel file), if that option is requested, it uses the Excel object model (all you need is excel installed on that machine) it takes care of turning the autofilter option on in the excel file.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com