Search results for query: *

Your assumptions on the number of sheets and the fields is correct. The crystal formula you gave would work if the special program sheet contained ALL the IDs from the mainsheet. What happens in the scenario you gave is that my entire data report is whittled down to the subset of members that...

I Need help desperately: Crystal Reports 9 on WinXP, using Excel worksheets at datasource. I have several excel worksheets imported as datasources and linked by a common ID field. Each spreadsheet contains a different subset of the larger spreadsheet. The main sheet contains an ID# and...

Thanks, synapsevampire for earlier response below. This did return a value, but not what I needed. I need to display the value in {CSL_STD_CALENDAR.STD_ACTIVE_ON_DAY} (which is Y or N) for the date (({CSL_STD_CALENDAR.CAL_DATE}=CDate (2004, 05, 01)) I cannot use select expert and just set the...

I am trying to use if..then to select dates with certain criteria... if ({CSL_STD_DEMO_SCHOOL.ENROLLMENT_DATE})<= Date (2003, 08, 20)then "2003, 08, 20" else if ({CSL_STD_DEMO_SCHOOL.ENROLLMENT_DATE})> Date (2003, 08, 20) then {CSL_STD_DEMO_SCHOOL.ENROLLMENT_DATE} The formula works for getting...

I have a text field, 255 char, free text input called {reasons}. I am trying to write a formula to query that field for multiple, possible text strings. For example, I will want to include all responses that include "fish", "culture" or "dance" What is the best way to have the report query that...