Learn how to a build a cloud-first strategyRegister Now


Need help identifying the right .dll

Posted on 2006-04-20
Medium Priority
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
  • 2
LVL 26

Accepted Solution

Kurt Reinhardt earned 0 total points
ID: 16505433
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 101

Expert Comment

ID: 16517105
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
ID: 16538028
Thanks mlmcc!


Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Screencast - Getting to Know the Pipeline
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

810 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