@Drill Down' on ASP Generated report

[PaulSc]

Hi,
I wonder if I can ask for some help/guidence please..

We have a small ASP based system whereby a customer can select various report options from a menu, input parameters and then be displ;ayed a 'report' (Table) containg their data.

This is actioned on a SQL Server 20000 database using stored procedures and works fairly well.

One facilty they require is the ability to 'drill down' further into the displayed data.

i.e 5 rows containing ref no, date, owner,description are diplayed initially but further information such as location, phone numbers etc needs to be displayed if a record is clicked.

Our idea is to have a small graphical + button in the first column which when clicked opens another form displaying the full record?

How would it be best to achieve this effect?

Any help/suggestions would be appreciated.

Regards and thanks

PaulSc.

 

[link9]

This is one of the main things we do here at my company, as well.

One option is to open that extra information in a popup window. Our users really like this because the parent page is still there, and they really haven't gone anywhere, just get extra info when wanted.

How I achieve this is to make that little link/graphic/button a javascript function link. So for example, the javascript might look like:

function popWin(val1,val2){
var url = 'pop.asp?val1='+val1+'&val2='+val2;
var x = window.open(url,'popWin','height=200,width=200');
x.moveTo(50,50);
}

Now, of course, you may need to send additional or fewer arguments to the function. Maybe even just key information for the row that you're on, but you get the idea, right?

On each row as you're writing the data, you write out the link to look like this:

javascriptopWin(1,2)

or whatever, so that pertinent information about that row goes into the javascript function as arguments, and when clicked, the popup window is opened, sending those arguments as querystring parameters.

Then, on your popup window, you pick up those parameters, hit the database for the information tied to them, and display it to the user.

hope that helps!
paul