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

Posted on 2014-08-27
Last Modified: 2014-09-13
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.
Question by:vbnetcoder
    LVL 1

    Accepted Solution

    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-

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Suggested Solutions

    Title # Comments Views Activity
    receive report server error 9 51
    SQL Reporting 8 72
    DTC in SQL Cluster 5 32
    SQL Server/SSRS 2008 r2 - Percentage Expression 6 47
    Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
    Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now