By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,552 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,552 IT Pros & Developers. It's quick & easy.

XML Filter

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.