MS Query SQL File Location
 

OS: XP, Excel 2000, Oracle 8-I

I have written an Excel Dashboard. I am constantly making
changes to it and need to pass it around in the office.

I store it on a shared network drive and dont have any trouble with the
Excel file, however the SQL Query file is stored on my computer and always
defaults to a path ending in the folder Queries.

I must physically go to the recipients computer and complete the process to
get it to work.

The next update to the Excel file requires starting the process over again.

How can I force the Dashboard to always look to the shared drive
for the SQL Query?

Thanks in advance.

--
Richard

MS Query SQL File Location
 

Take a look at the code that runs the Query......you should be able to change
it there......if not, post that section of the code and we'll take a
look......

Vaya con Dios,
Chuck, CABGx3


"Richard" wrote:

OS: XP, Excel 2000, Oracle 8-I

I have written an Excel Dashboard. I am constantly making
changes to it and need to pass it around in the office.

I store it on a shared network drive and dont have any trouble with the
Excel file, however the SQL Query file is stored on my computer and always
defaults to a path ending in the folder Queries.

I must physically go to the recipients computer and complete the process to
get it to work.

The next update to the Excel file requires starting the process over again.

How can I force the Dashboard to always look to the shared drive
for the SQL Query?

Thanks in advance.

--
Richard

MS Query SQL File Location
 

Not sure what you mean by "the code that runs the query but here's the query.

Is this what you mean?

SELECT CONCAT(BOOKING.LDATE,BOOKING.SCHEDSTATUS), COUNT(BOOKING.LDATE)
FROM TRAPEZE.PROVIDERS PROVIDERS, TRAPEZE.BOOKING BOOKING WHERE
(BOOKING.LDATE = TO_CHAR (SYSDATE -5, 'YYYYMMDD') ) AND (BOOKING.LDATE
<= TO_CHAR (SYSDATE +6, 'YYYYMMDD') ) AND BOOKING.PROVIDERID =
PROVIDERS.PROVIDERID AND (SUBSTR(PROVIDERS.PROVIDERNAME,1,2) = 'KC') GROUP BY
BOOKING.LDATE, SUBSTR(PROVIDERS.PROVIDERNAME,1,2) , BOOKING.LDATE,
BOOKING.SCHEDSTATUS ORDER BY BOOKING.LDATE,
SUBSTR(PROVIDERS.PROVIDERNAME,1,2), BOOKING.SCHEDSTATUSNot sure what you --

Thanks in advance.

Richard


"CLR" wrote:

Take a look at the code that runs the Query......you should be able to change
it there......if not, post that section of the code and we'll take a
look......

Vaya con Dios,
Chuck, CABGx3


"Richard" wrote:

OS: XP, Excel 2000, Oracle 8-I

I have written an Excel Dashboard. I am constantly making
changes to it and need to pass it around in the office.

I store it on a shared network drive and dont have any trouble with the
Excel file, however the SQL Query file is stored on my computer and always
defaults to a path ending in the folder Queries.

I must physically go to the recipients computer and complete the process to
get it to work.

The next update to the Excel file requires starting the process over again.

How can I force the Dashboard to always look to the shared drive
for the SQL Query?

Thanks in advance.

--
Richard

MS Query SQL File Location
 

I'm getting ready to leave for the weekend, but quickly.....if you would turn
on the Macro Recorder and then do Data GetExternalData CreateNewQuery,
and then run through the steps you took to create this query, it should
produce a macro that contains path information to the file you're using. It
appears you are using "TRAPEZE" but the query contains no path so it looks to
the default local drive.......maybe you could fix it by just adding a path to
the existing Query, but I have not done that so can't say for sure if it
would work. Sorry I can't give more specific help now........if you try the
macro and run into trouble, post back, and someone will help, but this is a
difficult area withoug being hands-on.

Vaya con Dios,
Chuck, CABGx3



"Richard" wrote:

Not sure what you mean by "the code that runs the query but here's the query.

Is this what you mean?

SELECT CONCAT(BOOKING.LDATE,BOOKING.SCHEDSTATUS), COUNT(BOOKING.LDATE)
FROM TRAPEZE.PROVIDERS PROVIDERS, TRAPEZE.BOOKING BOOKING WHERE
(BOOKING.LDATE = TO_CHAR (SYSDATE -5, 'YYYYMMDD') ) AND (BOOKING.LDATE
<= TO_CHAR (SYSDATE +6, 'YYYYMMDD') ) AND BOOKING.PROVIDERID =
PROVIDERS.PROVIDERID AND (SUBSTR(PROVIDERS.PROVIDERNAME,1,2) = 'KC') GROUP BY
BOOKING.LDATE, SUBSTR(PROVIDERS.PROVIDERNAME,1,2) , BOOKING.LDATE,
BOOKING.SCHEDSTATUS ORDER BY BOOKING.LDATE,
SUBSTR(PROVIDERS.PROVIDERNAME,1,2), BOOKING.SCHEDSTATUSNot sure what you --

Thanks in advance.

Richard


"CLR" wrote:

Take a look at the code that runs the Query......you should be able to change
it there......if not, post that section of the code and we'll take a
look......

Vaya con Dios,
Chuck, CABGx3


"Richard" wrote:

OS: XP, Excel 2000, Oracle 8-I

I have written an Excel Dashboard. I am constantly making
changes to it and need to pass it around in the office.

I store it on a shared network drive and dont have any trouble with the
Excel file, however the SQL Query file is stored on my computer and always
defaults to a path ending in the folder Queries.

I must physically go to the recipients computer and complete the process to
get it to work.

The next update to the Excel file requires starting the process over again.

How can I force the Dashboard to always look to the shared drive
for the SQL Query?

Thanks in advance.

--
Richard