I have multiple tables in the database. Something like this:
1 - Object Table (objects contain components and attributes)
2 - Component Table (components contain attributes)
3 - Attribute Table
We managed to generate one XML file that contained all information about a specific object(s). This was done by creating a recordset for the object table and sub-recordset inside it, one for the component table and one for the attribute table. This was then written to XML.
The problem when I connect to the XML file through crystal reports I only see the fields in the object table i.e. the top level recordset but I don't see the sub-recordsets i.e the components and attribtues.
Does anyone know how to fix this? Is it even doable - for crystal reports to understand sub-recordsets? How about other reporting tools that can read sub-recordsets from an XML file.
1 - Object Table (objects contain components and attributes)
2 - Component Table (components contain attributes)
3 - Attribute Table
We managed to generate one XML file that contained all information about a specific object(s). This was done by creating a recordset for the object table and sub-recordset inside it, one for the component table and one for the attribute table. This was then written to XML.
The problem when I connect to the XML file through crystal reports I only see the fields in the object table i.e. the top level recordset but I don't see the sub-recordsets i.e the components and attribtues.
Does anyone know how to fix this? Is it even doable - for crystal reports to understand sub-recordsets? How about other reporting tools that can read sub-recordsets from an XML file.