AnsweredAssumed Answered

excel like spreadsheet

Question asked by CStovin on Jun 5, 2013
Latest reply on Jun 7, 2013 by philmodjunk


excel like spreadsheet


     Is it possible to make a list view report that displays rows of fields and columns of fields?

     For the Rows I would like to have a list of customers

     For the columns I would like to have fields which display products.  I am thinking of having maybe 10-15 columns.  Each field would have an If type statement that if this column field which corresponds to the customer's Row, shows the amount out.

     In the attached image I would like the A column to populate with how ever many customers have items out that correspond with the Columns B,C,D,E,F....

     Row 1 Can be static.  I will only need certain reports on certain products which are out.  Perhaps if I need 10 products than I could create 10 fields that do a search for that specific item ?

     The information will be pulling from my work orders table which matching those particular items which are still out.  IF they are not out than a "0" will be in that cell.

     I'm a bit of a loss how to start this.