This topic is locked

PHPR - Crystal Report

3/1/2010 10:14:05 AM
PHPRunner General questions
T
taumic author

Hello,
is it possible to start a *.exe programm (Crystal Report) from inside PHPR,

e.g. with the new feature (PHPR 5.2) NEW BUTTON (under windows, local system).

(Add a new button on a list-row, which start the external programm with

the ID from the list-table as a parameter??? ==> CR is printing the invoice)
Is it absolute nonsense? In which way do you make invoices or other reportings?

Have you some examples?
Best regards!
Mike

K
KevinMillican 3/1/2010



Hello,
is it possible to start a *.exe programm (Crystal Report) from inside PHPR,

e.g. with the new feature (PHPR 5.2) NEW BUTTON (under windows, local system).

(Add a new button on a list-row, which start the external programm with

the ID from the list-table as a parameter??? ==> CR is printing the invoice)
Is it absolute nonsense? In which way do you make invoices or other reportings?

Have you some examples?
Best regards!
Mike


Are you trying to do this on the web server, or on the client's machine that is accessing your web application ?

T
taumic author 3/2/2010

Hello Kevin,
I try it on the clients machine, because I think it is too complicate and expensive on the web server.
Mike

E
electromotive 3/2/2010

Hi Mike
The PHPR generated client-side code runs on virtually any web browser.

It can do what any web HTML/Javascript based code (or script) can do.
For security sake, web-enabled code is usually sandboxed within the browser.

After all, you don't want any old hacker with a webpage to gain access to your PC, run programs, capture your on-line account details, access or destroy your data.
In addition, not all browsers are PC based. Many are MAC or Linux based. Still the same HTML/Javascript code runs the same on any standard browser, regardless of the OS. But trying to access particular OS specific applications doesn't work cross-platform (*).
In short there will be no easy way for web browser to directly start execution of a exe program (and this is a good thing from a security perspective).
Where access to functionality beyond that of the browser can provide, most browsers support extensions, plug-ins or add-ons. For instance, a browser may invoke adobe acrobat to display pdf files. However, writing a browser extension or add-on is not a trivial matter.
You might look for generic addons for your browser to see if something has already been developed to access the functionality you need. Or even better, use Crystal reports or other report writer to generate web-enabled code to provide the reports, rather than trying to execute a local exe program. That's the solution which has the best future.
Rick

K
KevinMillican 3/4/2010



Hello Kevin,
I try it on the clients machine, because I think it is too complicate and expensive on the web server.
Mike


You need to investigate the XML export functions of PHPR.

If you create a special view that contains the information you want to export, you should be able to directly link to the name of the view from Crystal Reports and display the data any way you wish.

Once set up, you can remove the menu links to the views. This is the way I handle reporting PHPR data in Paradox for Windows.
CSV is another possibility but I think XML will be more versatile.