Group fields with one above the other in separate rows.

Hi,
I am not really follow your scenario.
Do you insert the record at somewhere else? Have you try to refresh your report after insert a record?

It's really just a display issue.  Right now the data looks like this...
County 1  Name1   Addr1   City1
                Name2  Addr2    City2
County 2  Name3  Addr3   City3
I tell the county field not to repeat and each record shows on one line.
But I want the county to show on the line above like this...
County 1
   Name1   Addr1   City1
   Name2  Addr2    City2
County 2
   Name3  Addr3   City3
In access it would be 4 fields so you stagger them how you want. I'm new to Reporting Services and putting the fields into the table seems to limiit how they are displayed.  Maybe I shouldn't be using a table?  If so I don't know what I should use instead.

Oh I see what you meant now, you need to use grouping.
So on the header row, you only want to display County
On Details row, is where you want Name1 Addr1 ...

That is correct.  But whenever I try to insert another line it just increases the size of the row and doesn't let me put a field underneath.  When I do finally get a separte line inserted my grouping is all messed up and it doesn't display correctly.

Select table, right click Properties
click Groups tab
click Add
in the Group on , set to County
when this done, you should have a Header row and Group column row and Details row
See my screenshot for the result


ss.png

Maybe what I'm asking for isn't possible because what you  have is close but now I want to move the Name field underneath county in order to save space on the report.  So I used a photo program to alter your picture to show how I want it.  I don't need a header for County so I move Name and Address left and move Name field underneath the County field.
FormDisplay.jpg

Yes you can do that, I don't see it would cause error

So I should be able to move
     =Fields!Name.Value
1/2 way underneath =Fields!County.Value?
Because when try to adjust the "name" columns left it just makes the County field smaller.  It's not displaying all the way accross the name field.  Does that make sense?

Aww!  I think that will work!  Thank you so much!

Thanks again!