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

SSRS Hidden Parameter Logic Approach For STRING values

DECLARE @rpmProvider varchar(MAX) = 'Prudhvi, raj,Lalith, Kumar'; CREATE TABLE #PrvFilt(ID varchar(50)) DECLARE @xml xml BEGIN SET @xml = cast(('' + @rpmProvider + '') as xml) INSERT INTO #PrvFilt (ID) SELECT N.value('.',…
Prithvee raaj
  • 21
  • 6
-1
votes
2 answers

SSRS : Date format expression in Text box

In the SSRS Report I need to show the below format in TextBox. Example: By default, it should pick a current date. **Data Reporting 18, April 2018** How to write the Expression?
user9273914
  • 99
  • 2
  • 11
-1
votes
2 answers

SSRS Report grouping

I need to create a SSRS report with changes in UI. Previous my report format was like this: This is new RDL format I created but grouping is creating issue: I created this format in report design but data is not coming the way I want. My data is…
Mayank Gupta
  • 1
  • 1
-1
votes
1 answer

SSRS Predicament with expressions

I have an SSRS dataset that looks like this: The dataset rows are generated independent of each other using UNION ALL. I need to display these rows in my report as is, but I need to add an additional row that will calculate Total Won / Total Lost,…
Tony
  • 149
  • 2
  • 4
  • 14
-1
votes
1 answer

SSRS report parametrised

I am creating a tabular report with several conditions. As a case in point, the conditions could be either of these: X is NULL X is not NULL X like '%Y%' I want to create a kind of drill through report with the capability of selecting one of the…
SQL Lover
  • 1
-1
votes
2 answers

SQL SSRS-several conditions in one report

I am creating a tabular report with several conditions. As a case in point, the conditions could be either of these: X is NULL X is not NULL X like '%Y%' I want to create a kind of drill through report with the capability of selecting one of the…
user8086255
-1
votes
1 answer

aligning chart and tablix in parallell

I have two chart and tablix in my SSRS report. Degin page looks as follows The second chart in the report is shown after the tablix data. I need to show the data in parallel. The second chart should be available immediately following the first…
Remi
  • 214
  • 5
  • 17
-1
votes
1 answer

Total by group value not included in data

Imagine the following data, which includes a column "Color". Possible values are Red, Blue and Yellow. Other fields Color A B C -------------------------------- ... Red 1 3 0 ... Red 0 1 6 ... …
angus
  • 2,305
  • 1
  • 15
  • 22
-1
votes
1 answer

ssrs report 2008 pick 1 or other parameter

In an ssrs 2008 report, I have a user that would like to select 2 different parameters sometimes. Some times the user would like to: 1. select only zip code, 2. select only city and state, or 3. select both zip code and city-state combination. In…
user1816979
  • 511
  • 4
  • 13
  • 25
-1
votes
1 answer

Prevent like data from grouping in table? SSRS

I've seen how to's on how to display combined data however, I would like to keep all data separate in their own rows and columns. It seems to have to do with grouping, but when I attempt to delete the grouping, the report has an error when trying to…
d0nut
  • 3
  • 2
-1
votes
1 answer

SSRS 2014 : Add several cells inside of a large cell

I have created a table like below. The table use a dataset I want to add several cells within one of the row like below and be able to query through the same dataset and most of all, be able to leave the other rows intact (see below). Issue is I…
Andy K
  • 4,944
  • 10
  • 53
  • 82
-1
votes
2 answers

Return text if tablix results are empty

I have a tablix that is linked to DataSet1. DataSet1 uses the following TSQL code select ir.SourceRef as Account_Ref, rab.BalanceFromDate, rab.ClosingBalance Current_Balance, ra.Account_ID as rserial, ra.Current_Balance…
ikilledbill
  • 211
  • 1
  • 3
  • 17
-1
votes
2 answers

Multiple tablix for report

i have the following scenario i am trying to simplify using Visual Studio and Microsoft BI Stack (SSRS). I have a Dataset as follows. Year Employee Sales 1 A 5,000,000 2 A 7,500,000 3 A …
Komengem
  • 3,662
  • 7
  • 33
  • 57
-1
votes
1 answer

How to do different filters on different columns

i'am working with SSRS 2008 and my source is OLAP(mdx query) i created a report like this the report return me the following data: Nbre all Products Nbre Dell Products Nbre HP Products Month 1 50 50 …
user2460074
  • 1,252
  • 3
  • 11
  • 28
-1
votes
1 answer

SSRS - Repeat formatting on first row of each page

The requirement received for report in SSRS includes repeating formatting for the first row for 1 column on each page. I already have Column Headers repeating on each page. This requirement is to repeat formatting of first data row (below column…
whereisSQL
  • 638
  • 2
  • 13
  • 23
1 2 3
…
92
93