In 2008 R2, you can add page header & footer.

Select Report -> From Menu Bar Select Report - > There you can find Add Header / Add Footer.

Please go...

Just try below code. if necessary you can modify accordingly

=SWITCH

(

Parameters!region_id.Value=0 AND Fields!comp.Value*0.05>Fields!allcomp.Value,"Green"

Parameters!region_id.Value=1 AND Fields!comp.Value*0.05>Fields!mum_comp.Value,"Green"

Parameters!region_id.Value=2 AND Fields!comp.Value*0.05>Fields!rowcomp.Value,"Green"

Parameters!region_id.Value=3 AND Fields!comp.Value*0.05>Fields!southcomp.Value,"Green","Red"

)

Hope this will work with you

can you explain it more..

Hi,

The expression which is used to hide duplicate values, used that exp in Row visibility property.

= IIF([........Expression.....],True,False)

It's correct !!!!!!

Yes, the user will get the both role.

In your query u'll have these parameters

@ApplicationName = 'Informatica' or 'Velocity' or 'MSCloud' --manually added to parameter

@EnvironmentName = 'PROD' or 'UAT(ITSM = PROD)' --manually added to parameter

and for...

Check the attachment

you can chck the attachment

I think u r following some wrong process..

Below is an example

FIRSTNAMEBIRTHPLACEVALUE

ERIKLONDON0

ERIKLONDON3

HARRYEDINBURGH2

HARRYEDINBURGH5

1. Add a indicator in the table and go to indicator properties.

2. Simply Add the column name like Sum(Fields!Calls.Value).

3....

If you have 3 different report you can insert three different image.

Go to Toolbox--> Image --> import the image you want to use in the report.

Repeat this process...

Change the Measurement unit to "Numeric" in value and state and see the result.

You can use below expression in the background color property of BIRTHPLACE textbox.

=IIF(Fields!BIRTHPLACE.Value = "LONDON","Red","Blue")

I think it will help you.

You can use below expression:

="Today is: "& today &" Output: "& day(today)&" - "& WeekDayName(DatePart(DateInterval.Weekday,today),True,FirstDayOfWeek.System)

And output will look like this

Today is: 3/29/2013 Output: 29 - Fri

In Action properties which section will i choose and what is the expression i can use to achieve the above scenario?