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

  1. kime1974

    Need to pull bits of data from a record using alias tables

    Hello - using Crystal 2008 for this report. I have a report where I am pulling in 4 copies of the same table in order to display a hierarchy. There are 4 levels of hierarchy being displayed on the report from these alias tables. I need to pull two fields (Name and Tax_ID) of information from...
  2. kime1974

    Form to pull certain data based on what is selected in previous field

    Hi, We are looking to have a form display certain information from a table, based on the data entered in the previous field. For example: Employee: Joe Employee Organizational Unit: Operations Department: IT We want just the 3 departments under Operations to show in the drop-down while on...
  3. kime1974

    Search for Punctuation in a Field

    ...these errors prior to an extract being taken. We are currently looking for results to be returned in the select expert using the following: like ["*!*", "*#*", "*$*", "*%*", "*(*", "*)*", "*-*", "*,*", "*.*", "*:*", "*`*", "*~*", "*+*", "*=*", "@"] I was just wondering if there was...
  4. kime1974

    Need to find employees at certain age during a specific time period

    I have to check each month to see if they made the criteria. If they meet the age 55-64.99 at anytime during this time period, I need them to appear on the report. It's not set to 55 for 7/1/09 and 64.99 for 6/30/11, it needs to be evaluated every month.
  5. kime1974

    Need to find employees at certain age during a specific time period

    I know I probably did this the long way, but I made a formula for each month in the time period (24 of them!) and put them in my select expert like suggested above with an or for each month: {@AgeFormula} in 55 to 64.99
  6. kime1974

    Need to find employees at certain age during a specific time period

    The age limits are at between 7/1/2009-6/30/2011. If they are between 55-64.99 at any point during this time period, I need them to show. Each month needs to be checked and if they go over 64.99 during this time period, I would still want them to appear. If they are not 55 on 7/1/2009 but turn...
  7. kime1974

    Need to find employees at certain age during a specific time period

    I am currently using Crystal XI. I need to pull employees who are between the age of 55 and 64.99 between the time period of 7/1/2009-6/30/2011. If they reach this age at any time or go over 64.99 during any time during this time period, I will need them on my report. Thanks!
  8. kime1974

    Count for each month in a 12 month period

    We have been using this report and found another scenario where it does not appropriately count. If the employee has a membership line effective 11/1/2003 and terminates on 7/31/2008 and then they add another membership line effective 8/1/2008 with no termination date (happens for various...
  9. kime1974

    Count for each month in a 12 month period

    Wow! Thanks so much LB! This works slick! I was just about to give up and try to get someone to program this outside of Crystal!! Have a great weekend :)
  10. kime1974

    Count for each month in a 12 month period

    Thanks lbass...I am still having a problem where it will not count someone if they have become effective after the starting date of the parameter. For example: Joe Q. Employee is effective 7/1/2009 with no termination date. We are wanting counts for each month starting with 1/1/2009. He does...
  11. kime1974

    Count for each month in a 12 month period

    I am using Crystal XI and need to pull in counts for each month in a 12-month period. The 12-month period can be different each time it is run. The data is entered with an effective and termination date to capture eligibility. Here is an example of how someone can be in they eligibility...
  12. kime1974

    Convert m/d/yyyy to mm/dd/yyyy

    Thanks Skip! Good to know, looking at the data further it is pulling for other unmatched items I am also evaluating.
  13. kime1974

    Convert m/d/yyyy to mm/dd/yyyy

    I apoligize if this is already a thread, I searched but couldn't find exactly what I need. I am using Crystal XI and would like to create a formula for a date field to convert to mm/dd/yyyy from m/d/yyyy. I am looking to evaluate it against another database to determine if there is a keying...
  14. kime1974

    Selecting Text not in Upper case

    I am using Crystal 8.5 and XI. I need to display records that certain field data in not in Upper case. Examples are below: 125 Main Street 45 ELM STREET 45 PORTER CIRCLE 98 Salem Street I would like the results return: 125 Main Street 98 Salem Street Thanks! Kim
  15. kime1974

    Display Text after a Particular Character in Field

    Perfect! Thanks!
  16. kime1974

    Display Text after a Particular Character in Field

    I am using Crystal 8.5 and XI. I would like to display a field in my report that displays the text after the "-" in the field. Here are some examples: Field Data Formula should display JYMC-M$1 M$1 C100MC-M$1P M$1P...
  17. kime1974

    Exporting to Text from a Query

    Here is the SQL...I should not that this is for an insurance member conversion and it has to be in a fixed field lenghth format. If a field does not contain the fixed width, it must be filled with blanks at the end. SELECT Conversion_Sub_KimTest.RecordType, Conversion_Sub_KimTest.SubRefID...
  18. kime1974

    Exporting to Text from a Query

    We have a query to export to text using fixed width. The query is using 3 tables and is 9,134 characters per record. It allows us to run the query, but when we try to export it we get the error "Record is too Large." Any thoughts on how we can get the data out of Access in the fixed width...
  19. kime1974

    Insert Running Total

    I have a table of data that I want to run a query against to insert a running total column based on a field in the table (Member ID). Example of the column data would be: Member ID Benefit Plan Date I want to have a running total on a reoccuring Member ID. Example of...
  20. kime1974

    Converting DateTime to Date and Reformatting Dates

    I am using Crystal 8.5 and need to change the format of a date time field to a specific format. I can do it within the report, but when it is exported to Access it loses its format. Here is the current format 11/1/2006 12:00:00AM I need to format it in a formula to 2006-11-01-12:00:00 In...

Part and Inventory Search

Back
Top