Solved: SSRS Tablix only displaying one record

Create Account

Microsoft SQL Server

Questions

Followers

Top Experts

canuckconsulting🇬🇧

SSRS Tablix only displaying one record

I have a SSRS report which was working well but is now only displaying one record.

It was grouping by status type and displaying some totals for each type. Now it only displays the first records and while that data appears correct I need the rest.

There are a number of columns which have been formatted and parameters set on the report which is why I don't create a new one.

Here is a shot of the report in design:

And here is a snip of some of the totalled columns:

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

ASKER CERTIFIED SOLUTION

Jim Horn🇺🇸

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

canuckconsulting🇬🇧

ASKER

Thanks.

I did only have two rows but still only showing one record as below:

And here's what the advanced row/col looks like>

I also manually had to add Detail_Collection to the DataElementName as shown:

Finally here is the actual output...there should be six records:

canuckconsulting🇬🇧

ASKER

In the end I had to recreate the report but at least this helped me see the tablix was beyond help.

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Microsoft SQL Server

Questions

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.