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!

Recent content by borisbe

  1. borisbe

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

    Hi Laurie, I might be doing something wrong or it might be my version of Crystal (version 9). I have a person_id and start date group. I've selected "Select Expert" on the start date group but I don't see a "Show Formula" option. Thanks for your help!
  2. 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...
  3. 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...
  4. 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 /...
  5. 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...
  6. borisbe

    Splitting up a string

    I wanted to compare certain portions of the address to an excel file using a reporting tool so I think I might just split up the address in the reporting tool since I know someone can help me here and it should be easy. Thanks again everyone.
  7. borisbe

    Splitting up a string

    Good question. If the characters between the 1st space and 2nd space doesn't include E, W, S, N, East, West, South, North then have the Address_2 blank so: Address_1, Address_2, Address_3, Address_4 3347, E, Michelson, Dr 140, W, 200 S 123, ,Martin Luther King, Blvd (Blvd is also in the list...
  8. 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...
  9. borisbe

    Exporting as Excel

    I got a new computer and it now remembers the last folder I downloaded the last excel file so I'm thinking it was computer setting so problem solved.
  10. borisbe

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

    Thanks Ken. Sorry it took awhile to reply back. I just tried it and it worked but now I need to change it to show 2 decimals so 0.46% instead of just 0% since most of them (not all) will be below 1%. I right clicked on the percent field in the crosstab then clicked format field and changed the...
  11. 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...

Part and Inventory Search

Back
Top