In your table you should insert a group, the group will probably be switched on the cost centre field.

Make sure you have a header or footer available on your group.

Put...

I think I would probably look at using...

You really can't change anything in the reports parameters area in the way you are looking for, I suppose the only way you will be able to do this is...

Not sure why you want to use the rownumber method in the Top N filtering, you shouldn't need to use this. Just set the filter to Top N and...

It sounds as though you are printing all of the fields seperately on the report, I would probably create a single address field that takes care of the blanks, for...

I would have thought you would need to decrypt within the stored procedure before returning the dataset to the report, what is the problem with doing it this way?

Hi

I think you should probably look at creating a stored procedure that is called from the .RDL using the necessary parameters that will allow you to manipulate the dataset. ...

I have no idea what the Azalea UPCTools are, so...

Hi

The way to do this is to go to the properties of the table, then go to the filters, and add a filter in with an operator called TopN.

Should be...

Hi There Mr or Mrs Desperate!

First, I wouldn't try to put the whole thing into a single table, you'll struggle to make this work the way you want to. ...

Not sure of your actual syntax, but summing a calculated value is very easy:

EG:

Calculated value = IIF(Field1.Value="Yes", 1, 0)

The Total of this would be =SUM(IIF(Field1.Value="Yes",1,0))

It's really as simple as that,...

Hello Rob

As far as I know there is no method available to create a "standard" conditional format based on a Cell value, because the concept of cell value just doesn't...

Have you tried using:

="Average Tube Weight: " &

format(avg(fields!Wt_Tube1.value + fields!Wt_Tube2.value + fields!Wt_Tube3.value + fields!Wt_Tube4.value), "#.##")

Regards,

Rich text formatting is not supported in SSRS 2005, you could try using an icon embedded as an image in the document and then use that to the left of...

If all you want to do is to suppress the negative then you can set the value to it's absolute value by the following expression:

=ABS(Fields!FieldName.Value)

This will convert any negative number...