Stack Overflow
Stack Overflow

Questions tagged [ssrs-tablix]

A SQL Server Reporting Services (SSRS) Tablix Data Region is a control to create lists, tables, and matrices.

The tablix data region is a generalized layout report control that displays report data in cells that are organized into rows and columns. It is the underlying structure for lists, tables, and matrices.

References:

1388 questions
5
votes
2 answers

Interactive sorting In SSRS on Values - Matrix report

I want a interactive sorting in SSRS matrix report. From database we are getting 3 columns -PrimaryKey,Columns and Value. We are grouping rows by Primary Key and grouping column by Columns and use Value as data. My Matrix Report - ID …
Wumar
  • 103
  • 1
  • 1
  • 11
5
votes
1 answer

SSRS Comparing 2 rows (new vs old) and highlighting the differences / changes

I have a report which gives the current state of an item, and the previous state of an item and I want to display both rows and highlight the differences. For example: STATUS ORDER# NAME ADDRESS QTY PRICE TOTAL new …
Jay
  • 455
  • 3
  • 17
  • 34
5
votes
1 answer

How to I get cumulative monthly subtotals in SSRS?

I'm using SSRS to create a report which shows a lot of transactions according to a trade date. I've made a group on the month and year called 'grpMonthYear'. Inside that group I've made a subgroup on 'TradeDate'. The groups and all work perfectly.…
Vivek Todi
  • 361
  • 1
  • 9
  • 24
5
votes
2 answers

SSRS Dynamically setting table position/location

I see in Report Builder / design mode, there is a Position and Location property that allows you to set how far from the top or left the table should appear. My question is, is there a way to set 2 or more tables in the same location (ie top of the…
Jay
  • 455
  • 3
  • 17
  • 34
5
votes
1 answer

SSRS Tablix Insert Row Keyboard Shortcut

I have several SSRS reports to create for a client that need to have a table layout. I know that some people frown on using the Tablix only for this purpose, but trying to align rectangles and other controls is extremely time consuming. Many of…
GibsonCode
  • 89
  • 2
  • 13
5
votes
1 answer

Reporting Services - aligning a right-to-left matrix

In a RS report I have a matrix whose LayoutDirection property is set to RTL (because it's in Hebrew). I created a column group by dragging a field form the dataset field list and dropping it in the column header of the matrix. So the number of the…
kodkod
  • 1,556
  • 4
  • 21
  • 43
5
votes
2 answers

Check if field value is in a list of strings in SSRS report

I'm using SSRS (VS2008) and creating a report of work orders. In the detail line of the report table, I have the following columns (with some fake data) WONUM | A | B | Hours ABC123 | 3 | 0 | 3 SPECIAL| 0 | 6 | 6 DEF456 | 5 | 0 …
D.R.
  • 1,199
  • 5
  • 19
  • 42
5
votes
2 answers

RDLC tablix colspan equivalent

Is their some sort of colspan equivalent for the RDLC markup? I of course tried colspan and the report doesn't render in design view then, deserialaztion error. The project and zipfile are much longer than the single column to display.
Somejerk
  • 193
  • 1
  • 11
5
votes
1 answer

How to add a tablix control to a report?

This seems like a simple question but I cannot find anything on adding a tablix control to an SSRS report. I don't see this control in the toolbox in bids or in report builder 3.0. I'm using SSRS 2008 R2. Can someone kindly tell me how to add this…
Mike Cheel
  • 12,626
  • 10
  • 72
  • 101
4
votes
1 answer

How can I fix the error incorrectly set FixedData property within the TablixRowHierarchy when I deployed my report in SSRS?

In my report I have 1 tablix with 1 row group and 1 column group. When I deployed, my report showed me the following error : Warning : The tablix 'Tablix1' has an incorrectly set FixedData property within the TablixRowHierarchy. Only the outermost…
B.Avramov
  • 57
  • 1
  • 8
4
votes
1 answer

How can I fix the number of groups in each page of SSRS

I have a Report which displays 6-groups(5-Rows in each Group) of information. The report is having some filter which can be modified by user. When first time report get loads without any filter its page rendering in report viewer and Print page is…
Irfan
  • 665
  • 6
  • 29
4
votes
1 answer

SSRS Report Table Add Column Expression Record x of y?

I have an SSRS, which is compiled of report tables, each tied to a stored procedure, all keying off the same ID. I pass the ID automatically, through the UI. Because there is so much information in the report, For each section, I wanted to add a…
missscripty
  • 529
  • 2
  • 11
  • 30
4
votes
2 answers

How to group this SSRS report?

I have an SSRS report. It looks like this: Its definition looks like this: As you can see it's just a bunch of numbers in different columns A to G. Those numbers were grouped by A then B then C. For each row in the report, column D,E,F,G are my…
Just a learner
  • 26,690
  • 50
  • 155
  • 234
4
votes
1 answer

BC30201 Error SSRS

Good morning, Using SSRS, I am getting the following error: The Value expression for the textrun ‘Textbox63.Paragraphs[0].TextRuns[0]’ contains an error: [BC30201] Expression expected." I am using this expression in the Textbox:…
MarioS
  • 262
  • 1
  • 3
  • 12
4
votes
1 answer

Can't go into advanced mode in SSRS 2008 R2

I cannot find advanced mode in SSRS 2008 R2. I need to freeze the top row in a tablix so it stays there when scrolling on a report. Apparently I can do this in "advanced mode", but when I click the arrow to the right of the groups in the grouping…
Dom Vito
  • 507
  • 8
  • 38
1 2 3
…
92 93