problem with conditional formatting in matrix
-
mercredi 20 juin 2012 12:46
I have a matrix developed like in the image. In the marked area I use this expression
=iif(InScope("matrix1_RowGroup2"),"inscope", "outscope")
and this expression for setting the color:
=iif(InScope("matrix1_RowGroup2"),"blue", "red")
The result is this:
Can anyone explain me why the "outscopes" are not colored red? I dried several things but I cannot figure this out.
May thanks for your help,
Kristof
Toutes les réponses
-
vendredi 22 juin 2012 08:24anybody got an idea? Is it because it is in a static group or something? I still don't have a clue.
-
vendredi 22 juin 2012 08:30Modérateur
Hi There
Please have a look on th blog that might give you the answer to your question
many thanks
Syed
- Modifié Syed Qazafi AnjumMicrosoft Community Contributor, Moderator vendredi 22 juin 2012 08:31
-
vendredi 22 juin 2012 11:04Modérateur
Hi Kristof,
Based on the current information, your expression set for Color property should work. At this time, let’s try a different way. Let’s assume the textbox that contains the "=iif(InScope("matrix1_RowGroup2"),"inscope", "outscope")" expression is textbox10. Then, you can modify the Color expression as follows:
=IIF(ReportItems!textbox10.Value=”Inscope”, “Blue”, “Red”)The two blogs Syed provided above are helpful; you can have a look at them. If the issue persists, could you elaborate the issue? If possible, you can upload a sample project file to https://skydrive.live.com for further analysis.
Regards,
Mike Yin- Modifié Mike YinMicrosoft Contingent Staff, Moderator vendredi 22 juin 2012 11:04
-
vendredi 22 juin 2012 12:24
@Syed : Thank you for the links, but they are just explaining the logic behind the Inscope function, which I am familiar with.
@Mike : Thanks for the tip Mike, I tried this out without any result. I also tried to use me.Value also which is valid syntax. I shall elaborate the issue and upload a sample to https://skydrive.live.com as soon as I find some free time.
Regards,
Kristof
-
mercredi 27 juin 2012 09:52Modérateur
Hi Kristof,
Thanks for your posting during your busy schedule.
Sometimes, the IIF() function may not work as expected when being used in color expressions. At this time, I suggest that you try the expression below:
=IIF(ReportItems!textbox10.Value=”Inscope”, “Blue”, ReportItems!textbox10.Value=”Outscope”, “Red”)
Hope this helps.
Regards,
Mike Yin- Marqué comme réponse Mike YinMicrosoft Contingent Staff, Moderator dimanche 1 juillet 2012 17:01
.png)
