Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tech2
Yak Posting Veteran
51 Posts |
 Posted - 2014-02-06 : 19:15:55
|
| Hi,Below is a basic table with 3 item numbers, and a brief explanation on what I'm trying to accomplish.. The data has several locations but the same three item numbers.Location - item - Calculated value FL widget1 -1 FL widget2 3 FL widget3 0I have a tablix filter that filters the data to only show negative numbers. I'm trying to write an expression that 'IIF' the report displays one row for a specific location, in this case 'FL', then display the other rows for the same location.I've visited many help sites but I can only find IIF statements that return specific rows, which, I've done here. I also want to display related rows.Thanks in advanceSSRS 2008 R2 - Report Builder 3.0 |
|
|
|
|
|
IIF statement to include related rows