help with report

• montu_patel_2005

  Newbie

  Points: 8

  More actions

  December 8, 2014 at 11:37 am

  #292694

  hi,

  i have a simple report that i am trying to figure how how to avoid empty rows/cells.

  this is just an example of how i have it setup.

  column is grouped on account numbers and the detail is the order number.

  it seems like the report is create a row for each actual row for each account number.

  i want to get rid of the empty cells and have the order numbers one after another and then go to the next

  account number and do the same.

  i have tired hiding the row/cell if it ="" but that does not seem to work.

  i wanted to break on a column so that way once the first account number has all the orders for it it goes to the next column and list all the orders for that account number that way if breaks on column then maybe it will not have empty cells. below is a snippet of the data i am getting.

  Open to any suggestion.

  thanks in advance