.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Tablix Grouping Layout

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :Sql Server


I'm failry new to reporting services so sorry if this seems like such a trivial questions. I'm working with reporting services 2008.

I have the following data:

Group A   Item 1

Group A   Item 2

Group B   Item 3

Group B   Item 4

Group B   Item 5 

And I would like to display the data as follows:

Group A

Item 1

Item 2

--------------------------- Page Break ----------------------------

Group B

Item 3

Item 4

Item 5 

Is there any way to achieve this? I know I can do this with subreports but there has to be an easier way to do this.

Thank you for your help,


View Complete Post

More Related Resource Links

Report with Static Layout (Restrict Rectangle Growth/Static Tablix size)

How do you stop a Tablix or the rectangle that is a Tablix is contained in from growing.  I have been designing a report that must have a very specific layout due to government and commericial policies.  In this report is a header on top, a footer, some other reporting data above and below a rectangle that contains a tablix region.  I need this tablix and/or rectange to stay a constant size, if there are more rows, it should start another page in the report.  Instead, it grows and pushes all the datafields below it, down and off the page.    I have also tried this with a frame.  The table must show within the frame on form only.  The frame can contain maximum of 10 rows, but the table will grow outside the frame and the items below are pushed down and off the page.  I cannot see how I can setup a page break on every 10th row on a table. Does anyone know how setup a constant size Tablix/Table in a rectangle or frame so that it will not grow beyond the specified size (so the data fields below it will not be moved) and will instead create a new page?  This is crucial to our application and we may have to switch reporting solutions if we can get this figured out. Thanks for you help!  

Playing with Linq grouping: GroupByMany?

One of its features is grouping. Many people understand grouping like it is defined in Sql. Linq is implementing grouping quite the same way. Let's discover this syntax and how to make consecutive groups easier.

Grouping Gridview with jquery

The requirement of the project is to show a table of data with the riskdetails(just for assumption) which have the corresponing values for every month and people used to compare the values for last months.

Building a grouping Grid with GridView and ASP.NET AJAX toolkit CollapsiblePanel

I've posted an update to this post to apply on demand loading of Details data using ASP.NET AJAX PageMethods. I'm demonstrating the usage if CollapsiblePanelExtender client events on the new post. Check it out.

I admit, Matt Berseth is really inspiring me! Few days ago I pass through 2 of his great posts:

.Surrounding your Data Table and Dialog Controls with ComponentArt Styled Panels
.Building a Grouping Grid with the ASP.NET 3.5 LinqDataSource and ListView Controls
The first one is pure design tips one which I used for making good presentation of my demo here. The 2nd post is actually the idea.

Grouping Gridview with jquery in asp.net

The requirement of the project is to show a table of data with the riskdetails(just for assumption) which have the corresponing values for every month and people used to compare the values for last months.

Panels messing up page layout



On a few different pages in my web app I have a scrollable panel that contains a gridview. When there is nothing in the panel display as I want it to, however when the grid view is populated with data it stretches the panel across the page which looks awful, it means the panel is partially stretched across the window but is still scrollable

Anyone know why this might be happening?



Change grid view from table to other HTML layout



You'll have to excuse my ignorance, I'm coming at this from a front-end perspective, and don't really know how to deal with data views in ASP.NET.

Basically, I'm trying to change the layout of some repeated data from a straight table, to something more design-heavy.  It's the same data, just re-organised slightly.  The current ASP.NET code looks like this:

                    <asp:GridView ID="GVMoments" runat="server" AllowPaging="True" AllowSorting="True"
                        AutoGenerateColumns="False" PageSize="20" RowHeaderColumn="FirstName"
                        SkinID="GroupSkin" DataKeyNames="moment_id" 
                        <PagerSettings Mode="NumericFirstLast" PageButtonCount="20" Position="TopAndBottom" />
                        <RowStyle />
                                <asp:BoundField DataField="moment_id" HeaderText="moment_id" ReadOnly="True" SortExpression="moment_id"
                                    Visible="False" In

Crystal Reports can grow fields with large amounts of text layout problem


A can grow field in the details section of a crystal report may have so much text that the section will be larger than the remaining space available on the page (the space below the previous record).  The section has vertical lines on it with Extend to bottom of section when printing set to true.  The section starts on a new page (and may continue on the following one).  I want it to start on the page where the last record was laid out, and continue to the new page without leaving a gap with vertical lines on it.  I'm using Crystal Reports 9 and I can't work out how to do it. Has anyone got a solution?

Page layout list not displaying in page settings



I have 4 different custom page layouts in my publishing site at the site collection level. I have one site named "Services" in site collection. When i create page, i select one page layout from above 4. But when i go to the page settings of that page to change the page layout of it, i can see only one page layout which this page based on.

Problem is why all the page layouts not listing there? I checked "Page layout and site templates" settings from look and feel of Site Settings, this r set to "Pages in this site can use any layout".

Please help..!

Thanks in advance.


Sandip Patil

Sharepoint Developer


Content deployment: pages not based on a page layout

Is it possible to use content deplyoment feature when pages (in page library) are not based on a Page Layout?

Variation label in a page layout and Translated Columns



Can any body elaborate on this two terms in publishing sites.

1: Variation label in a page layout

     When i edit the page layout from browser interface of publishing site with variation, there is one field called "Variation" where user

     have to select the variation label from a list.

2: Translated Columns

     Don't know what is this, i try to google a lot but not found any information.


Thanks in advance

Regards Sandip Patil Sharepoint Developer http://www.worldofsharepoint.com

SharePoint 2007 - Consolidating everything as feature into WSP [Content Type, Page Layout, Pages, Ma


Hello –


Overview – We are building a Mobile Web Site using SharePoint 2007. The big screen site has been already built and we need to integrate the mobile site into same site collection of big screen –


·         The Mobile site will use the existing content types of existing big screen site

·         We will build a new custom Master page

grouping summary data gridview


how can I gruping summary data in gridview like that; Thanks for helping


Car                   Rate 1               Rate 2            Rate 3  

 BMV                 5                          7                       9

                         4                          6                      7


Tablix Header missing on last page of PDF output

Tablix Headers don't show on last page of PDF and TIFF output.   I've tried all things mentioned including installing SQL Server 2008 Cumulative Update# 7.   My issue is that I have a Tablix with some header rows that repeat fine until the last page.   On the last page they are hidden.  This appears to be true of PDF and TIFF output.  THere are other issues with Word output.   The standard HTML viewer works fine.   So its clearly a PDF renderer issue.  

Suppress Blank Rows in Grouping on SRS

I have a Table on a SRS report.  Within that Table I have a Group. I display Rows from the DataSet in the Group Header.  In the Detail Line of the Group, I display rows if a condition is true.  That condition is in the Filter Criteria (Fields!GroupID.Value > 0).  If the GroupID equals 0, I want to suppress the detail line.  If GroupID is greater than 0, I want to show it.  This works great in development mode within Visual Studio 2005. I deploy to SRS on our Test Server and run the report. All of the detail rows are displayed even the ones where GroupID = 0. I am using the same Data Source.  The only difference is running the report within Visual Studio and the SRS web site. Does anyone have a suggestion.  

VS2008 BIDS Report export to Excel not grouping the same as VS2005

I have a report that I created in VS2005 BIDS and got it to export to Excel to group/subtotal the same way it does in the BIDS report window.  Now I have copied the .rdl files to a VS2008 project, open it in VS2008 BIDS, made NO changes to the report format and the exported Excel file is combining what should be the 2nd and 3rd groups into 1 group.  In the BIDS window, the grouping is working correctly.  Does anyone have any ideas what has changed between 2005 & 2008 that may cause this problem?  Thanks in advance.    
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend