Hi Everyone,
I am using a predefined dataset which contains staff names and roles. What i want to achieve is to display only names with respect to a role in a column. So example Team Leader need to appear in one column and the rest should appear in another column next to it. ( Same Tablix ).
I modified 2 separate tablix and placed it side by side. Filter was used to retrieve names based on the Roles. The issue i get is that if on column contains more than one name, the size of the row will grow, but the row next to it stays the same. I would like them to render with the same row size, that is a possibility to join the two separate tablix columns in one row.
The other option to try is to create one tablix and use conditional expression to display data based on the roles. But this is tricky and it does not work. My code below:
=IFF(First(Fields!StaffRole.Value, "AuditReportStaff")="Team Leader",First(Fields!StaffName.Value, "AuditReportStaff"))
Any idea as to why this code does not work or is giving error. ( "The Value expression for the textrun ‘StaffName.Paragraphs[0].TextRuns[0]’ contains an error: [BC30451] 'IFF' is not declared.)"
What do you suggest ?
appreciate your help on the above.
Thanks & Regards



