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...

Hi pmax9999 Sorry for the delay in responding. I did end up resolving the issue just by chance but doing suppressing all the detail fields that were duplicated. When I did this I found one field that was not duplicating and realized what was causing the multiple lines to appear (it...

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 pmax9999; I did exactly what you suggested and enter a formula (just to see what would happen) which was {XHCTRL00.XHCNTD}/50 and first crystal allowed me to save the formula and when I added this formula field to the report it actually showed results. So I guess this really is a numeric...

Hi SkipVought Thank you. Would I be able to convert the text to a number if I had to with the data the way it is? Thanks Rose

Hi pmax9999 and SkipVought: First thank you both for responding. Excellent help and learned quite a few things. pmax9999 I used your suggestion with a little modification for additional criteria and the formula now appears to be working. Never thought about only needing to test the time...

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...