=Count(Fields!Attachment.Value)

2 in the count

How can I configure the field to display.

1, 2

Instead of 2.

If the output is 32, do you want 1,2,3,4....?

Hi,

Good question, 

I have the following matrix;

The field is the count of attachments grouped on the name,  moving forward can a numerical count across the column so it will look like 

These will then be bookmarked! Thanks for the help... As I think Can the column be counted as it goes down and through the Name's in this Matrix ?? 

Thanks, Richard

• Edited by Richard I Evans 21 hours 37 minutes ago

Hi Richard, 

According to your description, we are not clear about your requirement. 

In Reporting Services, Count() function returns a count of the values from the specified expression. In your scenario, if you want to return the required result (like 1,2,3), you need to use report code. For you requirement, please add the following VBA code to the report. 

Function fun(x)
    Dim k As Byte
    k = InStr("9876543210", x)
    fun = Mid("9,8,7,6,5,4,3,2,1", k+k-1 , x+x)
End Function

You can pass a value to the function, and then it will return the required result. Please use the expression below to call the function: 

=Code.fun(Count(Fields!Attachment.Value))

If you have any other question, please feel free to ask. 

Regards,
Shrek Li