Recent content by milmand

Anyone? I never expected this to be such a problem, but it seems that theer is no solution to this rather basic requirement? Please help!

Hi all, I am trying to show values that appear in AS in alphabetical order and do not see any options in FM for doing so. When I initially set out to do that, I assumed that it would be a very easy thing to do, but it is proving to be a PITA. Am I missing something? Please help! Many thanks.

Good news! I just got a reply from cognos support technitian who actually knows what he's doing! Here's his solution that I tried and it works: QUOTE:____________________________________________________________ To get in straight to a report one has to call the report newsitem, run the report...

Menno, I am stuck! I've looked through the Upfront Dev Guide and do not see any reference to passing the user's Upfront login credentials! I was expecting to find it in chapter 4, but it's not there. Please help! Thanks. Dmitry.

Menno, Thanks a lot for your reply. Please forgive my ignorance, but where do UID and PW go? Thanks. Dmitry.

Current situation: A JAVA application uses a custom servelet to take users from its GUI to the appropriate Upfront page based on the user's security credentials. After that, user must select a report to run. I need to know if it is possible to bypass that user class's main report page and to...

Guys, Thanks for helping me out on this one. Here's what I will do: (hope it works) In order to avoid creating new user classes and adding filters to them in the catalog, I will have only 3 major user classes. I will create a security table in the DB with "UID", "REPORT" and...

Dave, I am already using the script to update both, the catalog and the Access Manager/LDAP security. The problem is that I can only execute this script at night, when there are no users runing reports. If I run the script while there are reports running, the script fails because it is unable to...

Dave, I'm glad you answered my post. I saw lots of good answers from you in this forum. To answer your question, yes, I am using catalog user class object to apply filters. Unfortunately, due to the way my company does business, I have to create a user class for each individual user - that's...

The situation: - A company has more then 10,000 users. - Each user can only see his own data. - All users use a set of 20 IWR reports. - A new user may be added or the existing user may be changed at any time. - In order to implement security on what basically is a User level, a user class was...

My IWR server constantly accumulates orphan jobs. These jobs do not go away by themselves and require extensive manual intervention in order to kill them. I am sure everyone who uses IWR has had this problem. In my case, these jobs overload the server and prohibit automatic catalog updates...

Dave, Thanks for your reply. Unfortunately the report gets its data as one string, so there is only one column. I am using Currier New, and also, I tried to play around with the stored procedure that builds the string in order to adjust spacing between values. None of this helped, because...

Virtual memory errors usually occur when too many applications are open. Your macro should probably execute reports in succession and not all at the same time. If that does not help, increase RAM on the cognos server. Given the info you provided, these are the only two answers that come to mind...

I have the following situation: Impromptu report has to have values located in precise positions on the page in order to be printed to a specialized printer. Data for the report comes from a stored procedure that returns a ref cursor. I tried to use combination of database-specified spacing and...

Check out Cognos Macro Language documentation. It (the language) is very similar to VB and can sometimes pasted into VB and executed.