Parameters in Business Actvity Query

Yahoo Archive
1
Since you're wanting to export into Excel anyway, try this...
Connect to the database using ODBC in Excel with M.S. Query.
Then setup the query parameters there.
You can set the query properties to automatically refresh each time the file is opened and/or fill down adjacent cells with formulas, etc...

________________________________

From: vantage@yahoogroups.com on behalf of midwestsigncompany
Sent: Wed 12/28/2005 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Parameters in Business Actvity Query



Has anyone been able to set up a business activity query that asks for
parameters?

I need to get an excel spreadsheet of my electronic deposit
informaitno to import into my ACH program and don't really want to do
it through Crystal if at all possible.

Teresa Davis
Sign Productions






Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links










[Non-text portions of this message have been removed]
2
Has anyone been able to set up a business activity query that asks for
parameters?

I need to get an excel spreadsheet of my electronic deposit
informaitno to import into my ACH program and don't really want to do
it through Crystal if at all possible.

Teresa Davis
Sign Productions