Search results for query: *

yes---it was entered incorrectly by the user --it is a freee text field. I would like to eliminate these ridiculous dates before executing the rest of the SQL expression

I am converting a string to a date field in an SQL expression and get the error 'failed to retrieve data from database - not a valid date'. The date entered was 10/50/2011. How can I determine if a string date is valid before I execute the rest of the SQL expression?

There is a dynamic parameter (numeric type) that is for locations--multi reponse. How can I convert those values to the name of the locations and display them in the report header? So, parmeter values are 13000, 14000, 14288. I want displayed on the report: Locations: Hospital A, Hospital B...

Yes--it is an "Allow muliple values" parameter. User can enter 1 or up to 10 values. Using CR 10 --soon switching to CR XI. So, subreport best way to go? Create a stringvar "names" and put that in the details of the subreport? Put subreport in Header?

My reports have a parameter for location that is based on the location ID (Number). I would like to display the location names (string)in the report header. So, if user picks loc_ID 14 and 13 then the report header will list Location Names "Main Hospital, West Hospital". Is there an 'easy' way...

Current turnaround time forumla is below. I want to exclude Saturday and Sunday from the equation. Suggestions? Thanks. I've looked at the DayOfWeek function, but not sure how to apply it. (DateTimeValue ({Report.date_signed_out},{Report.time_signed_out}) -DateTimeValue...