export into excel with auto filter

[sandeep0000]

i want to export my crystal report into excel, i am going to automate this process with crystal enterprise and export into excel. does anyone know here how i can have the auto_filter tabs to show up, without having to go into the report and setting it everytime

i asked in the crystal forum and didnt get an answer

 

[SkipVought]

Hi,

Don't know about CR.

Turn on your macro recorder and record turning on the AutoFilter. Save the macro in your PERSONAL.XLS amd connect to a keyboard sequence

But, heck, it's 3 mouse clicks.

Skip,

_[red][/red]