Hi,
I have a report with an xml file as a data source.
The report is loaded on an aspx website and the xml data is generated on the fly and than passed to the crviewer as a dataset.

In this described case below, the crviewer always say database login failure(German: Datenbankanmeldung fehlgeschlagen)

How to solve this ?

The report is designed for this xml source

<Company>
<Street>Street</Street>

<Person>
<Firstname>X</Firstname>
<Lastname>Y</Lastname>
</Person>

<Person>
<Firstname>A</Firstname>
<Lastname>B</Lastname>
</Person>

</Company>

But there are cases, where the company doesn't have person. For example:
<Company>
<Street>Street</Street>
</Company>


If I try to load this in web, crystal report says "Database login failure"

And if I try to load preview the report in the crystal report designer, it tries first of all to look for the field Company_Id, which is usually automatically generated by crystal report to link the person to the company.

Then it says, that the table Person is not found. and whether I want to remove the table from the report or not. If I say no, it says that the database is refreshed and than not implemented.

What should I do ? Isn't it possible that crystal report automatically knows that if the child table doesn't exist to just skip it ?

Thanks

Hi lockwelle,
thanks for your input. The problem is, that the xml is created dynamically.
Is it possible, that I for example display another error message instead ?
The error message is thrown without an exception, so I can't catch it.
Thanks

Hi lockwelle,
thats the point. I also have the same assumption, that CR would recognize this.
And since the table is created dynamically, I can't check which table is blank because its supposed to be there or the table is really should not be in the structure :(

Hi lockwelle,
the problem is, there is a formula which reference to this table. I think the problem is in the formula, because it doesn't check whether the field/table exists or not. How to do this ?
Thanks