Thanks for all the feedback

OK. Thanks!! Could you show me how to convert my code to use the switch function?

The code expression is below:

=iif((Fields!PERIODID.Value=1) and (Fields!Year1.Value = Parameters!Year.Value),(sum(Fields!Cost_Code_Actual_Cost.Value,"Cost_Element_Group")),"0")

Hi Thanks for the feedback. Reporting services doesn't support the CASE statement from my understanding. Is that your understanding?

SQL Server 2005 Reporting Services "Essential Skills for Database Professionals" by Brian Larson.

Hi. Thanks.

That worked perfectly!!!

@Year is the Year Parameter value.

Thanks!! It worked. The only thing is that it returned to me the same amount of rows as before the group by clause. Is that the way it should be?

Thanks very much fpr the advice. I will try some more and see how it goes.

Hey there,

Thanks very much for your help. It all works now!!

Hey there,

Thanks very much for your help. It all works now!!

Hi There,

I have finally worked it out. A big thanks to you for all of your help.

Now I just need to test it to make sure that the data it...

Hi there. I am getting a little confused. Here is my latest version:

SELECT

CAST(timesheet.ProjectId as varchar(17)) as Job_ID_Timesheet,

timesheet.TaskCode as Cost_Code_Timesheet,

timesheet.Name as Cost_Code_Description_Timesheet,

cast(null as varchar) as Job_ID_TRAF,

cast(null as varchar) as Cost_Code_TRAF,

cast(null as...

Hi there. Thanks for your help.

I just tried that and then get this error:

Msg 102, Level 15, State 1, Line 61

Incorrect syntax near 'Latin1_General_CI_AS'.

Line 61 is the last row of...

Thanks very much for your help.

I was just wondering is the following also acceptable in both the color and value properties:

=IIf(Fields!DocNumbr.Value = Nothing,"Red","Black")

Hi there again. I have been fixing up the code and I am still getting errors. The latest error is:

Msg 205, Level 16, State 1, Line 3

All queries combined using...