concatenate

Question

concatenate

sharonsql2013

SSCertifiable

Points: 5908
More actions
August 28, 2013 at 3:16 pm

#281738

I am trying to concatenate Prodyear and ProdMonth in SSRS (which are basically both integers in table)
So, when I execute it sums up year and month instead of concatenating.
Is there a expression i can use?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

geoff5 Hall of Fame Points: 3560 More actions · Answer 1

Your expression should use the & symbol instead of the + symbol, which is a SQL concatenation symbol but not for SSRS expressions.

sharonsql2013 SSCertifiable Points: 5908 More actions · Answer 2

Wow, That surely helped.

But my data should start from June,2013 going backword. ( Thats how the Query is written and executes in SMS).

In the matrix it starts with 012013

Any Idea how I could fix that?

geoff5 Hall of Fame Points: 3560 More actions · Answer 3

Even though the default option is to sort a grouping by the same expression as the grouping and the displayed value, that is not necessarily what you want, and it is definitely not what you want here.

For the group value and the displayed value, add a space to make it readable: = Fields!ProdMonth.Value & " " & Fields!ProdYear.Value

For the sort value, first sort by Fields.ProdYear.Value (descending) and then add a second sort by Fields!ProdMonth.Value (also descending).

Change the rule in the group properties of the column group.