[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Group fields with one above the other in separate rows.

Posted on 2011-10-26
11
Medium Priority
?
220 Views
Last Modified: 2012-05-12
I'm creating a report in Visual Studio using Report Services.  I'm using a table and in order to save real estate on the form I want to stack my grouped fields like this.  

County 1
   Name1   Addr1   City1
   Name2  Addr2    City2
County 2
   Name3  Addr3   City3

When I insert a new row to add County my grouping messes up.  Can you explain how to do this?
0
Comment
Question by:BobRosas
  • 6
  • 5
11 Comments
 
LVL 1

Expert Comment

by:TJCombos
ID: 37077069
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?
0
 

Author Comment

by:BobRosas
ID: 37077179
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.
0
 
LVL 1

Expert Comment

by:TJCombos
ID: 37077366
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 ...
0
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

 

Author Comment

by:BobRosas
ID: 37077587
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.
0
 
LVL 1

Expert Comment

by:TJCombos
ID: 37077741
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
0
 

Author Comment

by:BobRosas
ID: 37077809
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
0
 
LVL 1

Expert Comment

by:TJCombos
ID: 37078004
Yes you can do that, I don't see it would cause error
0
 

Author Comment

by:BobRosas
ID: 37078421
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?
0
 
LVL 1

Accepted Solution

by:
TJCombos earned 500 total points
ID: 37078463
Or you can do like this at Details Name row
="  " &Fields!Name.Value
ss.png
0
 

Author Comment

by:BobRosas
ID: 37078496
Aww!  I think that will work!  Thank you so much!
0
 

Author Closing Comment

by:BobRosas
ID: 37078505
Thanks again!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month19 days, 7 hours left to enroll

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question