
Note:
You'll see this number only if you have the Status Bar option selected on the View menu.
2.
On the Report menu, click Section Expert to access the Section Expert.
3.
In the Sections list, select Details.
4.
On the Common tab, select Hide (Drill-Down OK). This hides the report's Details section, so that
only group header displays in the report. (In this case, the report is grouped by Country.)
5.
Click OK in the Section Expert. The Details records will disappear from the report.
6.
Press F5 to refresh the report data (or click the Refresh button on the toolbar).
Notice that 269 records are still returned for the report, even though the Detail records are hidden
from view.
7.
On the Database menu, click Perform Grouping on Server.
Now notice that only 71 records are returned for the report. The grouping (by Country) has been
performed on the database server, and fewer records have been transferred to the report.
8.
Drill down on a country by double-clicking the report.
Tip:
When drill down is available, your cursor turns into a magnifying glass.
Crystal Reports retrieves the appropriate Detail records as you need them.
For instance, if you drill down on Australia, Crystal Reports quickly retrieves the seven records that
make up the group.
By hiding the Details section of this report, you've created a summary report that's easy for users to
navigate. Each user can first locate the Country with which he or she is concerned, and can then drill
down to retrieve valuable details.
Moreover, by enabling the Perform Grouping on Server option, you've ensured that the initial processing
is completed on the database server. Consequently, only the necessary records are transferred to the
report.
For more information on server-side processing, see Server-side processing.
6.6.3 Using SQL Expressions for groups, sorts, and totals
For reports using Perform Grouping on Server, avoid sorting, grouping, or totaling on a formula field
(whether Crystal or Basic syntax). Instead, replace the original formula field with an equivalent SQL
Expression Field, and then sort, group, or total on the SQL Expression field. This will greatly improve
the chances of the processing being done on the server.
For details on when else to use SQL Expressions, see Using SQL expressions where appropriate.
2012-03-14127
Designing Optimized Web Reports
What are the upsides of contracting skilled web optimization organizations? Expert search marketing companies utilize teams of experts focused on elevating your site's content for browsing engines. This encompasses researchingsearch phrases, adjusting on site characteristics, and managing off-domain enhancements. Moreover, these firms monitor adjustment in from Google parameters and refresh the text on your website as needed. This saves both you your time and your workers from unwanted a
Securing the security of your home is essential in today's unsettled times. Among the best ways to safeguard your belongings and peace of mind is by committing in a trustworthy safe. Regardless of whether you're securing money, important documents, or precious heirlooms, a safe gives a protected repository solution. Regarding selecting the right safe for your house, there are several elements to consider. Above all, assess your safety requirements. Determine what items you plan to store in
Arranging an open-air wedding in Phenix and anxious about the unpredictable weather? Don't let Mother Nature rain on your parade – truly! At [Event Rentals Phoenix], we provide stunning wedding tent rentals that will ensure your distinctive day goes off without an hitch. Our wedding tent rentals are created to supply both charm and functionality. Say "I do" under tha elegant canopy of one of our tents, surrounded by your loved ones and tha breathtaking scenery of Pheonix. With one assortmen
In both personal and professional situations, encountering issues is unavoidable. However, mastering productive trouble-shooting techniques is key for triumphing over hurdles and accomplishing success. In this piece, we delve into the strategies and methods for efficiently addressing dilemmas. From analytical thinking to creative brainstorming, we look into various approaches that can help individuals tackle challenges with certainty and accuracy. Effective challenge solving begins wit
Hello, im noob :)