Search results for query: *

The simplicity of this is killing me, i am not sure if I am missing something here or not. I have a report of part numbers (field 1) and their descriptions (field 2)using crystal 2013. If the part number revision is ["Obsolete"= true] I only want the first/single line of its description to show...

I am using Crystal 2008 pulling in measurement data from .csv files to generate reports on the Cp & Cpk process values. I am looking for methods or formulas that can be used to accomplish this relatively easy. I know the formulas for Cp & Cpk are readly available but are in depth and possibly...

Well every couple years someone wants a new report and I get elected.. too bad I don't use this program more often. Let me preface this request with the fact that I have tried everything "I know" and it caves in. This is a basic BOM breakout of a main assembly to its second level sub's and...

I have been using acm2006 for some years now and never had this problem. I have gotten drawings from another person using 2009 and swears that he "saved as" 2004 format. I can open the drawing fine...but if I do anything other than zoom around.....acad error.....click "OK"....crash straight to...

Using CR11 Just trying to make a small quote form. I have established parameters for Part # and Qty. This formula should return to my detail section the quantity of parts that is associated with part #1,2 or 3. But not working ! Brain dead need suggestions possibly different approach. Everything...

CR10 I have to do a listing report on components {IPART.IPPART}in our inventory and I wish to "group" by any change in the first (4)digits in the part number {IPART.IPPART}. The part numbers are strings not an actual number. Examp: 1004-235, 1004-387, 2000-658, 2001-897, 4002-264, etc...

Using CR10 Reporting from Foxbase DB I am missing something here........ I have created a report for retrieving costs based on a BOM for a manufactured assembly. I assign the parameter {? What Part to Produce} to the select expert for the main assy PN#. This will then retrieve all the...

New @ trying to report from log files..!! USING CR 10 DATA PATH IS A MAPPED DRIVE TO THE FOLDER ON A WIN2000 SERVER "ISA LOG FILES" LOG FILE FORMAT IS W3C FILE NAMING CONVENTION IS "WEBEXTDYYYYMMDD" FOR DAILY LOGS. I have been trying to read all the threads pertaining to this...

Lost.... I have been reading everyone's threads on "moving" folders and retaining shares, permissions and all....but I need to move from "drive to drive" on the same server not a different server. Backup & restore would work great for another machine...but will not work using the same server...

This has to be simple...but I am drawing a blank using CR9 I wish to compare a collection of detail values and supress everything except the values that don't have an exact match. example; 4001-065 4001-070 4001-070 4001-091 4001-091 all I want to see is 4001-065 Thanks in advance G

This has to be simple...but I am drawing a blank using CR9 I wish to compare a collection of detail values and supress everything except the values that don't have an exact match. example; 4001-065 4001-070 4001-070 4001-091 4001-091 all I want to see is 4001-065 Thanks in advance G

using CR9 pulling from VFP (6.something) thru ODBC from current report; database > Show SQL Query SELECT DISTINCT `ipart`.`ippart`, `ipart`.`ipdesc`, `ipart`.`ipclas`, `ipart`.`ipqoh`, `ipart`.`ipqal`, `ipart`.`ipminq`, `ipart`.`iptype`, `hpodt`.`hdpo`, `hpodt`.`hdpum`, `hpodt`.`hdrecd`...

Using CR9 In the "select expert" I need to specify (3) different ranges to get my complete set of parts. #1. Range req'd. is {ipart.ippart}in 9402-000 to 9402-868 #2. Range req'd. is {ipart.ippart}in 9506-100 to 9506-750 #3. Range req'd. is {ipart.ippart}in 9602-000 to 9603-999 What is...

I have looked & possibly missed it in help....but how do I specify font formating in my formulas.? if {@RawReqd}>{@RawAvailable} //make bold then crRed //default font else crBlack Is it possible to callout other formating of fonts in formulas ?? If so where do I find the white...

Using CR9 I have used the following formula in the detail section to suppress duplicate records ..BUT.. I also get a single extra record for each record that has an open PO condition. In each instance where there is a PO how can I get only the (1) record showing the PO issued? //check for open...

In CR9; I am trying to get part descriptions (formated in excel as text) into a report but because for some reason when CR reads them it thinks they are numbers and it eliminates anything that is a mix of numbers & letters. Is there a way to force CR to read as text ?? I have tried "ToText" in...

Using CR9 I am having no luck trying this in Hierarchical Grouping Options, the sub #'s will not break out with detail. Here is a brief explanation on what I need. (need to pull in 4 sub PN#'s) I guess you could call this an assembly breakout. Chosen Main assy PN# from parameter: #9400 First...

In CR9 I am having a problem getting my lines (records) to show alternating colored lines. I know on a straight up report with no detail supression formulas running it is just... if Remainder (RecordNumber, 2) <> 0 then Silver else NoColor but I have a detail supression formula of... if...

I am in need of a little layout/procedure help..! I am using CR9 I have been able to call in by parameters the "main" assy # and the "Qty" I wish to report on. This is going to be a "what-If" type report...("What-If" I need to make 5 assy's, do I have enough materials or parts.?) The report...

I need to "add Command" in my report and generate a composite table using SQL. I am unsure what the correct syntax is for this expression that crystal will accept. I am getting information thru OBDC visual foxpro. SELECT (syntax for table fields?) FROM (syntax for table fields?) WHERE (syntax...