Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Crystal Reports recognizes the <code>*</code> as a wild card in like comparisons.</p> <p>From some <a href="http://publib.boulder.ibm.com/infocenter/radhelp/v7r5/topic/com.businessobjects.integration.eclipse.designer.doc/html/topic901.html" rel="nofollow">CR documentation available online</a>:</p> <blockquote> <p>Like pattern operator Basic and Crystal syntax.</p> <p>The Like operator is useful for selecting records to include or exclude from your report. </p> <p>Usage x like y</p> <p>{fieldname} like "c?n*"</p> <p>This operator tests to see if the contents of {fieldname} matches a pattern that you specify in a character string "c?n*". If the contents of the field do fit the pattern "c?n*", then the formula returns the value True. If the field starts with anything else, the formula returns False.</p> <p>Use the wildcard symbols ? and * to stand for variable characters. The ? stands for a single character. The * symbol stands for any number of characters.</p> <p>Examples The following examples are applicable to both Basic and Crystal syntax:</p> <p>{customer.FIRST NAME} like "D?n"</p> <p>TRUE, where {customer.FIRST NAME} = Dan or Don.</p> <p>{customer.FIRST NAME} like "D?n"</p> <p>FALSE, where {customer.FIRST NAME} = Doug or Rob.</p> <p>{customer.LAST NAME} like "<em>s?n</em>"</p> <p>TRUE, where {customer.LAST NAME} = Johnson or Olson or Olsen.</p> <p>{customer.LAST NAME} like "<em>s?n</em>"</p> <p>FALSE, where {customer.LAST NAME} = Johnston or Smith.</p> </blockquote>
    singulars
    1. This table or related slice is empty.
    1. POConditional formatting of text using wildcards in Crystal Reports
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USKrease
    1. USdotjoe
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POConditional formatting of text using wildcards in Crystal Reports
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks a lot for the explanation!
      singulars
      1. PO
      1. USShah
    2. COso if i do {fieldname} like " X?" it should be true for " X", " X12345", correct?
      singulars
      1. PO
      1. USShah
    3. COno the `?` is a wildcard for a **single** character. so it'd be false for both examples. The `*` is a wild card for 0 or more characters, so that'd be true for `like " X*"`
      singulars
      1. PO
      1. USdotjoe
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload