Click here to Skip to main content
15,885,546 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I having a matrix ssrs table which looks like this

Exceptions 3/10/2021 3/10/2022 3/9/2022 3/8/2022 3/7/2022 3/4/2022 3/3/2022 3/2/2022 3/1/2022 2/28/2022 2/25/2022
ACCOUNT NOT EFFECTIVE FOR FILING PERIOD. 0 24 24 24 24 24 24 24 24 24 24
ACCOUNT NOT YET STARTED 6 208 208 208 208 208 208 208 208 208 208
ACTIVE TRANS IN PAST ACCOUNT CLOSE DATE 0 11 11 11 11 11 11 11 11 11 11
ADDITIONAL DOCUMENTATION - REVIEW REQ 0 0 0 0 0 0 0 0 0 0 0
ADDRESS ASYNCH FAILED 2 42 42 42 42 42 42 42 42 42 42
ALC ACCOUNT DOES NOT EXIST 0 24 24 24 24 24 24 24 24 24 24

I wanted to check the count increased from yesterday date to todays date >10 or <10 if > 10 % then fil the rows with green else red

please help me out I tried all other ways but nothing worked.

What I have tried:

I tried to use dynamic query but it gives dynamic column so not able to pass the colour logic and now I using union to my data then in ssrs I tried running function but not able to find the exact solution.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900