How to get ASP.NET using C# to transform Access Reports

[Peter Petrillo]

The Access development group here at this company has exported its reports in xml format from Access 2003. I have no influence on how they have created them. I received the following files

xm
xs
xsl
asp or html (my option

Using a simple ASP.NET form with only a System.Web.UI.WebControls.Xml on it, I receive an error (below) that the scripting language 'vbscript' is not supported. The xslt file has in it vbscript scripting to generally calculate cerain amounts in the report. I have not been able to find any help info on working around this. Running the supplied asp or html file the report is displayed however that means a web page outside of my C# .NET code. Can anyone help me on this

****************************
The scripting language 'vbscript' is not supported.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Xml.Xsl.XsltException: The scripting language 'vbscript' is not supported

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[XsltException: The scripting language 'vbscript' is not supported.
System.Xml.Xsl.ContainerAction.AddScript(Compiler compiler) +29
System.Xml.Xsl.ContainerAction.CompileTopLevelElem ents(Compiler compiler) +85
System.Xml.Xsl.ContainerAction.CompileDocument(Com piler compiler, Boolean inInclude) +17
System.Xml.Xsl.RootAction.Compile(Compiler compiler) +
System.Xml.Xsl.Compiler.CreateRootAction() +12
System.Xml.Xsl.Compiler.Compile(NavigatorInput input, XmlResolver xmlResolver, Evidence evidence) +20

[XsltCompileException: file:///c:/inetpub/wwwroot/DEDWebACA/DEDxml/rptRecentActivity.xsl(157,3)

System.Xml.Xsl.Compiler.Compile(NavigatorInput input, XmlResolver xmlResolver, Evidence evidence) +29
System.Xml.Xsl.XslTransform.Compile(XPathNavigator stylesheet, XmlResolver resolver, Evidence evidence) +21
System.Xml.Xsl.XslTransform.Load(String url, XmlResolver resolver) +19
System.Xml.Xsl.XslTransform.Load(String url) +2
System.Web.UI.WebControls.Xml.LoadTransformFromSou rce() +22
System.Web.UI.WebControls.Xml.Render(HtmlTextWrite r output) +2
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +24
System.Web.UI.Control.RenderChildren(HtmlTextWrite r writer) +7
System.Web.UI.HtmlControls.HtmlForm.RenderChildren (HtmlTextWriter writer) +4
System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTex tWriter output) +26
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +24
System.Web.UI.Control.RenderChildren(HtmlTextWrite r writer) +7
System.Web.UI.Control.Render(HtmlTextWriter writer) +
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +24
System.Web.UI.Page.ProcessRequestMain() +192

-------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

[Dare Obasanjo [MSFT]]

The System.Xml.Xsl.XslTransform class does not support VBScript as a
scripting language in script blocks. Only C#, VB and Jscript are supported.
From the MSDN documentation at
http://msdn.microsoft.com/library/en...sxslscript.asp

"The language attribute is not mandatory, but if specified, its value must
be one of the following: C#, VB, JScript, JavaScript, VisualBasic, or
CSharp. If not specified, the language defaults to JScript. The
language-name is not case-sensitive so 'JavaScript' and 'javascript' are
equivalent."

--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Peter Petrillo" <an*******@discussions.microsoft.com> wrote in message
news:80**********************************@microsof t.com...

The Access development group here at this company has exported its reports in xml format from Access 2003. I have no influence on how they have
created them. I received the following files:
xml
xsd
xslt
asp or html (my option)

Using a simple ASP.NET form with only a System.Web.UI.WebControls.Xml on it, I receive an error (below) that the scripting language 'vbscript' is not
supported. The xslt file has in it vbscript scripting to generally
calculate cerain amounts in the report. I have not been able to find any
help info on working around this. Running the supplied asp or html file the
report is displayed however that means a web page outside of my C# .NET
code. Can anyone help me on this?

*****************************
The scripting language 'vbscript' is not supported.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Xml.Xsl.XsltException: The scripting language 'vbscript' is not supported.
Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception
can be identified using the exception stack trace below.
Stack Trace:
[XsltException: The scripting language 'vbscript' is not supported.]
System.Xml.Xsl.ContainerAction.AddScript(Compiler compiler) +298
System.Xml.Xsl.ContainerAction.CompileTopLevelElem ents(Compiler compiler) +858 System.Xml.Xsl.ContainerAction.CompileDocument(Com piler compiler, Boolean inInclude) +175 System.Xml.Xsl.RootAction.Compile(Compiler compiler) +7
System.Xml.Xsl.Compiler.CreateRootAction() +128
System.Xml.Xsl.Compiler.Compile(NavigatorInput input, XmlResolver xmlResolver, Evidence evidence) +204
[XsltCompileException: file:///c:/inetpub/wwwroot/DEDWebACA/DEDxml/rptRecentActivity.xsl(157,3) : ]
System.Xml.Xsl.Compiler.Compile(NavigatorInput input, XmlResolver xmlResolver, Evidence evidence) +296 System.Xml.Xsl.XslTransform.Compile(XPathNavigator stylesheet, XmlResolver resolver, Evidence evidence) +215 System.Xml.Xsl.XslTransform.Load(String url, XmlResolver resolver) +194
System.Xml.Xsl.XslTransform.Load(String url) +26
System.Web.UI.WebControls.Xml.LoadTransformFromSou rce() +221
System.Web.UI.WebControls.Xml.Render(HtmlTextWrite r output) +28
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWrite r writer) +72
System.Web.UI.HtmlControls.HtmlForm.RenderChildren (HtmlTextWriter writer) +44 System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTex tWriter output) +260
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWrite r writer) +72
System.Web.UI.Control.Render(HtmlTextWriter writer) +7
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Page.ProcessRequestMain() +1929


-------------------------------------------------------------------------- ------ Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573