Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: richardh9920
- Order by date
-
Macro Hangs
I would suggest that you use anything (that's ANYTHING) other than the Cognos Script Editor to debug your macro. If you have it you can use Visual Basic (6.0 works fine and is 100% compatible). Failing that create a macro in MS-Excel and cut and paste your script into it. The reason you are...- richardh9920
- Post #6
- Forum: Cognos solutions
-
Force Impromptu to filter on database
Or, if you really want control over what is sent to be processed then you can edit the SQL directly and then save it. This way you can add hints etc. but you lose some of the drag and drop functionality of a normal report. The best way to do this is to write a report and get it pretty much how...- richardh9920
- Post #4
- Forum: Cognos solutions
-
Force Impromptu to filter on database
Change to the Profile tab and click on the SQL radio button. Then hold down Left-Shift, Left-Ctrl and Left-Alt all at the same time and left click the Edit button. This will take you into the "Magic Query" window where you will see what the "true" SQL is, i.e. what is going to be passed to the...- richardh9920
- Post #3
- Forum: Cognos solutions
