Problem binding XML to Crystal report
I found the problem. This recordset was created manually in the VB code,
and the XML file had them in a section named <rs:insert>. These rows are
NOT visible through Crystal! When I called .UpdateBatch (with
.ActiveConnection = Nothing), the recordset was visible with Crystal (or if
I manually remove the <rs:insert> parts from the file). FYI, deleted rows
show up as <rs:delete> and are also not visible. Rows that are filtered out
do not end up in the XML file at all.
Quote:
> I have saved an ADO recordset (ADO2.5) as XML, and am now trying to use it
> to design a new Crystal report. I was able to connect to the XML and see
> the columns, but no data gets displayed. I know there is data in the XML.
> I think this might have to do with the Table Hint and Row Hint stuff, but
> I'm not sure. I have also tried pressing F5 to refresh the data and that
> doesn't work, either.
> I have seen the same problem when I took an existing Crystal report
> (designed with TTX) and tried to "Set Location" to change from the TTX to
> the XML. Once again, no data is displayed. I don't know if this is the
> right thing to do (to bind an existing Crystal Report to a "new"
> datasource - the Crystal documentation does not say how to do it, but this
> seems "reasonable"), so if anyone can tell me if this is the right way to
do
> it or if there is some other way to do it, I'd appreciate it. Thanks!
> Christine Wolak
