Hi,

As per my knowledge i will create a summary and detailed reports (drill through),

summary report with project, count(orders) and quantity. and detailed report with project, order and other details...

Create a parameter with boolean datatype, you will get 2 radio buttons true and false.

then in table visibility property write a below expression

=iif(Parameters!sample.Value=true,true,false)

=IIF(Enddate.value> Startdate.value,swith(............),IIF(Endate.value=Startdate.value,newexpression))

use nested iif conditions like below

IIF(Job_Type.value="install" and completion.value<72,"red",iif(Job_Type.value="service" and completion.value<100,"red"),"green")

Hi

As per my understand we can't use straight line under table, if you want line under text use TextDecoration=Underline, or if you want straight line to divide subtotals or...

try below expression

=IIF(instr(Fields!Line.Value, "Avg")," %" & CSTR(MTD.value),MTD.value)

use below expression in Avg column

="%" & cstr(Avg.Value)

=IIF(Reportname.Fieldname="yes",reportname.Amount1,reportname.amount2)