landaufortecollege

I understand that What I mean is that I would like to be able to export the report data into an existing spreadsheet (or a template) that contains formulas that I have previously setup. That way when the new data is imported the calculations automatically update. Does that make sense? Cheers, James

Afternoon First of all I am quite new to reporting in SIMS. I know how to create reports and can generally find the information I need and export it out but this has me stumped. I am trying to run a report that exports information into an Excel spreadsheet. The values that get exported need to be manipulated with formulas to generate the results we need. At the moment all I can do is select Standard Portrait or Standard Landscape in the Excel Settings area, but this generates a new speadsheet. Is there a way that I can create an Excel template that includes all these formulas, which SIMS uses to export the data to? That way I can include all the formulas and styling I need so the resulting spreadsheet is ready to be mail merged. I have noticed that there is a Report Template option, however there seems to be no documentation for this and I can't find any support for it anywhere. I might not have explained this very well so please let me know if you need any more info. Thanks for your help, James