Question

Price List SSRS Report

  • 26 August 2021
  • 1 reply
  • 92 views
R

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?

1 reply

fred
Userlevel 3

In these situations I use the Row_Number() function so that you get the row number for the part sorted by the quantity break.  Then in the matrix, your columns use the Row_Number field so that there aren’t “gaps”.  For the label of the column, use the quantity instead of the row_number.

Fred Zelhart, CodaBears, Inc.

Reply


Terms & Conditions