![xyplorer color alternating row xyplorer color alternating row](http://cdn4syt.solveyourtech.netdna-cdn.com/wp-content/uploads/2012/06/format-alternating-row-colors-excel-2010-4.jpg)
But facing an issue after 11 rows the runningvalue is not getting incremented properly i.e. I find this post very useful and I am trying to implement something similar in matrix. Any idea why this may be occurring? Thanks! I have tried setting it to hidden and everything else I can think of but nothing works.
![xyplorer color alternating row xyplorer color alternating row](https://images.sftcdn.net/images/t_app-cover-l,f_auto/p/55ce7daa-9a9f-11e6-8c2a-00163ed833e7/4044904427/xyplorer-screenshot.jpg)
When I run my report in report builder everything looks exactly how I want it to, however, when I upload this into our production server that column shows up. I am running into an issue though, I have tried setting the width of my "Group1" column to 0 but by default it always goes back to. Thank you so much for posting this article, it is excellent and has been very helpful. This article helped me in very simpler and short way. I then set fill logic based on the value of the OddEven value for that row. I worked around the problem by building in even odd logic into the dataset using dense_rank and an over clause:ĬASE WHEN (dense_rank() OVER (ORDER BY abpm_project.abpm_accountidname,Ībpm_project.abpm_projectid, abpm_project.abpm_projectid)) % 2 = 0 THEN 'EVEN' ELSE 'ODD' END AS OddEven Your solution worked well for me on small reports, but on large datasets, I had some difficulty in that it really slowed the report down (especially after I added it to CRM. Thanks a lot for posting the entire explanation and screen shots I was looking to change the color on the rows alternating and with this hint I was able to do it. This time I was creating a report that contains several rows. Very helpful, I'm a MES engineer sometimes I need to run and create SQL queries to retreive data for end users with not experience on SQL. Howerver the column does not appear when the print function or save to (word, pdf, excel) is use. I only have a one problem : The group column created to alternate color background on a Matrix doesn't appeat on report preview in Visual Studio but it is displayed once the report is deployed on report server. Thanks a lot for this very nice tutorial. Thanks a lot.your tutorial worked for me too.very well explained.
![xyplorer color alternating row xyplorer color alternating row](https://proactivatonkeys.com/wp-content/uploads/2021/04/1-1.jpg)
Thanks for this tip! Particularly when it comes to Matrixes, doing alternating colours does my head in! Your tip was very helpful.