Search results for query: *

I want to combine extended description fields into one field that shows at the record level. For example... Table1:Inventory Item Table2:Extended description on inventory items Table1.ItemNo Table2.ExtDesc Table2.Sequence Details > Record #1 A100ZX Interface, tabl...

I have a Bill of Lading where I need certain disclaimers to print in the right column. The disclaimer is fixed text and will span a range of details (items shipped). Here is the jist of what the form looks like... QTY ITEM# DESCRIPTION (This is where the 1 ABC ABC PART...

I need to strip the slashes from a date field. I have: 1/2/2003 I need: 01022003 &ru

I need a formula that will return a value for which week the transaction date falls within the current month (1-5). In other words, if the transaction date is 2/3/2003 the result should be "2" since it is based on a Sunday - Saturday week. Another example is if the transaction date...

Problem: I have a subreport in footer "a" and a large footer in footer "b". When the report exceeds one page, my page footer (where it says, "continued") does not show. I know that the reason for this is that I have a conditional suppress on the page footer...

I have a Bill of Lading that is printing on a dot matrix and need to change the page length to 8 1/2 x 7. Any way to accomplish this? &ru

Why would the following formula return an error? totext({SO_23CRWInvoiceDetail.QtyShipped}/{IM_90_UDF_IM_Masterfile.Weight}) + " " + totext({IM_90_UDF_IM_Masterfile.Label}) When I save the formula in Crystal it does not find an error, yet when I preview the report the error pops up. &ru

I want to create a group and then gather records into that group based on the contents of a certain field. IF {Field A} contains "SBN" OR "QTR" THEN gather record into GROUP A. ELSE IF {Field A} contains "DA" OR "BEAK" gather record into GROUP B. My...

I need to strip / mask a field if it matches another field within the same record. For example, I have these two fields along with an example of their corresponding values: {IM.Category3} = CATALANA {IM.Category1} = 4X4 {IM.Description} = CATALANA FENDI GOLD 4x4 = CATALANA...

I need to strip / mask a field if it matches another field within the same record. For example, I have these two fields along with an example of their corresponding values: {IM.Category3} = CATALANA {IM.Description} = CATALANA FENDI GOLD = CATALANA FENDO BONE...

I have account numbers in the below format: 54000-1 I need them to appear in a 9 digit format, by removing the "-" and adding 3 zeros to the end. So the above number becomes like this: 540001000 Any ideas? Andrew Hagenbach OPUS SYSTEMS, INC. 916.503.3173 ahagenbach@opus-sys.com

I have combined 5 fields by simply inserting a "+" in between each field. This works fine, but I need to insert some formatting to remove/add some digits in there. The bank needs a file to read 37 characters long in a given format. There are two fields that need formatting within the...

I need to combine 4 fields from 3 separate tables so that they appear as one result. It works with some but not with others. Example: In the below formula, I get my desired result. {PR_02DirectDepDataEntry.RoutingTransitNumber} + {PR_02DirectDepDataEntry.AcctType} However, when I add a...

I need to be prompted to enter two separate criteria - (1) the date range and (2) the salesperson. I currently have the date range prompting me to enter a date range, but how can I have the next step be to enter a range of salespersons? Andrew Hagenbach OPUS SYSTEMS, INC. 916.503.3173...

I have an Accounts Receivable Trial Balance where I need all invoices that meet the following criteria: (a)They must have an invoice balance that does not equal zero; and (b) they must have a transaction date <= 3/31/02. However, not all records are appearing when I generate the report. All...

I have created an accounts receivable aging report based on a column of data. I have established the aging categories by using an IF THEN ELSE formula in like manner... if {@InvDueDate}-{AR4_OpenInvoice.InvoiceDueDate}>119 then {AR4_OpenInvoice.Balance} else 0 It is [randomly] returning two...

What is the &quot;IsNull&quot; used for? Thanks, Andrew Andrew Hagenbach OPUS SYSTEMS, INC. 916.503.3173 ahagenbach@opus-sys.com

I have a field of information that prints onto a form, and I need to mask it so that the first three characters do not appear, but only the remainder of it. How to? Thanks, Andrew Hagenbach OPUS SYSTEMS, INC. Andrew Hagenbach OPUS SYSTEMS, INC. 916.503.3173 ahagenbach@opus-sys.com

I have a cable modem (RCA) and try to use a VPN connection to a client's network, frequently getting disconnected. I am wondering if there are any known issues regarding this combo.

How can I hide only certain data fields? In other words, is there a formula (i.e. &quot;no show&quot;) that can be used to hide a field when the information contained in that field shows a specific result? For example, I have a Crystal Invoice form that I want to show if the field contains a...