Need help identifying the right .dll

My turn to ask a question!

Here's the background.  Among my many duties, I'm a product manager for one of my companies' reporting solutions.  Most of our standard reports (which I inherited) are written in CR8.5 and are accessed in a client-server application using the CR7 OCX.  I believe the application was written in Delphi 5.

Since I'm the hoighty toighty Crystal Expert, I've undertaken a project to analyze our standard reports (which were originally written in Crystal 6) and to update them using functionality that is availble in CR 8.5, but still have them be compatible with our very old application (we are writing a web-based application that will use CRXI and Crystal Reports Server, btw).

One of my enhancements is to use of SQL Expression fields in the Record Selection Criteria in lieu of formulas.  This makes the reports run much more efficiently because the SQL Expression can be passed to the database for processing, whereas the formulas cannot.

Herein lies the crux of my problem:

When I run a report in CR 8.5, the SQL Expression fields are passed to the DB for processing as expected.  I see that 6 0f 6 records have been evaluated, for example.  However, when I run the same report from within our application the viewer clearly shows the report reading 6 of 3000 records, which means that the part of the record selection criteria that uses the SQL Expression fields isn't being passed to the database for processing.  The SQL Expression fields ARE recognized, else the report would fail, but are being filtered on the client after the fact.

I am not a progammer and I don't have access to the source code.  Our application distributes a number of the runtime .dlls in an easily identifable folder, however.  If I knew which .dll and/or registry key to update, then I could effectively use this functionality in our application.

Any ideas?

~Kurt
LVL 26
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectAsked:
Who is Participating?
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectAuthor Commented:
About 5 minutes after I posted this question, I found the correct .dll.  For future reference, for my situation it was p2sodbc.dll (I'm calling reports in the application via ODBC).  The file probably changes depending on how you access the reports.

mlmcc, would you please close this question, but not delete it?  Some future user may find this information useful.

~Kurt
0
 
mlmccCommented:
Sure will.  As I read your question, I was thinking perhaps the OCX couldn't handle the SQL expressions.

Question - closed and points refunded as requested.

mlmcc
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectAuthor Commented:
Thanks mlmcc!

~Kurt
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.