SAP Crystal Reports 2011, Win Betriebsanweisung Seite 472

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 718
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 471
2.
In the Field Explorer, select Parameter Fields and click New.
The Create New Parameter dialog box appears.
3.
Enter a name for the parameter in the Name field.
This example uses Customer Name.
4.
In the List of Values area, click Dynamic.
5.
Click Insert and, in the Value field, select Customer ID.
6.
In the Description field, select Customer Name.
7.
In the Value Options area, set the Prompt with Description Only option to True.
8.
Click OK.
When your users see this prompt in the prompting dialog box, they do not see values from the Customer
ID field (the field on which the parameter is based), but rather, they see a list of customer names.
21.8.3 Using command objects as list-of-values data sources
Crystal Reports supports command objects as data sources for unmanaged lists of values. To use this
feature, you first create a command object using the Database Expert to return the values that you want
in your list-of-values object.
For more information see "Defining an SQL Command" in the online help.
The query you create should return at least one database field per level in the new list-of-values object.
For example, if you want to build a Country, Region, City list-of-values object, your query should return
at least three columns from your database: Country, Region, and City. You need to return all three
values in a single select statement. There is no need for an order by clause, because the prompting
engine sorts the values according to your specifications.
Note:
It is not necessary to link your command object to your report fields. In general, command objects that
you use only to populate lists of values do not need to be linked to your report. However, if you want
to use a column from this command object in your report, you need to link the command object to the
report.
All the command objects defined in your report appear in the value fields drop-down list, and in the
description fields drop-down list in the Create New Parameter dialog box. You can then associate your
list of values with the command object.
21.8.4 Null handling
2012-03-14472
Parameter Fields and Prompts
Seitenansicht 471
1 2 ... 467 468 469 470 471 472 473 474 475 476 477 ... 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 :)