3 Replies Latest reply: May 15, 2014 9:52 AM by Scott Johnson RSS

    Include column on second page

    Wayne _

      I have a report with the following format:

       

      Page 1

       

      111 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx 

      222 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx 

      333 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

       

      Page 2

       

      111 yyy

      222 yyy

      333 yyy

       

      I would like the ouput like this:

       

      111 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx yyy

      222 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx yyy

      333 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx yyy

       

      yyy is lined up directly under the first xxx column but does have a different heading. 

      How can I trap yyy to appear as a column at the end of the Page 1 data?  The report deals with sales people and each sales person has two pages like above.

        • Include column on second page
          Wayne _

          I have a report with the following format:

           

          Page 1

           

          111 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx 

          222 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx 

          333 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

           

          Page 2

           

          111 yyy

          222 yyy

          333 yyy

           

          I would like the ouput like this:

           

          111 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx yyy

          222 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx yyy

          333 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx yyy

           

          yyy is lined up directly under the first xxx column but does have a different heading. 

          How can I trap yyy to appear as a column at the end of the Page 1 data?  The report deals with sales people and each sales person has two pages like above.

          • Include column on second page
            Scott Johnson

            Well one way that would work would be to create two models, one that picked up the information on the first page and one for the second.  Export both of the results as two separate databases/tables and then join them together with the merge database options.  If the information in column A is the same on the first page and the second, this would be the field that you would use to join them together.  You would then have a table with all of the information together.

             

            Good Luck,

            Scott

            • Include column on second page
              Scott Johnson

              Well one way that would work would be to create two models, one that picked up the information on the first page and one for the second.  Export both of the results as two separate databases/tables and then join them together with the merge database options.  If the information in column A is the same on the first page and the second, this would be the field that you would use to join them together.  You would then have a table with all of the information together.

               

              Good Luck,

              Scott