I have created a report with one subreport inside it. (using Crystal report 8.5)
The report shows list of orders placed by various customers.
The subreport shows items inside each of the order.

I chose "On-demand subreport" option so that the report won't burst into hundreds of pages.

I stored the report into another software that has embeded Crystal Report Viewer into it (the vendor said it is version 8.5) and ran the report, I can see the link for drill down but nothing happened when I clicked it.

I thought it was runtime problem so I disable the On-demand subreport option and used Crystal Report Viewer to see the report again. It showed the subreport (and yes, a few hundred pages)

Could anyone please suggest a solution so that I can drill down the subreport on-demand?

Many thanks,