We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Crystal Reports ocx VB4(16) - Error 515

Parkie
Parkie asked
on
Medium Priority
2,669 Views
Last Modified: 2012-08-14
Hi,  I have a small problems...well a big one really.  When using the Crystall reports OCX in my VB4-16 project.  I keep getting an error (515)in setting the SELECTIONFORMULA field.  The formula I am setting is:

CrystalReport1.SelectionFormula = "{Info.MthSelect} = 1;"

{Info.MthSelect} is an integer field

This formula works in the Crystal report designer in the record selection area but will not work when called from CODE.

The crystal reports version is 3.x

I assume from the error code that the formula is not correct and I can only guess that it is the systax???.

Comment
Watch Question

Error: 515 - Invalid formula

The "Error in formula" warning indicates that Crystal is unable to evaluate a formula in the report. A common reason is that a formula is being set incorrectly from an application, refer to the Technical Support Document for the programming language you are using.

Another reason is that in v3 of Crystal Reports, the .SelectionFormula property of the CRYSTAL.VBX appends to any selection formula already in the report whereas previous versions overwrote. Clear the selection formula in the report to solve this problem (ensure that not even an empty space is left). This also applies to the updated VBXs on our BBS for v2 Pro (PROVBX.ZIP) and v2 for VB (VBVBX.ZIP).

Also, reports created with the Pro version may contain formulas that use functions from the Additional Functions list. The code for these functions actually exists externally from CRW in files that begin with "UFL" and end with ".DLL". In v3 two UFLs are included, UFLSAMP1.DLL and UFLDTS.DLL (for v2 Pro only UFLSAMP1.DLL is included), these need to be in the same location as the CRPE.DLL that is being loaded by an application for them to be found.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Glad I could help.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.