madawc -
meant no harm by the caps - - - meant to emphasize the word usually - - - - didnt' realize caps were on in the header of the qeustion.
point taken.
yes, I was wondering how to use the next command to figure it out - - - I haven't been successful thus far.
so, for example, if line a...
that's the problem! there is nothing in the datafile to indicate that.
However, the kit items USUALLY show up immediately after the kit master and USUALLY have 0 cost - - - - 99% of the time.
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...
LB -
Thanks, I forgot to add "together" - - I did have "can grow" on, though...
Now that I add together I'm getting blank records -- - all of em
sample below of what I was reading in the text and then the formula I used:
text =
07/18/05 AT: wrote off finance charges....customer thought he...
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 will respond to both in this message.
1) I have done the set location to no avail. And the odbc driver is ok because it is reading the other tables (from same accounting system)
2) this is on both new and existing reports - - - crystal just will not see this arcust table.
thanks!
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 Brian - -
thanks for the reply.
the running total criteria is actually summing a forumla field
the logic of the formula field that is being summed is as follows:
if ordate <> xxxx/xx/xx then 1
(the xxxx is 1900/00/01, or something like that - - - a null value that converts to a...
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 -
Now I'm stuck again.
The above formula works when the records are grouped by invoice # and sorted by date. (see my first posting above)
However, my final report needs to look like this: (grouped by Status)
Invoice Date Status #Days
1 12/01/02 Created...
Thanks very much for pointing me in the right direction.
I used your forumla and did a variation as follows:
if {TEST.Record#}=next({TEST.Record#}) then
(next({TEST.Date})-{TEST.Date})
else
CurrentDate-{TEST.Date}
because I need it to count the days and post next to the current record ONLY...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.