Data Warehouse on the web

Home

Rql

RqlServer

Our Services

RqlServer FAQ

Presentation

Our Clients

Our Partners

DW3 Staff

Contact Us

ISP-clients

På svenska

RqlServer - FAQ

0001 How do i get Excel files to open in Excel and not in Internet Explorer
0002 What is needed in the web server to use SQL job administration in RqlServer
0003 What is needed in the web server to make Excel graphics work
0004 Hidden links in Excel

 

0001 How do i get Excel files to open in Excel and not in Internet Explorer

In explorer, Tools, folder options, file types, go to Microsoft Excel kalkylblas (.XLS), Advanced, uncheck "Browse in same window".

0002 What is needed in the web server to use SQL job administration in RqlServer

Microsoft SQL "Client Components" has to be installed. Note: SQL Job administration in rqlServer uses "SQL Server Distributed Management Objects", which is installed among other SQL components.

0003 What is needed in the web server to make Excel grahics work

If Excel-charts is not displayed in we pages, it may be due to "Graphics filter" for GIF-files are not installed. Use Control panel, Add/Remove programs, Microsoft Office, shared components select Graphics filter and select GIF-filter.

0004 Hidden links in Excel

An Rql formula in A2 may give problems with links if A1 has something else and A1:A2 is merged, Excel keeps the formula in A2, but it can no longer be visible since A1:A2 are merged.