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
187
votes
6 answers

Tablix: Repeat header rows on each page not working - Report Builder 3.0

I have a tablix with lots of rows that span over multiple pages. I have set the Tablix property Repeat header rows on each page but this does not work. I read somewhere that this is a known bug in Report Builder 3.0. Is this true? If not, is there…
Ayrton Senna
  • 3,735
  • 5
  • 34
  • 52
78
votes
6 answers

Is there an easy way to rearrange tablix columns in SSRS design mode?

I have an SSRS report which contains more than 20 columns in a tablix. Our users have decided that the data is OK, but they want the columns moved around (sigh!). It seems like it should be easy to re-arrange the columns (move column 3 to column 1,…
PaulStock
  • 11,053
  • 9
  • 49
  • 52
42
votes
2 answers

SSRS How to repeat the table header on each page in print preview

I have an SSRS report, for some reason the header is not repeating on all of the pages in the print preview mode. Below is the image of the table: I have as well checked the Repeat Header rows on each page option as below: I would like the headers…
voonna
  • 741
  • 3
  • 10
  • 24
32
votes
3 answers

Copy and paste a table (tablix) in SSRS

I have a tablix that has data for one day, and I need to have the same data at the bottom but in 3 different lines. I'd like to copy the main day table 3 times at the bottom, and then use different datasets for each one. I tried copying the tablix…
urbanmojo
  • 737
  • 3
  • 12
  • 21
31
votes
2 answers

SSRS - Changing tab name when exporting to excel

I have tabbed my report in SSRS 2012 by having my page breaks based upon grouping classname and it works great. How do I change the tab names when exporting to Excel? I tried having an expression for page name =Fields!classname.Value. In doing so,…
user3798811
  • 493
  • 1
  • 4
  • 7
22
votes
18 answers

SSRS Dataset Field Refresh not updating for Tablix

I have updated the SP for the attached dataset that the tablix is using. The refresh worked fine and I can see my new fields in the shared data set when I look in the Fields tab. My problem is the tablix itself is not giving me access to the new…
Tony
  • 3,269
  • 1
  • 27
  • 48
22
votes
7 answers

How to check if SSRS Textbox is empty

How do you check if a textbox is empty in SSRS 2008? I've tried this code and it doesn't work. IIF(ReportItems!txtCountVolunter.Value = "", false, true)
Link
  • 531
  • 4
  • 10
  • 18
20
votes
4 answers

SSRS Expression Divide by Zero Error

I have a tablix box that has a division expression. When dividing by zero or nulls I get #Error displayed in my report. I tried to create an IIF statement and tested with static values. This verified my syntax was correct but I still see the error…
d90
  • 767
  • 2
  • 10
  • 28
19
votes
6 answers

Is it possible to create a row that spans all columns of a Matrix in SSRS 2008?

Is it possible to have add a row to an SSRS 2008 Matrix that spans all of the matrix's columns? This crude diagram shows roughly what I'm looking for: The basic idea is that each line item is a person, and each column is a field in a form for that…
AaronSieb
  • 8,106
  • 8
  • 39
  • 58
17
votes
1 answer

Trying to Add Sub Row Group inside Parent but flush left in the nested cell

What I am trying to do: I am trying to create nested groups but I want the sub row group to show directly underneath the parent, flush to the left like the parent. So in this case You'd have: Market SubMarket so results for example would…
PositiveGuy
  • 46,620
  • 110
  • 305
  • 471
16
votes
2 answers

Freezing column headers while scrolling in SSRS

I have a simple table in ssrs with a single header row and no grouping. I want to freeze the columns while scrolling. I have set the properties of table(Fixed column headers AS true) . I have also checked the checkbox which says"Headers should be…
Apoorv k
  • 183
  • 1
  • 2
  • 8
15
votes
5 answers

SSRS Stop group in tablix being split across printing pages

I have a tablix in SQL REPORTS (SSRS) that has many grouped items. It fits roughly 3.5 groupped item per page when printnig, however I dont want the groups to be split up over the 2 pages, I want a pagebreak to happen whenever the group needs to be…
Michael
  • 8,229
  • 20
  • 61
  • 113
14
votes
2 answers

Set Tablix row height to a specific number in SQL Server Report Builder 3.0?

I'm trying to set the row height of the detail row to a specific value, like 0.5 in. If I click on the Tablix handle for the detail row; it selects the row but the Size property does not expand for the Height property or allow entry for something…
Dan Metheus
  • 143
  • 1
  • 1
  • 4
11
votes
1 answer

SSRS- TextBox Border Width property reverting to 1pt after saving expression

I've been working on this for the last couple hours. I placed the following code into the textbox Border Width Property (this applies to a table not a matrix): =IIF(Fields!SortOrder.Value = 2,"3pt","1pt") Once I click OK on the expression editor…
misterManager
  • 1,174
  • 4
  • 12
  • 33
11
votes
3 answers

SSRS fitting Tablix to exported pdf page

I currently have a Matrix within an SSRS report. Usually, the matrix will fix to a standard page in portrait mode, however there are cases where the length of the columns will exceed a page. Is there a way to have SSRS render the report to a PDF…
mservidio
  • 12,817
  • 9
  • 58
  • 84
1
2 3
…
92 93