 |
|||
 |
|||
 |
|||
|
|||||||||
|
Crystal Reports Tools: Improve Performance While Saving Time and Money |
|
Crystal Reports: Summary Functions Inside Your CrosstabThe most common summary used inside the crosstab is the Sum() of a field. However, all the other summary functions are also available. You can also include more than one summary inside each cell in the crosstab grid. Use Count to show how many records are included and DistinctCount can also be useful here. Use Maximum or Minimum to show the highest and lowest values of the field.
Embedded Summaries in a Crosstab in Crystal Reports 2008 Beginning with Crystal Reports 2008, you can use crosstab functions to create an Embedded Summary in the crosstab. An embedded summary is a new value in a cell in the crosstab, rather than a new row or column. There are a couple of Crosstab functions we find useful here. To retrieve the first summary from the cell use this as your starting point:
Change the third argument (0) to select other summaries in the cell. So to calculate a ratio of your second and third summaries you could use
It gets even better. You can use this feature to create percentage crosstabs in a Crystal Report. After you insert a summary field into the crosstab you can make that summary a percentage of the row or column total. More, below.... |
Click Image to Enlarge
| This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects. |
| Keep track of your cross-tabs with
Report
Analyzer "Report Analyzer does it all. This is the best Crystal Reports 3rd party application on the market today! The numerous features combined with great performance makes Report Analyzer the ultimate documentation and analysis tool." -- Brian Kuipers, CrystalInfo.Net, USA
Report Analyzer is the ultimate documentation and analysis tool for Crystal Reports users and developers. With a comprehensive library of analysis and documentation reports, Report Analyzer provides you with complete documentation, analysis, and performance suggestions for your Crystal Reports projects. Keep your investment in Crystal Technology at its best performance using Report Analyzer! How does Report Analyzer Work?Report Analyzer connects to your local Crystal Reports or Crystal Enterprise APS servers and imports their design definition into a documentation database. These imported reports are organized into documentation groups within the database to organize your information for easy referencing and reporting. How can Report Analyzer help you?Report Analyzer now comes in two editions -
Standard and Enterprise (click
here for Enterprise features). Improve report performanceReport Analyzer automatically detects potential performance issues in your report design settings, including record selection formulas, grouping options and database options.
Improve report reliability and maintenanceReport Analyzer documents over 30 design and style settings.
Speed development and maintenanceYou can easily view dependencies between report objects such as formulas, SQL expression fields, parameters, and database fields with the dependency viewer. Additionally, the powerful query feature lets you view dependency information across reporting projects.
Project ManagementReport Analyzer generates comprehensive documentation of your reports, with over 100 presentation quality reports. Complexity metrics assist with test case planning and maintenance estimates.
|
){kind=link}