September 29, 2015 at 3:24 pm
I have a little bit of an unusual situation for one of my reports. I only want to display rows for the several accounts (170, 171, 200, 380) if the Cost Center is 480 or 485. All other accounts should be displayed for all cost centers. If one of the above accounts should appear on any other cost center, then it should NOT be displayed in the report. I’m thinking I may need an expression like “='480' or '485' for the Value field (using IN) but I’m not sure what the Expression field should be. Thanks for the help.........
September 30, 2015 at 12:45 am
Might just be me, but I'm not entirely sure I'm following. Could you please post some sample data and the expected solution? Are you allowed to write stored procedures for this, or are you locked into doing it all inside SSRS?
I think you can use calculated fields for some of this, but I'm not entirely sure yet.
September 30, 2015 at 8:21 am
Thanks for the reply. I have to do all of this within SSRS. I'll try to explain in some more detail. My report returns data for a number of accounts for a number of cost centers.
Account Numbers: 123 / 125 / 130 / 140 / 145 / 170 / 171 / 200 / 380
What I would like the report to do is only display accounts 170 / 171 / 200 / 380 for Cost Centers 480 and 485
For example:
Cost Center 400: 123 / 125 / 130 / 140 / 145
Cost Center 440: 123 / 125 / 130 / 140 / 145
Cost Center 480: 123 / 125 / 130 / 140 / 145 / 170 / 171 / 200 / 380
Cost Center 485: 123 / 125 / 130 / 140 / 145 / 170 / 171 / 200 / 380
Cost Center 500: 123 / 125 / 130 / 140 / 145
Accounts 170 / 171 / 200 / 380 should only be displayed if the Cost Center is 480 or 485. The report is run by Cost Center. Some of the other Cost Centers will have results for accounts 170 / 171 / 200 / 380 but the user doesn't want to see these accounts in the any Cost Center other than 480 or 485.
Thanks for taking a look at this.....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply