Search results for query: *

Hi, can anyone give me info on how to set up an Oracle 8.17.1 or 9.1.0 OLEDB database connection in Impromptu 6. I have tried setting it up but keep getting a 'ORA-12154: TNS:could not resolve service name' error. My connection string is "Provider=OraOLEDB.Oracle.1;Persist Security...

Hi, I'm running SQLServer 7 on Win2K and I'm suddenly getting an error when I try to export data from a table within the Enterprise Manager using the export wizard. I get 'DTS Wizard Error: CoCreateInstance - The Specified Module Could Not Be Found' Any ideas what could be causing it?

Hi, whats the best method of converting an Oracle date e.g. seconds from 01/01/1970 to a date/datetime in cognos impromtu 6 (version 6.0.506.0)? I currently use the following function (which I inherited from the bloke who had my job before me)...

Hi, whats the best method of converting a unix date e.g. seconds from 01/01/1970 to a date/datetime in cognos impromtu 6 (version 6.0.506.0)? I currently use the following function (which I inherited from the bloke who had my job before me)...

Just wondering... is there any way of doing a top 10 funtion in Impromptu? e.g. from a list of 100 products return the top 10 best sellers

Does anybody have a list of cognos impromptu 6 error codes? I had error 24608 in one of my macros yesterday but no idea what that error means cheers

I have several macros that save impromptu 6 reports to PDF format, however I have noticed that the file size is rather large... are there any option to make the published PDF size any smaller?

I have a report that references a dataset to exclude data from the report e.g. where not x in [dataset] (both using the same catalog) which works perfectly when opened in impromptu itself. However, when I write a macro to run the report and export the data so that it can be run nightly the macro...