I'm trying to write a report with multiple sort options. It is telling me that the default: "" needs to be a date field. If I put a date field then it tells me the last three lines need to be a number. What is the proper fix?
//Output 1st sorting criteria
if count({?Sort Conditions})>=1 then
(
select {?Sort Conditions}[1]
case "Job": {MASTER_JCM_JOB.Job}
case "State": {MASTER_JCM_JOB.State}
case "PM": {MASTER_JCM_JOB.Project_Manager}
case "Super": {MASTER_JCM_JOB.Superintendent}
case "Contract Amount": {MASTER_JCM_JOB.Revised_Contract_Amount}
case "Size": {MASTER_JCM_JOB.Size}
case "Start Date": {MASTER_JCM_JOB.Actual_Start_Date}
case "Complete Date": {MASTER_JCM_JOB.Actual_Complete_Date}
default:""
)
Thanks!
//Output 1st sorting criteria
if count({?Sort Conditions})>=1 then
(
select {?Sort Conditions}[1]
case "Job": {MASTER_JCM_JOB.Job}
case "State": {MASTER_JCM_JOB.State}
case "PM": {MASTER_JCM_JOB.Project_Manager}
case "Super": {MASTER_JCM_JOB.Superintendent}
case "Contract Amount": {MASTER_JCM_JOB.Revised_Contract_Amount}
case "Size": {MASTER_JCM_JOB.Size}
case "Start Date": {MASTER_JCM_JOB.Actual_Start_Date}
case "Complete Date": {MASTER_JCM_JOB.Actual_Complete_Date}
default:""
)
Thanks!