Search results for query: *

Crystal XI with an SQL Server Database 2005 (JobBoss) SELECT 'Tax_Code_Detail'.'Rate' FROM 'Tax_Code_Detail' WHERE 'Tax_Code_Detail'.'Tax_Code' = 'NC TAX' or SELECT "Tax_Code_Detail"."Rate" FROM "Tax_Code_Detail" WHERE "Tax_Code_Detail"."Tax_Code" = 'NC TAX' The first bit of code comes...

I am comparing two dates and would like an image of a flag instead of a plain "X" when the two dates do not match. //if scheduled begin date has past and percent complete is less than 100%, mark with a flag Global StringVar tryImage; if {Job_Operation.Sched_Start} < CurrentDate AND...

Using MS Access 2003 We are creating labels for our upcoming inventory. We currently have a Crystal Reports label that uses font format Code 128AB to create the bar code. We need more information on the label, so I'm trying to create one in MS Access. For my bar code I am using the formula...

Thank you very much! I needed to switch to Basic Syntax before writing the code. I never would have guessed that!

I am trying to use Select Case to set the value of a variable called LimitPct. It is the percentage limit of an invoice quantity over the PO quantity we will accept. It is different for different vendors plus the may be ranges we negotiate for a given vendor. I prefer Basic Syntax b/c that is...

May I jump in? I have the same question. I have created a caculated field in Group 3 section. The field is: ({Source.Inv_Qty}-{Source.Act_Qty})*{PO_Detail.Unit_Cost}. I now need to summarize it in the report footer. I tried using the formula wizard box, but the results I get are very...

We're new to MAS 90. I'm trying to create a report via Crystal that lookings for packing lists without invoices. I am unable to identify which table contains packing list history. Any suggestions