I'm trying to write an expression in SSRS to allow for different fields to display based on the result set. This example is for the Title line, and obviously it would be adjusted for the row containing the data.
if SectionCategory is null and SectionType is null, then nothing;
if SectionCategory is null and SectionType is not null, then "Type"'
if SectionCategory is not null, then "Category"
Fields!SectionCategory.Value is nothing and Fields!SectionType.Value is nothing, nothing,
iif (Fields!SectionCategory.Value is nothing
and (IsNothing(Fields!SectionType.Value)="No"), "Type", nothing),
iif ((IsNothing(Fields!SectionCategory.Value)="No"), "Category", nothing)
Is it possible to nest IIF statements in a Switch statement? I've experimented several different ways and I'm getting "#Error" in Preview.
"Drats! Foiled again!"