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

  • Users: borisbe
  • Content: Threads
  • Order by date
  1. borisbe

    Include person_id if previous record start date is more than 3 years from specific start date/term

    I hope I can word this so it makes sense and I didn't forget anything. person_id start_date term class 1 10/23/2012 1128 test 1 05/07/2013 1136 life 1 07/20/2013 1136 life 1 10/07/2014 1148 test 1 01/26/2015 1154 test 2...
  2. borisbe

    Calculating the Number of Weeks between Dates. Only held on certain days of week (Problem: Holidays)

    I have version 9. name mon tues wed thurs fri sat sun start_date end_date test1 Y N Y N N N N 01/13/14 2/24/14 test2 Y N N N N N N 01/13/14 2/26/14 "Y" in a day of the week means it is being taught on those days of the week. DATEDIFF("w", start_date...
  3. borisbe

    Problem: Move beginning of a string to the end of the string (forward slash is in the string)

    I have a title "Beginning / Intermediate Jazz" and I want to move the "Beginning / Intermediate" to the end with a colon before it so I need: "Beginning / Intermediate Jazz" changed to "Jazz: Beginning / Intermediate" ============ I have in the formula if instr({title}),"Beginning /...
  4. borisbe

    Totals based on the same number of weeks for the current year's start date and 2 previous years

    I want the total # of persons every week for current year and 2 previous years based on start dates. I will be running this report weekly until December. We are trying to figure out if the numbers in the same weeks of a start date are higher or lower. I'm using Crystal 9 with a csv file that...
  5. borisbe

    Splitting up a string

    I have an address field that I want to split up to 4 fields. I can split out the 1st part but not sure how to do the rest. Addresses 3347 E Michelson Dr 140 W 200 N For Address_1, I used "substr(ADDRESS,1,(instr(ADDRESS,' ')) - 1) Address_1, Address_2, Address_3, Address_4 3347, E...
  6. borisbe

    Exporting as Excel

    Using Crystal version 9. Whenever I export to excel, it always shows the temp folder so have to always change the folder that the file needs to go. When I export as a PDF (set the printer as PDF and click on the printer button on the standard toolbar then it remembers the last drive folder where...
  7. borisbe

    Percent of the total for a distinctcount in a cross-tab

    I'm using version 9. My cross-tab so far. The enrls are totaled by using distinctcount instead of sum. Area Enrls ART 5 DANCE 15 Total 20 Is it possible on a cross-tab to get the percentage of the total per area so: Area Enrls Enrls Percentage ART 5 25% DANCE 15 75%...
  8. borisbe

    How to search for a certain string of characters then move them to the back

    I have titles that begin with certain words like "Non-major","Introduction to the","Introduction to", "Beginning", etc. and if a title begins with them then I want a comma and these words at the end of the title else just the title if they don't begin with these words. How is this completed...
  9. borisbe

    Find the minimum number for a field then change all of the following numbers, if necessary

    Hey I have data where there could be 1 pattern or multiple patterns. set pattern 1 1 1 2 1 3 2 2 2 4 3 3 Is there a way in a case when, if or some other expression that I can write that would find the minimum pattern for a set and always make it number 1 then...
  10. borisbe

    Compare table in production database and development database

    I'm using Crystal 9 and connecting to mysql. We have a production database and a development database. Is there a way in crystal to compare the tables to make sure there are the same fields in a production database table and a development database table? Example: Production table "class"...
  11. borisbe

    move word from front to back and add a comma and space

    Working with a csv file in Crystal 9. We have titles in the csv file. Just a few examples: 1. Beginning Yoga 2. Beg Yoga (Beg short for Beginning) 3. Advanced Yoga 4. Intermediate Yoga 5. Intrm Yoga (Intrm short for Intermediate) 6. Intermediate Pilates Is it possible to move the first word...
  12. borisbe

    ID at a certain locations and other locations (if any)

    I hope I can explain this correctly. How do I complete a select statement so if a person's ID is at a specific location and other locations (if any) then retrieve the locations that I specify and the other locations. TABLE A ID term crse_nbr 1 0094 1 1 0094 5 1 0094 6 2 0094 1 2...
  13. borisbe

    select id at a location and also if at a different location

    TABLE A ID term crse_nbr TABLE B term crse_nbr session title TABLE C term crse_nbr session location ======================== select TABLE A.ID, TABLE B.term, TABLE B.title, TABLE C.location from TABLE A, TABLE B, TABLE C, where TABLE A.term=TABLE B.term and TABLE A.crse_nbr=TABLE B.crse_nbr...
  14. borisbe

    Week by Week Comparison

    My data: year id stat_date 2008 1 01/01/2008 - this is a date in week 1 of 2008 2007 2 01/08/2007 - this is a date in week 2 of 2007 2008 1 02/04/2008 - this is a date in week 6 of 2008 2007 3 02/06/2007 - this is a date in week 6 of 2007 I need to compare week to week (id...
  15. borisbe

    Week # Expression

    I'm using a query manager but I can create oracle expressions so I'm hoping this can be done. I hope I can explain what I need so that it makes sense. I have a start_date and end_date field. Is there anyway to have it break out per week# in the calendar year so: ID Start Date End Date 1...
  16. borisbe

    Data count per Week

    I'm trying to create a report (crystal 9) and is there a way to sum enrollment on a weekly basis? I have id, start date, end date and enrl data. id start end enrl 1 01/01/08 01/30/08 5 2 01/03/08 02/15/08 10 3 03/03/08 06/30/08 6 I need a count: week# enrl 1 15 -...
  17. borisbe

    Include in Count if Certain Criteria is Met

    I am using Crystal 8 with a csv file. I hope I can word this problem so it makes sense. CSV File: ID Task 1 95555 1 55555 1 52154 1 62154 2 95555 2 55587 3 84444 3 55522 4 84444 4 95212 4 51555 5 95555 5 54545 Needed Results: Task 95555 Other...
  18. borisbe

    Formula Count Problem

    I have a table with ID, task # and forward date. Example: ID Task # Forward Date 1 1 01/01/2006 1 2 01/03/2006 1 3 01/05/2006 1 4 01/07/2006 1 5 01/09/2006 1 6 01/10/2006 1 7 2 1 2 2 2 3 2 4 2 5 2 6 3 1 01/10/2006 3 2...
  19. borisbe

    Select Statement Question

    I have a person address table and a person table. A person can have different address types (HOME, MAIL, etc.). Everyone in the database should have a MAIL address type but sometimes that type is not entered. I know how to include where address type is MAIL but then how do I also get a person...
  20. borisbe

    Splitting up a String

    I have a string field. Examples: 121 100 106 111 115 301 302 305 306 307 308 311 312 106 103 106 110 111 131 115 301 302 305 306 308 309 310 311 How can I split up this field so each of the set of numbers is a separate field? Thanks

Part and Inventory Search

Back
Top