XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext 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
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

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
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.