2 Replies Latest reply on Jun 3, 2013 9:40 AM by CG_1

    Report PARENT plus several CHILD

    CG_1

      Title

      Report PARENT plus several CHILD

      Post

           I have a parent table - SHIFT - that connects to other child tables, through ID SHIFT, SHIFT HOUR and TEAM RESPONSIBLE.

           On the layout, I have several portals to those child tables. Portals have several rows and don't work well on report because sometimes the rows are empty and don't slide up. Using the method of reporting a child table and add the parent's details isn't good to, because there are several child tables.

           How can I do this?

        • 1. Re: Report PARENT plus several CHILD
          philmodjunk

               Portals are able to slide up to remove unused portal row space, but fields within the portal row cannot slide up to produce rows of varying heights.

               If you can't get at least one portal to work for your report (You can base your layout on one of the two portal's tables), your options for getting the report to work the way you want it may get fairly complicated.

               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.
          • 2. Re: Report PARENT plus several CHILD
            CG_1

                 So, my bad. Portals work. I forgot to slide some titles, so the portals couldn't slide...

                 I guess I'm ok with this method, for now at least!

                 Thank you.