SQL 2008 R2 - Print Fixed Number of Columns per Page

• rrs1977

  Grasshopper

  Points: 16

  More actions

  August 23, 2011 at 9:39 am

  #256122

  I have a report - which prints total 30 columns.

  The first four columns on each page need to be Item, Desc, Category, Unit Price.

  The other 26 columns are Qty and Price for total of 13 different locations.

  My table is pretty simple -

  --------------

  Item,

  Desc,

  Category,

  UnitPrice,

  Loc1_Qty,

  Loc2_Qty,

  Loc3_Qty,

  .

  .

  .

  Loc13_Qty

  ---------------

  I would like to print the first four columns on each page and then print Qty and Price for 3 locations at a time.

  In other words, when printed in portrait, the report page should have total 10 columns - the first four columns being the same (Item, Desc, UnitPrice, Category) and the next six columns for each warehouse, print Qty and Price.

  What is the best way to achieve this?

  Thanks in advance.

• pieterlu

  SSC-Addicted

  Points: 467

  More actions

  September 5, 2011 at 7:24 am

  #1377031

  I have not tried this myself, but offhand I would say you could try using a subreport, or data region (tablix within a tablix).