Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSRS Grouping Imputes missing data

Status
Not open for further replies.

Johnhny

Programmer
Apr 12, 2023
1
US
I have a table with some grouping and math in the SQL query that creates the SSRS tablix.

When a number or record is correctly missing from the dataset, the group uses the first value in the result set instead of nothing.

Nothing I do besides joining the table back onto itself to add a null value to every missing entry works. Any ideas?

ssrs_i3k4we.png
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top