Report Generation in PHP / MYSQL app

[-Farid]

Hi
I've been thinking of switching from ASP / MS-SQL Server to PHP/mySQL.

My one concern is how the reporting will work. In the MS world I used
Crystal Reports which had a nice editor and worked well for all types
of reports.

Can someone please recommend the preferred report generation solution
for PHP/mySQL ? Ideally something freeware / shareware and not too
expensive.

Thanks

-Farid

[DH]

-Farid wrote:

Hi
I've been thinking of switching from ASP / MS-SQL Server to PHP/mySQL.

My one concern is how the reporting will work. In the MS world I used
Crystal Reports which had a nice editor and worked well for all types
of reports.

Can someone please recommend the preferred report generation solution
for PHP/mySQL ? Ideally something freeware / shareware and not too
expensive.

Thanks

-Farid

phpMyEdit lets you easily create a script that works with an included
class file ... to list, search, add, change, copy, delete records.
http://platon.sk/projects/main_page.php?project_id=5

[-Farid]

Thanks. Looks like a great tool. But it seems to more geared to data
entry pages than reporting...did I miss something ?

[-Farid]

Well, here's a couple more reporting options I found.

1. Navicat has a great report designer. Drafg and drop, graphs,
everything. Even better than the designer that comes with Access in
terms of ease of doing reports

2. fPDF looks promising if you want to roll your own PDF based reports
instead of working in a designer

Hope this helps someone + if someone has used these it would be good to
hear what you think

-Farid

[Greyhawkes]

-Farid wrote:

Well, here's a couple more reporting options I found.

1. Navicat has a great report designer. Drafg and drop, graphs,
everything. Even better than the designer that comes with Access in
terms of ease of doing reports

2. fPDF looks promising if you want to roll your own PDF based reports
instead of working in a designer

Just recently used fPDF and one of its html2PDF extensions to generate
a report from MS SQL. It was pretty straightforward but has some
limitations. I was using the html2PDF extension to save rewriting some
PHP code that basically did the same report in HTML format and it was
a bit of a pain getting my layout to be consistent.

Be well,
Steve

[Henk Verhoeven]

-Farid wrote:

Hi
I've been thinking of switching from ASP / MS-SQL Server to PHP/mySQL.

My one concern is how the reporting will work. In the MS world I used
Crystal Reports which had a nice editor and worked well for all types
of reports.

Can someone please recommend the preferred report generation solution
for PHP/mySQL ? Ideally something freeware / shareware and not too
expensive.

Just make the report in HTML? php is a nice tool for generating html ;-)
If you need to get the results in Word, do the same trick with RTF. Or
generate pdf, there are tools for that written in php.

Greetings,

Henk verhoeven,
www.phpPeanuts.org.

[-Farid]

Well yes. That's an option :)

Actually don't mind doing report in HTML, but HML is not the easiest to
printout the way you need. The PDF option is good as you can be sure
your report will look exactly the same whenever it is printed

-FARID