Search results for query: *

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!

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...

Thanks Chris

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...

Thanks kray4660 and pmax9999. Both ways worked.

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 /...

Thanks. I'll try the datepart.

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...

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.

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...

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...

Thanks Ken.

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.

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...

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...

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%...

Beautiful. thank you so much.

CoSpringsGuy - The formula is wonderful but with just one little problem. Some titles have roman numeral numbers so "II", "III" etc. so the proper case is making them show as "Ii" instead of "II." Thanks

Thank you so much cospringsguy. I'll try it tomorrow when I get to work and give you an update.

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...