To eliminate white space due to hidden columns :
1. in the grouping pane, click on thesmall black triangle and select "Advanced Mode" to show static members in the grouping pane
2. under the column groupings, you should now see a list of gray "(Static)" items. Select the item that represents the column that you want to conditionally hide. Once selected, the property grid window should show the tablix member properties for that static column. In those tablix member properties, make sure to set the Visibility.Hidden expression to the desired condition
By doing this, you will hide the entire static column tablix member and as a resultthe whitespace will disappear.
Friday, July 30, 2010
Rules To Better Business Intelligence
http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterBusinessIntelligence.aspx
How to display dataset Field value in Page Header of SSRS report?
Put the dataset feild value in any textbox inside the report body ,then in the report header textbox put the expression as
ReportItems!.Value ,where the textbox name should be the textbox you put in the report body having the dataset field value.
How to repeat group header on each new page on Tablix in SSRS 2008
In SSRS 2005, you go to Table properties and tick the "Repeat header rows on each page" option under Row Headers. This will do the trick; however, it does not necessarily work in SSRS 2008 especially if you have added grouping on to the tablix, which is very annoying.
In SSRS 2008, under Row Groups - Column Groups pane, click the pointed downward arrow at the corner right then select "Advanced Mode". For row grouping, under Row Groups, select "Static". In the properties for "Static", set the following:
- KeepTogether = True
- KeepWithGroup = After
- RepeatOnNewPage = True
Tablix headers not repeating in SSRS 2008
The "Repeat header rows on each page" tablix property does not work in SSRS 2008 but works on SSRS 2005. This is clearly a bug and very annoying.
To turn this functionality on:
there is a small down arrow (not the down arrow on the group bar). Clicking that arrow will allow you to view advanced properties. When you select advanced properties you will see your groups in orange bars and the static rows in gray.
Set the KeepWithGroup property in the following way:
- For a static row that is above a group, click After.
- For a static row that is below a group, click Before.
If the above does not work then check the number of static rows above the Details group. Make sure that there are EXACTLY same number of the static rows. This nomally happens when you happen to delete a row(s) or grouping from the tablix. If the number of static rows does not match, then re-create the tablix from scratch.
How do I label my bloger's posts?
The Basics
When you're writing a post, you'll have a space at the bottom of the form marked "Labels for this post." Enter whatever labels you like, separating them with commas. You can also click the "show all" link to display a list of labels you've used previously. Then just click on the labels to add them.
When you publish your post, the labels will be listed with it. Clicking any of the labels will take you to a page containing only posts with that label.
Advanced Use
You can easily change the formatting used here by editing your blog's layout. You can also add a list of all your labels in the sidebar of your blog, sorted alphabetically or by frequency of use.
Labels are handy if you blog about a lot of different subjects, since readers can then choose to view all of your posts on, say, dancing at once. Or politics, or knitting, or whatever you happen to be writing about. If you have a team blog, you could also give each member their own label, so you could easily read all the posts by any one of them. Feel free to come up with other creative new uses as well!Note: The following characters cannot be used in labels:
&<>@!,
Understanding Tablix Data Region Cells, Rows, and Columns
Understanding Tablix Data Region Cells, Rows, and Columns
http://msdn.microsoft.com/en-us/library/cc627578.aspxTo control how the rows and columns of a Tablix data region display data in a report, you must understand how to specify rows and columns for detail data, for group data, and for labels and totals. In many cases, you can use the default structures for a table, matrix, or list to display your data. For more information, see Adding a Table (Reporting Services) [ http://msdn.microsoft.com/en-us/library/ms159169.aspx ] , Adding a Matrix (Reporting Services) [ http://msdn.microsoft.com/en-us/library/ms157334.aspx ] , or Adding a List (Reporting Services) [ http://msdn.microsoft.com/en-us/library/ms159121.aspx ] .
A Tablix data region displays detail data on detail rows and detail columns and grouped data on group rows and group columns. When you add row groups and column groups to a Tablix data region, rows and columns on which to display the data are automatically added. You can manually add and remove rows and columns to customize a Tablix data region and control the way your data displays in the report.
To understand how to customize a Tablix data region, you should first understand how to interpret the visual cues you see when you select a Tablix data region on the design surface.
A Tablix data region displays detail data on detail rows and detail columns and grouped data on group rows and group columns. When you add row groups and column groups to a Tablix data region, rows and columns on which to display the data are automatically added. You can manually add and remove rows and columns to customize a Tablix data region and control the way your data displays in the report.
To understand how to customize a Tablix data region, you should first understand how to interpret the visual cues you see when you select a Tablix data region on the design surface.
Understanding Tablix Visual Cues Visual cues on a Tablix data region help you work with a Tablix data region to display the data you want.
Row and Column Handles
When you select a Tablix data region, the row and column handle graphics indicate the purpose of each row and column. Handles indicate rows and columns that are inside a group or outside a group. The following table shows a variety of handle displays.
| Icon | Description |
|---|---|
 | Only the details group on the row group hierarchy |
 | One outer group and the child details group |
 | One outer group, one inner group; no details group |
 | One outer group, one inner group, and the child details group |
 | One outer group with a footer row for totals and one inner group |
 | One outer group with a footer row for totals, one inner group with a footer row for totals, and one details row |
 | One outer group with a header for labels and a footer for totals, and an inner group; no details group |
Group Rows
Rows inside a group repeat once per unique group value and are typically used for aggregate summaries. Rows outside a group repeat once with respect to the group and are used for labels or subtotals. When you select a Tablix cell, row and column handles and brackets inside the Tablix data region show the groups to which a cell belongs. This figure displays the following visual cues:
- Row and column handles that indicate group associations.
- Highlighted group indicators that show the innermost group membership for a selected cell.
- Group indicators that show all group memberships for a selected cell.
Total Rows
After you add row and column groups, you can add a row to display totals for columns and a column to display totals for rows. The following figure shows a matrix with both row and column groups, and a total row and a total column.
Grouping Pane
The Grouping pane displays the row and column groups for the currently selected Tablix data region on the design surface. The following figure shows the Grouping pane for this Tablix data region.
The Row Groups pane shows the parent group Category and child group Subcat. The Column groups pane shows the parent group Geography and child group CountryRegion, and also the Year group, which is an adjacent group to the Geography group. When you select the Subcat group in the Row Groups pane, the group bar turns a darker shade of orange, and the corresponding row group member cell is selected on the design surface.
The Row Groups pane shows the parent group Category and child group Subcat. The Column groups pane shows the parent group Geography and child group CountryRegion, and also the Year group, which is an adjacent group to the Geography group. When you select the Subcat group in the Row Groups pane, the group bar turns a darker shade of orange, and the corresponding row group member cell is selected on the design surface. Displaying Data on Rows and Columns Rows and row groups and columns and column groups have identical relationships. The following discussion describes how to add rows to display detail and group data on rows in a Tablix data region, but the same principles apply to adding columns to display detail and grouped data.
For each row in a Tablix data region, a row is either inside or outside each row group. If the row is inside a row group, it repeats once for every unique value of the group, known as a group instance. If the row is outside a row group, it repeats only once in relation to that group. Rows outside all row groups are static and repeat only once for the data region. For example, a table header or footer row is a static row. Rows that repeat with at least one group are dynamic.
When you have nested groups, a row can be inside a parent group but outside a child group. The row repeats for every group value in the parent group, but displays only once in relation to the child group. To display labels or totals for a group, add a row outside the group. To display data that changes for every group instance, add a row inside the group.
When you have detail groups, each detail row is inside the detail group. The row repeats for every value in the dataset query result set.
For more information about group hierarchies, see Understanding Groups (Reporting Services) [ http://msdn.microsoft.com/en-us/library/bb677373.aspx ] .
The following figure shows a Tablix data region with nested row groups and a details group.
For a Tablix data region that displays detail data, the details group is the innermost child group. Rows that you add to a details group repeat once per row in the result set for the query for the dataset linked to this Tablix data region. The following figure shows the last page of the rendered report. In this figure, you can see the last detail rows and the subtotal row for the last order.
For each column in a Tablix data region, the same principles apply. For example, a column is either inside or outside each column group; to display totals, add a column outside the group.
To remove rows and columns associated to a group, you can delete the group. When you delete a group, you have the choice between deleting the group definition only or deleting the group and all its associated rows and columns. By deleting just the group, you preserve the row and column layout on the data region. When you delete the group and its related rows and columns, you are deleting all static rows and columns (including group headers and footers) and dynamic rows and columns (including group instances) that are associated with that group.
For step-by-step instructions about adding or deleting rows and columns, see How to: Insert or Delete a Row (Reporting Services) [ http://msdn.microsoft.com/en-us/library/ms155913.aspx ] and How to: Insert or Delete a Column (Reporting Services) [ http://msdn.microsoft.com/en-us/library/ms155996.aspx ] .
For each row in a Tablix data region, a row is either inside or outside each row group. If the row is inside a row group, it repeats once for every unique value of the group, known as a group instance. If the row is outside a row group, it repeats only once in relation to that group. Rows outside all row groups are static and repeat only once for the data region. For example, a table header or footer row is a static row. Rows that repeat with at least one group are dynamic.
When you have nested groups, a row can be inside a parent group but outside a child group. The row repeats for every group value in the parent group, but displays only once in relation to the child group. To display labels or totals for a group, add a row outside the group. To display data that changes for every group instance, add a row inside the group.
When you have detail groups, each detail row is inside the detail group. The row repeats for every value in the dataset query result set.
For more information about group hierarchies, see Understanding Groups (Reporting Services) [ http://msdn.microsoft.com/en-us/library/bb677373.aspx ] .
The following figure shows a Tablix data region with nested row groups and a details group.
For a Tablix data region that displays detail data, the details group is the innermost child group. Rows that you add to a details group repeat once per row in the result set for the query for the dataset linked to this Tablix data region. The following figure shows the last page of the rendered report. In this figure, you can see the last detail rows and the subtotal row for the last order.For each column in a Tablix data region, the same principles apply. For example, a column is either inside or outside each column group; to display totals, add a column outside the group. To remove rows and columns associated to a group, you can delete the group. When you delete a group, you have the choice between deleting the group definition only or deleting the group and all its associated rows and columns. By deleting just the group, you preserve the row and column layout on the data region. When you delete the group and its related rows and columns, you are deleting all static rows and columns (including group headers and footers) and dynamic rows and columns (including group instances) that are associated with that group.
For step-by-step instructions about adding or deleting rows and columns, see How to: Insert or Delete a Row (Reporting Services) [ http://msdn.microsoft.com/en-us/library/ms155913.aspx ] and How to: Insert or Delete a Column (Reporting Services) [ http://msdn.microsoft.com/en-us/library/ms155996.aspx ] .
Understanding Tablix Cells Tablix cells belong to one of four Tablix areas: the Tablix body, Tablix row or Tablix column group areas, or the Tablix corner. Although each cell can potentially display any value in the dataset, the default function for each cell is determined by its location. For detailed information about Tablix areas, see Understanding Tablix Data Region Areas [ http://msdn.microsoft.com/en-us/library/cc645966.aspx ] .
By default, cells in Tablix row and column group areas represent group members. Group members are organized into multiple tree structures in the report definition. The row group hierarchy expands horizontally. The column group hierarchy expands vertically. These cells are added automatically when you create a group, and display the unique values for a group at run time.
Cells in the Tablix corner are created when there are both row and column group areas. You can merge cells in this area to create a label or embed another report item.
Cells in the Tablix body area can display detail data when the cell is in a detail row or column and aggregated group data when the cell is in a group row or column. The scope for the data in a cell is the intersection of the innermost row group and innermost column group to which the cell belongs.
By default, cells in Tablix row and column group areas represent group members. Group members are organized into multiple tree structures in the report definition. The row group hierarchy expands horizontally. The column group hierarchy expands vertically. These cells are added automatically when you create a group, and display the unique values for a group at run time.
Cells in the Tablix corner are created when there are both row and column group areas. You can merge cells in this area to create a label or embed another report item.
Cells in the Tablix body area can display detail data when the cell is in a detail row or column and aggregated group data when the cell is in a group row or column. The scope for the data in a cell is the intersection of the innermost row group and innermost column group to which the cell belongs.
 Note |
|---|
| The actual data that is displayed for each cell is the evaluated expression for the report item that the cell contains, which is typically a text box. In a cell that belongs to a detail row or column, the expression defaults to the detail data (for example, [LineTotal]). In a cell that does not belong to a detail row or column, the expression defaults to an aggregate function (for example, Sum[LineTotal]). If an expression does not specify an aggregate function even though the cell belongs to a group row or column, the first value in the group is displayed. For more information about aggregates, see Calculating Totals and Other Aggregates (Reporting Services) [ http://msdn.microsoft.com/en-us/library/bb630415.aspx ] . |
Merging and Splitting Cells
Inside a Tablix area, you can merge multiple adjacent cells together. For example, you can create cells for labels that span multiple columns or rows.
In the Tablix corner area, cells can be combined in only one direction at a time: horizontally across columns or vertically down rows. To merge a block of cells, merge the cells horizontally first. After all cells have been merged into a single cell in each row, select adjacent cells (you can select all adjacent cells in a column) and merge them.
In the Tablix body area, cells can only be merged horizontally. Merging cells vertically is not supported.
For more information, see How to: Merge Cells in a Data Region (Reporting Services) [ http://msdn.microsoft.com/en-us/library/bb630416.aspx ] .
You can split a cell that was previously merged. You can split cells horizontally across columns or vertically down rows. To split a cell into a block of cells, split the cell horizontally first, and then split vertically as many times as necessary.
In the Tablix corner area, cells can be combined in only one direction at a time: horizontally across columns or vertically down rows. To merge a block of cells, merge the cells horizontally first. After all cells have been merged into a single cell in each row, select adjacent cells (you can select all adjacent cells in a column) and merge them.
In the Tablix body area, cells can only be merged horizontally. Merging cells vertically is not supported.
For more information, see How to: Merge Cells in a Data Region (Reporting Services) [ http://msdn.microsoft.com/en-us/library/bb630416.aspx ] .
You can split a cell that was previously merged. You can split cells horizontally across columns or vertically down rows. To split a cell into a block of cells, split the cell horizontally first, and then split vertically as many times as necessary.
See Also Other Resources
Working with Data Regions [ http://msdn.microsoft.com/en-us/library/ms156394.aspx ]
Working with Report Data [ http://msdn.microsoft.com/en-us/library/cc281181.aspx ]
Report Layout How-to Topics [ http://msdn.microsoft.com/en-us/library/cc281084.aspx ]
Report Designer F1 Help [ http://msdn.microsoft.com/en-us/library/ms186946.aspx ]
Subscribe to:
Posts (Atom)