Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MCuthill

    Help with formula to check month/day range

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

    Help with formula to check month/day range

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

    IsNull and Not Null

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

    IsNull and Not Null

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

    Month value dynamically default to current month

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

    Need to print all employees under the his/hers manager without regards to a time sheet

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

    Month value dynamically default to current month

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

    Month value dynamically default to current month

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

    Another formula question for If Then statement

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

    How to understand this formula?

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

    Ranking on a Formula Field

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

    Month value dynamically default to current month

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

    Subraction in Group

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

    Format Decimal to Pounds

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

    Crystal Formual & Excel = Different Results

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

    Passing more than one value to a subreport

    Marty, The solution is to restructure the report - I am nearly certain your subreport is likely displaying the last Invoice of the group? The solution is: (1) either the Subreport should be in the details level of the main report, OR (2) it is perhaps possible to link the Subreport on other...
  17. MCuthill

    Passing more than one value to a subreport

    Marty, I think you have to have your Subreport located in the same group-level as the field upon which it is linked. Is your Subreport in the details section of the main report? If not, please provide clarification about the placement of the Subreport, as well as any groups which exist on the...
  18. MCuthill

    INSTR, PARAMETER QUESTION

    Thanks briangriffin! Have yourself a TT ! 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 adventure, in the hours of companionship. It is, most of all, to...
  19. MCuthill

    INSTR, PARAMETER QUESTION

    Kim, I knew it was recently I read an example, I found it - posted 2 days ago by user briangriffin. This example is used for a rather different result, but I beleive could be modified to suit your needs. I have not dealt with multiple-selection parameters before, so not entirely sure how to...
  20. MCuthill

    INSTR, PARAMETER QUESTION

    Kim, I am afraid I haven't used Array's much, and don't know specifically what the fix is. By memory on seeing posts on TT about it, you need to "loop" through the Array conditionally based on the length of the Array. Beyond that, I am afraid I am not too much help. Hopefully this points you...

Part and Inventory Search

Back
Top