October 27, 2013 at 11:16 pm
i have a report in which it has one table with 9 columns
one of the cell in the table will highlight green in color when a condition is met.it's working fine on the SSRS side only related columns are highlighted in green but when report is exported to excel all the rows within in that cell after the green color cell are highlighted in green color, so the color green is repeating for all the cells
for example if in the report it has 10 rows, in ssrs 5 th row gets highlighted in green color based on condition met, but when exported to excel all the rows related to that cell begining with 5th row getting highlighted green in color. As in the excel also only 5th row should get highlighted.
could someone please help me with solutions.
October 28, 2013 at 1:36 am
Lucky9 (10/27/2013)
i have a report in which it has one table with 9 columnsone of the cell in the table will highlight green in color when a condition is met.it's working fine on the SSRS side only related columns are highlighted in green but when report is exported to excel all the rows within in that cell after the green color cell are highlighted in green color, so the color green is repeating for all the cells
for example if in the report it has 10 rows, in ssrs 5 th row gets highlighted in green color based on condition met, but when exported to excel all the rows related to that cell begining with 5th row getting highlighted green in color. As in the excel also only 5th row should get highlighted.
could someone please help me with solutions.
Can you attach a jpg of the report and excel showing the highlighting? From your description are you using a single table or matrix, or have you got a embedded table within a table?
Fitz
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply