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. StateYearInsurance Code
NY1111 NY2016111
Vehicle Make Vehicle Model
Vehicle ColorInsurance Expiration Date
As your need has multiple rows in each item, you could add two rows with values to show it. The following article shows a demo with a custom format and you could have a look.
Member
33 Points
152 Posts
How to create this subreport?
May 16, 2016 12:36 PM|zhao790|LINK
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
-----------------------------------------------------------------------------------------------------------------------------
Star
7970 Points
1586 Posts
Re: How to create this subreport?
May 17, 2016 08:47 AM|Weibo Zhang|LINK
Hi zhao790,
About creating sub report in SSRS, please have a look at below link.
https://msdn.microsoft.com/en-us/library/dd220581.aspx?f=255&MSPPError=-2147217396
As your need has multiple rows in each item, you could add two rows with values to show it. The following article shows a demo with a custom format and you could have a look.
http://oakdome.com/programming/SSRS_UsingSubReports.php
During this process, maybe you could refer to below link to learn how to pass parameters to the sub report if you need.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/92ea8f6b-ad27-42b9-a673-72ee9ce2d1fc/how-to-pass-parameters-to-ssrs-sub-reports?forum=sqlreportingservices
Best Regards,
Weibo Zhang