jtrapat1
asked on
Immediate If Or CASE Statement to Concatenate values
I have a table on a report in SSRS and I need to format a field in a cell;
I have Eventnames and Rooms;
In my sql query on the back end (ms sql server), I select both fields as such:
ISNULL((R.[meeting room]),'') AS meetingroom,
E.[EventName] AS eventname,
But, Im thinking I should do the logic on the report gui instead;
If the eventname is NULL, ignore it;
And If the field is not null, concatenate the eventname at the end of the meetingroom, preferably in parentheses-
Valid values for my meetingroom are:
Mtg Rm 1
Mtg Rm 2
Valid values for EventName in my database field are: --
Plaza Summer Crafts
Farmers Market
NULL
So, an example of a valid value for the table would be: Mtg Rm 1 (Plaza Summer Crafts)
Thanks In Advance.
John
I have Eventnames and Rooms;
In my sql query on the back end (ms sql server), I select both fields as such:
ISNULL((R.[meeting room]),'') AS meetingroom,
E.[EventName] AS eventname,
But, Im thinking I should do the logic on the report gui instead;
If the eventname is NULL, ignore it;
And If the field is not null, concatenate the eventname at the end of the meetingroom, preferably in parentheses-
Valid values for my meetingroom are:
Mtg Rm 1
Mtg Rm 2
Valid values for EventName in my database field are: --
Plaza Summer Crafts
Farmers Market
NULL
So, an example of a valid value for the table would be: Mtg Rm 1 (Plaza Summer Crafts)
Thanks In Advance.
John
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You have to specify a line break in the expression:
="First Line" & vbCrLf & "Second Line"
="First Line" & vbCrLf & "Second Line"
ASKER
If you are still around, I have another related question-
I will open up a new post if I dont hear from you;
But, Is there any way, that I could force a line break on the cell in this table?
I would like to have this cell height increase, if need be, and if the other two columns increase, that is OK.
Thanks.
John