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

[ResearchDev]

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}

[Hei_aQing · Accepted solution]

Hi @ResearchDev ，

Try converting the above command to DAX?

SSRS Report Builder with DAX Query Support (mssqltips.com)

Best regards，