Search results for query: *

Ian, Here is the formula for @min that worked for me, whileprintingrecords; global numbervar min; If {ShotDeckInventory.DeckOrder} <> maximum({ShotDeckInventory.DeckOrder}, {ShotDeckInventory.HoleID}) then min:= minimum({ShotDeckInventory.Quantity}); I am still testing and I am sure this is...

If I make changes to the following formulas I get correct results for the @max formula. @reset whileprintingrecords; global numbervar min:= 0; global numbervar max:= 0; @max whileprintingrecords; global numbervar max; If {ShotDeckInventory.DeckOrder} <>...

Ian, The formulas now are correct in that there are no errors. Thank you. However I am not getting the correct results. The end results as well as looking at the data in the details section are all zeros(0). The only exception is that in the details I am seeing the quantity of 2 for Hole 1...

Ian, I understand and thank you for your quick responses. Once I change min to minimum the error, as expected moves to the next min. I update that min to minimum and so on. Once all min are updated to minimum I get an error saying that, 'The remaining text does not appear to be part of the...

Ian, Thank you very much for your help. I am getting an error in the min and max formulas. The error comes at the first min (or max) and the error is 'A number, currency...is expected here'. I have it grouped by hole. The exact formula is below. //If section <> min(section, hole) and...

I have a set of holes and within each hole there are sections. (Picture a cardboard tube divided into sections and each section has a number of units in it.) Each section has a quantity associated with it. I need to determine the minimum and maximum quantity for these sections. The...

CoSpringGuy No problem on the time, you are doing me the favor and I appreciate it. I am going to be off through the holidays coming and will not get back to the report until December. Any additional assistance is welcomed. Thanks again for your efforts.

The code above worked with the sample data as well as several other sets. I had to make a very slight change due to my mistake. I stated earlier that the Time Difference criteria was "less than or equal to" but it is only less than. I changed, ({Sheet1_.table#time})) <= {Sheet1_.tabletimediff...

LB, Thank you for your time. The records are grouped by //@Label({table.X} + ToText({table.Y},0)). Their records are in order of X,Y. For a bit more information/clarification, the record, {table.Time} represents an assigned time (simply a number) not a timestamp. Also, for what it is worth...

Very nice, thank you. I will be able to take a look on Monday.

Thank you very much for your time. I will give your suggestion a try.

Yes. Each record has to be compared to all records to get the difference in time. You would then use that difference result to see if it meets the TimeDiff criteria. There could be hundreds of records with multiple sets of records that meet the TimeDiff criteria. You would then take the maximum...

The {table.TimeDiff} requirement in the above case is 8 so the Time difference between any of the records that is 8 or less would be considered. The final result would be the records who's sum is the greatest. B1 has a Time of 92 B4 has a Time of 100 Difference of 8 which meets the TimeDiff...

Thank you for your time. The results from the above data should be; B1, B4 As a side note, A2 and B3 meet the {table.TimeDiff} requirement but the sum of their weight is less than B1, B4.

My apologies for the title, it was a hard one to summarize. I am using CR 2008. Here is an example of my data and what I am trying to accomplish. ({table.Weight}, {table.Time}, {table.X}, {table.Y}, {table.TimeDiff}) (100, 0 , A , 1 , 8) (100, 25 , A...

LB Thank you very much.

I am trying to bring in the date range parameters for a report. I believe I could simply use text boxes and the {?BeginDate} and {?EndDate} fields to accomplish this but I was wanting to concatenate the two fields as such, {?BeginDate}& " to " &{?EndDate}. My issue is the date format is set so...

The final solution was simple on my part. The programmer for the app created a summary table that I can pull from. It seemed to be easier to do with code rather than within Crystal. Thank you for your help and time on this one. I learned from it if nothing else.

You should be setting up the command as the sole datasource for the report." Would this mean since I have several fields that the report references (the datecode summary is only one of them) that a subreport for the datecodes with the sole datasourse set there? "Which fields in your actual...

Once I insert the Command in the report the rest of the report (not entirely) brakes. I am now getting the same Line/Shotpoint details for every instance of a Datecode. Here is the SQL Query. Select Summary.Det1DateCode as Datecode, [Summary.Line/ShotPoint] from Summary UNION ALL Select...