I created report using two database files: one is excel and an other one is lotus notes. I have to display only non-matching records. I pull data from lotus into main report and data from excel into subreport .I using shared variable to pass data from main report to subreport and then condense matching records to display desired results. I have about 35000 records in each database. I am getting results but report runs too long. How I can improve performance?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
REPORT running too long
- Thread starter trmoney
- Start date
synapsevampire
Programmer
Unfortunately, there isn't much you can do within Crystal.
I would take a different approach, perhaps you can import these disparate data sources into a real database, even MS Access would help a lot.
Keep in mind that Excel is a horrible data source, as is Lotus, and when you're linking on two different types of data sources, plus using shared variables to pass to a subreport, you're going to get thoroughly punished...
Try to offload the majority of the processing to a real database, inclusive of condensing matching records to display desired results within the database.
Both of these files could be LINKED to from within MS Access and then you could base your CR off of a MS Access query, or even just import the data into MS Access or a real database.
-k kai@informeddatadecisions.com
I would take a different approach, perhaps you can import these disparate data sources into a real database, even MS Access would help a lot.
Keep in mind that Excel is a horrible data source, as is Lotus, and when you're linking on two different types of data sources, plus using shared variables to pass to a subreport, you're going to get thoroughly punished...
Try to offload the majority of the processing to a real database, inclusive of condensing matching records to display desired results within the database.
Both of these files could be LINKED to from within MS Access and then you could base your CR off of a MS Access query, or even just import the data into MS Access or a real database.
-k kai@informeddatadecisions.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question