locked
How to create this subreport? RRS feed

  • Question

  • User-609535877 posted

    I try to create a SSRS report to display vehicle information for one owner which is one to many relationship in SQL, means the owner can own at least one vehicle and up to 5. How do I implement to show the vehicle information in subreport in following format? Thanks in advance!

     

    Plate No.                    State                           Year                            Insurance Code

    NY1111                       NY                               2016                            111

    Vehicle Make             Vehicle Model            Vehicle Color             Insurance Expiration Date

    HONDA                      CR-V                           GREY                         01/01/2017

    -----------------------------------------------------------------------------------------------------------------------------

    Plate No.                    State                           Year                            Insurance Code

    NY2222                       NY                               2016                            222

    Vehicle Make             Vehicle Model            Vehicle Color             Insurance Expiration Date

    FORD                         EXPLORER                GREY                         01/01/2017

    -----------------------------------------------------------------------------------------------------------------------------

    Monday, May 16, 2016 12:36 PM

Answers