Forum Discussion
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}
Hi ResearchDev ,
Try converting the above command to DAX?
SSRS Report Builder with DAX Query Support (mssqltips.com)
Best regards,
1 Reply
- Hei_aQing
Helper I
Hi ResearchDev ,
Try converting the above command to DAX?
SSRS Report Builder with DAX Query Support (mssqltips.com)
Best regards,