| :: Problem displaying report groups :: (4) | Post a New Message | Post a Reply |
 Problem displaying report groups | Post a Reply |
since: Nov 24, 2005
from: Bournemouth, England
The issue is that the main page does not display correctly. The tables, views and procedures display OK (including the build report button) but the report groups are not displayed. In their place is the following.
&
true true false false true true
&closewin=true if(confirm('Are you sure you want to delete this report?')){window.location=' ?a=d&id= '} x
Looking at the source for the page and comparing it to the output from the development server that works OK it appears that XSL data is being sent through to the browser. The output is quite different.
It is possible to build reports (which run OK) and these are saved back to the REPORTS.XML file but the application fails to display the new or existing reports as described above. Same with new report groups which are saved back to the XML file but also fail to display.
Both Servers are NT4 with the latest Service pack 6a. Using the tool at http://www.topxml.com/parsers/sniffer/default.asp reveals that XML parser version 3 and 4 are installed on this server. The code to initialise the page has been taken back to basics, i.e. the same as the sample code except file locations. Permissions have been checked for the locations of the data and XML files and the basic REPORTS.XML file has been downloaded and substituted for the one we have created. We are using the latest version of the reportwizard.
Any assistance to resolve this issue would be greatly appreciciated.
 Re: Problem displaying report groups | Post a Reply |
from: Washington, DC
Try this download link
http://www.cityjams.com/downloads/xml_upgrade.zip
unzip the files to your desktop (
msxml3sp2setup.exe & run.bat). double-click on the
run.bat file (it should install the exe file silently) I think you need to restart (not sure)
let me know if this works.
-------------------------
Ghost
| Re: Problem displaying report groups | Post a Reply |
since: Nov 24, 2005
from: Bournemouth, England
We installed the Service pack as suggested and this didn't resolve the issue, installing SP5 of the XML Parser 3 didn't help either.
However installing the ASP Report Wizard product using the MSI package removed the issue with the XSL coming throuh to the web page and the corrupt display, but still no report groups or reports were displayed but the page was at least 'clean'. We could click on tables and view the output. Previously we had just registered the DLL to install the product.
Further testing revealed that whenever we tried to create a new report or report group a message "ActiveX control cannot create object" appeared. This suggested that the Reports.xml file could not be read or written to on the basis that the error message only appeared when saving a new report. Permissions were checked to the reports.xml file and all was well.
In the end we reinstalled MDAC (2.8) and everything started working correctly.
This is curious as we have another application on this server that uses XML transformation from an Access database that was working correctly before we started, and is fortunately still working!
 Re: Problem displaying report groups | Post a Reply |
from: Washington, DC
It seems IE also replaces the
msxml.dll-------------------------
Ghost