SSDN - How my applications can generate from xml; html / pdf / excel reports

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

e p

Subject: How my applications can generate from xml; html / pdf / excel reports
Author: e p
Date: 29 Oct 2006 06:14 AM

Hi,

In our company we need that our application will generate a report for browsing and printing

Our application can produce data in XML format and we look for a method that enables my application to produce: html pdf and excel from this xml.

I saw that Stylus studio produces such output from xml.report
but I didn't understand how my application can do this:

1) my application is running on WinXP win2K OS
2) it is not server based (a simple exe application)
3) what software should be added to my application in order to accomplish the report generating?
4) can these software elements can be distributed with my software for free?

can you describe me the process:
a) my app generates xml file data.xml

.... ?? what should be done from my app here?

till data.html data.pdf and data.xls are generated
and can be opened by user.

(I prefer generation mail html (mhtm) - all in one file)

thanks,
As soon as I get the answer and check it really works
we will buy the Stylus studio 2007 Enterprise (I have the budget)

I need replay ASAP

Ivan Pedruzzi

Subject: How my applications can generate from xml; html / pdf / excel reports
Author: Ivan Pedruzzi
Date: 17 Jun 2008 12:07 PM
Originally Posted: 29 Oct 2006 02:59 PM

The Stylus Studio XML Publisher creates reports as XSLT or XQuery tranformations.

You need to check if the language/framework you are using to build your application supports XSLT.

For example C# (.NET) has built-in support for XSLT, in C++ you can use Microsoft MSXML.

For question number 4 it depends if you need to build report on data that is not XML like relational database or flat files

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

e p

Subject: How my applications can generate from xml; html / pdf / excel reports
Author: e p
Date: 30 Oct 2006 01:01 AM

We use VC++ 6.0
We use MSXML DOM for creating the xml data file

I understeand that I use StylusStodio to generate two fixed xsl files:
data_pdf.xsl (XSL-FO XSLT 2.0)
and
data_htm.xsl (HTML+CSS and XSLT1.0)

each time my application generates data.xml
I would like to create the pdf and html reports.

what code should I use from my VC6.0 application to generate:
from data_pdf.xsl and data.xml the pdf file
and
from data_htm.xsl and data.xml the html file

a VC 6.0 code sample will be extremly helpful

thanks.

e p

Subject: How my applications can generate from xml; html / pdf / excel reports
Author: e p
Date: 31 Oct 2006 12:32 PM

can't I get response by this forum - only by phone ?

Ivan Pedruzzi

Subject: How my applications can generate from xml; html / pdf / excel reports
Author: Ivan Pedruzzi
Date: 31 Oct 2006 01:46 PM

As you know generate PDF documents using XSLT FO is a two steps process

1) translate XML to XSL:FO using an XSLT processor
2) Create PDF from XSL:FO using a FO processor

This is a quick tutorial that shows how to run XSLT transformation using MSXML
http://www.codeguru.com/cpp/data/data-misc/xml/article.php/c4565/#more

I am sure you will be able to find more on Microsoft Developer Network
http://msdn.microsoft.com/library/en-us/xmlsdk/html/b24aafc2-bf1b-4702-bf1c-b7ae3597eb0c.asp

As FO processor you can either use a Java based version like

Apache FOP open source
http://xmlgraphics.apache.org/fop/

RenderX commercial
http://www.renderx.com/tools/xep.html

C++
AntennaHouse Commercial
http://msdn.microsoft.com/library/en-us/xmlsdk/html/b24aafc2-bf1b-4702-bf1c-b7ae3597eb0c.asp

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

e p

Subject: How my applications can generate from xml; html / pdf / excel reports
Author: e p
Date: 02 Nov 2006 02:06 AM

Sorry I need more help...

We need to sell our application with the ability to produce html and PDF reports from a simple xml data file we produce.

We need a solution which:
1) The only cost for us is Stylus and maybe one more developing
software but no additional cost for user!
2) A simple solution for us as programmers and for user to install our application

For generating html report we can use MSXML4 which is simple to use from our VC++6.0

BUT XML-FO --> PDF is very complicated...
I saw that if I want to use Apache FOP
I need user to install Apache tomcat server with cocoon - to make this FOP work ... it is much too complicated solution.

A simple way similar to using MSXML is needed also for the PDF generation otherwise we can't use your very nice package for our needs

I thought that producing html and PDF reports from an application would be a trivial task using your sophisticated system!

I need to finish the report creation next week PLEASE help me ASAP

Ivan Pedruzzi

Subject: How my applications can generate from xml; html / pdf / excel reports
Author: Ivan Pedruzzi
Date: 02 Nov 2006 08:23 AM

To run FOP you just need the FOP library and the Java Virtual machine.
Stylus Studio does exaclty that.

Ivan Pedruzzi
Stylus Studio Team

Ivan Pedruzzi

Subject: How my applications can generate from xml; html / pdf / excel reports
Author: Ivan Pedruzzi
Date: 02 Nov 2006 12:04 PM

Here how the FOP command line looks like

java.exe -cp fop.jar org.apache.fop.apps.Fop [fop config pathname] [xslfo pathname] [output pathname]

Here what you app needs to do

1) bundle Apache FOP

2) be sure that the target system has the Java Virtual Machine installed

3) Run a stylesheet using MSXML to translate your XML document to XSL:FO

4) Use FOP to translate XSL:FO to PDF

For step 3 Stylus Studio XML Publisher may be helpful to design the stylesheet.

Makes sense?

Ivan Pedruzzi
Stylus Studio Team

e p

Subject: How my applications can generate from xml; html / pdf / excel reports
Author: e p
Date: 02 Nov 2006 12:43 PM
Originally Posted: 02 Nov 2006 12:44 PM

If I use images in xml is enogh to use the FOP?
I herd I need something from coocon!?!?

thanks

e p

Subject: How my applications can generate from xml; html / pdf / excel reports
Author: e p
Date: 02 Nov 2006 12:53 PM

can you please take a look on errors:

D:\_Docs\Install\XSLT\fop-0.92beta>fop -xml D:/xml/d.xml -xsl D:/xml/d_pdf.xsl -
pdf D:/xml/d.pdf
Nov 2, 2006 7:51:34 PM org.apache.fop.fo.FONode attributeWarning
WARNING: Warning(Unknown location): fo:table, table-layout="auto" is currently n
ot supported by FOP
Nov 2, 2006 7:51:34 PM org.apache.fop.fo.FONode attributeWarning
WARNING: Warning(Unknown location): fo:table, table-layout="auto" is currently n
ot supported by FOP
Nov 2, 2006 7:51:34 PM org.apache.fop.fo.FONode attributeWarning
WARNING: Warning(Unknown location): fo:table, table-layout="auto" is currently n
ot supported by FOP
Nov 2, 2006 7:51:34 PM org.apache.fop.fo.FONode attributeWarning
WARNING: Warning(Unknown location): fo:table, table-layout="auto" is currently n
ot supported by FOP
Nov 2, 2006 7:51:34 PM org.apache.fop.fonts.FontInfo notifyFontReplacement
WARNING: Font 'Arial,normal,400' not found. Substituting with default font.
Nov 2, 2006 7:51:34 PM org.apache.fop.fo.FOTreeBuilder$MainFOHandler endElement
WARNING: Mismatch: page-sequence (http://www.w3.org/1999/XSL/Format) vs. root (h
ttp://www.w3.org/1999/XSL/Format)
Nov 2, 2006 7:51:34 PM org.apache.fop.fo.FOTreeBuilder fatalError
SEVERE: javax.xml.transform.TransformerException: java.lang.NullPointerException

Nov 2, 2006 7:51:34 PM org.apache.fop.cli.Main startFOP
SEVERE: Exception
javax.xml.transform.TransformerException: java.lang.NullPointerException
at org.apache.fop.cli.InputHandler.transformTo(InputHandler.java:167)
at org.apache.fop.cli.InputHandler.renderTo(InputHandler.java:114)
at org.apache.fop.cli.Main.startFOP(Main.java:159)
at org.apache.fop.cli.Main.main(Main.java:190)

---------

; SystemID: file:///D:/xml/d_pdf.xsl; Line#: 4; Column#: 90
javax.xml.transform.TransformerException: java.lang.NullPointerException
at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(Tr
ansformerImpl.java:2416)
at org.apache.xalan.transformer.TransformerImpl.applyTemplateToNode(Tran
sformerImpl.java:2281)
at org.apache.xalan.transformer.TransformerImpl.transformNode(Transforme
rImpl.java:1367)
at org.apache.xalan.transformer.TransformerImpl.transform(TransformerImp
l.java:709)
at org.apache.xalan.transformer.TransformerImpl.transform(TransformerImp
l.java:1284)
at org.apache.xalan.transformer.TransformerImpl.transform(TransformerImp
l.java:1262)
at org.apache.fop.cli.InputHandler.transformTo(InputHandler.java:164)
at org.apache.fop.cli.InputHandler.renderTo(InputHandler.java:114)
at org.apache.fop.cli.Main.startFOP(Main.java:159)
at org.apache.fop.cli.Main.main(Main.java:190)
Caused by: java.lang.NullPointerException
at org.apache.fop.layoutmgr.table.TableLayoutManager.getNextKnuthElement
s(TableLayoutManager.java:158)
at org.apache.fop.layoutmgr.inline.InlineLayoutManager.getNextKnuthEleme
nts(InlineLayoutManager.java:294)
at org.apache.fop.layoutmgr.inline.LineLayoutManager.collectInlineKnuthE
lements(LineLayoutManager.java:647)
at org.apache.fop.layoutmgr.inline.LineLayoutManager.getNextKnuthElement
s(LineLayoutManager.java:582)
at org.apache.fop.layoutmgr.BlockStackingLayoutManager.getNextKnuthEleme
nts(BlockStackingLayoutManager.java:275)
at org.apache.fop.layoutmgr.BlockLayoutManager.getNextKnuthElements(Bloc
kLayoutManager.java:105)
at org.apache.fop.layoutmgr.BlockStackingLayoutManager.getNextKnuthEleme
nts(BlockStackingLayoutManager.java:275)
at org.apache.fop.layoutmgr.BlockLayoutManager.getNextKnuthElements(Bloc
kLayoutManager.java:105)
at org.apache.fop.layoutmgr.BlockStackingLayoutManager.getNextKnuthEleme
nts(BlockStackingLayoutManager.java:275)
at org.apache.fop.layoutmgr.BlockLayoutManager.getNextKnuthElements(Bloc
kLayoutManager.java:105)
at org.apache.fop.layoutmgr.FlowLayoutManager.getNextKnuthElements(FlowL
ayoutManager.java:98)
at org.apache.fop.layoutmgr.PageSequenceLayoutManager$PageBreaker.getNex
tKnuthElements(PageSequenceLayoutManager.java:234)
at org.apache.fop.layoutmgr.AbstractBreaker.getNextBlockList(AbstractBre
aker.java:502)
at org.apache.fop.layoutmgr.PageSequenceLayoutManager$PageBreaker.getNex
tBlockList(PageSequenceLayoutManager.java:226)
at org.apache.fop.layoutmgr.AbstractBreaker.doLayout(AbstractBreaker.jav
a:252)
at org.apache.fop.layoutmgr.AbstractBreaker.doLayout(AbstractBreaker.jav
a:220)
at org.apache.fop.layoutmgr.PageSequenceLayoutManager.activateLayout(Pag
eSequenceLayoutManager.java:152)
at org.apache.fop.area.AreaTreeHandler.endPageSequence(AreaTreeHandler.j
ava:320)
at org.apache.fop.fo.pagination.PageSequence.endOfNode(PageSequence.java
:147)
at org.apache.fop.fo.FOTreeBuilder$MainFOHandler.endElement(FOTreeBuilde
r.java:357)
at org.apache.fop.fo.FOTreeBuilder.endElement(FOTreeBuilder.java:193)
at org.apache.xml.serializer.ToXMLSAXHandler.endElement(ToXMLSAXHandler.
java:261)
at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResul
t.java:1399)
at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(Tr
ansformerImpl.java:2411)
... 9 more
---------
java.lang.NullPointerException
at org.apache.fop.layoutmgr.table.TableLayoutManager.getNextKnuthElement
s(TableLayoutManager.java:158)
at org.apache.fop.layoutmgr.inline.InlineLayoutManager.getNextKnuthEleme
nts(InlineLayoutManager.java:294)
at org.apache.fop.layoutmgr.inline.LineLayoutManager.collectInlineKnuthE
lements(LineLayoutManager.java:647)
at org.apache.fop.layoutmgr.inline.LineLayoutManager.getNextKnuthElement
s(LineLayoutManager.java:582)
at org.apache.fop.layoutmgr.BlockStackingLayoutManager.getNextKnuthEleme
nts(BlockStackingLayoutManager.java:275)
at org.apache.fop.layoutmgr.BlockLayoutManager.getNextKnuthElements(Bloc
kLayoutManager.java:105)
at org.apache.fop.layoutmgr.BlockStackingLayoutManager.getNextKnuthEleme
nts(BlockStackingLayoutManager.java:275)
at org.apache.fop.layoutmgr.BlockLayoutManager.getNextKnuthElements(Bloc
kLayoutManager.java:105)
at org.apache.fop.layoutmgr.BlockStackingLayoutManager.getNextKnuthEleme
nts(BlockStackingLayoutManager.java:275)
at org.apache.fop.layoutmgr.BlockLayoutManager.getNextKnuthElements(Bloc
kLayoutManager.java:105)
at org.apache.fop.layoutmgr.FlowLayoutManager.getNextKnuthElements(FlowL
ayoutManager.java:98)
at org.apache.fop.layoutmgr.PageSequenceLayoutManager$PageBreaker.getNex
tKnuthElements(PageSequenceLayoutManager.java:234)
at org.apache.fop.layoutmgr.AbstractBreaker.getNextBlockList(AbstractBre
aker.java:502)
at org.apache.fop.layoutmgr.PageSequenceLayoutManager$PageBreaker.getNex
tBlockList(PageSequenceLayoutManager.java:226)
at org.apache.fop.layoutmgr.AbstractBreaker.doLayout(AbstractBreaker.jav
a:252)
at org.apache.fop.layoutmgr.AbstractBreaker.doLayout(AbstractBreaker.jav
a:220)
at org.apache.fop.layoutmgr.PageSequenceLayoutManager.activateLayout(Pag
eSequenceLayoutManager.java:152)
at org.apache.fop.area.AreaTreeHandler.endPageSequence(AreaTreeHandler.j
ava:320)
at org.apache.fop.fo.pagination.PageSequence.endOfNode(PageSequence.java
:147)
at org.apache.fop.fo.FOTreeBuilder$MainFOHandler.endElement(FOTreeBuilde
r.java:357)
at org.apache.fop.fo.FOTreeBuilder.endElement(FOTreeBuilder.java:193)
at org.apache.xml.serializer.ToXMLSAXHandler.endElement(ToXMLSAXHandler.
java:261)
at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResul
t.java:1399)
at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(Tr
ansformerImpl.java:2411)
at org.apache.xalan.transformer.TransformerImpl.applyTemplateToNode(Tran
sformerImpl.java:2281)
at org.apache.xalan.transformer.TransformerImpl.transformNode(Transforme
rImpl.java:1367)
at org.apache.xalan.transformer.TransformerImpl.transform(TransformerImp
l.java:709)
at org.apache.xalan.transformer.TransformerImpl.transform(TransformerImp
l.java:1284)
at org.apache.xalan.transformer.TransformerImpl.transform(TransformerImp
l.java:1262)
at org.apache.fop.cli.InputHandler.transformTo(InputHandler.java:164)
at org.apache.fop.cli.InputHandler.renderTo(InputHandler.java:114)
at org.apache.fop.cli.Main.startFOP(Main.java:159)
at org.apache.fop.cli.Main.main(Main.java:190)
D:\_Docs\Install\XSLT\fop-0.92beta>

Ivan Pedruzzi

Subject: How my applications can generate from xml; html / pdf / excel reports
Author: Ivan Pedruzzi
Date: 02 Nov 2006 06:54 PM

FOP has built-in support for JPEG; for PNG you will need to download a separate library.
http://xmlgraphics.apache.org/fop/0.20.5/graphics.html

To embed fonts in you document you will need to edit the FOP configuration file called userconfig.xml and un-comment the font section you would like to use

You will also need to generate the font metric files as decribed in the documentation.
http://xmlgraphics.apache.org/fop/0.20.5/fonts.html

Watch out because the Apache TTFReader utility works only with Java 1.4.x

Ivan Pedruzzi
Stylus Studio Team

fo.ZIP
sample project

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.