Forum Discussion

ResearchDev's avatar
ResearchDev
Icon for Helper II rankHelper II
4 years ago
Solved

How to do this equivalent in Report Builder (code is in Crystal)

In Report builder how do I do something like this below if it is a parameter in Crystal? I setup the parameter in Reportbuilder and then Available values I specify values . In crystal the parameter has 4 different sort selections. Each case statement is the sort selection. It is one big SQL but based on what sort selection, the data comes out sorted in the specified way

Select {?Sort Options}
case 'DEFAULT' : {Late_Activities.RESP_RESOURCE}&{Late_Activities.COUNTY_NAME}&{Late_Activities.PIN}&{Late_Activities.ACTIVITY_ID}
case 'CNTY' : {Late_Activities.COUNTY_NAME}&{Late_Activities.PIN}&{Late_Activities.ACTIVITY_ID}
case 'PROJMGR' : {Late_Activities.PROJ_MGR_ID}&{Late_Activities.SCHED_MGR_ID}&{Late_Activities.RESP_RESOURCE}&{Late_Activities.PIN}&{Late_Activities.ACTIVITY_ID}
case 'ACT' : {Late_Activities.ACTIVITY_ID}&{Late_Activities.PIN}
case 'SCHEDS' : {Late_Activities.SS}&{Late_Activities.PIN}&{Late_Activities.ACTIVITY_ID}