By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,664 Members | 1,669 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,664 IT Pros & Developers. It's quick & easy.

Wanting a "pretty output" for tabular data

scubak1w1
P: 53
Hello,

I am wanting a "pretty output" of tabular data generated on the fly and saved in an array (PHP)...

That is, I have a link so users can chart (JpGraph) and download (CSV) tabular data, based on their selections on a query web page and using PHP, etc to pull the data out of a PostgreSQL database.

I have been requested to make ('on the fly') a 'reporting quality' version of the CSV available for download - sort of like you might get out of a report in MS Access, with say a summary at the end of the number of results, summary statistics, etc, etc.

I was seeking suggestions on software and/or approaches on how to format the data and make into, say, a 'pretty' PDF 'on the fly' that the user can download directly.

(i.e., the CSV is for the more technical users useage (sic), the 'static' PDF 'report' would be more for the manager types...)

The web server is on a Windoze OS, IIS.

I have Acrobat, MS Access, Excel, Word, PostgreSQL, etc, etc on the data/web server also if that is of any use.

I have never used Crystal Reports - but I kind of see this functionality being a web version of that?

Anyway, thanks in advance for any suggested approaches.

Regards & TIA,
GREG
Feb 29 '08 #1
Share this Question
Share on Google+
3 Replies


hsriat
Expert 100+
P: 1,654
See if this helps you.
Feb 29 '08 #2

P: 11
Hello,

I am wanting a "pretty output" of tabular data generated on the fly and saved in an array (PHP)...

That is, I have a link so users can chart (JpGraph) and download (CSV) tabular data, based on their selections on a query web page and using PHP, etc to pull the data out of a PostgreSQL database.

I have been requested to make ('on the fly') a 'reporting quality' version of the CSV available for download - sort of like you might get out of a report in MS Access, with say a summary at the end of the number of results, summary statistics, etc, etc.

I was seeking suggestions on software and/or approaches on how to format the data and make into, say, a 'pretty' PDF 'on the fly' that the user can download directly.

(i.e., the CSV is for the more technical users useage (sic), the 'static' PDF 'report' would be more for the manager types...)

The web server is on a Windoze OS, IIS.

I have Acrobat, MS Access, Excel, Word, PostgreSQL, etc, etc on the data/web server also if that is of any use.

I have never used Crystal Reports - but I kind of see this functionality being a web version of that?

Anyway, thanks in advance for any suggested approaches.

Regards & TIA,
GREG
If you are pulling the data out of the database can't you prepare the data in html tables and style them (css) at the same time, with a print media css file? So before you convert to pdf you will have something 'pretty'.
If you are storing in an array or extracting you can still store or exhibit the data as html tables with in-line styling. hth
Mar 1 '08 #3

scubak1w1
P: 53
Thank you both... this is my first web site, and so still learning this stuff... will follow up your suggestions and links now! :-)
Mar 4 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.