CODEWITHSUNDEEP
reporting-servicesssrs-2008
Alex Gordon
Alex Gordon

Reputation: 60751

how to associate two fields

I have a report that looks like this:

enter image description here

As you can see there's the yellow/orange bracket.

I believe that I need the bracket to cover both fields like this:

enter image description here

Because there's a 1:1 relationship between the two fields, and I want them to be displayed like this:

Field1
Field2
Field1
Field2

How can I associate them together like this?

Currently it's reporting this way:

Field1
Field1
Field1
Field2
Field2
Field2

Upvotes: 0

Views: 1485

Answers (2)

djangojazz
djangojazz

Reputation: 13242

I would do this potentially as it may be simpler than getting into something already happening wrong:

  1. Add a new details row
  2. verify both details row return data of one of each for each data line in a dataset
  3. Add a grouping and see if that works.

If that does not work, never tried this before sorry, then I would create a subreport that does the grouping and takes a parameter that is at the group level then next a subreport that accounts for two lines. I have done that before :)

Upvotes: 2

Registered User
Registered User

Reputation: 8395

Right click on the Details row. Insert Rows -> Inside Group - Above.

Upvotes: 2

Related Questions