General discussion

  • Creator
    Topic
  • #2291935

    Crystal Reports from Excel

    Locked

    by paige.heard ·

    Does anyone know how to create crystal reports from complex excel tables? I need to use the workbook approach and a wide variety of complex tables from the multiple worksheets (pages) in the workbook and to export this data to create crystal reports that calculate the same data the excel spreadheet has been doing.

All Comments

  • Author
    Replies
    • #3295874

      Reply To: Crystal Reports from Excel

      by paige.heard ·

      In reply to Crystal Reports from Excel

      Point value changed by question poster.

    • #3295837

      Reply To: Crystal Reports from Excel

      by paige.heard ·

      In reply to Crystal Reports from Excel

      Any good links would be helpful

    • #3297255

      Reply To: Crystal Reports from Excel

      by pierrejamme ·

      In reply to Crystal Reports from Excel

      I assume you have tried the Crystal Report Wizard on the Excel program to no avail?

    • #3295402

      Reply To: Crystal Reports from Excel

      by misscrf ·

      In reply to Crystal Reports from Excel

      Have you tried exporting your excel data to text file first and then importing directly to crystal???

      Also, is your data all on one worksheet? If not, I would get it all on one worksheet in a workbook with only one worksheet, and see if that can import.

      If that won’t do, can you explain the data more, so I can understand why it can’t go into Access first? Even just linking the data?

    • #3296501

      Reply To: Crystal Reports from Excel

      by paige.heard ·

      In reply to Crystal Reports from Excel

      I want to use the formulas in excel not just the data

      • #3022292

        CSV

        by travis.stock ·

        In reply to Reply To: Crystal Reports from Excel

        Is the data in the Excel workbook going to be updated regularly? Or could you export to a CSV file. I did this and was able to see the data in Crystal.

Viewing 4 reply threads