So far what I did to fix this was basically repeat the Search action by a
hyperlink at the top of the page that adds the search args from the form to
in hyperlink string. That way I have the args in the post arg that excel
uses. This works seems like a kludge but the fault seems to be with excel.
Any other thoughts?
I have another report that uses no form input arguments so that one should
be fine right?
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com
> From: Dan Stein <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Wed, 23 Oct 2002 11:55:43 -0400
> To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]>
> Subject: Witango-Talk: Witango and Web query from excel
>
> I want to use the web query function in excel to pull in a resultset table
> from our witango site.
>
> In excel when you choose web query opens browser fine and we can navigate to
> report and run report. Table returned is the right data based on the
> criteria entered in the search action criteria from the form submit prior to
> the search.
>
> We choose the table for import but when it then does the import it bring in
> all the data in the table ignoring the criteria in the search action.
>
> Is there a way around this or do I have to use the file write action and
> create a file to then import into or open in excel.
>
> Dan
> --
> Dan Stein
> Digital Software Solutions
> 799 Evergreen Circle
> Telford PA 18969
> Land: 215-799-0192
> Mobile: 610-256-2843
> Fax 413-410-9682
> FMP, WiTango, EDI,SQL 2000
> [EMAIL PROTECTED]
> www.dss-db.com
>
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
>
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
