3 Replies Latest reply: May 15, 2014 10:13 AM by ricklesgolf _ RSS

    New User Needing Help With Staggered Fields

    ricklesgolf _

      I am a new user and have created a few reports without any problem but this one is giving me problems.  I have a pdf report that has staggered fields like:

      Field 1, Field 2, Field 3, Field 4 (Record #1)

                           Field 3, Field 4 (Record #2)

                                      Field 4 (Record #3)

      Field 1, Field 2, Field 3, Field 4 (Record #4)

                           Field 3, Field 4 (Record #5)

                           Field 3, Field 4 (Record #6)

                           Field 3, Field 4 (Record #7)

                Field 2, Field 3, Field 4 (Record #8)

      FYI  My fields on my PDF are aligned unlike this post.

       

      I need Field 1 data to be repeated until the next Field 1.  I need Field 2 data to repeat until the next Field 2 and the same for field 3.  Below is how my data should look:

       

      Field 1, Field 2, Field 3, Field 4 (#1)

      Field 1, Field 2, Field 3, Field 4 (#2) (Fields 1 and 2 from #1)

      Field 1, Field 2, Field 3, Field 4 (#3)  (Fields 1 and 2 from #1 and Field 3 from #2 )

      Field 1, Field 2, Field 3, Field 4 (#4)

      Field 1, Field 2, Field 3, Field 4 (#5) (Fields 1 and 2 from #4)

      Field 1, Field 2, Field 3, Field 4 (#6) (Fields 1 and 2 from #4)

      Field 1, Field 2, Field 3, Field 4 (#7) (Fields 1 and 2 from #4)

      Field 1, Field 2, Field 3, Field 4 (#8) (Field 1 from #4)

       

      I hope this makes since.  How would my Template be set up to do this?  Thanks