Recent content by atomictortoise

Hi All, I have just installed Cognos Express 64 bit on Windows server 2003 64 bit SP2. I am trying to create a Data source to an IBM iSeries using the IBM Client Access 64 bit ODBC drivers. I understand that for this to work I need both 32 bit and 64 bit ODBC drivers installed and identical...

Many thanks I'll give that a try.

Hi Has anyone got a macro script example of how to save a.ppx file as an Excel spreadsheet? I see lots of examples of saving .imrs but not .ppx. Any help much appreciated

Thanks Ties for your suggestions.

Hi All, Can anyone tell me how to solve this problem. I have 3 queries in my report which provide summary values for 'Sales' 'Purchases and 'Labour' I need to calculate a margin value which is 'Sales' - ('Purchase' + 'Labour') however for certain types of sale there may be no purchases and in...

I am getting a process running on my SQL Server (2005) which is obviously kicked off by Cognos 8. This process consumes 100% of the CPU for over 3 hours before ending itself. It then kicks off again approx 1 hour later. This repeats constantly. The SQL statement that it runs is as follows...

Hi Lex, Thats great I'll give it a try. Thanks Martin

Hi All, Has anyone got an example of a script that can dynamically change the labels in special time categories? I have a special time category with child categories that are generated using a custom time calculation. I have currently got the category labels manually created eg. Current Month...

I need to be able to render Function Keys in dialog boxes so that they appear as buttons. However the default rendering set restricts the recognition of Function Keys to rows 23 and 24. How do I set up custom rendering for dialog boxes? Hope someone can help. Martin