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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 510
  • Last Modified:

Adjacent row group - the second row group is only showing on row

i am creating a report where the first group is working properly but the adjacent group (by country) is only showing on detail record per group.  See the attachment.
rptEmployees.png
0
vbnetcoder
Asked:
vbnetcoder
1 Solution
 
JA ReynoldsCommented:
Sounds like maybe your layout setup is not correct?
Here is an article on layout of SQL reports that might help you.... By Stacia Misner

'In SQL Server Reporting Services (SSRS), there are several controls (also known as data regions) that you can use to lay out your data in a report. You can choose one of the data visualization options, such as a chart, gauge, or map, or you can choose to present the data in a table, matrix, or list. Beginning in SQL Server 2008, the latter three data regions were consolidated into a single type of report item called a tablix. The Toolbox window still lets you choose a table, matrix, or list for your report, but if you look at the Report Definition Language (RDL) that gets generated for these data regions, you'll see that they each get defined as a tablix.

The tablix gets its name by combining "table" with "matrix." As you'll see later, the tablix can behave like either of these data regions. When you add one of them to your report, the properties governing the behavior of the rows and columns are predefined to make it easier for you to lay out the report quickly. For example, if you start with a table data region, the layout of the tablix has a fixed number of columns, but you can easily change it to include dynamic columns rather than start over with a separate data region.

I'll take you on a tour of the tablix so that you can better understand how it works. With that knowledge, you can take advantage of the tablix as you structure the data in your reports."

Here is the link to review your data setup-

http://sqlmag.com/sql-server-reporting-services/touring-tablix-sql-server-reporting-services
0
 
vbnetcoderAuthor Commented:
ty
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now