471,336 Members | 1,239 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,336 software developers and data experts.

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

Jul 17 '05 #1
6 7503
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
Jul 17 '05 #2
Thanks. Looks like a great tool. But it seems to more geared to data
entry pages than reporting...did I miss something ?

Jul 17 '05 #3
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

Jul 17 '05 #4
-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
Jul 17 '05 #5
-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.
Jul 17 '05 #6
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

Jul 17 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Mr.Bogi | last post: by
8 posts views Thread by Abhi | last post: by
4 posts views Thread by Nathaniel Price | last post: by
1 post views Thread by vipindev.s | last post: by
4 posts views Thread by pmcgover | last post: by
2 posts views Thread by Jack | last post: by
1 post views Thread by =?Utf-8?B?S3VtYXIuQS5QLlA=?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.