Reporting Functionality for Web Applications? 164
"It's not vital that the reports be printed from the client machine (as opposed to the servers), but that would be preferable, for flexibility. At the very least, the person initiating the reporting should be able to choose an appropriate network printer on the server's network, but ideally a client network printer would be better.
Of course it would be nice if the reports were relatively easy to build; I would prefer not to have to write a ton of source to gather and format data. I'd prefer not to have to write any, really. The kind of drag-and-drop report builders you get with something like Microsoft Access would be nice, although it's not a requirement.
First of all, what are the thoughts and solutions on this general problem space? What tools can I make use of to really do this kind of thing well in a web application space.
Secondly, considering that I'd prefer to make use of J2EE for the project, what are some of my options for integration with J2EE. It would be nice if the reporting software could integrate with the object model rather than the database, so that I could re-use business logic. Not necessarily critical, but definitely a nice-to-have feature."
Use PDFLib (Score:1)
For Java based PDF generation try iText (Score:1)
Re:Not Difficult - Crystal Reports (Score:1)
Re:Long printed reports are obsolete, deal with it (Score:2)
I hope you enjoy you stay on our little blue world.
Crystal Reports (Score:2)
You can implement two basic kinds of reports. Pre-generated report files, a link to which opens Crystal's web-based viewer(Java, ActiveX or HTML). and custom-data reports which allow you to modify the data displayed based on input from the web page (on-they-fly modification, replaccement of the SQL) as well as reports (the format of which) is generated on the fly. You can also (from the web) export(in just about any format you could want) and print. All formatting, etc. is preserved(when not using the HTML viewer).
And of course, Crystal Reports generation creation tool for Reports is very nice. better than any other I've seen and the only one useable by non-tech savvy people. Of course, if you're wedded to a *nix-based solution, you're pretty much left to code your own, and god forbid someone not of your programming staff needs to generate the report formatting.
What really scares me (Score:2)
Ultimate Solution (Score:3)
First of all, all of the solutions being mentioned here are useless if you need to genrate more than a few hundred pages per report. Apache FOP for instance explodes at 60-100 pages depending on content (Any bad xml/xsl transform tool will do that to you, its called running out of heap by way of using xsl on a huge xml document). If money is no object, I suggest you go for Actuate (http://www.actuate.com/) They have the best reporting server solution out there, it allows complete formatting control with a GUI builder, support for a VBScript like language in addition to Java and extremely neat control over data sources. From my experience extremely scalable too. I generate over 3 gigabytes of PDF reports every night for hundreds of clients in addition to an interactive report generation system that creates PDF output on the fly.
If money is an issue (what!! you cant afford a $80K/Processor 8 Processor recommended solution? what are you working for? a
Hope I helped you solve the problem
If not, give me a shout at optimizer@hotpotatoesmail.com and I will be happy to assist you.
You will need to be able to wire money to Pakistan
Faraz Babar
Something at Linux World (Score:1)
Re:Not Difficult (Score:2)
Re:Actuate (Score:1)
"What are the three words guaranteed to humiliate men everywhere?
Nicely printed output with html - it's possible (Score:1)
If you don't mind throwing combatibility with pre-6 netscape browsers and pre-5 ie browsers out the window, it's quite possible.
Okay, I know I'm plugging my own resume, but I found that I could do CSS tricks with http://www.math.jhu.edu/~martind/resume.html [jhu.edu] to make certain that my resume printed just the way I wanted it to from ie 5.x browsers (which were the most common in the HR departments I was targetting). Remember that a resume's purpose is to get you past the HR drones; they will either print it out and hand (or fax) it to the person who'd you would actually be working for, or ignore it entirely. In a few very rare cases, I've seen HR departments clued enough to send resumes as email attachments, but not before first converting them to Word and trashing all the formatting anyway. Therefore, ie5-specific CSS in a resume isn't that big a deal.
Not only that, but it wasn't hard to include the necessary extra xml-foo so that office 2000 would load the html as a word doc. with all the borders, etc. set correctly. This made keeping the html, pdf, plain text, and doc formats of my resume in sync quite easy - I'd update the html from anywhere, and use lynx -dump to give me the plain text. I'd then walk over to a windows machine that had the full office 2000 suite on it, and load that page up in ie5. Print to file from ie5 to generate postscript, and also load up http://math.jhu.edu/~martind/resume2k.doc [jhu.edu] in Word (that file's just a symbolic link to the html). Save the Word doc. in office 95 format and ftp/scp the postscript and '95 doc format back to the server. Then use ps2pdf on the server to turn the postscript version into pdf.
It got a bit more complicated than that for a while - inserting pdfmark stuff into the postscript so that hyperlinks worked in the pdf file - but basically, that's it. (Maintenance of the multiple separate versions has lagged since I landed a job back in August - I only generated the most recent files a few months ago to get recruiters off my back)
Use JReport from JInfonet (Score:2)
Re:Long printed reports are obsolete, deal with it (Score:2)
Re:Long printed reports are obsolete, deal with it (Score:2)
I'd like to see the numbers on it, since you are interested. How much fuel is required to haul a tree to the paper mill? Produce the paper? Ship the paper to retail and the to the customer? Then what, is the above poster going to pay fedex to burn massive amounts of jet fuel to overnight the precious report somewhere?
This useless waste of energy has to stop. Check out today's SF Chronicle: Californians use 15 megawatts of power just to stir the water in their fucking swimming pools [sfgate.com]. WHAT THE FUCK ARE WE DOING WASTING SO MUCH ENERGY?!?!
Actuate (Score:5)
Anyway my personal opinion is that HTML is wrong wrong wrong for this stuff. Generate TeX output and convert to postscript, or *roff, or generate postscript directly. If the target is dead trees you should use dead-tree-era technology.
Re:Long printed reports are obsolete, deal with it (Score:1)
use SVG from Adobe. (Score:1)
PHP 4 and [pdf]LaTeX (Score:1)
It is not to fast (~1-2 pages a second),
but for reports this should be fast enught IMHO.
Documentation on this is right now only available in German, but if you push me hard enough i'll translate it
use PDF for rendering reports (Score:1)
Granted, you'll have to write a renderer. However, HTML does not have enough expressiveness to deal with page break situations, and other complications of paged printing anyhow.
PHP and PDF (Score:2)
http://www.php.net/manual/en/ref.pdf.php
Or, its seems that people always forget that you can write postscript files by hand. : )
Jinfonet seems nice (Score:1)
I had a similar requirement about 18 months ago. I checked out Jinfonet and it seemed pretty nice. I had no budget so I instead used PHP, and LaTeX and some TeX to PDF converter. It was nice since I could offer the option to output to a printer, view a couple pages in HTML, view the whole thing in PDF or export to CSV. I used the largetable macro in LaTeX I think. The output was quite nice but I didn't have time to mess with formatting very much. It wouldn't have been too hard to create several templates. Now I'm stuck with an NT system using Crystal Reports. It's quite nice to design in but not as fast or fun as before.
PHP can massage your data and output to either or. (Score:3)
If you use XML you can really go to town on the data, and ignore what you don't need, generate a PDF (or HTML with XSLT but that's less transportable and controling page formatting is more explicit [you'll have to do that work yourself.])
The client web browser can then load the HTML or the PDF and use Acrobat to view & print to their heart's content.
Re:A step at a time... (Score:1)
A step at a time... (Score:3)
You need fonts and page breaks? Just about anything other than raw text can do that (yes, even HTML). I use HTML/CSS for all my reports (ranging from crosstabs to listings to canned documents) - how you generate it is wide open.
Hundreds of pages worth of reports at once? If your reports are that large, you probably don't even want to deliver it to a browser. Some sort of server-side report queue would seem to be in order (ie the user requests a report and if they need to download a copy they come back and pick it up later when it's done). If you're printing from the server, just pick and choose your tech.
Drag-and-drop? Well, I far prefer building reports in HTML than in something like Crystal (which is what Access uses, by the way) - I hate mucking around with field alignments/sizes etc. I find that things go a lot quicker for me with HTML (CSS helps tremendously).
I'd really recommend reviewing your requirements. Is *anybody* really going to read hundreds of pages of reports? Perhaps you should be building a more flexible query tool so that your users can get the specific data they want without having to wade through mammoth wads of paper?
XML to PDF (Score:2)
Re:reporting (Score:1)
In particular, take a look at the XML Apache Project's FOP [apache.org].
FOP, which is written in Java, will transform your XML data into PDF format.
reportlab (Score:3)
www.reportlab.com [reportlab.com]
Check the demos.
Really, it's cool
User Oracle 9iAS or Forms/Reports 6i. (Score:1)
Re:Long printed reports are obsolete, deal with it (Score:1)
I appreciate your zeal to blast everyone into the 21st century, but there are still many entities that cannot think outside of the "dead trees in a metal box" box.
Who, you ask? Dealing substantially with the public sector, I would have to say government agencies. They still view computers as a way to streamline form and report generation, provided that they even use computers at all. To boot, government is just now getting the "it's gotta be on the web" bug. Their bottom line is "...and if it doesn't come in triplicate so that I can stuff it into a filing cabinet, I can't use it."
Re:Long printed reports are obsolete, deal with it (Score:1)
Crystal Reports++ (Score:1)
Good luck,
Mike Hunter
Re:Crystal Reports++ (Score:1)
Re:No page breaks in HTML (Score:2)
You can kind of cheat with table row counts and style codes. In plain English, if the number of rows so far is greater than, say, 50, put in STYLE=page-break-before:always. v4 & above browsers honor it, if I remember right.
Re:Long printed reports are obsolete, deal with it (Score:2)
Oh, I wish. We have a similar setup to what the original poster has: we have to generate huge reports for our clients, most of which aren't able to get high-speed internet access. (We scan comment cards for hotels, restaurants, etc.) They want consolidated reports with color graphs explaining their customer satisfaction trends. We make all of the reports available on the internet, but people just don't want to see them that way. They don't have the time to download 100 pages worth of reports with color graphs over a 33.6.
Reporting with Crystal, PDF's, and GB's of data (Score:5)
We have a few large (2-5gb) databases that we have to report on. Most reports are generated on a periodic basis, but we've got a few that have to be done on-the-fly when the user requests them. The formatting has to be flawless, and we print out reports on color lasers as well as make them available for download.
The solution (picked long before I came on board) was Crystal Reports. Whether you like Windows-based development tools or not, you have to admit that it's easier to hire a Crystal person off the street than it is to hire & train for any other report writer.
To give you some idea, we have a dedicated Crystal person on staff, and several machines that churn out Crystal Reports full time. (We keep five Tektronix color lasers busy for most of the day.)
The same Crystal Report files are used whether the report is going online or being printed. In fact, we print to PDF format, and save the PDF's. Before you get one of our report packets in the mail (or FedEx or whatever), you can view the same report online in your web browser, and it prints out perfectly. Plus, there's no CPU/database load on our servers - each report is run once, and stored on hard drive.
For the reports that are done on-the-fly, we use the Crystal Reports viewers. There's several, a Netscape plugin, ActiveX plugin, and a Java plugin. You have to redirect your web users to the right page for your browser, of course. But for these on-the-fly reports, PDF isn't involved. They can print using the Crystal plugin, and page breaks and everything work fine.
I understand why a lot of people on here throw out solutions like XML, but my experience has been that spending more money on the famously well-used tool usually means spending a little less money on the hiring end later. When this becomes a big business (and aren't you planning for that?) you want to be able to hire quickly, and nothing's more widely used than Crystal Reports.
If you've got any questions about the setup, you can e-mail me.
Spreadsheet::WriteExcel (Score:1)
The clients had been used to getting Excel formatted reports for years, and many of the reports needed colors. This let them dynamically do all that from a web page, but still have excel to manipulate the data. May not be what you were looking for, but it was pretty neat. Plus the output from WriteExcel looks great in Gnumeric as well.
Use Python.... (Score:1)
I've done some very impressive stuff using this combination, and Python is so easy to learn it hardly feels like programming.
Re:BRL with LaTeX (Score:1)
I've used text based reports in a variety of enviornments, with, and without ReportGenerators in the sequence and straight text is always flexable. You can readily convert it to a format which is what the end users want. (PDF is very nice for 'laser like' output. It looks exactly like it will print. The viewer is easily integrated into the browser, and the viewer is free. (major bonus if the website is publicly accessable).
If you use Python... (Score:1)
Hmmm...printing (Score:1)
I solved part of this problem by creating a new MIME-type for the page to print and then create a DOS-app which does `type %1 > lpt1:' which I associated with the MIME-type/extension.
This is not a very good solution. Maybe someone has expierience with this? Is it possible to use a Java-applet or something like that?
for generating printable documents (Score:1)
use LaTeX? want an online reference manager that
Re:Preventing Easy Questions (Score:1)
So you think Slashdot needs a database of answers to questions which have easy answers?
I think questions that could very easily be solved with a mild application of google don't belong here.
"Web Platform: WebObjects" (Score:1)
(For what it's worth, WO 5.0 (due any time) is supposed to be Java only)
Crystal Info (Seagate) (Score:1)
It can use many data sources, including flat files, web server logs are catered for, Exchange mailboxes, as well as the usual ODBC.
It has a web interface which allows you to view reports, it can e-mail reports to users, you can set up security on reports, it can produce reports in HTML and Word format too.
They even gave away a 50 user license of version 7 for free. Not sure if it's still available, but if you can find a copy of their free CDROM you'd be set.
Depends on how much you want to spend... (Score:2)
Actuate's e.Reporting Suite [acutate.com]
This system is something the company I currently work for is using for reporting. It consists mainly of three parts:
1) The report server
2) The development IDE (Workbench)
3) The report viewer
The report server is what actually runs the report - it interfaces with the web server you aare using to parse reporting requests, then runs the report, builds a DHTML page with the report result, and sends it back through the web server to be delivered to the client. The reports can be downloaded/printed by the client as PDF files (we are working on a way of making it a single step process - harder than it sounds). In some way it is possible to print from the server to a networked printer (this is an area I am not too familiar with).
The development IDE is where you create the reports - you can use simple wizard functions to create "ad-hoc" type reports relatively quickly, then you can flesh them out further with code (using a customized form of VB script), to allow a ton of functionality, from simple linking/drill down reporting, to custom reports that change depending on what data is wanted (I have created reports using it that look the same, but I didn't want to write two seperate reports, so I made one report that changes based upon a parameter passed into the report from the input form/URL). The IDE is drag-and-drop simplicity, very much like developing under VB (it is like VB for reporting) - drag text controls, size them, set properties, double-click and add custom code, then compile and run!
Finally, the report viewer is an application that allows the running of the reports without using a server - it is basically a desktop based viewer.
The downsides to all of this? Windows-based, and expensive. But overall I think it is a great product - it is almost possible to create a website based on nothing but reports. One could do the same using PERL or Python, or some other language (like Java, even C/C++) - but the ease of creation won't be there, and you won't have the "same-on-paper-as-on-screen" type print capability, either.
The one thing I don't get - why the need to print to paper? Why not just regenerate the report when you need to view it?
Worldcom [worldcom.com] - Generation Duh!
Re:CrystalReports??? (Score:1)
www.dynalivery.com [dynalivery.com]
Re:Crystal Reports++ (Score:1)
Look at Parallel Crystal... (Score:2)
Re:What about using XML/XSL? (Score:1)
I would LOVE to be able to take my XML datasets, and convert them using XSLT into a PDF somehow.
anyone know how?
www.perceive.net [perceive.net]
Gee, where could this be? (Score:1)
Gee, it sounds like you could use a Practical Extraction & Reporting Language [perl.org]. Eh?
Crystal Reports is the old standby (Score:1)
If you happen to be using WebObjects, then ReportMill [reportmill.com] is an excellent solution. They are working on a non-WebObjects version.
Re:Long printed reports are obsolete, deal with it (Score:5)
So until there are some better, lighter, and more eye-friendly solutions to reading through computers, paper will still have a place in and out of the workplace.
"Sweet creeping zombie Jesus!"
troff: oldie but goodie... (Score:1)
tbl -> groff -> acrobat distiller
As old as it is, tbl still produces very nice
looking output, and is very easy to generate.
SAS (Score:1)
J2EE and PDF (Score:2)
Re:PHP and PDF (Score:2)
So, you can write the web site and the offline background stuff in the same language.
Not that this has anything to do with the original poster's search for J2EE solutions.
--
ReportMill (Score:1)
we do that (Score:1)
Oh god, you know too much already.
~@#$F~-connection terminated
Re:htmldoc (Score:1)
R&R Report Writer (Score:2)
I see a lot of comments which mention Crystal Reports. I've got it installed on my computer, but every attempt to use it has left me frustrated. It is a truely evil piece of software. R&R is far easier to learn in my opinion, and there has been very little I haven't been able to do with it, and I don't think Crystal Reports would have helped in those situations either. Being able to create an informative, professional looking report quickly is very valuable and I don't think the added complexity of Crystal Reports is beneficial.
Re:PDF does what you want (Score:1)
PDFlib is a good thing. Better than the lack of page breaks in HTML.
Here's a good demonstration of it: Paper CD Case [papercdcase.com]. Make paper cases of you CDs. Enter details, it makes you a PDF.
Hey moderators! My post is off-topic. Do something about it!
htmldoc (Score:1)
Easy, lightweight, quick HTML -> PDF .
Try Roxen's Business Graphics Module (Score:1)
Very cool and easy to use. Roxen is available at http://www.roxen.com
-- CKM
internet systems architect - scalability - commerce
Maybe... (Score:2)
jade(xml) to pdf
ipp(pdf) to printer(remote or local)
Most of your network printers have or are adding IPP and PDF capability, though I'm sure you could just as easily translate your document to PostScript. Fonts shouldn't be a problem, just use the ones on your printer. PDF is handy because you can also kick it around a lot more easily than other document formats, although it does have the problem of being mostly write-only.
Just some thoughts. Hope they help.
Hi Slashdot, can anyone do my job for me? (Score:4)
Please, no confusing external libraries other than CGI.pm or Win32 ODBC. Oh, I heard that printf is gay, so please don't use them.
Thank you!
Re:Crystal Reports (Score:1)
--Clay
Re:Reporting with Crystal, PDF's, and GB's of data (Score:1)
OR, in the ASP or component that is using CRPE (Crystal Reports Print Engine) call the apropriate viewer for the browser itself.
Crystal really was/is the cats a$$ (especially for report creation) but v7 would only run 1 report at a time and QUEUED all other requests - really crappy if your database is SLOW - therfore useless for online processing. If each dynamic report takes 5 minutes for querying, and 5 requests come in at the same time, the 5th user is gonna lose 25 minutes waiting and if the user's IE default timeout is 5 minutes (default), you're gonna have cranky users until. CR V8 supposedly did away with that limitation.
Oh, I've also used ActiveReports(VERY NICE!!!!, requires VB, not as easy to use as Crystal but it is your slave) and Actuate (v 3 or something, such a beast to develop a report but the doc's/self training are GRRREAT)
--Clay
Re:Reporting with Crystal, PDF's, and GB's of data (Score:1)
From their website (Data Dynamics [datadynamics.com]):
ActiveReports [datadynamics.com]
Full run-time access to objects, data sources and binding and the ability to create the entire report on the fly
--Clay
Crystal Reports (Score:2)
Actuate (Score:1)
We wrote one... (Score:2)
Excel can read tables, you just set the content type. If you need fancy formating, plug it into the PHP source.
If you don't want to code, there are dozens of programming shops that will develop a system for you for a reasonable fee.
You don't want to spend money or effort? Well, you're in trouble. Labor isn't free. Do it in house or hire someone. Some of our baselevel systems (including our DB class, which can help you abstract your DB from the engine, you'd need to write your own if you aren't using Postgres or MySQL) are available on our website. If you want to hire us, e-mail myself or sales@feratech.com.
Alex
reporting (Score:5)
Regardless of the program you use, try to store the data in XML format. Why? Because then you can use one XSLT for conversion to HTML for web use, another XSLT for conversion to PostScript for printing, another XSLT for conversion to Excel spreadsheets -- you get the idea. While I hate to say so on this site, SQL Server 2000 offers some particularly nice functionality that can be used to implement this -- such as automatic transformation of tables to XML documents.
If you require graphics as well as text, check out the gd graphics library [boutell.com]. The Webalizer [mrunix.net] is an absolutely delicious example of how gd can be used to create slick PDF graphs on the fly.
You mention that you'd like to integrate with J2EE... I'm somewhat of a Java guru and can say without wavering that Java is not a first-choice solution for text-based reporting. If your reports are being generated by a Perl or PL/SQL script and you're just outputting the results from Java, it's fine ;), but text processing and transformation isn't too hot in the standard Java APIs. Now if you want to pay for a third-party API, you may be able to get around this...
For graphical reporting, however, Java is one of the best solutions. There are a plethora of Java charting tools available, although the decent ones will cost some dough...
Anyhoo, if you provide some more details on your specific task I can give a better recommendation.
--
Re:Blah. (Score:1)
An extremely detailed report (with subreports, aggregates on multiple levels, etc) can be generated (by someone who knows what they are doing) in Crystal Reports or MS Access and integrated into a reporting framework that handles all your filtering, interface, etc in about 15 minutes, or less. How quickly can this be done with web interface (and the Crystal web deployment is not a valid solution, because it doesn't scale.)
If profit and efficiency is a concern (which I'm sure it is for his manager, not sure about you though; Efficiency, yes, profit....well....), then I think he is asking a very valid question. I have been searching the internet extensively the last couple of days for an application that will allow you to easily design and serve up internet based reports, but I have not found a single product that even attempts to reproduce the functionality of the multitude of client server report writers on the market.
And to all of the people who say "why don't you do your homework before you ask questions with obvious answers", you might want to read some of the postings from the helpful and knowledgeable people here, I know I've learned of a few products that I was unable to find in Google.
Re:Blah. (Score:2)
Try doing a little research (Score:2)
I'm as much in favour of linux (and uk spelling) as the next guy but to be fair windows has better tools for this sort of thing.
If you want to go down the linux root then I suggest using perl or php to create a pdf file which the client could then print. It'll require a fair chunk of effort on ur part but the final solution will be infinitely more controllable than it would be on a drag and drop windows system.
Re:Long printed reports are obsolete, deal with it (Score:2)
We have many clients that paper reports for many reasons. In this case, it is what the client wants, not what you want, that is important!
Many people can't see the monitor very well, or it gives them a headache (either vision trouble, or having bi-trifocles, etc. can cause this.) Personally, a monitor gives me a headache after a while. This means I have to print out pages that need extra careful study and look at them on the printed page.
Use VB (Score:3)
First, with VB, you can use ADO to do all the database work. An ADO recordset has support for paging, so you can easily separate your report into pages. It has an easy to use Printer object(which seems to be there by default, I didn't have to declare an object). At the end of each page, all you have to do is call Printer.Print and Printer.NewPage. At the end of your document, call Printer.EndDoc. Presto. A paginated database report, with no external(read: $$$) component. You can further refine your report by setting fonts, etc, but the above outlines the basics.
Another cool thing about VB is that you can drag a WebBrowser control onto your form to make an instant browser. You can then host your web based app in this form. The only reason I recommend doing the printing with VB instead of the web based app is that you generally have to display everything you print if you do it all on the web page, whereas VB you can print things without necessarily displaying them.
I'm hoping Mozilla has the same functionality, as I've done this, with the majority of the application logic in the (cross-platform) web app, using VB only to display the application and to print. If Mozilla has the same functionality, I'll have a powerful application that is cross-platform and updateable without needing to send clients install programs.
Not Difficult (Score:4)
I'm surprised something like this got through. Its kinda like asking 'I'm looking for a way to share files between my multiple machines, and I don't want to use floppy disks any more."
Web-based Reporting Tools (Score:2)
Crystal Reports can be integrated into your application itself as well and features a killer report designer and query builder interface and great printed reports. Crystal Reports can publish report datastraight to the web as well. For more information, check out Seagate's web site [seagate.com].
Business Objects is very popular for its interactive report functionality, where you can drill down into your query getting different levels of information. It helps you avoid information overload in large reports and is generally the tool of choice for doing crossreporting on related queries. For more information, check out Business Object's web site [businessobjects.com].
-Pat
Check out FOP (Score:2)
You will need to use Java (FOP is Java-based), and if the reports are generated on the client, you will need to download about 2.5MB of JAR files to the client for the required libraries. If you use Java servlets, you can generate the reports on the server and save on the size of the download and the processing needed at the client.
What I use... (Score:2)
Brio.Report's got a spiffy-looking GUI design tool, but I honestly haven't used it much. All of my existing reports were written for SQR 3.0 on a VAX so I didn't need to worry about design too much. Amazingly, most of them ran with very minimal modifications.
It seems to be build for batch processing - it's quite happy churning out hundreds of reports at a time. The ActiveX control included with it sucks, though - I wound up writing my own wrapper for it in VB to integrate more easily with IIS. (No flames, please - I have to use what I'm given.) It's certainly capable of generating nicer-looking output than what I'm doing, with GIF and JPEG graphics and such, but appearance isn't my primary concern right now and I don't have time to mess with it.
On the down side, it's not cheap. I believe they license it by server class - on a midrange NT box I think we paid around $10K, and about $15K on an Alpha running OpenVMS. So if this is for home use, you're probably out of luck.
Hope that helps....
Custom tags? (Score:2)
Just a quick aside, there is also the matter of just how page breaks are generated. These are usually part of the printer driver, and there hooks in the word processor, etc for trigger the printer driver code. This was never set up, as far as I know, in HTML. This is a capability that would have to be intergrated via a plugin or something into the browser itself. Now add this to multiple browsers, etc. and you have lots of problems.
I supposed you could generate an activex thing to generate a page break that would get auto loaded into IE, and have it fire when there is a specific tag such as [pgbrk] or similar.
You would also have to integrate specified type sizes so that it still prints correctly even if the user has the parameter to view the browser type set to extra large.
So that is another angle, because then you could set up custom reports using JDBC, Interdev, or similar to pull info from the database. You would just need to generate something that would create a custom tag for the web page
Check out the Vinny the Vampire [eplugz.com] comic strip
Missing something? (Score:5)
Now there are a number of products where you could generate a report for a database with HTML tags inserted in the correct local, then print to a text file. snd a separate one for printing. This essentially generates HTML pages for you as you need. All it becomes is a specialized report, that can be uploaded as needed.
So the best option is to have a report that is generated for web display, and have a second one for download in PDF or whatever for printing.
Let's face it, depending on the database, custom reports etc have been where a lot of database analysts and programmers have made the big bucks for a very long time. While you can get away wit simple reports in something like ms access, in the long run your are going to have to get someone who has the knowledge and experience to put it together right.
When I used to do tech support for a consumer database company, I ran into this all the time - Customers wanting to do sometimes complicated things with only a minute or two of effort. Add in some anomolies because the database was not normalised correctly, and you get a bloody mess. It was not so much the system, as it was getting the query right (Alphabetized by state, then town, then family name, and filtering those custers using master card for purchase over 250$ during the month of december, and who still owe us money as of the end of the preceding month)
Depending on the setup, the query could be trivial or a nuisance.
In some cases, you can't get there from here.
Check out the Vinny the Vampire [eplugz.com] comic strip
Re:Missing something? (Score:2)
Ooh! Ooh! I know. (Score:4)
Paper still has uses (Score:2)
I have a printout of our inter-office phone directory (database-generated with BRL/LaTeX) up on my wall because, although I type fast, my fingers are slower than my eyes for finding a specific name.
Printed reports are also useful for face-to-face meetings.
Hundred-page reports are probably for archival purposes. It's understandable that a lot of people are more comfortable with paper archives than electronic archives, given the general low quality of software today, and the obsolescence, sometimes intentional, of file formats.
Use Cobol, it has a report generator (Score:2)
-- .. . Since I run their ftp+webserver for personal use for free, I might as well put up the link here.
Well, querying the web, I found that imatix [imatix.com] actually has something remotely related
I also found Fujitsu Cobol for the Web [adtools.com].
Done (Score:2)
Re:Long printed reports are obsolete, deal with it (Score:2)
Paperless Society Zealot! Woo!
In your ideal world, it may be the case that you can get away with a paper-free workplace. However, if I handed a disk to the guy who signs my paychecks instead of a printed report, he'd hand me a pink slip instead of a pay check.
The world is going paperless. It's not yet there.
Business Objects. (Score:2)
PDF does what you want (Score:4)
Try PDFLib ( http://www.pdflib.com/ ). I've used it for generating reports from both Perl and PHP web apps, and it's worked great. You can allow users to set fonts, max. # of pages, etc etc.
According to their site, it supports:
ActiveX/COM for use with Visual Basic, Active Server Pages, Allaire ColdFusion, Borland Delphi etc.
ANSI C
Class wrapper for ANSI C++
Java (via Java Native Interface, JNI), including servlets
Perl
PHP hypertext processor
Python
Tcl
I think one of those languages should suit your needs.
With large, hundred-plus page reports, generating PDFs can take a while (and a large chunk of your server CPU) so you will probably want to cache the generated PDFs and serve them up statically for a few hours...of course, it depends on how often the data gets updated in your application.
Crap replies (Score:5)
Crystal Reports (Score:2)
The downside? It tends to be difficult to format complicated reports, it has a archaic data access layer which makes database independence difficult, and the server components only works with Windows/ASP.
--
Convictions are more dangerous enemies of truth than lies.
Re:CrystalReports??? (Score:3)
Contrary Opinion of Crystal Reports (Score:3)
Avoid Crystal Reports at all costs if you can. It's irrating, confusing, and buggy, and it's been that way since I started using it in 1993. On every one job I take I swear I won't use Crystal again, but somehow I keep getting stuck with it, becuase it's already being used, or somebody somewhere thought it was a good idea. If you need formatting and page breaks go with some kind of PDF generator, and find one with a Java interface because you're already on J2EE.
Report generation is one of the necessary evils of business application development, so the best thing you can do is find something that will let the users create their own reports; instead of pestering you to do it for them.
End of grumpy report creator rant.
-----------------
Zope (Score:2)
It sounds like (Score:2)
- CrackElf
Re:A step at a time... (Score:2)
You have never worked on a government project, have you?
Try Jreport (Score:2)
Of course, this applies if you're working with Java.
On the same topic, there's a funnier question: if you are programming in Java your site, you ought to have your data access and manipulations encapsulated, say in beans or EJB's. If you try to use a such a tool to generate reports, you step over this data access classes, something that is not recomendable. Anyone has idea of a tool that permits accessing via my own Persistence Layer and generate the reports anyway? I have searched, but cannot say any one.
Re:No page breaks in HTML (Score:2)