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
4
votes
1 answer

How to convert Horizontal table to vertical table in SSRS?

I have to show all my headers left side vertically and values right to it instead of horizontal display?
Manideep Hv
  • 41
  • 1
  • 3
4
votes
1 answer

Show/Hide Column Header on Toggle in SSRS

I am working on a requirement that allow me to show columns when a user clicks on "+" (expand a row), and hides the column when a user clicks on "-" collapse a row. So for example, when all rows are collapsed, report looks like: When a user click…
BIDeveloper
  • 767
  • 3
  • 14
  • 28
4
votes
1 answer

SSRS Reporting: How to limit the number of rows returned in a group

How can I limit the number of rows returned in a group? So far, when the report runs, it returns a lot of records for each group. However, I only want it to return the top 4 records in each group. I tried the expression:…
Guillermo Greco
  • 63
  • 1
  • 1
  • 5
4
votes
1 answer

how to display multivalued parameter value in SSRS text box

I am having a multivalued parameter 'client',i have almost 60 values in the client parameter,my requirement is display the selected client values in the header text box but when i select 'SELECT ALL' option in the parameter i should display just…
SqlLearner
  • 763
  • 8
  • 23
  • 37
4
votes
5 answers

Freeze column headers in browser while scrolling

I am trying to freeze all column headers in a report when scrolling down. I have read numerous articles about how to go to Advanced Mode, select the header and set FixedData to True, KeepWithGroup to After, RepeatOnNewPage to True. That works when…
Jeff Stock
  • 3,796
  • 12
  • 46
  • 61
4
votes
1 answer

SSRS Auto Generating all columns from Dataset into tablix (Report Builder 3.0)

Is there a simple way to just auto generate every field/column from a dataset into a flat table/tablix in SSRS without making it a matrix? Seems like something that should be so easy, rather than having to drag each and every column over. Not sure…
Jay
  • 455
  • 3
  • 17
  • 34
4
votes
2 answers

How to add a total count column for an expression field

If I have a table (tablix) in SSRS, and one of the columns is a simple expression: =Fields!NumPorts.Value - Fields!PortsUsedLastQuarter.Value Then how can I add a "total count" column for this? I can't add a total column, it's greyed out because…
Matt Roberts
  • 26,371
  • 31
  • 103
  • 180
4
votes
1 answer

SSRS 2008 R2 Drill Down On-Demand to Sub Report

In SSRS 2008 R2, I was under the impression that a drill down to a sub-report would query the data on-demand. This isn't the case when my report gets rendered. Specifically, I have a Tablix that initially loads rows grouped by Person. When someone…
JJT
  • 407
  • 5
  • 12
4
votes
1 answer

Displaying the value of a textbox in other parts of a report

In a report table there is this formula to calculate a subtotal for an invoice. This is the formula: =Sum(Fields!LineTotal.Value) The textbox is called TextBoxSubTotal. I would like to display this in another part of the report such as in the…
Emad-ud-deen
  • 4,734
  • 21
  • 87
  • 152
3
votes
2 answers

SSRS Tablix border size inconsistent

I am using a totally standard tablix table (no embedded sub-tables or anything) in a SSRS report with a 1pt solid border around all cells which looks as I would expect during preview with consistent borders. But when I deploy the report and run it,…
aw_6534
  • 31
  • 2
3
votes
1 answer

Can I use a method that returns a list of strings in SSRS report code as the headers in a tablix?

I have table that needs to contain 50 columns for each half hour in the day (+2 for daylight savings). So each column will be HH1, HH2, HH3... HH50. I have written this piece of code in the report properties code section. Function GetHH() As List(Of…
Usman Khan
  • 676
  • 1
  • 7
  • 20
3
votes
1 answer

Render HTML Tags in SSRS Tablix

I have markup text (HTML tags) in one of the SQLView\columns, which I have to show in a Tablix report as a formatted text in one column. Markup is for bold, italic, underline. I could enable the HTML in Text box but not in Tablix. Could you please…
Siva Azure
  • 33
  • 1
  • 5
3
votes
1 answer

Count value in SSRS

I want to ask a question regarding the count error that is generated in SSRS reporting server. I have two condition simultaneously, but the count is working only for one condition not for both. Please suggest is there any problem in my logic or…
Arpit Sharma
  • 138
  • 1
  • 11
3
votes
1 answer

Can i add a filter button in ssrs report?

I have an SSRS report which displays lacks of records. the user wants a filter button on the report to display only filtered records. I tried searching on the internet for the same but unfortunately, I didn't find anything helpful. This screenshot…
Shahab Haidar
  • 625
  • 3
  • 11
  • 25
3
votes
1 answer

Hitting tablix exception with rdlc

I try to add new rows to my rdlc report using Microsoft Visual Studio 2010. When I try to generate the report I am hitting this exception. Exception: Microsoft.ReportingServices.ReportProcessing.ReportPublishingException: The tablix 'table12' has an…
newbie
  • 61
  • 8
1 2 3
…
92 93