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

How to enable Add Total option in Tablix

I had a problem of couting sum of grouped rows in a tablix. I posted it on stackoverflow. There I found the detailed answer by a user. But the problem is now, he is asking me to add "Add Total" in one cell of my tablix. Whereas I find no option of…
asma
  • 2,795
  • 13
  • 60
  • 87
6
votes
1 answer

SSRS Sum in table group

I am working on SSRS reporting services. I have a table on which I applied group. Originally I had this data: I changed something in my tablix and created a tablix and added a parent group of Age i.e. left column and then in the right column, I…
asma
  • 2,795
  • 13
  • 60
  • 87
6
votes
1 answer

Make SUM of Column value of all row up to current row in SSRS

I have webapplication having SSRS Reports... I have a situation where i have to Update sum of particular field into last column for all above row up to current row.. for example.. ID Balance Total ---------------------- 1 100 100 …
ghanshyam.mirani
  • 3,075
  • 11
  • 45
  • 85
6
votes
5 answers

SSRS csv export with comma in the column header names

By default, csv takes the text box name as the csv header name for the columns. The text box does not allow a space. How do I make a different header than the text box for the csv? Is there a way to display comma in the header when exported to…
Lijo
  • 237
  • 1
  • 3
  • 8
6
votes
1 answer

How to freeze First Column in tabular Report?

I have a Table Report with 70 columns. My requirement is to freeze the First Column as I scroll horizontally. I have tried checking row headers in Tablix properties, but still it's not working. How can I freeze the first Column?
SqlLearner
  • 763
  • 8
  • 23
  • 37
6
votes
1 answer

SSRS tablix split report into two sets of columns

I have a report that lists some basic data about a company for all (possibly) 52 weeks of the year. The report takes in parameters of year and UptoWeek. So for example i can put in 2013 and 31 and it will spit out all the values for year 2013 up to…
d90
  • 767
  • 2
  • 10
  • 28
6
votes
2 answers

SSRS : How to repeat header row of a table on each page that is embedded in a LIST?

I have a SSRS report that has a list which includes two embedded tables. For these tables if I set the header rows to repeat on each page, I get an error "All tablix member elements in a TablixColumnHierarchy must have the RepeatOnNewPage Property…
SelectStarFrom
  • 141
  • 1
  • 2
  • 8
5
votes
3 answers

How do I export a SSRS matrix to CSV without losing the structure?

Consider the following data source: declare @Test table (EmpId int, ProdId int, Sold int) insert @Test (EmpId, ProdId, Sold) values (1, 1, 1) insert @Test (EmpId, ProdId, Sold) values (1, 2, 2) insert @Test (EmpId, ProdId, Sold) values (1, 3,…
Mike
  • 7,500
  • 8
  • 44
  • 62
5
votes
1 answer

What does the do exactly?

Accidentally removed this line true not sure what it actually does, if it's worth going through and recovering it. Tried Googling and looking up documentation and couldn't seem to find anything defining what it does
triedgooglingit
  • 85
  • 6
5
votes
0 answers

MS CRM 2016 Online custom SSRS Report with Sub report

I have a custom SSRS FetchXml based report 'A' for a MS CRM 2016 online instance.The report has RowGroups as well as ColumnGroups as shown below - I am using a tablix here and for the expression in the header I'm formatting the date field (Target…
Aritra B
  • 1,726
  • 6
  • 29
  • 45
5
votes
1 answer

Need help in calculation using two Datasets using Expression SSRS

I am creating an SSRS report where In Dataset15, I have value Jan - 100 & Feb - 110 in Dataset16, I have value Jan - 80 & Feb - 100 Now I want to calculate same thing in a line chart using expression - Jan - 80/100 which should be 80% & Feb -…
Abhirup Dash
  • 75
  • 1
  • 2
  • 5
5
votes
3 answers

SSRS Conditional Formatting

I am working on SSRS Ranking report, where Rank 1 should have background of Green and last Rank should have background of Red. Example below: I tried using custom code but that's not working for me as below: SSRS Expression used as…
user2827587
  • 231
  • 4
  • 15
5
votes
3 answers

Rownumber() function of RDLC report isn't correct

Below figure is my report. This tablix has 10 row from dataset. It's grouped by TOOL_CODE and TYPE for get count. At "Count" Column is use this expression .. = Count("Detials") "Detials" is a name of group(by TOOL and TYPE) And No.Column I…
Fame th
  • 1,018
  • 3
  • 17
  • 37
5
votes
2 answers

How to set default value of Boolean parameter false in SSRS?

I have 18 Boolean parameters in my report. I want to make their default value to false through expression when ever user runs the report. I am trying this but its not working =SIDIdNum.Value = "false" Getting Error: parameter SIDIdNum caontain an…
younus
  • 101
  • 2
  • 2
  • 10
5
votes
1 answer

Hide a row is a field is empty

I am having a problem. One of the field is empty in a row and I want to hide that row. I have tried the below expressions =IIF(Fields!CRM_PO_Ref.Value= "",TRUE,FALSE) =IIF(IsNothing(Fields!CRM_PO_Ref.Value),TRUE,FALSE) I added this expression by…
mfredy
  • 597
  • 1
  • 8
  • 16
1 2
3
…
92 93