.NODE

Creating Effective Summaries

Troubleshooting

graphics/troubleshooting_icon.jpg

Group Selection Formula

Where can I find the Group Selection formula?

The group selection formula can be found on the Report menu, under Selection Formulas, Group.

Crystal Reports in the Real WorldNesting Formulas

It's common for some more complex formulas to be combined to provide specific insight into report data. For example, a user might need to have a report that lists all customers with their total sales, but also show the average value of sales over a given amount. As described previously, there are many ways that a report design expert can approach this; what follows is one method.

  1. Open the report Chap3RunningTotal.rpt. Insert a group on Customer ID. Select the running total field, right-click it, and choose Edit Running Total. Under the Reset section, choose On Change Of Group. Now the report is ready for the new functionality and should look like Figure 3.9.
     

    Figure 3.9. This is the starting point for the new functionality.

    graphics/03fig09.jpg  
  2. Create a new formula named Large Orders with the following code:
     

    
     
     
    
    WhileReadingRecords;
    
    If {Orders.Order Amount} > 3000 Then
    
     {Orders.Order Amount}
    
    Else
    
     0;
    
    
     
  3. Add this formula to the report. Right-click on the new formula field and select Insert, Summary and for the section Summary Location change this value to your Group 1 field. This creates the numerator for your average.
     
  4. Next, to determine the value for the denominator, right-click the Large Orders formula and choose Insert, Running Total. For Type Of Summary select Count; for Evaluate, select Formula and enter the following code:
     

    
     
     
    
    {@Large Orders}>0
    
    

    Under Reset select Group 1. Check your settings against Figure 3.10.
     

    Figure 3.10. Create Running Totals easily using the Running Total Expert.

    graphics/03fig10.jpg  
  5. Now with the numerator and denominator values defined, simply create a new formula with the following code:
     

    
     
     
    
    Sum ({@Large Orders}, {Orders.Customer ID})/{#RTotal0}
    
    
     
  6. Insert this new formula onto the Group Footer and the report now has a summary value showing the average of all orders greater than $3,000 (see Figure 3.11).
     

    Figure 3.11. A report complete with complex formulas.

    graphics/03fig11.jpg  
  7. Save the report as Chap3AverageLargeOrder.rpt.
     

Part I. Crystal Reports Design

Creating and Designing Basic Reports

Selecting and Grouping Data

Filtering, Sorting, and Summarizing Data

Understanding and Implementing Formulas

Implementing Parameters for Dynamic Reporting

Part II. Formatting Crystal Reports

Fundamentals of Report Formatting

Working with Report Sections

Visualizing Your Data with Charts and Maps

Custom Formatting Techniques

Part III. Advanced Crystal Reports Design

Using Cross-Tabs for Summarized Reporting

Using Record Selections and Alerts for Interactive Reporting

Using Subreports and Multi-Pass Reporting

Using Formulas and Custom Functions

Designing Effective Report Templates

Additional Data Sources for Crystal Reports

Multidimensional Reporting Against OLAP Data with Crystal Reports

Part IV. Enterprise Report Design Analytic, Web-based, and Excel Report Design

Introduction to Crystal Repository

Crystal Reports Semantic Layer Business Views

Creating Crystal Analysis Reports

Advanced Crystal Analysis Report Design

Ad-Hoc Application and Excel Plug-in for Ad-Hoc and Analytic Reporting

Part V. Web Report Distribution Using Crystal Enterprise

Introduction to Crystal Enterprise

Using Crystal Enterprise with Web Desktop

Crystal Enterprise Architecture

Planning Considerations When Deploying Crystal Enterprise

Deploying Crystal Enterprise in a Complex Network Environment

Administering and Configuring Crystal Enterprise

Part VI. Customized Report Distribution Using Crystal Reports Components

Java Reporting Components

Crystal Reports .NET Components

COM Reporting Components

Part VII. Customized Report Distribution Using Crystal Enterprise Embedded Edition

Introduction to Crystal Enterprise Embedded Edition

Crystal Enterprise Viewing Reports

Crystal Enterprise Embedded Report Modification and Creation

Part VIII. Customized Report Distribution Using Crystal Enterprise Professional

Introduction to the Crystal Enterprise Professional Object Model

Creating Enterprise Reports Applications with Crystal Enterprise Part I

Creating Enterprise Reporting Applications with Crystal Enterprise Part II

Appendix A. Using Sql Queries In Crystal Reports

Creating Enterprise Reporting Applications with Crystal Enterprise Part II

show all menu





Special Edition Using Crystal Reports 10
Special Edition Using Crystal Reports 10
ISBN: 0789731134
EAN: 2147483647
Year: 2003
Pages: 341
Similar book on Amazon

Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net