2/21/2013

2 Cool Features #SAP #CrystalReports

Working with Crystal Reports since 1996 version 5, I've had lots of exposure to it's functionality.

I've also worked with Microsoft SQL Server Reports Services (SSRS) for some time now.

I wanted to point out two advantages that I've seen with Crystal Reports.

1. Report Bursting Indexes - is a feature that can speed up your report by identifying key fields, typically found in the Select Expert.


You can find this feature under the Report menu item --> Report Bursting Indexes.

Here you can select specific field(s) by selecting the field on the left and pressing the > button to move specific field(s).

Another way is to click the "Auto" button which will identify the Field(s) in the Select Expert and add them automatically.

You must run / re-run the report.

2. Performance Information - can be found under the Report --> Performance Information menu item.  After you run a report, select this feature to find enormous amounts of detailed information about your report:


You can also select the "Save..." button to create a text file:


****************
Quota_Report.rpt
****************

Report Definition
-----------------

 Number of Database Fields:   11  
 UFLs in use:   None  
 Number of Subreport Objects:   1  
 Page N of M Used:   No  
 File Format Schema:   14.0.0  


Saved Data
----------

 Number of Data Sources:   1  
 Unicode Saved Data:   Yes  
 Total Number of Records:   6002  
 Selected Number of Records:   6002  
 Recurring Database Record Length:   1 KB  
 Recurring Formula Record Length:   0 bytes  
 Constant Formula Record Length:   0 bytes  
 Size of Saved Records:   9 MB  
 Size of Saved Memo Fields:   0 bytes  


Processing
----------

 Grouping Done on Database Server:   No  
 Sorting Done on Database Server:   Yes  
 Record Selection Done on Database Server:   Yes  
 Require Two Passes:   No  
 Require the Total Page Count:   No  
 Number of Nodes in Group Tree:   1  
 Number of Summary Values:   0  
 Size of Saved Group Tree:   98 bytes  
 Built the Group Tree in Progress:   No  


Latest Report Changes
---------------------

 Recurring Database Fields:   Changed  
 Record Selection Formula:   Changed  
 Print Time Formulas:   Changed  
 Database Table Linking:   Changed  


Performance Timing
------------------

 Open Document:   0 ms  
 Run the Database Query:   1853 ms  
 Read Database Records:   35 ms  
 Number of pages formatted:   1  
 Average time to format a page:   385 ms  
 Number of page starts generated:   97  
 Average time to generate a page start:   59 ms  

***********
Sub-Report1
***********

Report Definition
-----------------

 Number of Database Fields:   7  
 UFLs in use:   None  
 Page N of M Used:   No  
 File Format Schema:   14.0.0  


Saved Data
----------

 Number of Data Sources:   1  
 Unicode Saved Data:   Yes  
 Total Number of Records:   0  
 Selected Number of Records:   0  
 Recurring Database Record Length:   1 KB  
 Recurring Formula Record Length:   0 bytes  
 Constant Formula Record Length:   0 bytes  
 Size of Saved Records:   0 bytes  
 Size of Saved Memo Fields:   0 bytes  


Processing
----------

 Grouping Done on Database Server:   No  
 Sorting Done on Database Server:   Yes  
 Record Selection Done on Database Server:   Yes  
 Require Two Passes:   No  
 Require the Total Page Count:   No  
 Number of Nodes in Group Tree:   0    For all instances
 Number of Summary Values:   0    For all instances
 Size of Saved Group Tree:   82 bytes  
 Built the Group Tree in Progress:   No  


Latest Report Changes
---------------------

 Recurring Database Fields:   Changed  
 Print Time Formulas:   Changed  
 Database Table Linking:   Changed  


Performance Timing
------------------

 Run the Database Query:   367 ms   For all instances
 Read Database Records:   0 ms   For all instances
 Format First Page:   2 ms   For all instances
 Number of pages formatted:   1    For all instances
 Average time to format a page:   2 ms   For all instances
 Number of subreport instances formatted:   1  
 Time to format all subreport instances:   381 ms  

These two cool features are great for developing reports and can only be found in Crystal Reports from my recollection.

And so it goes!




No comments:

Post a Comment

Note: Only a member of this blog may post a comment.