Showing results for 
Search instead for 
Did you mean: 

Dynamic links in Excel Output

Completely unfamiliar with Crystal Reports. I'm hoping it can help reduce the redump-and-repeat portion of the "dump to Excel, analyze, post journals, redump, re-analyze, repeat" accounting month-end process.

Is there any way for users to annotate a _dynamic_ copy of the output? See screenshot, below. I'd like to have columns A-I generated directly by CR, with column G annotated by remote users, so that I can refresh the CR report and retain / easily update the comments in column J.

I know that it can be done with Spreadsheet Server, but wanted to confirm it could be done with CR.

Many thanks!

Community Manager
Community Manager

Welcome and thanks for visiting SAP Community to get answers to your questions. Check out our tutorial to get started in SAP Community: By adding a picture to your profile you encourage readers to respond to your question. Learn more about your profile here:

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

If the structure of the data remains the same (only the numbers change), then a third-party Crystal Reports automation tool can insert an excel export in an existing Excel template. See list of 3rd-party tools here.