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 » XSLT Help and Discussion » xsl report, with xml feed, SVG components and connection to SQL server
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + How to change XSLT parameter s... (3)
-> + how to change format of the da... (2)
-> + Search "Next 8 Results " doesn... (2)
-> - Support for Git (1)
-> + newbee (8)
-> + How to substitute element or t... (2)
-> + Xalan support in x16? (2)
-> + The context item for axis step... (5)
-> - ASP to XSL (1)
-> - xsl report, with xml feed, SVG... (7)
-> ->xsl report, with xml feed...
-> ->xsl report, with xml feed...
-> ->xsl report, with xml feed...
-> ->xsl report, with xml feed...
-> ->xsl report, with xml feed...
-> ->xsl report, with xml feed...
-> + XSLT code to transform CSV typ... (2)
-> + Make xstl file working in brow... (4)
-> + identity template, result-docu... (6)
-> - identity template and xsl:resu... (1)
-> + java.lang.RuntimeException: Er... (5)
-> + How to check matching parenthe... (2)
-> - Error only on using xalan:eval... (1)
-> + XSLT not displaying SOAP respo... (2)
-> + How do i delete the node from ... (2)
-> + How to break xslt lines to mak... (4)
-> - Marge node using attribute val... (1)
-> - Replce utf to unicode using xs... (1)
-> - getting different instances of... (1)
-> + XML to Flat (4)
-> + non breaking space   in e... (2)
-> - How can i attach a empty names... (1)
-> + Cannot find a matching 1-argum... (7)
-> - get value from different docum... (1)
-> + How can I change the XML heade... (2)
-> + Stylus Studio and Datapower (9)
-> + Generate XML form a XSD (2)
-> + There is no way to run xslt tr... (3)
-> + XML-Source NS is copied into t... (3)
-> + new guy attempting xslt (2)
-> + XML 2011 question (7)
-> + Manipulating XML with external... (2)
-> + removing duplicates from xml w... (8)
-> + Wnat to use presence of tag t... (2)
-> + modifing Andrew Welch's csv 2 ... (5)
-> + Can't use (or see) XSLT or WYS... (3)
-> + Delete the xsi:nil attribute ... (2)
-> + FOTY0012: Cannot get the typed... (20)
-> + XSLT Mapper - Two way xslt map... (2)
-> + EDI (5)
-> + XSL Test for lack of XML eleme... (4)
-> + Trouble Calling a java functio... (4)
-> + How to generate EDI 997 (2)
-> + followup on tokenize with /r (5)
-> + tokenize a string with \r (4)
-> + How to convert XML to XLS file... (2)
-> - How to convert XML to XLS file... (1)
-> + how to pass value to xsl for t... (3)
-> + entity expansion liimit exceed... (4)
-> + Creating XSLT Stylesheet (2)
-> + Create XSLT from XSD (2)
-> + How to remove nodes from xml b... (4)
-> + Highlighting text in XSL file (4)
-> - XSLT to Excel, predefine cell ... (1)
-> + CSaxon8Driver issue...time out (2)
-> + Is it possible to generate a X... (2)
-> + Is there any tool which genera... (2)
-> + xslt to html producing double ... (2)
-> - ADD 2 XML 2 Generate Single XM... (1)
-> + converting XML1 to XML2 struct... (2)
-> + How to remove the name space i... (2)
-> + Dump Payload into String (4)
-> + Converting Global EDIFACT into... (2)
-> + Auto mapping of XSLT? (3)
-> + Numbering a list broken into m... (3)
-> + help in xsl:analyze-string (2)
-> + Use XSLT with SOAP (2)
-> + Order of Processing Child Elem... (2)
-> + XSL finding a node based on va... (2)
-> + grouping a group? (11)
-> + Query on Looping (5)
-> + java.lang.Assertionerror_: Slo... (7)
-> + CONVERT SQL Server data to XML... (11)
-> + Error using "xsltproc" command... (3)
-> + XML refresh via web broswer (3)
-> + XSL-mapping usage for csv file... (4)
-> + form controls with xslt (2)
-> + Stylus Studio 2011 XML Enterpr... (2)
-> + Looping through Itema and gett... (2)
-> + Image src through System Varia... (3)
-> + XSL-mapping usage for csv file... (3)
-> + How to achieve UTF-8 encoding ... (2)
-> + sorting Using JavaScript (6)
-> + Display values from .xml horiz... (5)
-> + query on xslt for-each (3)
-> + query on xslt for-each (2)
-> + issue for First occurance (2)
-> + XSL: Mapping 2 XSD to 1 XSD (2)
-> + xslt mapper looses linkage fro... (2)
-> - How to Modify only few nodes a... (1)
-> + XSLT autocomplete function (2)
-> + i need to display dynamic list... (2)
-> + How to group when source has m... (11)
-> - Using EXCEL to create XSLT for... (1)
-> + Mapper generating XSLT, popula... (2)
-> + multiple columns (2)
-- [1-20] [21-40] [41-60] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Sanj MicunovicSubject: xsl report, with xml feed, SVG components and connection to SQL server
Author: Sanj Micunovic
Date: 12 Feb 2016 08:21 AM
Hello,

I would appreciate if you can give us a hint how in ONE xsl report that is fed from an xml we can draw:

1) Bar Chart which gets data from MS SQL database
2) and the same report should have a table that gets data from xml feed.

Our problem is not a table that gets data from xml. We are stuck in creating SVG Bar Chart that should be getting data from MS SQL.

Best Regards,
Sanja Micunovic
Postnext
Ivan PedruzziSubject: xsl report, with xml feed, SVG components and connection to SQL server
Author: Ivan Pedruzzi
Date: 12 Feb 2016 05:01 PM

Sanj,

Are you coding your XSLT manually or using Stylus Studio XML Publisher?

What your desired output (HTML, PDF, SVG)?

XML Publisher allows you to use relational data for populating dynamic content but you will need to generate XQuery and it does not feature charts.

If you willing to code your transformation manually, Stylus Studio bundles an SVG example which you could alter to generate table and chart in a single SVG. Alternatively you could generate PDF with embedded SVG.
See example "Instream SVG in XSL FO" at http://www.renderx.com/usecasestest.html

Does it help?

Ivan Pedruzzi
Stylus Studio Team

Postnext
David BartellSubject: xsl report, with xml feed, SVG components and connection to SQL server
Author: David Bartell
Date: 30 Oct 2019 03:43 PM
I have the latest version of Stylus Studio, but can not find the SVG example (chart.xsl or examples.prj) anywhere in the install directory. I had the examples option checked when I installed.

Is there a trick to that, or is it just not included anymore?

Postnext
Ivan PedruzziSubject: xsl report, with xml feed, SVG components and connection to SQL server
Author: Ivan Pedruzzi
Date: 30 Oct 2019 07:34 PM
David,

The example is simple SVG document located at

c:\Users\Public\Documents\Stylus Studio X16 XML Enterprise 64-bit\examples\SVG


Ivan Pedruzzi
Stylus Studio Team
Postnext
David BartellSubject: xsl report, with xml feed, SVG components and connection to SQL server
Author: David Bartell
Date: 30 Oct 2019 07:40 PM
Found them, thanks!
Postnext
Sanj MicunovicSubject: xsl report, with xml feed, SVG components and connection to SQL server
Author: Sanj Micunovic
Date: 13 Feb 2016 09:12 AM
Hello Ivan,

I don't have much experience with this stuff.

We recently bought Stylus Studio and I got a task to create xsl report. Report will be displayed in browser as html report.
Source will be xml. For the time being I can skip a part connecting to relational database. I could get everything in that source xml.

But my ultimate goal is to have on one xsl report 1)table and 2)hart.

In the past for this my colleagues were using vbscript. But would it be possible to embed svg instead?

In short would you be able to share with me small example where you have a table and bar chart?

Best Regards,
Sanja
Posttop
Sanj MicunovicSubject: xsl report, with xml feed, SVG components and connection to SQL server
Author: Sanj Micunovic
Date: 13 Feb 2016 04:02 PM
Hello Ivan,

Just to say I managed somehow. So we can close this.

Thanks Sanja
   
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.