473,390 Members | 1,339 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,390 software developers and data experts.

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

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

Nov 12 '05 #1
1 6867
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

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Joris Kempen | last post by:
Hi people, I know that the question has come around sometimes: How to open an Access Report using ASP and export it to for example RTF. I'm trying to implement the first method of David...
1
by: Shaileen Patel | last post by:
Hi, I am trying to convert a lot of web reports from ASP/VB to ASP.NET/VB.NET. I would like to save my dataset in XML and then use XSLT to transform the XML. The catch is I would like to have...
2
by: Daniel Walzenbach | last post by:
Hi I need to know how to transform a XML file by using a XSLT file. Consider the following XML file <?xml version="1.0" encoding="UTF-8" standalone="yes"?><LogFile><Dog TimeStamp="16.02.2004...
1
by: Matt Alanzo | last post by:
On another newsgroup an Access knowledgable party posted: >You should be able to connect an Access ADP to an existing SQLExpress >database running in SQLS 2000 compatibility mode. The only thing...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
5
by: cesco | last post by:
I have a set of pairs defined as follow: set< pair<UserEquipment*, double> > numberOfFreqSlotsToAdd; and I need to iterate through all the elements of the set in order accumulate the second...
3
by: knightsmastergeneral | last post by:
Hi, I'm currently working on getting junit and junireport to take some java files, convert it to xml and then display error messages / success rates etc in html which is one of the features of...
2
by: Donald Adams | last post by:
I'm creating Word 2007 reports in asp.net 1.1 via xml transform. I get data from the SQL server in .5 sec., first transform takes less than a sec. and uses 10MB. I have 900MB free memory of the...
0
by: Peter Herath | last post by:
I want to create a custormizable report . For an example, there's a form with four combo boxes and two of them having database tables columns/field names as values in the combo box(one for select row...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.