Search results for query: *

Hi all; I am writing a report and would like to do compare a File date field to the current date in order to tell if the current date is less than the File date field. Is there a formula I can write to accomplish this? Thank you Rose[smile]

Hello; We have a report which runs based upon certain data within our system files. Report works great when the data is in the files however the data purges after a set number of days. Is there a way to create an output table based upon the data while it is on the files which can then be...

Hi; I have added a running total to a report I created and the run time has significantly lengthened. Since this is the first time I a using a running total in a report are there any suggestions on how to use running totals without or minimizing the impact to the report run times? Thanks Rose

Hi; We have created a Cycle Count report which shows a status of either; Create Task for First Count, Create Task for Second Count, Cycle Count Outstanding or Yearly Cycle Count Completed for each location being counted. There is a minimum of 2 counts required for each location for our...

Hello; Need a little assistance with a report I am attempting to complete. I have 3 files from which I am getting data and I have used the Select Distinct Records under the Database tab but this is not eliminating my duplicates. The files I am using are Task file, InvAdj File and finally...

Hi; Can someone help me to write the following formula within Crystal Report. Here is the data I am working with and what I need: There is a field called PSCrtDt (YYYYMMDD(number) and PSCrtTime (number) which I want to combine into one field called PSTiming. I then have a field called...