I'm using the standalone Report Designer, and I'm trying to export my report to Excel with each order line item on a separate sheet. My report has orders, and each order has one or more line items. Basically, our customer wants to see separate reports on each tab showing the order header data and the line item data.
I've seen suggestions to use the Report Book feature, but we're using the standalone designer, and the report book feature seems to be a programmatic solution. I need a solution I can implement in the designer.