XML Filter

C

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
 
M

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.aspx?scid=kb;EN-US;305346

Mike
 

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

Similar Threads

Hoping some one here can help me, or at least point me in the right direction 2
How To Create Dynamic Dataset with XML Schema 1
Exporting XML Schema 1
Program create xsd for Crystal Report and provide all data on repo 2
How to create a dataset from XML for use in Crystal Reports 5
c# and mysql datetime 1
typed vs strong typed dataset 3
XML Dataset 2

Top