Not sure if the title is exactly the right heading for this topic but it's the best way I can describe it. I'm curious if it's possible, like the dynamic dashboards (I'm about to watch some videos on that topic), to use a single Excel report template to generate a report based on the currently displayed values. Here's what I'm trying to do.
I have a client who has something like 50 commercial tenants, each one with an electric submeter. I'm going to build a quick dashboard for these tenants using the dynamic displays so that the tenants can log in and see their usage data and some stats. My client has requested that the tenants be able to download a report based on this data. The data would all be the same for each tenant, just the name and point data would differ. Maybe Excel reports aren't the way to accomplish that?
Thank you again, always saving my butt!