SAP Crystal Reports 2011, Win Betriebsanweisung Seite 511

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 718
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 510
"Table name LIKE" is based on the SQL LIKE clause. This option allows you to specify the kinds
of table names you want to appear in the Choose SQL Table dialog box. You can use the
underscore character (_) or the percent sign character (%) as wildcards with this function. The
underscore character specifies any single character, while the percent sign signifies any character
string. For example, DAV_ matches DAVE only, while DAV% matches DAVE and DAVID. Table
name LIKE C% would display only those tables that have a table name beginning with the letter
C.
"Owner LIKE" is also based on the SQL LIKE clause. The Owner LIKE option allows you to select
the Owner (or Creator or Alias) of the table, not the table name itself. For example Owner LIKE
C% would display only those tables that have an owner beginning with the letter C.
Note:
For more information on the SQL LIKE clause, refer to your SQL documentation.
4.
Click OK to exit the Options dialog box.
5.
On the Start Page, click Blank Report.
6.
Locate and select the SQL Server data source that contains the stored procedure you want to use.
7.
Click Next to go to the Connection Information dialog box.
8.
Enter the required information to log in.
9.
Click Finish.
23.2.2.1.2 To change a parameter in a stored procedure
1.
Highlight an SQL stored procedure in the Stored Procedures folder, and click the > arrow to add it
to the Selected Tables list.
The Enter Parameter Values dialog box appears.
2.
Highlight a parameter in the Parameter Fields list.
3.
Assign a value by typing into the Discrete Value box and then click OK.
You are returned to the Database Expert.
4.
Click OK and create your report using the fields in the stored procedure.
The first time you refresh your report's data the parameter you entered is used. Only the records that
satisfy that value are used in your report. Subsequent refreshing prompts for new parameter values.
23.2.3 How does Crystal Reports use SQL?
When you connect to an SQL database, Crystal Reports acts as an SQL client application, connecting
to your SQL server through your network.
When you design a report that accesses SQL data, Crystal Reports builds an SQL query. This query
can be seen by choosing Show SQL Query from the Database menu.
2012-03-14511
Understanding Databases
Seitenansicht 510
1 2 ... 506 507 508 509 510 511 512 513 514 515 516 ... 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 :)