Search results for query: *

If you put into the 'Report / Selection Formulas / Record' the formula: {yourTable.yourSurveyField} in ["initial","termination"] this will only allow those two type of surveys into your report.

if Remainder(val(MID({Sheet1_.bin_num},5,2)),2) = 0 then "Even" else "Odd

There is a function called: OnFirstRecord So formula would be something like: If OnFirstRecord or {table.xyz} = previous({table.xyz}) then ...

These look like Sage100 tables. Keep in mind that the table SO_InvoiceWrk is an empty table and only gets populated during invoice processing, then empties out again.

I have had this happen. The screens are opening off-screen or onto a mythical second screeen. Here is something from our Ken Hamady: https://kenhamady.com/cru/archives/2491 -Andy

kray, The 'mean' would be the average of the three values. The 'median' is the middle value'. -Andy

I have an extra int() function that's not needed. so ...: To get duration HH:MM (assuming this all happens on the same day): numbervar mns := {yourTimein}-{yourTimeOut}; totext(int(mns/60),0,"") & ":" & right("0"&totext(mns mod 60,0,""),2)

To get Time Out use this formula: numbervar hr := int({yourTimeOut}/60); numbervar mn := {yourTimeOut} mod 60; time(hr,mn,00) To get Time In use this formula: numbervar hr := int({yourTimeIn}/60); numbervar mn := {yourTimein} mod 60; time(hr,mn,00) To get duration HH:MM (assuming this all...

I think it might be the HASVALUE() function. That function might not exist in your version of Crystal (it doesn't in mine). You can probably change it over in some way by using the isnull() function. Maybe: not(isnull({?Pm-?Reporting Time Frame})) -Andy

pmax's formula will work unless it is December. If you change the function from date() to dateserial(), it understands that month 12 + 1 is actually January of the next year and then when you subtract one day it know it is the previuos year again (great function)...

A formula for returning the last day of the month is: dateserial(current_year_value,current_month_value+1,1-1) (the first day of next month minus one day) -Andy

One way is to bring the second report in as an unlinked subreport on the first report - put that subreport in the Report Footer (of the first).

One way - In your Selection Criteria, add: instr(ucase({yourField}),"L") = 0

Here are links to Ken Hamady's formula's for Work Days and Work Hours that Linda is referring to: http://www.kenhamady.com/formulas/form01.shtml http://www.kenhamady.com/formulas/form13.shtml

Using the Crystal SOUNDEX function that Pete suggested would have treated all of your Weapon spellings ("WEAPON" "WAEPON" and "WEAPN") (also "Wepin","Wepon","Weapom","Wepom",...) as Weapon. They all have a soundex value of W150 If SOUNDEX({yourParameter}) = SOUNDEX("WEAPON") then "W"; -Andy

I think this is the FAQ that lbass recommended that wrburch used: faq767-3543

I looks like it is: thread149-1039223

If you want that Excel ability to understand dates, use DateSerial() function instead of Date(). That function knows that month 12 plus 1 equals January and automatically know the year is one month later too.

Pete's 'Group Selection' formula would exclude (it would not display) the fastest truck from the sorted list of trucks.

Staceyn, Another place to look is in your report, see if under File / Report Options / on the right-hand side you have "Read Only" checked. -Andy