mercredi 20 juin 2012 12:46
I have a matrix developed like in the image. In the marked area I use this expression
and this expression for setting the color:
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,
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
Please have a look on th blog that might give you the answer to your question
- Modifié Syed Qazafi AnjumMicrosoft Community Contributor, Moderator vendredi 22 juin 2012 08:31
vendredi 22 juin 2012 11:04Modérateur
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.
- 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.
mercredi 27 juin 2012 09:52Modérateur
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.
- Marqué comme réponse Mike YinMicrosoft Contingent Staff, Moderator dimanche 1 juillet 2012 17:01