Putting Query Data Into Page Footer

rpolunsky

I need to run a query to fetch back-end information and put the resulting string in the page footer. Of course, the footer cannot contain data-bound elements, so I want to run a query in the report initialize event then put one column of that query into a global report variable. I assume I can then put a reference to that variable into the master page footer.

What I haven't been able to do is write a generic SQL query that will run in the context of the initialize() event. Is this possible?

mwilliams

Hi rpolunsky,

You should be able to grab data from the dataSet in the dataSet's script, store it to a variable, and display it in the masterpage.