I have developed a PHP application using the Yii framework. I have integrated the designer to allow users to design their own reports. As a security measure I am only allowing them to use predefined datasets.
Then in various places they can view their reports in the application either embedded into the application as an HTML component or using the viewer in full screen mode.

Justin Pos
Just Informatics