Search results for query: *

fyi- Here is how I was able to accomplish the task noted in the first post in this string. Two Formula Fields were created. 1) ABBREV VALUE= InStr ({ITEMMAST.DESCRIPTION},' ') 2) ABBREV= Left ({ITEMMAST.DESCRIPTION},{@ABBREV VALUE} ) thanks for the assistance....

Idle, {ITEMMAST.DESCRIPTION}[1 to InStr({ITEMMAST.DESCRIPTION}," ")] The above produces the following error: "The subscript must be between 1 and the length of the string."

lovalles: Where the word is of variable length.

Crystal 7.0.1.100 Oracle 8.0.5.0.0 How can I extract the first word in a string? Where the word is of variable length. Is there a function which will allow me to extract the text value from the first text character until the first space in a string?

When I export a Crystal report, which includes a sub-report, to MS Excel, the data from fields in the sub-report will not display. Any suggestions? Crystal 7 Pro MS Excel 97

How can I force ownership of a *.rpt file to Crystal Reports?

The result set from a Right join includes all the records in which the linked field value in both tables is an exact match. It also includes a row for every record in the lookup (right) table for which the linked field value has no match in the primary table.

Ken, The term infinite login refers to the apparent inability of the copmiled report to connect to the database. The report does connect to the database, and runs to completion when executed from same pc that it was compiked on. Yes, an ODBC is the method used. The report does no...

Problem: Compiled Crystal Report-Cannot connect to Oracle database (infinite login) Completed Prerequisites: 1) Installed & configured Oracle SQL Net Client 2) Configured Microsoft for Oracle ODBC driver Any suggestions? Thx Alan

How do I cause the (PageNofM) field to follow the format of a group parameter?<br><br>example<br>Group 1= 25 pages (1 - 25 of 25)<br>Group 2= 12 pages (1- 12 of 12)<br>Group 3= 2 pages (1-2 of 2)<br><br>Currently this value only considers the total report page count(1 - 39 of 39).<br><br>I've...

How can I populate the &quot;Select or enter value to add:&quot; window, within the &quot;Create Parameter Field&quot; dialog box, to include relevant database values for the table and field chosen?<br>Currently, if I want to provide the report user an option to choose from a default value(s)...

Malcolm,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Disregard the post that requests further elaboration.<br>I was able to use the formula code (with slight modification)and successfully insert the formula field in my report.<br><br>Thank you very much!<br>Alan

Could you elaborate further, regarding the task methodology for the suggested conversion?<br>How and where is the Text String created?

How can I display and print a &quot;Date Range- Parameter Field&quot;?

Crystal Reports 7.0 Professional<br>Report Type: Custom / SQL-ODBC<br>Data Source: Lawson Procurement Application<br>Database Type: Oracle<br>Table Count= 5<br><br>Problem: inconsistent data population in single table field<br><br>The report is extracting data from Purchase Order related tables...