Recent content by MCuthill

Pete: That is excellent! "Note to future self" should I ever be looking to do anything similar. Have a star! Mike --------------------------------------------------------------- "To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love...

Huytonscouser, Is it just the 4 possibilities? or is it A & B based on the "Month-Half" and "x" months ahead of the dates analyzed? If just the four options, an IF using either DatePart() as Madawc suggests, or the Year(), Month() and Day() functions identified in your original post. If it is...

Hahaha. Thanks Pete! I was looking at this thread for replies this morning, and thought "wait... that should be an OR" (I should really pay attention for same-named fields), scrolled down, and saw you already covered me. Cheers! Mike...

Tata004, I am thinking it is a quirk of Crystal Reports that is getting you. IsNulls have to appear before your other critiera - not sure why that is, but has been my experience, and nearly certain you would find similar responses on TT if you took a look. Try changing the order of your...

Hopefully they are okay with default "text" and pressing enter to run the report, a workaround such as this is the only means I can think of to do what you are asking - essentially "trick" Crystal into calculating the dynamic value if the trigger is selected. It always surprises me how often we...

taterday, Not sure if I am out in left field on this one or not... but I'll take a stab at it - or at least some logic suggestion to try. What if you had your report structured something like (my apologies if you have tried this and I missed it in the explanation): Group 1: Manager ID Group 2...

Erm... Sorry, I goofed the mock up. ... THEN Month(Table.SomeDateField) = Month(CurrentDate) ELSE ... Mike --------------------------------------------------------------- "To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and...

NorthW, The "simplest" way around it I can think of is to all "Current" as the default text option, and conditionally setup your report criteria when "current" is chosen. If you could provide your current Selection Criteria, myself (or another TekTipper) should be able to assist you further...

Wanzek1, Unfortunately, all the results of an IF statement have to be of the same data type. Ergo, either the Project managers would need to find a numeric flag of some form (not very ideal), OR you could convert all of your numeric results to Text with ToText(). It might be a little tedious...

Wanzek1, This is a Running Total, where each time the formula "triggers" the value of the variable "JobEndSubPhase" is incremented by the value of the formula field {@JobEnd+-} in the same instance. Example: {@Formula in Question} ... {@JobEnd+-} ...... 200 ................... 200 ...... 350...

Fsyeda, TopN is an option in the "Group Sort Expert" dialogue box, and functions in the same manner as a sort except with a limitation as to the number of results visible (the entire report still runs in order to determine the TopN results). As Ian stated, you will want a very high value for...

NorthW, In my version of CR (10), there is a button on the dialogue box for creating a Parameter called "Default Value". This is the same as when you "edit" an existing parameter. The subsequent dialogue box should provide you with the options needed to set up a default. I haven't worked much...

Fsyeda, This looks like a Running Total solution. There is a wizard within Crystal that is likely sufficient for something like this, though I have personally never used it and prefer to setup the RT's manually. I would suggest taking a look at the wizard first, and if that is unable to help...

MochaLatte, Can you please provide a bit more detail, and perhaps some examples? (a conversion isn't mentioned, but that doesn't mean you don't have one). I would assume you mean it is decimal format, in pounds. Which would mean that "10 lbs. and 8 oz." would appear as 10.5 in your original...

aj: Further to Skip's post - perhaps your fields themselves have more than 2 decimal places as well. You could try enclosing your fields with Round() functions to test. Alternately, expand all columns to more decimals and see if there is another cause (posting the results of said expansion...