Skip to Content
author's profile photo Former Member
Former Member

Excel as data source In CMC

Hi,

How can we create report with Excel as data source In CMC?

I have a scheduled report in CMC which exports the results to an excel on a network drive and I want to schedule another report to use this excel as data source. Can this be possible?

Help will be appreciated.

Thanks,

Jyothi

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2009 at 11:47 AM

    Hi,

    Yes you can do that. However, the report that uses the Excel Workbook should be developed first. After that, when the export has finished, your exported Excel Workbook needs always to:

    - Have the same name

    - Have the same layout (e.g. Workbook name, location, sheet name(s), column name(s)s, placement of data, data type(s))

    This is logical if you think about it: you developed the Crystal report with certain parameter the report should rely on.

    Steps:

    1) Export the first scheduled report. You have now an Excel sheet.

    2) Build a Crystal Report based on this Excel sheet (It's name, location and layout).

    3) Schedule the new Crystal Report, after ⚠️ the first scheduled report.

    4) Enjoy.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Events can be used in CE to trigger one report after another.

      In CMC, define a new event, Schedule type, based on success. Then schedule your first report, setting Events to Trigger Upon Completion to include this new event. Sechedule your second report to run at the same time, except select the new event in the Events to Wait For section. The second report will wait until the first report completes successfully before starting to execute.

      Another possible way is to use Object Packages. However, if such a package is run on a report server that allows multiple reports to run simultaneously, I think the multiple reports in the package will run at the same time. (This would have to be verified, as I am not positive.) But if the report server that the object package is scheduled to run under was single threaded, they would probably execute in order.

      HTH,

      Carl

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.