How about this:

=IIf((ReportItems!qty_complete.Value + ReportItems!qty_scrapped.Value) <> 0, (ReportItems!qty_complete.Value/(ReportItems!qty_complete.Value + ReportItems!qty_scrapped.Value)), 0)

You cannot connect to the data source, probably need to adjust the authentication/credentials that are used for the connection.

I use 2012 so I don't know if this works in 2008. Go to the properties of the tables and set the PageName property to what you want the...

I haven't done exactly what you are doing but here is a possible solution.

Change the Groups area at the bottom of the screen to 'Advanced Mode' - there...

Make sure you set the color value in the else part. Here is code I use to set the background color for a row:

=IIf(Parameters!Program.Value = "ALL",

Switch(Fields!CurrentClub.Value = 1, "DarkGray"...

If I understand correctly what you want, you can have an expression for the image in the Image Properties. Something like below based on a parameter:

=IIf(Parameters!Database.Value = "CCDApp", "/CDMS/Images/CCD_Annual_TB_Screening_Questionnaire.png",...