1 Reply Latest reply: May 4, 2017 11:35 AM by Grant Perkins RSS

    How do I get all my lines to show up?

    April Grimes

      Hello,

      I have a report that lists a SLS Rep, an Item # and the Customers who are purchasing.

      My problem is the report is laid out so that the Customers purchasing are listed first, then the Item information underneath and the SLS Rep info is listed under all of the Customers purchasing for that SLS Rep.

      I have having an issue getting all of the customers to list for each item.

      I have tried changing each line to be Page Header, Detail, and Group footer but none of these combinations are getting all of my info to extract.

      Example of what I am working with:

      Customers   111111

                          222222

                          333333

                          444444

      Item               1111

      SLS Rep         07

       

      Thanks

        • Re: How do I get all my lines to show up?
          Grant Perkins

          April,

           

          You have not said what your eventual output format is for and what it needs to look like but, based on the posted data, I would suggest that Customer data looks like the DETAIL for that report format and the Item and SLS Rep fields would be footer(s) data.

           

          It's a bit unusual to see it like that but if your objective is one row (record) with customer, product and SLS rep it looks likely to work from what you have posted.

           

           

           

          Grant