Search results for query: *

I am using the lookup function to place data into my main report. I have 9 additional datasets and everything is working fine. However when I added my 10 dataset I need to sort the data so that just the last date would show on the report. I wrote the query as SELECT [Task_Type]...

I have a Crystal Report that I am converting to SSRS. In a formula in Crystal Report it uses a not one of. See the example below: whileprintingrecords; numbervar sample; if {pr_proj_job_pay.a_job_class_code} <> "XXXX" and {pr_proj_job_pay.a_pay_type}in [10, 20, 30] then sample := 0 else if...

I am using a tablix. I get just the Fields!line1.Value. If the Fields!line1.Value is blank I see nothing. I did get this to work I made the iif statement as follows: =iif(Fields!db_bud_desc_line1.Value < "A",Fields!a_account_desc.Value,Fields!db_bud_desc_line1.Value)

I am new to SSRS and trying to write an IIF statement. My Crystal If Then statement is as follows:if {Field_line1} = "" then {Field_account_desc} else{Field_line1}. This works fine. In SSRS I wrote an IIF statement=iif(Fields!line1.Value = "",Fields!account_desc.Value,Fields!line1.Value)...