Closing Pop upafter SQL query is executed

[karlmcauley]

I have three pages:
1. A reports main menu
2. a reports sub menu
3. a run reports page

basically the User selects what report they wish to run from 1. which fires up 2. in a new pop up window so the user can define criteria before running the report. Then they select run report on 2. which fires up an SQL query and page 3 (which displays the report).

First question: Page 3 is firing up within the pop up window (ie. page 2). This is much too small to display the report. How do i fire up a new window and display the results in a full screen. The run report button is a submit button based on a form with a post action.?? Any ideas. Do i have to incorporate the target parameter to the form?

2nd Question: If i wanted to fire up excel to display this information (from a sql query) is there an easy way to connect to excel and transfer the data?

Many thanks in advance

[karlmcauley]

Dave,

would this be alright or is the target meant to be different if you wish to fire up a different window to display the results of the form?

<form name="reportinfo" method="post" onsubmit="return validate(this.form)" target="_blank" action="run_reports.asp" >

And does <% Response.ContentType = "application/vnd.ms-excel"%> have to be between the head tags?

Thanks in advance.