How automate Python from Crystal Reports data

[JMcJr]

Good morning,

My company uses Crystal Reports for their data. I recently started doing the President of the company's data reports. I am trying to automate the data so it will be a "live update" when the data changes. Thanks in advance!

[sritaa]

Python is very much matured programming language - having support to connect and fetch data from almost any type of systems (include Crystal data, Database, internet etc).

To automate - I guess you are talking about running certain programs to execute and retrieve data at particular times. You can either develop “daemons” using Python Programming or You can schedule your task (developed in Python) using systems “cron” jobs.

Hope it will help you!!

[JMcJr]

Hi Sritta!

Unfortunately I am on a secured network here at work so Python will not download. Now I need to figure out how to automate the report in excel. So when the crystal reports is refreshed/updated, the pivot table in excel reflects. Is there a good way to do this? Should I be using VBA?

[Rabbit]

Why would you need to download Python? You must already have it because your question is about how to automate Python and you posted in the Python forum.

[JMcJr]

I have python on my own computer at home. I work for a bank that has a secured network and will not allow me to download Python

[Rabbit]

I'm confused, if you can't use python, why are you asking about python in the python section of the forum?

The section you're in and the title of your question both reference python
home > topics > python > questions > how automate python from crystal reports data

[JMcJr]

I thought I would be able to download Python at work so I asked the question in the Python tab. I went to work and tried to download Python and I couldn’t due to the secured network. I’m confused on why you’re trying to acting like my mother?

[Rabbit]

I'm just trying to clear up the confusion so we can move this thread to the appropriate section so you can get help from people that can offer the correct help.

As it is, only python experts will see this question, and you won't be able to get any answers if only python people see it.

If you have a different forum section you would like us to move it to, then we can help you move it there. We can also change the title of the question so people reading it won't be confused about the wording.