Reports download to Excel

[Bryan Harrington]

Ok.. the subject line is a little mis leading.. I don't have a problem
getting a recordset to download to excel..

The problem that I'm having is that the report page has a form to define
criteria, which then posts to itself. Logic in the page shows either the
form or the results. I can add code to download the rs to excel, but it
delivers the entire page. Obviously I don't need the header, nav, footer
etc.. does anyone have a suggestion to only get a portion of the page? I
really don't want to physically duplicate the page without the included
files.. but that's my plan B. Part of the problem physically duplicating the
pages is that the SQL strings are dynmic based on date ranges and other
selection criteria, and have the potential of being upwards of 1224
characters in length.

Your thoughts are appreciated.

Thanks!

 

[Ray at]

What header and nav stuff are you talking about? HTML links in your page?
Why not use the same logic that determines if form or results should be
displayed to also control if that stuff is displayed?

Ray at work

 

[Bryan Harrington]

<quote>Why not use the same logic that determines if form or results should
be
displayed to also control if that stuff is displayed?</quote>

SLAPS Forehead....

duh.. why didn't I think of that.. it's been a long day..

 

[Bullschmidt]

In general a bunch of If Then Else statements around code that sometimes
should show up and sometimes should not might be helpful.

Best regards,
J. Paul Schmidt, Freelance ASP Web Consultant
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...