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 Chriss Miller 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: *

  • Users: smsherman
  • Content: Threads
  • Order by date
  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

    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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. smsherman

    Summing true/false statements?

    Okay, a relatively easy proposition has led to several days of frustration. I have two columns with similar date ranges. I need to do a summary comparison returning the total number of hits for each column. I also need to account for those instances where two dates occur for the same row(unique...

Part and Inventory Search

Back
Top