Sample Header Ad - 728x90

How to use a list in a list in report builder?

1 vote
1 answer
815 views
I'm currently using Microsoft SQL Report Builder to create a custom report for my data. I have a table of customers, a table of devices and a table of jobs (each customer has a couple of devices, each device has a couple of jobs). What I want is a list of customers, and when I click on a customer it should expand and show all associated devices, and when I click on the device it should expand and show all jobs. Should I just use a list in a list in a list? Or should I embed a subreport inside my list? Should I split all 3 tables in different datasets? Or just use 1 dataset? I imagine there are a lot of different options (I did my research online) but there seems to be little consensus about whether it's a good idea to use subreports or not for example.
Asked by Edeholland (113 rep)
Dec 5, 2016, 10:02 AM
Last activity: Dec 5, 2016, 06:47 PM