Crystal Reports Subreport Using DataSets

Question

I use Crystal Reports XI with C# Visual Studio 2005. I am trying to create a subreport from a summary dataset. A simple example would be Company listing with Employees. I load the Company dataset (with CompanyId). I want to create a subreport which is linked by CompanyId whereby the dataset is loaded (obviously) on demand. I can create this subreport if I load all the detail into one monster dataset, but in my real-world implementation this would involve loading millions of detail rows (not an option).

Is there a way I can capture the SubReport event and load the dataset from my database connection? I basically want to intercept the subreport link call to build the dataset myself.