I am not sure if this is possible but I thought I would ask. I have a report that is posted on our crystal server, I have set up ASP forms that is used to get the report parameters. Once the user select his parameters and click run report the values are passed via a URL to the report server. The report runs and opens in the crystal report viewer.
This is the question - for reason I will not go into, the report can be exported in excel but it has merged fields in it that the user must unmerge, and mess with the column width etc. before they can search. I have a macro that I run the fixes the report up fast - but what I would like is for the macro to run on the export excel file once it is exported from the crystal viewer and before the user sees it. IS that poosible and if so can someone explain how