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
-----------------------------------------------------------------------------------------------------------------------------