Search results for query: *

Hi - I'm tearing my hair out with this one. I need to create a group but the data in the records isn't helping me much: ex: item line # price cost kit a 1 10,000 yes b 2 0 3000 c 3 0 20 d 4...

Hi - I've asked this question a few different ways and can't seem to get it right - - - so here goes again! I'm using CR10 to read a foxpro file with a memo field that has multiple bits of info in it. here's a sample 04/09/08 RB: No more refridgerated truck delivery. His house is in town...

Hi - I have a memo field that I want to remove text from. The memo field may have a lot of text from various entries - - - and I would want to remove everything in between what STARTSWITH ****- and ENDSWITH -**** (SEE SAMPLE BELOW) Please note that there may be multiple **** in betweeen the...

Hi - I have a memo field that I want to split into various records: here's how the memo field appears (for records that make sense!) 01/17/05 NN: His plant problems seem to be from urea application. Plants were growing, got tip burn then collapsed and died. He had pictures to show, I asked...

Hello - I use crystal to read many tables in an accounting system (sagepro). We recently upgraded the accounting software, and I believe it's now in vfp9 - Problem is that some of the crystal reports bomb because one of the tables is now not recognized by crystal as being a table...

I'm reading a customer order file that lists items and quantities ordered. Ex: Order # Item qty 1 15 1 2 18 2 However, now I have order # 3 with item 19, which actually consists of item 15 and 18, so I need to append them as item and...

Hi - - Is it possible to kick off a report using Com Server Capability in Crystal Reports version 8? If so, please advise! Thanks Mary

Hi - - I have a report with several groups that have running totals. All is well in the initial preview, but when I drilldown, the group totals change to reflect only the drill down data, rather than the overall totals - - - - is this fixable? Ex: Main preview = group x 8 group y 2...

Hi - - I'm doing a report that has 2 columns - - - first is ytd and 2nd is prior ytd. I created running totals using a formula for the order.date fiels to be in ytd or last ytd depending on the column. However - - - the fiscal year is not the calendar year. For example - - 12/30/01 is 1st...

Hi - I'm reading SQL files and some of the data is in chinese - - - how can I display in English in Crystal 8.5. Thanks Mollie

Hi -- I need to calculate the number of days between two records using the same date field. Example: Invoice# Date Status 1 12/01/02 Created 1 12/15/02 Submitted 1 03/01/03 Forwarded There can be up to to 6 records per invoice number, each with a...

I'm trying to change the location on existing reports. Just did an accounting application upgrade to visual foxpro 7, so now there is a dbc. I set up a new odbc connection and was able to set location properly on a couple of the existing reports to look at the new location for the file it...

Hi, I'm linking to tables Table 1 Table 2 OrderID OrderID Name UPS Tracking number I only want to show the records from table one that DON'T have a record in table 2. (Meaning, not all of the orders were shipped via ups). This should be easy, but I just can't get it...

Hi - I'm trying to create a report reading the following tables. (they are dbf files) icitem sotran artran item item item qty qty extprice extprice I'm trying to list open order details (sotran) and sales details...

Hi - I'm trying to create a report that uses an item file an invoice file and an open order file. I link from the item file to invoice file and from item file to open order file. I have 2 detail lines (one invoice/ one for orders). I'm getting tripped up because it doesn't skip if there is...