Sage 300 - Sage Intelligence - drill-down functions

I have built a financial balance sheet report and an income statement using the demonstration report designer template. I want to be able to distribute these reports via email or file publish and have the end-user be able to drill-down on the data without needing Sage. How do I fix my report so it allows me to do this? I believe my issue is that my report data is pulling from a live data connection but I don't know how to fix this. Any solutions?