473,390 Members | 1,042 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Looking for XML driven reporting tool


Hi,

I support an enterprise web application (IE client) built in VB6, with about
200 classes, serving about 7000 users, running on 3 clustered servers. I
need to incorporate web reporting for the first time, so I am interested in
learning what web reporting options are out there, and the pros and cons of
each. In general I need to generate reports with XML documents as inputs,
and make them available to all web users.

I am partial to generating PDF docs, but am open to all suggestions.
Ideally they will be generated on the
fly (synchronously), although I could do it asynchronously, and notify users
when the reports are ready to be viewed. I need to reporting engine to be
server safe (i.e. not interested in automating Microsoft Office, and
exporting Access, Word, or Excel to files).

Thanks for any suggestions!

PJ
Nov 12 '05 #1
6 2307
Crystal Reports 10 allows the use of XML as the database for reports and
offers pdf as one of the export options. One caveat, their support is VERY
poor!

Wayne

"P Jones" <p.*****@NOSPAM.private.priv> wrote in message
news:Om*************@TK2MSFTNGP12.phx.gbl...

Hi,

I support an enterprise web application (IE client) built in VB6, with about 200 classes, serving about 7000 users, running on 3 clustered servers. I
need to incorporate web reporting for the first time, so I am interested in learning what web reporting options are out there, and the pros and cons of each. In general I need to generate reports with XML documents as inputs,
and make them available to all web users.

I am partial to generating PDF docs, but am open to all suggestions.
Ideally they will be generated on the
fly (synchronously), although I could do it asynchronously, and notify users when the reports are ready to be viewed. I need to reporting engine to be
server safe (i.e. not interested in automating Microsoft Office, and
exporting Access, Word, or Excel to files).

Thanks for any suggestions!

PJ

Nov 12 '05 #2
if you're using a SQL 2000 database you might wanna look into SQL Server
Reporting Services.

http://www.microsoft.com/sql/reporting/default.asp

"P Jones" wrote:

Hi,

I support an enterprise web application (IE client) built in VB6, with about
200 classes, serving about 7000 users, running on 3 clustered servers. I
need to incorporate web reporting for the first time, so I am interested in
learning what web reporting options are out there, and the pros and cons of
each. In general I need to generate reports with XML documents as inputs,
and make them available to all web users.

I am partial to generating PDF docs, but am open to all suggestions.
Ideally they will be generated on the
fly (synchronously), although I could do it asynchronously, and notify users
when the reports are ready to be viewed. I need to reporting engine to be
server safe (i.e. not interested in automating Microsoft Office, and
exporting Access, Word, or Excel to files).

Thanks for any suggestions!

PJ

Nov 12 '05 #3

Follow-up question: It was suggested to me that I look into XSL-FO to
satisfy my project's requirements (dynamically generate PDF files on a web
server using XML documents as the data source). Can anyone weigh in on the
topic of XSL Formatting Objects, and help me learn what tools are available
and currently being used to generate PDF files from XML?

Thank you in advance!

PJ

"P Jones" <p.*****@NOSPAM.private.priv> wrote in message
news:Om*************@TK2MSFTNGP12.phx.gbl...

Hi,

I support an enterprise web application (IE client) built in VB6, with about 200 classes, serving about 7000 users, running on 3 clustered servers. I
need to incorporate web reporting for the first time, so I am interested in learning what web reporting options are out there, and the pros and cons of each. In general I need to generate reports with XML documents as inputs,
and make them available to all web users.

I am partial to generating PDF docs, but am open to all suggestions.
Ideally they will be generated on the
fly (synchronously), although I could do it asynchronously, and notify users when the reports are ready to be viewed. I need to reporting engine to be
server safe (i.e. not interested in automating Microsoft Office, and
exporting Access, Word, or Excel to files).

Thanks for any suggestions!

PJ

Nov 12 '05 #4
Han
XSL spec in W3C.

http://www.w3.org/TR/2003/WD-xsl11-20031217/

I don't think there is a tool to format arbitrary xmls. You may want to
write your own xslt. There are examples in the spec. There are formatting
tools like FOP which you can download freely.

http://xml.apache.org/fop/index.html

"P Jones" <p.*****@NOSPAM.private.priv> wrote in message
news:un**************@TK2MSFTNGP11.phx.gbl...

Follow-up question: It was suggested to me that I look into XSL-FO to
satisfy my project's requirements (dynamically generate PDF files on a web
server using XML documents as the data source). Can anyone weigh in on the topic of XSL Formatting Objects, and help me learn what tools are available and currently being used to generate PDF files from XML?

Thank you in advance!

PJ

"P Jones" <p.*****@NOSPAM.private.priv> wrote in message
news:Om*************@TK2MSFTNGP12.phx.gbl...

Hi,

I support an enterprise web application (IE client) built in VB6, with

about
200 classes, serving about 7000 users, running on 3 clustered servers. I need to incorporate web reporting for the first time, so I am interested

in
learning what web reporting options are out there, and the pros and cons

of
each. In general I need to generate reports with XML documents as inputs, and make them available to all web users.

I am partial to generating PDF docs, but am open to all suggestions.
Ideally they will be generated on the
fly (synchronously), although I could do it asynchronously, and notify

users
when the reports are ready to be viewed. I need to reporting engine to be server safe (i.e. not interested in automating Microsoft Office, and
exporting Access, Word, or Excel to files).

Thanks for any suggestions!

PJ


Nov 12 '05 #5

Sorry, I should have specified, I am looking for tools that run on a Windows
platform to generate PDF files on a web
server using XML documents as the data source. Can anyone help me learn
what tools are
available and currently being used to generate PDF files from XML on a
Windows desktop or server?

Many thanks.

PJ
"Han" <hp****@kornet.net.korea> wrote in message
news:e9**************@TK2MSFTNGP10.phx.gbl...
XSL spec in W3C.

http://www.w3.org/TR/2003/WD-xsl11-20031217/

I don't think there is a tool to format arbitrary xmls. You may want to
write your own xslt. There are examples in the spec. There are formatting
tools like FOP which you can download freely.

http://xml.apache.org/fop/index.html

"P Jones" <p.*****@NOSPAM.private.priv> wrote in message
news:un**************@TK2MSFTNGP11.phx.gbl...

Follow-up question: It was suggested to me that I look into XSL-FO to
satisfy my project's requirements (dynamically generate PDF files on a web
server using XML documents as the data source). Can anyone weigh in on the
topic of XSL Formatting Objects, and help me learn what tools are

available
and currently being used to generate PDF files from XML?

Thank you in advance!

PJ

"P Jones" <p.*****@NOSPAM.private.priv> wrote in message
news:Om*************@TK2MSFTNGP12.phx.gbl...

Hi,

I support an enterprise web application (IE client) built in VB6, with

about
200 classes, serving about 7000 users, running on 3 clustered servers. I need to incorporate web reporting for the first time, so I am
interested in
learning what web reporting options are out there, and the pros and
cons of
each. In general I need to generate reports with XML documents as

inputs, and make them available to all web users.

I am partial to generating PDF docs, but am open to all suggestions.
Ideally they will be generated on the
fly (synchronously), although I could do it asynchronously, and notify

users
when the reports are ready to be viewed. I need to reporting engine
to be server safe (i.e. not interested in automating Microsoft Office, and
exporting Access, Word, or Excel to files).

Thanks for any suggestions!

PJ



Nov 12 '05 #6
PJ

I am using FOP http://xml.apache.org/fop/ to generate PDF's. The apache site
has some good information on the various moving parts. I have a win2k server
running tomcat and have created a java servlet that reads xml data and
transforms it using an xsl file (which is nothing but adding XLS:FO
formatting info).
The 2 main steps here are first converting your XML data into XSL:FO format
and then using the FOP API to create PDF.

here some sample java code using FOP API (this is the 2nd step after getting
your data in XSL:FO format)

public void renderFO(InputSource foFile,
HttpServletResponse response) throws
ServletException {
long coll_event_c_entity_id = 0;
try {

// Generate PDF from FO

ByteArrayOutputStream out = new ByteArrayOutputStream();
Driver driver = new Driver(foFile, out);
driver.setRenderer(Driver.RENDER_PDF);
driver.run();

byte[] content = out.toByteArray();

// Send output to Browser

response.setContentType("application/pdf");
response.setContentLength(content.length);
response.getOutputStream().write(content);
response.getOutputStream().flush();
} catch (Exception ex) {

throw new ServletException(ex.getMessage(),ex);

}
}

"P Jones" <p.*****@NOSPAM.private.priv> wrote in message
news:eg**************@TK2MSFTNGP12.phx.gbl...

Sorry, I should have specified, I am looking for tools that run on a Windows platform to generate PDF files on a web
server using XML documents as the data source. Can anyone help me learn
what tools are
available and currently being used to generate PDF files from XML on a
Windows desktop or server?

Many thanks.

PJ
"Han" <hp****@kornet.net.korea> wrote in message
news:e9**************@TK2MSFTNGP10.phx.gbl...
XSL spec in W3C.

http://www.w3.org/TR/2003/WD-xsl11-20031217/

I don't think there is a tool to format arbitrary xmls. You may want to
write your own xslt. There are examples in the spec. There are formatting
tools like FOP which you can download freely.

http://xml.apache.org/fop/index.html

"P Jones" <p.*****@NOSPAM.private.priv> wrote in message
news:un**************@TK2MSFTNGP11.phx.gbl...

Follow-up question: It was suggested to me that I look into XSL-FO to
satisfy my project's requirements (dynamically generate PDF files on a web server using XML documents as the data source). Can anyone weigh in on the
topic of XSL Formatting Objects, and help me learn what tools are

available
and currently being used to generate PDF files from XML?

Thank you in advance!

PJ

"P Jones" <p.*****@NOSPAM.private.priv> wrote in message
news:Om*************@TK2MSFTNGP12.phx.gbl...
>
> Hi,
>
> I support an enterprise web application (IE client) built in VB6,
with about
> 200 classes, serving about 7000 users, running on 3 clustered servers.
I
> need to incorporate web reporting for the first time, so I am

interested in
> learning what web reporting options are out there, and the pros and cons of
> each. In general I need to generate reports with XML documents as

inputs,
> and make them available to all web users.
>
> I am partial to generating PDF docs, but am open to all suggestions.
> Ideally they will be generated on the
> fly (synchronously), although I could do it asynchronously, and

notify users
> when the reports are ready to be viewed. I need to reporting engine

to
be
> server safe (i.e. not interested in automating Microsoft Office, and
> exporting Access, Word, or Excel to files).
>
> Thanks for any suggestions!
>
> PJ
>
>



Nov 12 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Alex | last post by:
Subject: Looking for an XML (database-based) Query Reporting Tool/advice First off, let me apologize if this thread is somewhat off topic... PLEASE REPLY TO: xml@solex-bi.com I am looking...
6
by: Bob | last post by:
I want to dump Crystal, one of the many reasons being that it requires a client-side installation. I'm looking for a reporting package that integrates into DotNet yet has absolutely no COM in it,...
1
by: John | last post by:
Hi vs2005 rc/sql server 2005 sep ctp. In vs 2005 when I try to add an item there are two icons 'report' and 'crystal report'. What is the difference between these two and sql server reporting?...
1
by: Mathieu [Marti-IT] | last post by:
Hi all, in creating a C# Windows Forms library to create professional applications with. In searching for a good reporting tool to create and distribute my applications reports with. Does anyone...
3
by: antonyliu2002 | last post by:
I am looking for a free reporting package for .net 2.0 against Oracle database 10g. The web application I am working on will let office staff members who don't know much about database generate...
0
by: AMDRIT | last post by:
I am looking for better concrete examples, as I am a bit dense, on design patterns that facilitate my goals. I have been out to the code project, planet source code, and microsoft's patterns and...
0
by: itsraghz | last post by:
Hello people, My present project need is to have an Open Source Java based reporting tool, which would allow the users to customize the fields to be chosen at runtime. The chosen fields are used...
3
by: John | last post by:
Hi I develop database winform apps which consist of several one-many forms. This is a pretty repetitive task and I wonder if there are tools that can speed up this generation of one-many forms...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

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.