Symptom
- Modifying Crystal Reports formulas allows for a more flexible report
- Formulas are always stored internally as a string
- Using the wrong syntax when assigning a string variable to a formula will result in errors
- A typical error would be: “a number is required here”
- Note that the Crystal Reports SDK for VS .NET can not create new formulas at runtime
- Use the RAS SDK to create formulas at runtime
Resolution
See the excellent blog Crystal Reports .NET: Modifying Formulas during Runtime written by Brian Bischof for a detailed discussion and code samples
Keywords
KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , How To
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2