XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » How my applications can generate from xml; html / pdf / excel reports
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + What Pipeline standard do you ... (4)
-> + How can i increase sylus memor... (2)
-> - Tutorial & Tech support needed (1)
-> + Generate HTML Documentation fr... (3)
-> + Use of saxonsa outside stylus ... (2)
-> + Schema to DTD (6)
-> + Trial version requires interne... (4)
-> - APACHE FOP text box (1)
-> + Cannot create SQL Server datas... (11)
-> + StylusValidator Crashes (2)
-> + XML diff with optimize Change ... (2)
-> + how do I get the .xsl page to ... (3)
-> + Can't Use WYSIWYG from the Fil... (6)
-> + EDI Help (2)
-> + XInclude support (3)
-> + Editor options and customized ... (3)
-> + Licensed version connectes to ... (6)
-> + handling abstract types in the... (5)
-> + XML not validating against its... (4)
-> + SS gets into state where the "... (6)
-> + Download Link from Order email... (2)
-> + Stylus Studio doesn't run (2)
-> + Indent XML Tags uses pretty sh... (2)
-> + Some questions on supported pl... (3)
-> + Apache FOP Border (2)
-> + line numbers, line-wrap.. (11)
-> + Not Able to Load Siebel Web Se... (3)
-> + XSLT node or nodeset as scenar... (4)
-> - tree view parsing error: Expec... (1)
-> + reactivating the license key f... (2)
-> + XSL FO region-body border (2)
-> + WhiteSpace facet default (2)
-> - Web Service Call (1)
-> + DB to XML convertion (6)
-> + Converting: How to handle data... (2)
-> + Toss Character Exception (2)
-> + EDI conversion COM segment (5)
-> - SS passing invalid CALS table ... (1)
-> + Carrier Related EDI SAP questi... (2)
-> + How to generate 1 output XML f... (2)
-> + Urgent Eval: How2 w/ Possibly ... (4)
-> + Preview Problems (7)
-> + Mapping to EDIFACT ORDERS UNT0... (8)
-> + Deploying Conversion XML to ED... (2)
-> + Use EDI Adapter within Sap BC (3)
-> + Uninstall->instal entepr. 2007 (2)
-> - xml data to sql 2000 table (1)
-> - Convert from Oracle DB to XML ... (1)
-> + NTFShardlink broken (5)
-> + Can't get catalog to work (3)
-> + Only One of each EDI segment g... (3)
-> + convert (2)
-> + convert (4)
-> + EDIFACT to XSD problem (3)
-> + quark xpress tags (2)
-> + Duplicating nodes allows to cr... (2)
-> + Duplicated, unused nodes are r... (3)
-> + Converting to XML from a varie... (5)
-> + xsd:import's with escaped char... (8)
-> + Viewing the FO Sample Applicat... (3)
-> + Stylus Studio - Window tiling (3)
-> + Question about XML->Java Objec... (2)
-> + SVG web-based editor (2)
-> + conversion process for the pdf... (2)
-> + GUI Mapper does not create pro... (4)
-> + JavaScript working inside prev... (4)
-> + Stylus Studio Crashes when I a... (4)
-> + SVG ImageReader for FOP (2)
-> + Web Service Call Using HTTPS (8)
-> + Meditech database (2)
-> + How to connect to Informix (5)
-> + long filenames in Berkeley XML... (3)
-> + Opening multiple documents = m... (3)
-> + MySQL Connectivity (2)
-> + using .xsd to create forms (3)
-> + Convert-to-XML Engine could no... (2)
-> + editor questions (2)
-> + Cannot connect to SQL server (7)
-> + Convert Cobol file to XML (2)
-> + XML Diff problem (4)
-> + running XSLT - time + memory m... (7)
-> + New wsdl creation (4)
-> + DB to XML Parameters (2)
-> + Help (html in xml) need to out... (8)
-> + Stylesheet questions (2)
-> + Verion 1.0 XPATH for testing "... (5)
-> + Berkely XML DB file system (2)
-> + WYSIWYG in 2007 demo (2)
-> + EDIFACT code list problem (3)
-> + XQuery over a Berkeley XML DB ... (3)
-> + Href and display linked ref. (2)
-> - How my applications can gener... (11)
-> -> How my applications can ...
-> -> How my applications can ...
-> -> How my applications can ...
-> -> How my applications can ...
-> -> How my applications can ...
-> -> How my applications can ...
-> -> How my applications can ...
-> -> How my applications can ...
-> -> How my applications can ...
-> -> How my applications can ...
-> + CLASSPATH (2)
-> + Fixed order of attributes (2)
-> + merging XML files (13)
-> - The Struzzo.exe hung with no G... (1)
-> + Problem Registering Old Versio... (4)
-> + CHART.XML + CHART.XSL to CHART... (17)
-> + Aplication not loading (6)
-> + Can Stylus Studio be used to s... (2)
-- Previous [1801-1820] [1821-1840] [1841-1860] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
e pSubject: 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

Postnext
Ivan PedruzziSubject: 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
Postnext
e pSubject: 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.

Postnext
e pSubject: 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 ?
Postnext
Ivan PedruzziSubject: 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
Postnext
e pSubject: 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

Postnext
Ivan PedruzziSubject: 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
Postnext
Ivan PedruzziSubject: 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
Postnext
e pSubject: 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
Postnext
e pSubject: 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>


Unknownxml(1).zip
Posttop
Ivan PedruzziSubject: 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


Unknownfo.ZIP
sample project
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.