Topic: How to Run reports from PHP GUI Posted: 26 Apr 2010 at 2:25pm
We have a SQL database and are currently developing a PHP web GUI user interface for it. The PHP will run under Apache Web server.
The PHP code validates the users, and allows them to view some data and make updates to the rest of the system and will run on a dedicated server ( actually a VM server) We need to be able to display data from the GUI and want to use Crystal Reports for this (We already have expertise in creating and running reports by those with Crystal Developer installed on their PC's).
We don’t want the users to have a copy of Crystal Reports Developer but they need to be able to run a previously developed report with their specific parameters on demand. THe paramters will be obtained by the GUi - we just need to knwo how to call and run the report passing the parameters and how to get the output back so we can display it
What do we need on the server to allow this and how do we run the report passing in the parameters from the GUI? We want to get the report output passed back and displayed on screen preferably as a PDF file so they can save it or print it if desired.
I have tried asking the retailers but they are all trying to sell us $100K solutions and we are certain that we can do it without this cost.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum