Recent content by stevehamby

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...

Tried that, still not working... oh well, backup database and install a new instance of sql server (again)

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?

I solved the problem myself, though its a bit of a cludge. The formula is now... datetime-to-date(days-from-1900-to-datetime((order_date/86400)+25568.001)) which forces the number of decimal places I need for it to be accurate.

The problem is that during the date conversion Impromptu rounds the calculation to 1 decimal place... thus making the date conversion inaccurate...

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)...

Sorry, not unix, Oracle dates

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

that worked wonders navshiv... from a 441kb file down to a 6.3kb file :-)

Ta Dave :-)

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?

it does work... just make sure they are only 256 colour bitmaps tho... pretty pointless exercise but you do get sick of sitting and waiting for that damned fish to stop swimming ;-)

The problem is not in the report. If I open the report in Impromptu it works fine and I can export it, etc... However, when I try to open the report from within a cognos script macro the report fails with an error number of 24634. I copied the macro into VB to see if the problem lay in the...