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!

Register Log in
  • Congratulations Rhinorhino 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. smsherman

    Unique value without using UNION?

    Hello, I am using Crystal 9 and I am simply at my wits end, any help or guidance is greatly appreciated. I am trying to pull distinct values from a table as follows: record, field1, field2, field3, field4, field5, field6, field7, field8, field9 I don't care what the record is- I just need...
  2. smsherman

    Unique values for Crystal output?

    Hello, I am using Crystal 9 and I am simply at my wits end, any help or guidance is greatly appreciated. I am trying to pull distinct values from a table as follows: record, field1, field2, field3, field4, field5, field6, field7, field8, field9 I don't care what the record is- I just need...
  3. smsherman

    Date Range Evaluation

    it looks like I missed a scenerio... Any suggestions on how to modify the above formula(s) to handle the following scenario: 1/1-1/31 3/1 - "active" Should return 3/1 to "active" 1/1-1/31 2/1-2/28 4/1-4/30 Should return 4/1 - 4/30 The display formula appears to pull in the first date 1/1...
  4. smsherman

    Date Range Evaluation

    This worked like a charm! Thank you so much! I modified the display formula as I want to export the data for start and end date as two distinct fields, so I used the minimum start date information for one formula, and the end date for the other formula. Would it be possible to group records...
  5. smsherman

    Date Range Evaluation

    I would want to see all record lines; however, I would want a return of 3/1 to _ as the output. 1/1 to 1/31 2/1 to 2/28 3/1 to 3/31 4/1 to _ = 1/1 to _ 1/1 to 1/31 2/1 to 2/28 3/1 to 3/1 = 1/1 to 3/1 1/1 to 1/1 2/1 to 2/1 3/1 to 3/31 = 3/1 to 3/31 I've managed to cover most of the...
  6. smsherman

    Date Range Evaluation

    I need to keep the canceled status for further calculations and to show record history. I run a record selection in 4 month increments (rolling) and a record can have a cancelled status in one month, but two months later be active again. In this instace, i would want to ignore the cancel...
  7. smsherman

    Date Range Evaluation

    Greetings, Crystal 9: I am trying to develop a formula to evaluate member records based on date ranges to calculate effective dates for coverage. fields: db.member_id; db.plan_id; db.start_date; db.end_date A member id can have multiple start and end dates for each plan, but they can only...
  8. smsherman

    Variable Calculation based on range within Sum?

    I apologize for the confusion, thanks for the reply! I made a mistake in my example. I am dealing with items sold. They can have either "returned" status, or a "sold" status. Returned status results in a negative number, "sold" results in a positive count. Commission payments are calculated...
  9. smsherman

    Variable Calculation based on range within Sum?

    Thank you in advance. Crystal 9. I am trying to put together a calculation that will apply different amounts to a sum based on the range. Put another way, the first 20 items should be multiplied against x; the next 20 items should be multiplied by y; and anything beyond that should be...
  10. smsherman

    Creating a column for field/text

    I have tried that, but it ends up messing up my entire report. I just need this one sub-section to have a column, the rest of the report (all the other stuff in the detail section) must not be placed within a column. Is there a way to just to do this with one formula within an entire report...
  11. smsherman

    Creating a column for field/text

    Crystal 9... I have a total of nine variables that can populate a formula in response to a database query: The formula outputs like this: Response1 Response2 Response3 Response4 Response5 Response6 7 8 9 I need to have the output be like this: Response1 Response6 Response2...
  12. smsherman

    Chinese Character support in formula writing

    Okay, this one is a doozie. Extra points for a work around solution: Does Crystal Report 9 (or any version) support any type of Chinese character set within the formula editor area? I am using PMingLiu font type (a Chinese character set), which can be produced in the text area of Crystal...
  13. smsherman

    Translating English date to Spanish date

    Simply brilliant! Thank you, thank you, thank you. May you live a long life and keep all your hair and teeth!
  14. smsherman

    Translating English date to Spanish date

    I need to develop a formula that will translate an English numerical date into the appropriate Spanish equivalent written out in long form. Thus, I need to turn 01/05/2005 (January 5, 2005) into "5 de enero, 2005. (enero is the Spanish word for Jan) Any suggestions on a plan of attack? Is...
  15. smsherman

    Set BackGroud Color for every other Row

    Thank you for this information! Oh, and if you want to use a different color than Pale Green, you can get the color coordinates by accessing the custom color grid (by checking the "background color" box) from the drop down menu (choose "More...") Moving the cursor around will show the RBG...
  16. smsherman

    Summing true/false statements?

    I'm not sure what I was doing wrong, but this is the final formula I put together: if isnull(sum ({@IVCcount}, {@Staff})) then count ({R_MILESTONE_SUMARY.OBVERIFY_D}, {@Staff}) else Count ({R_MILESTONE_SUMARY.OBVERIFY_D}, {@Staff})-Sum ({@IVCcount}, {@Staff}) The @IVCcount formula is: if...
  17. smsherman

    Summing true/false statements?

    Thank you MJRBIM! I rechecked some of my work and figured out where I went wrong with the sum check. I just used that formula and did a sum in the group footer refrencing the formula (for some reason I previously wasn't able to choose sum from the drop down menu). Anyway, thank you all for...
  18. smsherman

    Summing true/false statements?

    Tried that, didn't work. :( I keep getting errors when I try the sum function (not to mention that Crystal reads the 1 and 0 and true/false statements and returns a value for the 0). All the variations of the sum have not worked and I usually end up with errors when I try to validate the equation.
  19. smsherman

    Summing true/false statements?

    Thank you, this seems to be improving the situation... however, I am confused by how I am to use the "CurrentFieldValue=True". I tried replacing the currentfieldvalue with my formula, but it still counts false hits.
  20. smsherman

    Summing true/false statements?

    I don't quite understand what you are suggesting. Could you clarify? Thank you.

Part and Inventory Search

Back
Top