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

SSRS 2008 R2 - Group toggle aggregates

I'm working with a dataset where employee utilization is calculated as (Time Billed to X/Standard Billable hours). As such, to get the total billable percentage for an employee, I can just sum up the percentages billed to each client. However, I…
AJBCBR
  • 1
0
votes
1 answer

How freeze Tablix Header in SSRS

How to freeze the Tablix header after export to excel from rdl in SSRS. I am using report builder 3.0.
SaravRaj
  • 23
  • 2
  • 6
0
votes
1 answer

SSRS 2008R2 Matrix Column Group Totals

I am using a Matrix control in SSRS 2008R2 and I am trying to create totals for my column groupings. Here's a sample of my Matrix layout: January February March TOTALS 2011 2012 2011 2012 2011 …
BBK0919
  • 23
  • 2
  • 8
0
votes
1 answer

SSRS semi additive function for tablix cells

I have to produce a report where in my row values should sum up on collapse (summary data) but column values should not sum up on collapse, rather show the last value. Here is a sample report Fully expanded report -2012 …
sm1911
  • 1
0
votes
1 answer

SSRS Margin from page header for continued tables

When using SSRS and exporting to PDF, if a Tablix object extends beyond one page, it of course continues on to the next. Is there any way though that I can insert a margin between the page header and the continue Tablix? Currently the Tablix goes to…
mservidio
  • 12,817
  • 9
  • 58
  • 84
0
votes
1 answer

How to add a column grouping in a tablix?

I am developing a tablix in SSRS 2008 R2 and am trying to add a dynamic column. This column has four possible values: Quarter 1,2,3,4. Beneath each of these columns I want 2 child columns: Count and %. So I added a column to my tablix and placed…
salvationishere
  • 3,461
  • 29
  • 104
  • 143
0
votes
4 answers

sorting in SSRS

I have designed a tabular report in SSRS which has columns "Student Name", "Quarter" and "Amount". Is is possible to sort the report output with "Student Name" in Ascending Order and then by "Amount" in Descending order? Here a student will have…
user793468
  • 4,898
  • 23
  • 81
  • 126
-1
votes
1 answer

IIF Statement with Dataset fields SSRS

I have the below expression = IIF(Parameters!RepoLetterType.Value=2,"HI Fields!PaymentDueDate.Value " ,"") In this I need to write "The Letter Dated July 23 is being Printed with the value of 3000" in the else part of IIF Statement. The date and…
Rakesh Dhar
  • 1
-1
votes
1 answer

Questions SSRS Reports on how to customize primary groups (Group BY)

If possible, I would like to ask for help with how to do the following. As you can see, it shows the list of products on the rows, group by "food category" on the first group by on the column, then another group by "type of food" next to "food…
dax
  • 39
  • 1
  • 1
  • 6
-1
votes
1 answer

Can't Hide Tablix

This should be straightforward, but I can't get it to work. I want to hide tablix4, so I am modifying Tablix Properties --> Visibility --> Show or Hide based on formula: =iif(IsNothing(First(Fields!ab_new_varietypermitname.Value)),True,…
Unicorn_tech
  • 207
  • 1
  • 4
  • 18
-1
votes
1 answer

I have some values in brackets I need to sum the values in ssrs

I HAVE VALUES LOOKS LIKE BELOW 1.(-250.00) 2. 1293.01 3. (-3567.78) I NEED SUM OF these values using ssrs expression can anyone please helpme
Vinod Kumar
  • 1
-1
votes
1 answer

In SSRS is there a way to use newspaper columns and still have a new page per group?

My dataset is grouped by customer then itemtype and then the details are the itemcodes and descriptions. I am using the Newspaper column setting so that the list of items continues on to the right side of the page instead of moving on to the next…
Jessica Moreno
  • 1
-1
votes
1 answer

Group by multi select parameter in ssrs

I have a multi select parameter in SSRS report. I for each option selected there are records in table. I wish to show a table which is grouped by "option" selected in multi select, as shown in image. I am using =Parameters!IncidentNo.Label(0) in…
ShahidAliK
  • 30
  • 7
-1
votes
1 answer

SSRS Multi Value Parameter

I have a report having two tab-lix and also two data set(e.g=dataset1,dataset2) for each tab-lix. When i am generating report by passing the multiple parameter location id(38,39 & 40) value if there is no record of id-38 in dataset2 i want blank…
Rajib Sahoo
  • 1
  • 1
-1
votes
1 answer

How to define Row Data group in SSRS if we have two parameters to be considered?

Im new to SSRS reporting. Im trying to edit in *.rdl file, where it has row data grouping to view data for a month. eg: =Fields!EndOfMonth.Value Here EndofMonth will return September 30th /October 31st etc. So table is grouped by one month data. I…
Ratha
  • 9,434
  • 17
  • 85
  • 163
1 2 3
…
92 93