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?

LVL 26
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.

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

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.