Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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