How to Run reports from PHP GUI
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9820
Printed Date: 29 Apr 2024 at 4:24am
Topic: How to Run reports from PHP GUI
Posted By: vk3ujc
Subject: How to Run reports from PHP GUI
Date 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.
-------------
VK3UJC
|
|