Quick Tip: Crystal Reports' three-formula trick - TechRepublic.
If you want to add address in crystal report as a Add1, Add2, Add3. You can take a three Text object as a txtAdd1, txtAdd2, txtAdd3. you can manage this for your requirement. It's a very easy compare of formula. If you use formula it's so difficult to modify it's such as bold text, underline, alignment etc.
SQL Expression field versus a Crystal Reports formula field Often an SQL Expression field and a Crystal Reports formula field can accomplish the same goal. For example, a report design requirement is to display the first 3 letters of the first name of an employee. A formula field or an SQL Expression field can fulfill this requirement.
How to Add Data and Work with Parameter and Summary Fields in a Crystal Report You can add formulas in Crystal Reports to calculate values and summarize your data. If we use our report as an example, we can use a formula to add up how many customers we have listed.
FORMULA CHANGE REPLACE DOTNET VB.NET FORMULAS .NET Crystal Reports for Visual Studio Formula Fields Modify at runtime, c2010287, KBA, BI-DEV-NET, BI Software Development Kits (SDKs) - .NET or Other, How To.
Calculated formulas are used to perform mathematical calculations in Crystal Reports and they can be designed in the formula workshop. Arithmetic operators are used to design calculation formulas in workshop. There are different Arithmetic operators that can be used to Add, Divide, Exponential.
Inserting summaries or running totals in Crystal Reports can cause headaches when it comes to formula fields that contain calculations. Because of Crystal’s processing model, which evaluates summaries on the last pass, these formula fields will have to be totaled using a nifty 3-step technique.
Linking a subreport to the main report without modifying the selection formula. Crystal Reports uses a parameter field mechanism for linking subreports to main reports. When linking a main report field that is not a parameter field to a subreport field, the program: Automatically creates a parameter field to complete the link.