IT Farmer
|
| Posted: 05/17/2003, 5:09 PM |
|
Ok,
I am baffled, no idea and I could use some help from you wizards out there.
I done all this:
I have three pages in Code Charge
1. Search Form
2. Result Grid
3. Export Grid
Have your Search Form(Page 1) go to Result Grid (Page 2) with normal search parameters in the input. In the Header of the Result Grid place this: <a href="Export.asp?{formparam">Export To Excel</a> Then in the Export Grid form Events Property "Open" (in CCS this is "on initialize view" )put this in:
'No Header or Footer needed
sHeaderFileName=""
sFooterFileName=""
'Change HTML header to specify Excel's MIME content type
Response.Contenttype="application/vnd.ms-excel"
But when exporting to excel I get all the records in the database and not only the one's in the GRID.
What do I do wrong? It looks like it does not uses the search return for creating the Excel Spreadsheet.
Thanks in advance.
|
|
|
 |
rrodgers
|
| Posted: 05/18/2003, 6:57 AM |
|
Make sure the where clauses are the same for both the viewable grid and the export grid are the same.
rob
|
|
|
|
IT Farmer
|
| Posted: 05/18/2003, 6:56 PM |
|
Rod,
I made a copy of the grid than changed the name and the color. But still does not work.
I assume the clause would be copied accross. But where do you check that ?
I am a rookie on this stuff.
|
|
|
|
|
