3 Replies Latest reply: May 15, 2014 9:52 AM by Grant Perkins RSS

    Staggered Output

    Nick Osdale-Popa

      My table looks as such:

      [font="courier"]Folder                            Report

      -


         -


      /Accounts Payable Dept                  Receivers.rox

      /Accounts Payable Dept                  UnconfirmedPOs.rox

      /Accounts Payable Dept                  VendorLabels.rox

      /Accounts Payable Dept/Vendor Statements   Detailed Vendor Statement-By Job.rox

      /Accounts Payable Dept/Vendor Statements   Detailed Vendor Statement-Known Vendor Number.rox

      /Accounts Payable Dept/Vendor Statements   Detailed Vendor Statement-UnKnown Vendor Number.rox

      /Accounts Receivable Dept             excBilling.rox

      /Accounts Receivable Dept/Billings        excBillClosing.rox

      /Accounts Receivable Dept/Billings        excJobBilling.rox

      /Accounts Receivable Dept/Billings        excVendorList.rox

      /Admin                            appLACUSC.rox

      /Admin                            CostCodeYTDHours.rox

      /Admin                            DeleteArchives.rox

      /Admin                            ReportDriver.rox

      /Admin                            ShowArchives.rox[/font][/quote]I can get a summary to display as such:

      [font="courier"]Folder                            Report

      -


         -


      /Accounts Payable Dept                  Receivers.rox

                                  UnconfirmedPOs.rox

                                  VendorLabels.rox

       

      /Accounts Payable Dept/Vendor Statements   Detailed Vendor Statement-By Job.rox

                                  Detailed Vendor Statement-Known Vendor Number.rox

                                  Detailed Vendor Statement-UnKnown Vendor Number.rox

       

      /Accounts Receivable Dept             excBilling.rox

       

      /Accounts Receivable Dept/Billings        excBillClosing.rox

                                  excJobBilling.rox

                                  excVendorList.rox

       

      /Admin                            appLACUSC.rox

                                  CostCodeYTDHours.rox

                                  DeleteArchives.rox

                                  ReportDriver.rox

                                  ShowArchives.rox[/font][/quote]However, I'd like to stagger the second column like this:

      [font="courier"]Folder                            Report

      -


         -


      /Accounts Payable Dept

                                  Receivers.rox

                                  UnconfirmedPOs.rox

                                  VendorLabels.rox

       

      /Accounts Payable Dept/Vendor Statements

                                  Detailed Vendor Statement-By Job.rox

                                  Detailed Vendor Statement-Known Vendor Number.rox

                                  Detailed Vendor Statement-UnKnown Vendor Number.rox

       

      /Accounts Receivable Dept

                                  excBilling.rox

       

      /Accounts Receivable Dept/Billings

                                  excBillClosing.rox

                                  excJobBilling.rox

                                  excVendorList.rox

       

      /Admin

                                  appLACUSC.rox

                                  CostCodeYTDHours.rox

                                  DeleteArchives.rox

                                  ReportDriver.rox

                                  ShowArchives.rox[/font][/quote]I don't see an option to allow an offset like this.

        • Staggered Output
          Nick Osdale-Popa

          My table looks as such:

          [font="courier"]Folder                            Report

          -


             -


          /Accounts Payable Dept                  Receivers.rox

          /Accounts Payable Dept                  UnconfirmedPOs.rox

          /Accounts Payable Dept                  VendorLabels.rox

          /Accounts Payable Dept/Vendor Statements   Detailed Vendor Statement-By Job.rox

          /Accounts Payable Dept/Vendor Statements   Detailed Vendor Statement-Known Vendor Number.rox

          /Accounts Payable Dept/Vendor Statements   Detailed Vendor Statement-UnKnown Vendor Number.rox

          /Accounts Receivable Dept             excBilling.rox

          /Accounts Receivable Dept/Billings        excBillClosing.rox

          /Accounts Receivable Dept/Billings        excJobBilling.rox

          /Accounts Receivable Dept/Billings        excVendorList.rox

          /Admin                            appLACUSC.rox

          /Admin                            CostCodeYTDHours.rox

          /Admin                            DeleteArchives.rox

          /Admin                            ReportDriver.rox

          /Admin                            ShowArchives.rox[/font][/quote]I can get a summary to display as such:

          [font="courier"]Folder                            Report

          -


             -


          /Accounts Payable Dept                  Receivers.rox

                                      UnconfirmedPOs.rox

                                      VendorLabels.rox

           

          /Accounts Payable Dept/Vendor Statements   Detailed Vendor Statement-By Job.rox

                                      Detailed Vendor Statement-Known Vendor Number.rox

                                      Detailed Vendor Statement-UnKnown Vendor Number.rox

           

          /Accounts Receivable Dept             excBilling.rox

           

          /Accounts Receivable Dept/Billings        excBillClosing.rox

                                      excJobBilling.rox

                                      excVendorList.rox

           

          /Admin                            appLACUSC.rox

                                      CostCodeYTDHours.rox

                                      DeleteArchives.rox

                                      ReportDriver.rox

                                      ShowArchives.rox[/font][/quote]However, I'd like to stagger the second column like this:

          [font="courier"]Folder                            Report

          -


             -


          /Accounts Payable Dept

                                      Receivers.rox

                                      UnconfirmedPOs.rox

                                      VendorLabels.rox

           

          /Accounts Payable Dept/Vendor Statements

                                      Detailed Vendor Statement-By Job.rox

                                      Detailed Vendor Statement-Known Vendor Number.rox

                                      Detailed Vendor Statement-UnKnown Vendor Number.rox

           

          /Accounts Receivable Dept

                                      excBilling.rox

           

          /Accounts Receivable Dept/Billings

                                      excBillClosing.rox

                                      excJobBilling.rox

                                      excVendorList.rox

           

          /Admin

                                      appLACUSC.rox

                                      CostCodeYTDHours.rox

                                      DeleteArchives.rox

                                      ReportDriver.rox

                                      ShowArchives.rox[/font][/quote]I don't see an option to allow an offset like this.

          • Staggered Output
            Grant Perkins

            Nick,

             

            You do find them don't you!    

             

            The only thing that comes to mind at the moment is to engineer things in a such a way that you get a blank Report field somehow and retain it as a valid field in the table.

             

            If you don't have that possibility in the original input (I doubt you do) one option might be to process the file once to extract just the folder information (or path up to and including the folder info) and export that. Then concatenate it back to the main input file.

             

            With luck that would give you your 'blank field'  but at the risk of an incorrect count  - if that is important.

             

            I keep wondering if there is some way of juggling the summary but I think not for your purpose. Or indeed any other. May have missed something though.

             

            If you have any fields 'spare' - i.e. they get extracted but you filter them out -  it might be possible to convert one of them to an empty Report name and include THAT in the table.  If you see what I mean. Unlikely that you will have the data do that I would guess.

             

            HTH.

             

             

            Grant

            • Staggered Output
              Grant Perkins

              Nick,

               

              You do find them don't you!    

               

              The only thing that comes to mind at the moment is to engineer things in a such a way that you get a blank Report field somehow and retain it as a valid field in the table.

               

              If you don't have that possibility in the original input (I doubt you do) one option might be to process the file once to extract just the folder information (or path up to and including the folder info) and export that. Then concatenate it back to the main input file.

               

              With luck that would give you your 'blank field'  but at the risk of an incorrect count  - if that is important.

               

              I keep wondering if there is some way of juggling the summary but I think not for your purpose. Or indeed any other. May have missed something though.

               

              If you have any fields 'spare' - i.e. they get extracted but you filter them out -  it might be possible to convert one of them to an empty Report name and include THAT in the table.  If you see what I mean. Unlikely that you will have the data do that I would guess.

               

              HTH.

               

               

              Grant