SAP Crystal Reports 2011, Win User's Guide Page 471

  • Download
  • Add to my manuals
  • Print
  • Page
    / 718
  • Table of contents
  • BOOKMARKS
  • Rated. / 5. Based on customer reviews
Page view 470
7.
Click the blank field under Country and select Region, and then click the blank field under Region
and select City.
8.
In the Parameter Binding area, ensure that only the City value is bound.
9.
Click OK.
10.
Return to the Field Explorer dialog box, select Parameter Fields, and click New.
11.
Enter a name for the second parameter in the Name field.
This example uses CustomerCity.
12.
In the List of Values area, click Dynamic.
13.
Enter prompting text for your new prompt group in the Prompt Group Text field.
This example uses "Choose the City that your customer is located in."
14.
Select Existing, and select the list of values that you created in steps 6 through 9.
15.
Click OK.
You have created two prompts: a Country, Region, City hierarchy for the {?SupplierCity} parameter,
and a second Country, Region, City hierarchy for the {?CustomerCity} parameter. By reusing the
list-of-values object, you saved time and improved performance time in Crystal Reports.
Note:
You can also use an existing list of values if you have another parameter field that should have a country
value. For example, if you add a {?DivisionCountry} parameter to indicate the corporate division that
you want to report on, you could use the same list-of-values object in your report. You would bind this
parameter to the top-level value in your hierarchy—that is, the Country level of the Country, Region,
City hierarchy.
21.8.2 Using separate value and description fields
It is common in relational databases to make use of code fields that represent values. These codes are
often numeric or text strings that cannot be read by your users. For such cases, you can create separate
value and description fields in your list of values definition. You set the value field to the parameter; the
description field appears in the prompting dialog box. How the description field appears in the prompting
dialog box is controlled by the prompt option "Prompt with Description Only." When set to True, only
the descriptions are visible; when set to False, both the values and descriptions are visible.
21.8.2.1 To set separate value and description fields
1.
Open the sample report called Group.rpt.
Sample reports are located on the SAP Business Objects Support web site.
2012-03-14471
Parameter Fields and Prompts
Page view 470
1 2 ... 466 467 468 469 470 471 472 473 474 475 476 ... 717 718

Comments to this Manuals

Edwinfet 29 Feb 2024 | 09: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 | 12: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 | 10: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 | 07: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 | 16:39:54

Hello, im noob :)