Search results for query: *

Hi drlex Many thnaks for the response - this seems to be the solution to my quandary! Again, thanks for taking the time to give me the guidance. Regards Phil

Cognos Impromptu (Version 7.1.724.0) Hi I'm creating a macro to open, run and export an Impromptu report - no problems here. My problem lies with the report itself - I'm trying to set the query criteria so it filters on the field [InvoicedOn] to be between Date-9 and Date-3 Example being -...

Cognos Impromptu (version 7.1.724.0) A couple of things I could do with pointers on; 1) I have this version on a desktop machine used solely for scheduling reports to created. The machine is on it's last legs and could give up the ghost any time now - so we've brought in a brand new machine to...

Should also mention I am using Cognos Impromptu V7

Does anyone know of a way (within macro/CognosScript) to trap the error generated when a report is opened and it's source catalog is open elsewhere. I ask becasue I have a report scheduler kicking out reports hourly. Each report is connected to it's own catalog, however, occassionally someone...

Excellent drlex From the sample script it could just be possible that I could do the whole nine yards from Cognos and ditch the VBScript route! It's got me thinking now, anyhow! :) BTW, whilst it's great working on my own here I miss being able to bounce any ideas around - so thanks for the...

Hey drlex - that was a very good pointer, thanks. Is it possible to have a Cognos script open (and execute) a VBScript? My VBScript encapsulates what I'm ultimately wanting to achieve in a Cognos macro; open an Excel file, refresh the data within said Excel file, copy & paste the worksheet to...

I've just started using Cognos having come from MS Access (and some SQL Server) environment. It seems the Cognos ScriptEditor is a very close relative to the VBA language, so I'm quite chuffed as I used to do a fair bit of VBA stuf and found very enjoyable! Scouring Google (and their groups) I...

Hi Gary, Many thanks for this - and pointing out the erroneous variable - you were indeed correct with the strExt -(sound of head banging against wall, table keyboard....!) Just started with a Company where I'm the only person doing the job - no-one to catch/critique the glaringly obvious...

Within Cognos ScriptEditor (Impromptu Version 7 Series 2), I have written some subs to perform a simple file copy. However, it doesn't compile and I get the sub 'ArchiveDataFiles' highlighted in red. All my Sub sets out to do is to copy two CSV files and dump them into an archive. I wrote the...