SAP Crystal Reports 2011, Win Betriebsanweisung Seite 124

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 718
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 123
A new drop-down list appears.
11.
Click this second list and select {?SalesQuota}.
Tip:
Click the Show Formula button to view the new record selection formula, which appears as:
{Customer.Last Year's Sales} > {?SalesQuota}. Instead of using the Select Expert, you could have
created this formula yourself in the Record Selection Formula Editor. (To see the editor, open the
Formula Workshop and select Record Selection from the Selection Formulas folder.)
12.
Click OK in the Select Expert.
You've now added your parameter field to the record selection formula. When you switch to Preview
mode, or click the Refresh button, you will be prompted for new parameter values. You can then enter
a numeric value representing last year's sales quota. The resulting report will display only those
customers whose Last Year's Sales exceeds the numeric value you specify.
For instance, if you respond to the parameter by entering 40000, then the report will display only those
customers whose sales exceeded $40,000 last year. Notice also, in the bottom right of the Crystal
Reports window, that only 58 records are returned for your report, instead of the 270 records that were
returned before you put the parameter field into a record selection formula.
By enhancing this report, you've retrieved all the information you needed and, at the same time, you've
ensured that the fewest number of records is transferred from the database server.
Related Topics
Advanced parameter features
Parameter and prompt overview
Record Selection
6.5.4 Incorporating parameter fields into record selection formulas
Instead of displaying all of a report's data every time the report is opened, you can create parameter
fields that prompt users to specify the data they want to see. To decrease the amount of data transferred
from the database server, incorporate these parameter fields right into your record selection formula.
In general, parameter fields provide interactivity for users, who respond to the parameter prompts in
order to specify the data they want to see. However, by incorporating your parameter fields right into
your record selection formula, you not only provide interactivity, but you also decrease data transfer
and increase performance.
You can add a parameter field to your record selection formula by using the Select Expert or the Record
Selection Formula Workshop. When using the Record Selection Formula Workshop, you treat the
parameter field as you would any other field.
In the following example, you will create a parameter field and then add it to the record selection formula
with the Select Expert.
2012-03-14124
Designing Optimized Web Reports
Seitenansicht 123
1 2 ... 119 120 121 122 123 124 125 126 127 128 129 ... 717 718

Kommentare zu diesen Handbüchern

Edwinfet 29 Feb 2024 | 08:13:09

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

KarenSkaky 17 Apr 2024 | 10:11:41

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

Helenlal 18 Apr 2024 | 08:19:10

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

Helenlal 29 Apr 2024 | 05:23:21

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

Chrisnug 29 Apr 2024 | 14:39:54

Hello, im noob :)