Problem in creating Crystal Report from a different data source

G

Guest

Hi, i'm now trying to get CR to report from an XML file and the user will
determine which file to load. I created a dummy table for the report to
connect to. The program first read the XML file into a dataset and then use
SetDataSource to get CR to read from the dataset. the report runs fine when
i'm reporting off fields that the dummy table contains (fields with the same
name). however, when i want to report from fields that the dummy table
doesn't have, it returns an error message -

"Error in formula <Field1>.
'{table1.au_id}'
This field name is not known."

Did i do anything wrong is the process? is there a way to report from a
generic XML file? thank you very much for your advice.
 
G

Guest

Hi, i'm now trying to get CR to report from an XML file and the user will
determine which file to load. I created a dummy table for the report to
connect to. The program first read the XML file into a dataset and then use
SetDataSource to get CR to read from the dataset. the report runs fine when
i'm reporting off fields that the dummy table contains (fields with the same
name). however, when i want to report from fields that the dummy table
doesn't have, it returns an error message -
'{table1.au_id}'
This field name is not known."
generic XML file? thank you very much for your advice.

User submitted from AEWNET (http://www.aewnet.com/)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top