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
10
votes
3 answers

SSRS tablix Sorting not working on Date column

I have a SSRS report one Stock#_______Description_____Colum1_____Colum2_____Colum3 ABC__________XYZ_____________4334________4354_______454 detail part Transaction#_______Date 1__________________yyyy/MM/dd } Need to be…
Builder
  • 1,046
  • 2
  • 10
  • 30
10
votes
1 answer

Adding subtotals to SSRS report tablix

say i have this record.. lastname firstname mi checkno amount totalamount lastname1 firstname1 mi1 k1234 5000 lastname2 firstname2 mi2 k1234 5000 lastname3 firstname3 mi3 k1234 5000 lastname4 firstname4 mi4 k90788 5000 lastname5…
user3312649
  • 190
  • 1
  • 4
  • 17
9
votes
2 answers

SSRS show/hide tablix column programmatically based on parameter in rdl file

I have a SSRS rdl file that contains a 3-column tablix table, I want to show and show any of the columns programmatically based on the rdl paramter. I can achieve that by setting the Hidden property of a column to an expression:…
Pingpong
  • 7,681
  • 21
  • 83
  • 209
9
votes
1 answer

How to calculate number of days by two dates in SSRS formula field

I have an SSRS report and I have a table there, in which I have a column named as No. Of Days which are lying between two dates. I am getting those dates (datetime) through datasource but don't know how to calculate number of days between these two…
asma
  • 2,795
  • 13
  • 60
  • 87
9
votes
1 answer

How to get specific row from Dataset in RDLC report

I have three textboxes. Each text box will show a value which get from first row, second row and third row of "MyDataset" Dataset. My Dataset contain about these ____SEQ_NO____|____USER__ 1 | Beckham 2 | Cantona 3…
Fame th
  • 1,018
  • 3
  • 17
  • 37
9
votes
2 answers

Border formatting of SSRS row group

This is my report. Above row contains a parent row group and a child row group. I have done border formatting of the report . I simply right click each Text box and gives border accordingly. But, I am not able to set border for entire Group. In…
muhammad kashif
  • 2,566
  • 3
  • 26
  • 49
8
votes
4 answers

SSRS not letting me change dataset of a table

I have a report with a table in it. I need to change the dataset that this table uses. When I go the tablix properties and try to change the DataSetName, it automatically gets reverted back to the original dataset instead of the new one I selected.…
iDesi
  • 692
  • 1
  • 10
  • 19
8
votes
2 answers

Interactive sorting in tablix with column and row groupings

I'm trying to define interactive sorting in a tablix. The sorting should affect the row order. Attaching image of the tablix in order to explain what I'm trying to get: I already tried to define the column header with interactive sorting and get…
Gil Peretz
  • 2,399
  • 6
  • 28
  • 44
8
votes
1 answer

SSRS Reports - Hiding a Tablix doesn't shrink the space and move content after it up

I have a tablix with another tablix beneath it with 0 space between the bottom of the first tablix and the top of the second. When I change the Hidden property of the first tablix to true, it hides the tablix with empty space but doesn't move the…
pkr
  • 1,723
  • 5
  • 25
  • 43
7
votes
4 answers

SSRS "member not found (exception from HRESULT: 0x80020003 DISP_E_MEMBERNOTFOUND" Visual Studio2019 Community

enter image description hereTrying to use SSRS in Visual Studio 2019 Community. I am able to create a new "Report Server Project" Project in VS. However, when I try to "Add New Item" in the Project, I get the Error message: Member not found.…
Gabriela
  • 85
  • 1
  • 1
  • 8
7
votes
2 answers

SSRS Dynamically change the cell background and font color

I need to change the Table Cell Background color to Yellow and Font color to Bold / Red for values which are less than 80. Cell Expression is =Fields!Mark.Value How to change the Cell Background Color / Fill the Color to Yellow ?
goofyui
  • 3,362
  • 20
  • 72
  • 128
7
votes
1 answer

ssrs - repeat tablix at top of every page

I have a report made up of 2 tablix. The first tablix just has some basic information in it, and is linked to a dataset. The second tablix is linked to a different dataset and is made up of a lot of rows and spans multiple pages. All I am looking to…
Luke K.
  • 177
  • 3
  • 5
  • 16
7
votes
2 answers

SSRS Repeating group headers?

I have this data DateRecived JObNumber REcCnt 20130626 1234 1 20130627 1238 11 20130628 1240 2 20130629 1242 23 I applied the group by on…
user2553512
7
votes
5 answers

How can I unmerge cells in ssrs when exporting to excel to try to sort

I'm exporting an SSRS Report to Excel and when the user tried to sort it for some column. They got the message "This operation requires the merged cells to be identically sized. How can I generate the report in SSRS with unmerged cells? I tried to…
Eliana
  • 171
  • 2
  • 3
  • 13
6
votes
2 answers

empty page after tablix (Reporting services 2008)

I have created a report which contains a tablix. I observed that when the tablix contains a certain amount of rows, a blank page is added after the page with the tablix with only the header and footer of my report.This happens both in design and…
AGuyCalledGerald
  • 7,882
  • 17
  • 73
  • 120
1
2
3
…
92 93