Search results for query: *

Is there a way to specify in the macro, which version of Power Play you want the report opened with? I tried in the object to use openreport (application.cer4) not the exact snytax, but I am away from that computer right now. But just changing the .cer4 .cer3 etc did not make any difference...

In Impromptu 7.3, Cognos did away with save as Excel Without Format. This has caused the formats of DateTime and loss of column sorting or top 10 after opened in Excel. Do you have any tips how you got around this? I have searched the Cognos site and have not found any helpful hints...

Dave, Thank you very much for the reply. Yes, we do have support and I logged a call. Cognos will help me this morning. Whew!!

Do I have any options? The catalog is not huge and could be recreated with moderate effort, but someone did not even create an "icr" file for me to follow. Thanks!

I can think of 2 possibilities. Open the query and select the filter tab. Check the box for remove duplicate lines. Or if you have any sort/groupings you may be getting a total line for the group and a total line for the report. If that is the case you can delete one of the totals from the...

Hi drlex, The only advantage is that the image person does not know how to stop transformer from being loaded on every machine. It is included in the download file and says everything in the download should be put on every machine. When I load power play user manually, I select the default...

Thanks all. Drlex, hahaha on another vendor. I am so far down on the decision making chain, it is like the unseen life forms in the ocean. lol Well, I guess if I don't get it clarified by the vendor, the image guy will just install everything from the download on all 300+ machines. I...

Oh, I forgot to say that the version included in the user download is actually called Transformer (personal edition) and the version included in the admin download is actually called Transformer. In the power play help there is a comparison of the 2 versions. The main difference I see is that...

May I shift this question instead of creating a whole new thread? While installing Power Play 7.3 we found 2 versions of Transformer. One in the "ppuser" download and one under the "ppadmin" download. The ppadmin version is more powerful and is more to do with Web. So, do both of these...

Yes, navshiv, I did mean "edmacro32", since he wants to create a macro. Thanks for the correction.

Maybe in your organization you do need admin rights to create macros. Are you sure you cannot get to Cognos -> Tools ->Cognos script editor? In Explorer it would be something like C:\Program Files\Cognos\cer?\bin\runmac32.exe. I don't want to get you into trouble, but at our place we allow...

jv, This is rare, that I might actually be able to help someone else. I have received lots of good help here. This is what I use going from a Plumtree portal to an Impromptu report on a Cognos Web server. It will only work inside our firewall. url=...

Hi, I found an answer to this. I added this line to the macro sendkeys "(ESCAPE)" But now some of the reports stop because of a warning that I am using a different catalog than the original. Of course I am. I have to update in parallel directories to do testing before I put into production...

We are upgrading to Cognos 7.3 and have many many reports to upgrade. Cognos Website has a macro to update all reports in one directory, but the macro will not work with prompts. Is there any way to simulate hitting the Escape Key to bypass prompts and then save? That is how you would get...

I have created a report and an unrelated sub report. Each can be one or many pages based on the data. We only have Impromptu Web reports, not Report Net. C Sharp system calls Impromptu through URL so user can view the report and then print. The user does not like drilling through to the...

I have a request of a form and thougth frames were the best way to go, but feel free to make other suggestions. The report is to be printed and the user wants something like this. Heading proj:___________ Name: ____________ Unit:________...

DoubleD, Thanks for taking the time to reply. I am getting frustrated with this. lol I understand that I need a password, I just don't want it to be the Cognos Admin id and password. In my current case, I only want to view a PDF of a scheduled report. User class only has Read, although I...

There is a great thread in the history that should be able to help you. http://www.tek-tips.com/viewthread.cfm?SQID=633026&SPID=401&newpid=401&page=1 The problem I am having is this works great as long as you supply the ADMIN login and password. I don't really want that password floating...

http://bbidat01/cognos/cgi-bin/login.cgi?action=login&signon=user&password=user&return_url=%2Fcognos%2Fcgi-bin%2Fimrap%2Ecgi%3FIU%3DIMRAP%26KID%3D20%26PSRV%3D-4242494441543032-8020--2F636F676E6F73-11743-2-- I got the URL to work as long as I use the administrator id & password, but when I...

Thank you for this whole thread. I just had a requirement for this exact URL. Success for me too! This works great. Mary