Need help identifying the right .dll

Posted on 2006-04-20
Last Modified: 2008-03-03
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?

Question by:Kurt Reinhardt
    LVL 26

    Accepted Solution

    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.

    LVL 100

    Expert Comment

    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.

    LVL 26

    Author Comment

    by:Kurt Reinhardt
    Thanks mlmcc!


    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now