Report Generation in PHP / MYSQL app

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

re: Report Generation in PHP / MYSQL app

-Farid wrote:[color=blue]
> 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
>[/color]

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

re: Report Generation in PHP / MYSQL app

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

re: Report Generation in PHP / MYSQL app

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

re: Report Generation in PHP / MYSQL app

-Farid wrote:[color=blue]
> 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[/color]

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

re: Report Generation in PHP / MYSQL app

-Farid wrote:
[color=blue]
> 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.[/color]

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.

re: Report Generation in PHP / MYSQL app

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