8 Replies Latest reply on May 15, 2013 10:50 AM by kioaxis

    report with multiple levels?

    kioaxis

      Title

      report with multiple levels?

      Post

           Hi,

           I have created a database to collect job specific data.

           The structure of the data base is as follows

      Job #, Description, Date, Customer, Contact

      Group #, Description, Notes  ( multiple Per job )

      Station, Desc, Width, Height, length, depth ( Multiple per Group # )

      Car, Desc, Notes, Photo ( Multiple per Group # )

      Position, Desc, width, height, lenght ( Multiple per Car )

           I am trying to create a cmprehensive report that is saved as A PDF document that contains all the data related to the job.

           I can understand how to create a report that has this structure:

      Job #, Description, Date, Customer, Contact

      Group #, Description, Notes  ( multiple Per job )

      Station, Desc, Width, Height, length, depth ( Multiple per Group # )

            

           or this structure:

      Job #, Description, Date, Customer, Contact

      Group #, Description, Notes  ( multiple Per job )

      Car, Desc, Notes, Photo ( Multiple per Group # )

      Position, Desc, width, height, lenght ( Multiple per Car )

            

           but not the complete structure:

      Job #, Description, Date, Customer, Contact

      Group #, Description, Notes  ( multiple Per job )

      Station, Desc, Width, Height, length, depth ( Multiple per Group # )

      Car, Desc, Notes, Photo ( Multiple per Group # )

      Position, Desc, width, height, lenght ( Multiple per Car )

            

            

           can anyone proide an example or some guidance?

            

           Thank you

           Antonio

        • 1. Re: report with multiple levels?
          IT_User

               Hello,

               So if you put Station fields right above the Car fields, does it not show the correct information? (just curious)


               Also, you might have to have the structure like this: (even though Car isn't actually under Station), because the report mgiht look more ogranized this way.

          Job #, Description, Date, Customer, Contact

          Group #, Description, Notes  ( multiple Per job )

          Station, Desc, Width, Height, length, depth ( Multiple per Group # )

          Car, Desc, Notes, Photo ( Multiple per Group # )

          Position, Desc, width, height, lenght ( Multiple per Car )

          • 2. Re: report with multiple levels?
            philmodjunk

                 You may be able to set up a list view type summary report based on Position and use a portal to Station to list the data from the Station table. There are limits to what you can do with a portal in a report (size it many extra rows in height and set it to slide up | resize enclosing part), but if you can get that to work, it's the simplest approach toward getting what you need here.

            • 3. Re: report with multiple levels?
              kioaxis

                   Thank you IT_User, But Station and Car are at the same level.

              • 4. Re: report with multiple levels?
                kioaxis

                     Thank you, PhilModJunk, I will give this a try.  Will the portal auto adjust for the number of rows in the station table that is associated to the current group?  

                      

                For example on group might have 5 stations and the next 23.  Givent that the intent is to print ( or save the report ) as a PDF, it would be nice if it adjusted.

                • 5. Re: report with multiple levels?
                  philmodjunk

                       If you set a portal to "slide up", "resize enclosing part" on the Inspector's position tab, it will reduce in size to just the number of portal rows needed. The trick is to make your portal many rows taller than you ever expect to need. You might even use a count of the related records in a calculation field or conditional format to display a warning if you ever exceed that maximum number of rows just to be safe.

                       Key facts about sliding layout objects:

                         
                  1.           It's only visible in preview mode and when you print/save as PDF...
                  2.      
                  3.           Sliding fields will shrink but not expand.
                  4.      
                  5.           All layout objects below and in the same layout part as the slide/resize field need to also be set to slide up and resize.
                  6.      
                  7.           Objects in headers and footers will not slide.
                  8.      
                  9.           Portals will shrink/slide to fit the number of rows of records, but fields within the portal row will not shrink/slide.
                  10.      
                  11.           Fields will slide up only if Top alignment is specified for it and will slide left only if Left alignment is specified.
                  12.      
                  13.           Consistent side borders are difficult to achieve with sliding fields.
                  • 6. Re: report with multiple levels?
                    kioaxis

                         Hi PhilModJunk,

                    Much apprecited.  This is exactly what I needed.  This all makes sence. 

                    I have tried to: set a portal to "slide up", "resize enclosing part" on the Inspector's position tab,

                         Unfortunaly it does not seem to to shrink (reduce in size) to displsy only the number of rows needed. 

                         I have turned off the " Show vertical scroll bar"

                         set up number of rows for the portal to be 25

                         my test records are 7 in one instance and 4 in another and only 1 in another.  Howerver the dportal still displays enough space for 25 records.

                         Is there anothere seting that I am missing?

                          

                         Thank you for taking the time to look into this.

                          

                    • 7. Re: report with multiple levels?
                      philmodjunk

                           Were you checking the results in Preview or Browse Mode? Sliding is only visible when you Preview, print or save as PDF.

                      • 8. Re: report with multiple levels?
                        kioaxis

                             Thank you PhilModJunk

                        That was it, Just re read your instruction and was just about to respond.

                        Your help is much appreciated.

                        Best Regards