XML / XSL

How do you get the underlying stylesheet content of an XslTransform object

10-Apr-05 18:44

XMLDOM can be allowed to save edited XML Documents and provides the facility to transform the XML data using XSLT.

raman

Query Engine Error

dotnetquery31-Mar-05 0:09

dotnetquery

31-Mar-05 0:09

Hi All,

I am trying to build an application in VS.Net which uses Crystal Report 11 to build the rpt file. I have an XML and XSD file as my datasources. I want to view the report in PDF format. Now my source code looks like:

ReportDocument doc = new ReportDocument();
string fileName = Server.MapPath("MyReport.rpt");
doc.Load(fileName);

DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("MyXML.xml"));

doc.SetDataSource(ds);

ExportOptions exportOpts = doc.ExportOptions;
exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat;
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
exportOpts.DestinationOptions = new DiskFileDestinationOptions();

DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
((DiskFileDestinationOptions)doc.ExportOptions.DestinationOptions).DiskFileName = Server.MapPath("MyPDF.pdf");

doc.Export();

But it gives me the error
"Query Engine Error: 'c:\inetpub\wwwroot\MyWebsite\MyReport.rpt'"

I tried out all the forums but could not find any solution. Someone told me that it is due to xsd file error. But in Crystal Report it is running perfectly OK. Can anyone help.
Edit/Delete Message

about gml maps

reneemarukot29-Mar-05 4:46

reneemarukot

29-Mar-05 4:46

hi there. i was just wondering whether a developer should use wfs/wms in implementing a gml map.

sliu0@yahoo.com26-Mar-05 5:28

sliu0@yahoo.com

26-Mar-05 5:28

How do you get the underlying stylesheet content of an XslTransform object in .NET? In other words, how do you know what transformation the XslTransform object does? Assume that the object was created and loaded with something somewhere else, but you don't know what was loaded to it. You want to know exactly what was loaded to it (the content of the stylesheet file that was loaded to the object).

What property of the object will let you see that?
Thanks
Shell

XSL-Transforming a nestet structure to a flat structure - possible?

Uwe Keim25-Mar-05 19:15

Uwe Keim

25-Mar-05 19:15

Currently I'm in the process of writing a simple XSL to transform XHTML to the XML format understood by TallPDF.NET[^].

I struggle with a simple thing: Paragraphs with bold and italic. Here is an example:

<p>This is some text in <b>bold</b> and in <i>italic</i>.</p>

Now I want to transform it to something like this:

<textPragraph>
    <fragment>This is some text in </fragment>
    <fragment bold="true">bold</fragment>
    <fragment> and in </fragment>
    <fragment italic="true">italic</fragment>
    <fragment>.</fragment>
</textParagraph>

I.e. make the nested original XHTML into a flat list.

I'm not that XSL-T expert, so maybe someone can answer my questions:

Is it possible at all to do that in XSL (please remember that I usually don't know which tags are nested inside each other)?
If yes, could you provide a simple example as a starter for me?

Thanks
Uwe

--
Affordable Windows-based CMS: www.zeta-producer.com

dynamically creating selection box in xslt

jignatiu22-Mar-05 23:44

jignatiu

22-Mar-05 23:44

I have the following code:

Start Date

<xsl:attribute name="value">
<xsl:apply-templates select="StartDateTime">

2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010

which gives me a selection box with years from 2000 to 2010 and it is working properly. However, I wanted to make it more generic displaying years from current year - 5 to current year + 5. For that I have the following function:

<msxsl:script xmlns:msxsl="urn:schemas-microsoft-com:xslt" language="javascript" implements-prefix="extra">
function getYearListBoxOptions()
{
var sYear;
var sOptions = "";
var dateNow;
var i = 0;

dateNow = new Date();
sYear = dateNow.getYear() - 5;

for (i=0; i < 11; i++)
{
sOptions = sOptions + "<option value=" + '"' + (sYear + i) + '"' + ">" + (sYear + i) + "</option>"
}
return sOptions;
}

Now, the xsl looks like this:

But, I am getting an empty selection box Frown | :(

..Can somebody tell me what is going wrong?

Re: dynamically creating selection box in xslt

jignatiu22-Mar-05 23:53

jignatiu

22-Mar-05 23:53

Reposting as the 1st post had some parts missing

I have the following code:

Start Date

2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010

which gives me a selection box with years from 2000 to 2010 and it is working properly. However, I wanted to make it more generic displaying years from current year - 5 to current year + 5. For that I have the following function:

function getYearListBoxOptions()
{
var sYear;
var sOptions = "";
var dateNow;
var i = 0;

dateNow = new Date();
sYear = dateNow.getYear() - 5;

for (i=0; i < 11; i++)
{
sOptions = sOptions + "" + (sYear + i) + ""
}
return sOptions;
}

Now, the xsl looks like this:

But, I am getting an empty selection box...Can somebody tell me what is going wrong?

Re: dynamically creating selection box in xslt

DavidNohejl23-Mar-05 1:40

Re: dynamically creating selection box in xslt

23-Mar-05 1:40

jignatiu wrote:
Now, the xsl looks like this:

hmm, and where is your XSL?? Confused | :confused:

I think you meant something like

&xsl:template match="select">
....
<xsl:template/>

or am I missing something?

David

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

jignatiu24-Mar-05 0:57

jignatiu

24-Mar-05 0:57

The whole code is given below. I didnt want to put too much code in to my query Big Grin | :-D

. And somehow the xsl tags were not visible while posting it here. So, now I have replaced every <xsl tag="" with="" <-.="" hope="" this="" is="" readable.

<-xsl:template="" match="NonWorkingTimeCollection/NonWorkingTime">

NAME AND DESCRIPTION

HOLIDAY DETAILS
Start Date <-xsl:choose > <-xsl:when test="../../BrowserType = 'IE'"> <-xsl:attribute name="value"> <-xsl:apply-templates select="StartDateTime" /> <-/xsl:when> <-xsl:otherwise> <-xsl:attribute name="value"> <-xsl:apply-templates select="StartDateTime" /> <-/xsl:attribute> 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010

What is the difference between Xpath/XSL/XSLT

satishrg16-Mar-05 14:05

satishrg

16-Mar-05 14:05

hi
I am a new c# programmer and I wanted to use XML in data exchange.Can any give brief explanation about XSL/XSLT/Xpath.

Thanking you.
Satish

Re: What is the difference between Xpath/XSL/XSLT

DavidNohejl17-Mar-05 6:22

Re: What is the difference between Xpath/XSL/XSLT

17-Mar-05 6:22

I can, but http://www.w3schools.com/[^] says it better IMO.

best regards,
David 'DNH' Nohejl

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

raman_learn10-Apr-05 18:50

10-Apr-05 18:50

Xpath has a certain functions that can be used in XSL and XSLT. For example,
/ for root node

. for current node

XSL is a stylesheet Which has 2 kinds 1. Transformation 2. Stylesheet

XSLT converts from XML to HTML/XML/Text formats
XSL is based on FO which converts XML to PDF, SVG or other formats using Apache FOP Object

raman

sqlcommand

Anonymous16-Mar-05 4:27

Anonymous

16-Mar-05 4:27

how to fire update,delete command using sql query in vb.net

Re: sqlcommand

raman_learn10-Apr-05 18:51

10-Apr-05 18:51

Try query in appropriate forums not in XML forum

raman

Conditional Tables

Bassam Abdul-Baki16-Mar-05 2:31

Bassam Abdul-Baki

16-Mar-05 2:31

Greetings,

I have table data (reduced) in XML that looks like this:

<tables>
  <table>
    <header>Text 1</header>
    <row/>
    <row>Row 1</row>
    <row>Row 2</row>
  </table>
  <table>
    <header>Text 2</header>
    <row/>
    <row/>
    <row/>
  </table>
</tables>

I wish to create an HTML page displaying the non-empty row data as an actual table. If I just display everything, it is quite simple. However, if all of the row elements are empty (<row/> or <row></row>) for a table node, then I do not want to create that table. Is there a way to do this without looping twice to determine first if there is a non-empty row, then create the table tags?

Thanks

"For that one fraction of a second, you were open to options you would never have considered. That is the exploration that awaits you. Not mapping stars and studying nebula, but charting the unknown possibilities of existence." - Q (Star Trek: The Next Generation) Web - Blog

DavidNohejl17-Mar-05 6:47

17-Mar-05 6:47

hi,
well I guess the position of rows matters so exclude empty rows from xml is probably not an option...
One (quick&dirty) solution is to keep flag for each table - say hasRows attribute of table element.

Bassam Abdul-Baki wrote:
Is there a way to do this without looping twice to determine first if there is a non-empty row, then create the table tags?

hmm, well.. what about looping once, and keep flag (while creating table) if there were non-empty table? I don't know details so I have no idea what actions are expensive... btw how you do XML->HTML transformation? You said looping, to me it sounds like you are not using XSLT but your own code... is that right? Unsure | :~

If not my advices would probably differ Smile | :)

hope it helps

David

Never forget: "Stay kul and happy" (I.A.)

David's thoughts / dnhsoftware.org / MyHTMLTidy

Bassam Abdul-Baki18-Mar-05 7:04

Bassam Abdul-Baki

18-Mar-05 7:04

Thanks. Actually, got a tip from another XSL site and got it to work. Had to use table[row!=''] in an apply-template element to make it work. Neat stuff. Too bad that variables are only set once. Frown | :-(

"For that one fraction of a second, you were open to options you would never have considered. That is the exploration that awaits you. Not mapping stars and studying nebula, but charting the unknown possibilities of existence." - Q (Star Trek: The Next Generation) Web - Blog

raman_learn10-Apr-05 19:04

10-Apr-05 19:04

Take the stylesheet below

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="table">
<xsl:for-each select="row">
<xsl:if test="string-length(.) > 1">
<xsl:value-of select="."/><br/>
</xsl:if>
</xsl:for-each>
</xsl:template>

</xsl:stylesheet>

raman

Re: Learning XML :confused:

Bassam Abdul-Baki11-Apr-05 2:04

Bassam Abdul-Baki

11-Apr-05 2:04

Wouldn't this create empty tables for me?

"For that one fraction of a second, you were open to options you would never have considered. That is the exploration that awaits you. Not mapping stars and studying nebula, but charting the unknown possibilities of existence." - Q (Star Trek: The Next Generation) Web - Blog

Learning XML :confused:

ComplexLifeForm15-Mar-05 7:25

ComplexLifeForm

15-Mar-05 7:25

Hi Friends,

I want to learn XML but really confused where to make a start. The available knowledge on net is so much that it is difficult for a new babie to make a start.

Can someone please suggest how shall I make a start. I am looking for some guidelines to be followed in sequence like
1. Basic XML
2. Schemas
3. Parser etc..

I hope you get my point.

Any help is appreciated.

Thanks in Advance

DavidNohejl15-Mar-05 9:00