I am working on converting some Crystal Reports over to use Telerik Reporting, and I am stuck on writing a filter for my data. Basically, I have a parameter FacID that is able to be blank, and I will filter the data differently depending on that value. In addition to that, there is also filtering dependent on the value of another parameter ActiveOnly.
Here is what it looked like in Crystal:
IF {?FacID} = "" THEN (
IF {?LabelType} = "M" THEN (
{FacilityCustomFields.CFID} = 14 AND
({FacilityCustomFields.CFValue} = "Y" OR
{FacilityCustomFields.CFValue} = "CYCLE") AND
{FacilityCustomFields_1.CFID} = 13 AND
IF {?ActiveOnly} THEN
{Facilities.FacStatus} = "A"
ELSE TRUE
) ELSE IF {?LabelType} = "X" THEN (
{FacilityCustomFields.CFID} = 14 AND
{FacilityCustomFields_1.CFID} = 13 AND
IF {?ActiveOnly} THEN
{Facilities.FacStatus} = "A"
ELSE TRUE
)
) ELSE
IF {?LabelType} = "C" AND {?CycleGroup} <> "" THEN (
{FacilityCustomFields.CFID} = 28 AND
({FacilityCustomFields.CFValue}[1] = "Y" OR
{FacilityCustomFields.CFValue} = "PAPER") AND
{FacilityCustomFields_1.CFID} = 13 AND
{FacilityCustomFields_1.CFValue} = {?CycleGroup} AND
IF {?ActiveOnly} THEN
{Facilities.FacStatus} = "A"
ELSE TRUE
) ELSE (
{FacilityCustomFields.FacID} = {?FacID} AND
{FacilityCustomFields.CFID} = 14 AND
{FacilityCustomFields_1.CFID} = 13 AND
IF {?ActiveOnly} THEN
{Facilities.FacStatus} = "A"
ELSE TRUE
)