I’m trying to create a Price List report in SSRS for Kinetic 2021. The quantity breaks are stored as individual rows in the DB. I would like to have one line for each part with the quantity breaks listed. Unfortunately, in SSRS the Matrix table ends up spacing it all out because the quantities are all different. I end up with blank cells .
Part1 12 $10 24 $5 48 $2.50
Part2 12 $15 24 $10 36 $5
Does anyone have an idea on how I can get the report to remove the blank space? Or is there a way to pivot the BAQ query so that every quantity break is in a single row?