Selecting data with ADO.NET(XML) datasource

[janineo]

Hi,

I'm new to Crystal Reports, so forgive me if this a really straightforward question.

I have a report based on an ADO.NET(XML) datasource. It consist of several 'tables'.

I have one 'table' with some info including an address id.
I have a 'table' of addresses, with unique address ids.

I need to display the correct address for the data in the first 'table'.
I have no idea how to do this in Crystal. I could do it in SQL, but that's not an option as it's all based off an XML file.

Please help me!
Janine

 

[janineo]

Ok,

I worked out how to do it. I had to tell the two tables where they were linked.

As I said, I'm new to Crystal!

Janine