Skip to Content

Can Crystal Reports append to an Excel Spreadsheet?

Hi All,

I work for a Hospice and I use Crystal to query my patient census. However I'd like to also automate graphing our census day-to-day over time. It is not possible, due to the set up of the Electronic Medical Record data source, to build a query that 'looks back" at the census for previous days. Right now we have to enter the census on an Excel Spreadsheet which then serves as the source for a chart of census over time.

I'm wondering if I can take the census figure gotten from my Crystal Report and automatically append it to my Excel spreadsheet rather than our needing to enter it manually.

TIA

Chris

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 28, 2017 at 01:19 AM

    While Crystal can't do this, there are 3rd-party tools that can append to Excel or to database tables via export from Crystal.

    Add comment
    10|10000 characters needed characters exceeded