XML Filter

[cksj]

I was assigned to a project where the main database is XML files instead of
RDBMS. One of my primary responsibilities is to create Crystal Reports using
..Net.
We are having performance issues when we open and view reports. The reason
is because Crystal Report that uses XML as a data source pulls all of the
data into the report and I just have a filter inside the report. The XML
files are loaded into a strong-typed dataset. Then this dataset is passed to
Crystal Report. Is there away to filter XML data before I pass them to the
Crystal Report?

Thanks for any ideas!
Cesar

[Mike McIntyre [MVP]]

Cesar,

If you pull a new DataSet from the XML data for each report you could simply
delete unneeded data before passing it to the Crystal report.

Another approach is to clone the DataSet and then copy a sub set of the data
from the orginal to the clone. Send the clone to Crystal. Here is a link
to an article that may help:
http://support.microsoft.com/default...b;EN-US;305346

Mike
"cksj" <ck*******@hotmail.com> wrote in message
news:uP**************@TK2MSFTNGP12.phx.gbl...

I was assigned to a project where the main database is XML files instead of RDBMS. One of my primary responsibilities is to create Crystal Reports using .Net.
We are having performance issues when we open and view reports. The reason
is because Crystal Report that uses XML as a data source pulls all of the
data into the report and I just have a filter inside the report. The XML
files are loaded into a strong-typed dataset. Then this dataset is passed to Crystal Report. Is there away to filter XML data before I pass them to the
Crystal Report?

Thanks for any ideas!
Cesar