8 Replies Latest reply on Dec 17, 2013 5:03 PM by MartyGlenn

    Invoice Report

    MartyGlenn

      Title

      Invoice Report

      Post

           I have an invoice file that has the following:

           Invoice line items (These line items are based on a conditional value list)

           When I do the report script see attached it all comes up fine but what I want to show under each class is the dates and times for each class.  As you can see from the relationship graph the classes are built out of parts.  The part for the life of me I cannot figure out:

           No matter where I place the TO for Class Date Time I cannot get these records to fall into the body of the report under its class.

           Marty

            

            

      Screen_Shot_2013-12-16_at_4.45.45_PM.png

        • 1. Re: Invoice Report
          MartyGlenn
          /files/13ca539188/Screen_Shot_2013-12-16_at_4.46.29_PM.png 879x160
          • 2. Re: Invoice Report
            MartyGlenn

                 Last Pict to help.

                  

                 Marty

            • 3. Re: Invoice Report
              SteveMartino

                   It's really hard for me to see in my minds eye what is going on here with all the TO's. I think you're picking the wrong TO for c_Course_Name.  You have this field selected from Classes Condition, and I wonder if it should come from Estivoice Line Items | Class |

                   Also in your script, why do you GTRR, new window, then in the next step, Go To Layout (same layout)?

              • 4. Re: Invoice Report
                MartyGlenn

                     Steve

                      

                     Thanks on the script step. fixed.

                      

                     on the other the basic thing here is two TO groups.  Top is how the classes are built. Name of class then add dates and times for that class.  (These are the data fields I want to follow c_Course_Name thru to the invoice within the body of the invoice under 'PART' sort by c_course_name from the LINE_ITEMS 'TO' which is attached to invoices.  Estivoice is the same name as invoice for this solution.

                      

                     the TO group at the bottom is the estivoice group and on the right are my attempts to get this to work.

                      

                     Basically I want an invoice that shows the course name and its dates and times for each class they sign up for on that invoice.  I hope this helps more.

                      

                     Marty

                • 5. Re: Invoice Report
                  symbister

                       this might not help - but exactly what does the sort do - what is it sorting on?

                  • 6. Re: Invoice Report
                    MartyGlenn

                         Got Milk.

                         See pict... Maybe that is the problem?   :)

                          

                         Marty

                    • 7. Re: Invoice Report
                      philmodjunk
                           

                                No matter where I place the TO for Class Date Time I cannot get these records to fall into the body of the report under its class.

                           There are only two ways to get a group of records in the body of a list view type report:

                             
                      1.           Base the layout on the table for those records.
                      2.      
                      3.           Use a portal to the table for those records.
                      • 8. Re: Invoice Report
                        MartyGlenn

                             Phil

                              

                             OK.  Thanks. The issue then becomes the invoice or c_Class_name but I will base the layout on that table and see if I can get the report to look as close to it as I need it but that helps.  Thank you again.

                              

                             Marty