Hi,
We have XML files (and its XSD) that are dump of our tree-like data
structure in memory. These XML files may potentially have unlimited
levels of nesting because some elements can contain themselves
(recursively defined).
We want to build some reports using some third party reporting tool
(Crystal Report, for example).
The first question is - is there any way for Crystal Reports to
process such complicated (some elements have recursive definitions)
XML file directly? If not, anyone knows any other reporting tool that
can do that job?
The second question is - if we have to develop a small application
that converts the XML to dataset, anyone who has done similar thing
before can give us some recommendations as to which approach is the
easiest to take (Java, .NET, etc.)? I'd appreciate it if someone can
point me to some resources to get me started.
Another approach is to convert the hierarchical XML into relational
table set and store the data into relational database. In that case,
the reporting tool can simply read from the database. I'd appreciate
it if someone can let me know if there is any softeware/program that
can do the conversion. (I heard that some database server can do the
conversion from XML to relational tables, but didn't find anything
concrete.)
Any comment/recommendation is appreciated!
Thank you for your help in advance!! 2 3653
John wrote: Hi,
We have XML files (and its XSD) that are dump of our tree-like data structure in memory. These XML files may potentially have unlimited levels of nesting because some elements can contain themselves (recursively defined).
We want to build some reports using some third party reporting tool (Crystal Report, for example).
The first question is - is there any way for Crystal Reports to process such complicated (some elements have recursive definitions) XML file directly? If not, anyone knows any other reporting tool that can do that job?
The second question is - if we have to develop a small application that converts the XML to dataset, anyone who has done similar thing before can give us some recommendations as to which approach is the easiest to take (Java, .NET, etc.)? I'd appreciate it if someone can point me to some resources to get me started.
Another approach is to convert the hierarchical XML into relational table set and store the data into relational database. In that case, the reporting tool can simply read from the database. I'd appreciate it if someone can let me know if there is any softeware/program that can do the conversion. (I heard that some database server can do the conversion from XML to relational tables, but didn't find anything concrete.)
Any comment/recommendation is appreciated!
Thank you for your help in advance!!
Crystal can't but Oracle can.
But before we get to that what made you think it was appropriate
to post to every usenet group you could spell?
The solution is to use the native functionality in the database
to unnest the XML.
The solution to your obnoxious cross-posting is to learn usenet
etiquette.
--
Daniel A. Morgan
University of Washington da******@x.wash ington.edu
(replace 'x' with 'u' to respond) xi********@yaho o.com (John) wrote in message news:<85******* *************** ****@posting.go ogle.com>... Hi,
We have XML files (and its XSD) that are dump of our tree-like data structure in memory. These XML files may potentially have unlimited levels of nesting because some elements can contain themselves (recursively defined).
We want to build some reports using some third party reporting tool (Crystal Report, for example).
The first question is - is there any way for Crystal Reports to process such complicated (some elements have recursive definitions) XML file directly? If not, anyone knows any other reporting tool that can do that job?
The second question is - if we have to develop a small application that converts the XML to dataset, anyone who has done similar thing before can give us some recommendations as to which approach is the easiest to take (Java, .NET, etc.)? I'd appreciate it if someone can point me to some resources to get me started.
Another approach is to convert the hierarchical XML into relational table set and store the data into relational database. In that case, the reporting tool can simply read from the database. I'd appreciate it if someone can let me know if there is any softeware/program that can do the conversion. (I heard that some database server can do the conversion from XML to relational tables, but didn't find anything concrete.)
Any comment/recommendation is appreciated!
Thank you for your help in advance!!
IMO, you're better off writing your report with xsl. Call nested nodes
recursive using call-template passing necessary parameters as
required. It will probably take less time than configuring crystal
reports and won't cost you anything.
Wole This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John |
last post by:
Hi,
We have XML files (and its XSD) that are dump of our tree-like data
structure in memory. These XML files may potentially have unlimited
levels of nesting because some elements can contain themselves
(recursively defined).
We want to build some reports using some third party reporting tool
(Crystal Report, for example).
|
by: Anita C |
last post by:
Hi,
I have an xml document (Xml1.xml) with the foll.structure:
<?xml version="1.0" encoding="utf-8"?>
<REPORTS>
<SCOPE TITLE="My Reports">
<REPORT URL="Report1.aspx" AUTHOR="me">First Report</REPORT>
with several SCOPE and REPORT elements.
How do I create a dataset, where Table has the Scope info, with a column
Title; Table has Report info. that is only the InnerText in a particular
column; and Table has Attribute info. of the Report...
|
by: Sami |
last post by:
Could someone explain clearly how to go about doing this? I have
tried setting up the structure on numerous occasions, but it never
seems to work. Could someone please help me out? Thanks!
|
by: Dave |
last post by:
Our company intranet allows various users to submit address information and
contact names and numbers using ASP pages, that save to an Access 2000
database. There are no issues with retrieving, editing, or deleting the
information. This solution works well for 60 users, and results in a
database about 300 kB, that feeds other processes downstream.
Because most of the front end users are novice (or temporary hires), we want
to make more...
|
by: Joe_Black |
last post by:
Hi all,
I want to create an MDI app that allows reporting on XML data files
downloaded from the equipment that we manufacture, this MDI app will
have several default reports but due to the nature of the data different
people will want to see it in different ways.
What I would like to do is have several standard reports/graphing MDI
Children that come as standard, then allow the user to apply a plugin
that will allow them to view their...
| |
by: rreitsma |
last post by:
I want to create a form that will allow the user to select from a list of
available reports and based on a filter limit the records displayed in the
report. I have figured out how to access the reports collection to populate
a list box containing the report names. The filter I currently have lists
some key fields that I think the user may want to filter on. A WHERE string
is constructed based on the feilds that the user inputs values into....
| |
by: slawek86 |
last post by:
Hi, I use Crystal Reports for Visual Studio 2005 (v 10.2) and hierarchical grouping. I want to do summary of child rows in parent's footer, but it set itself above child rows. How can I do, to child rows were inside parent group between parent's header or details and parent's footer.
|
by: icenemesis |
last post by:
I am using Access 2000 and have this setup.
Tables
Program
Procedure
WorkInstruction
Form
the tables are set up with the following relationships.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |