reports

how to have a frame header for the report

[natty]

hi there,

i am moving some of our access reports onto the web..
the reports are running fine, thats not a problem..
however, i am wanting the headings for the report in its own frame.. which is also working fine, but at the moment, im calling the frame page that hold the report and its header with a querystring, - depending on the report im using.

<frameset rows="20,*" cols="*" frameborder="no" border="0" framespacing="0">
 <frame src="reporthead.asp?rp=<%=savrp%>" name="reportHead" scrolling="no" noresize>
 <frame src="<%=rp%>" name="reportMain">
</frameset>

at the moment the reporthead.asp , is a page that cases through all the reports and picks out the headings that way..
but this means that the heading data is duplicated in two places,(the reports themselves have hidden layers that are seen only when printing) meaning any changes also have to be in these two places..
so the question again.. can i either generate a page of the column headings on the fly or write to that page at runtime..
or ofc a better suggestion would be much appreciated.

many thanks

nat

[txbakers]

You can pull the column headings from a database at run time as well, based on the QueryString.

Make the entire report dynamic!

However, if Access is your back end you run the risk of gradually slowing down the server until it crashes. It's an Access limitation.

There are threads below which address this.