Excel Developer

Microsoft Excel VBA Function Procedures

User-Defined Functions Microsoft Excel VBA Function Procedures can be used to standardise and simplify any type of calculation in Excel spreadsheets. As a user of Excel you will be aware that the application already comes with a vast library of functions. In Excel, whether you use a simple SUM() function or a more advanced one,[…]

Crystal Reports

Crystal Reports Linking Main and Sub Report Data

Linking a subreport to the data in the primary report Frequently, the data in a subreport supplements the data in the primary report. You might, for example, have customer data in a primary report and then use subreports to show the orders for each customer. In such cases, you will need to coordinate the data[…]