Reports for non programmers

[scherom]

Hi

First let me compliment on this software.
I verymuch like the look an feel of it!
Why I was looking for this type of software is because under MS Access it is possible to create reports with different levels of grouping information. It's just that I do not work in an MS environment any more.

To generate the sql code for an query I used openoffice. The query did work fine. But then I get only a display of the records..how do I get to group information an sum them up.
...
Am I missing on a simple thing here or is that something really tricky.
I did see some tools pretending to do that but they were very buggous..

Cheers

[eleven8create]

Hi Marcello,

Thanks for the db, it's great. I have spent a few hours messing about with it and it all seems to work OK except for the 'XML Reports'.

While I can create 'new' reports and 'save' them (either from tables or from queries), I cannot preview the results...? Supposedly the generated files are to be found in http://www.example.com/xml/new_report1/ and http://www.example.com/xml/@new_report2/ but on closer inspection there are no files in the /xml/ directory...?

Could you perhaps shed some light on probable causes.
Thanks
Nial

[marciuz]

Hi, the xml folder use mod_rewrite for the URL.
Have you Apache mod_rewrite enabled?

[eleven8create]

Hi Marcello,

Yes, Apache mod_rewrite is enabled on my server (I have other sites using mod_rewrite). I have only one restriction [The .htaccess file containing the rewrite rules must be in the same directory as the target files]. This appears to be consistent with VFront.

Currently, when I try and preview ANY of my xml reports, I am simply redirected to the http://www.example.com/index.php page ???? I am using the default XSL sheet and XSL-FO stylesheet. My sql query is very simple

Code: Select all

SELECT DISTINCT category, Sum(guesstimate_value)
FROM MPH_230
GROUP BY category
ORDER BY guesstimate_value

I want to use VFront for two projects that I currently manage, but need to make a decision on implementing it soon. Without the report writing facility, I cannot use it. Any other ideas and suggestions are very much appreciated.

Thanks Nial

[marciuz]

I don't know, we need some additional information.

You can try:

1) Set to "public" your report: something change?

2) Set the "error_reporting" on E_ALL and look for some error for the debug

3) See the apache rewrite log ( http://httpd.apache.org/docs/2.2/mod/mo ... rewritelog )

[eleven8create]

Thanks Marcello,

Your 3rd point above got me on the right track. I had to put

Code: Select all

RewriteBase  /xml

in the /xml/.htaccess file and it now works.

So the xml and html reports all work fine but I am having difficulties with the pdf reports. I have installed the apache FOP and updated my conf.vfront.php file with the parameters

Code: Select all

define('_FOP_ENABLED',true);
define('_PATH_FOP','/usr/host/mycontent/html/fop-0.95/fop');

but all i get are blank pages??? No errors, no file forbidden, no code???

Any ideas please...

Thanks Nial

[marciuz]

So the xml and html reports all work fine but I am having difficulties with the pdf reports. I have installed the apache FOP and updated my conf.vfront.php file with the parameters

Code: Select all

define('_FOP_ENABLED',true);
define('_PATH_FOP','/usr/host/mycontent/html/fop-0.95/fop');

but all i get are blank pages??? No errors, no file forbidden, no code???

Have you tested FOP from command line? It works?
Can the Apache user execute FOP?