ssrs adding text fields

Question

Viewing 7 posts - 1 through 7 (of 7 total)

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Yes.

Do you want to do it as an expression in the report itself or as a calculated column in the dataset?

LSM-629223 SSC Enthusiast Points: 168 More actions · Answer 2

I was looking to do it as an expression in the report itself.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

You can concatenate like this:

Fields!FieldName.Value + ", " + Fields!FieldName2.Value

LSM-629223 SSC Enthusiast Points: 168 More actions · Answer 4

I need to be more specific. 🙂

EmpExp, Emp, and, MiscExp are all fields from the dataset.

textbox 1 = sum(EmpExp)/Count(emp)

textbox 2 = sum(MiscExp)

what I need is to have a 3rd textbox that will add textbox1 + textbox2

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

You can do it 2 ways. The first way is 1 I'm sure you have considered:

(sum(EmpExp)/Count(emp)) + sum(MiscExp)

Or you can use the ReportItems collection like this:

ReportItems!TextBox1.Value + ReportItems!TextBox2.Value

LSM-629223 SSC Enthusiast Points: 168 More actions · Answer 6

Thank you! the second solution is what I was looking for.