Search results for query: *

Thanks Cognoise I think I solved the problem. It looks like some of the calculated fields in the drill-thru report must also exist in the main report. It is strange, but this acts something like the powerplay drill thrus. I had to redo the drill thru - basically made a copy of the main report...

I have dealt with IWRs and drill thrus for a number of years. Somtimes, I notice that a particulr report's drill-thru comes up blank (it used to work before). The problem does not get solved even if I republish or even rename the folder, the reports etc before publishing. Does anybody know...

Thanks DrLex. That was really something. Question: Can this sql (in Magic Query) be edited and re-edited?

Thanks Dave again, I will try your suggestions and will let you know how it pans out. Rgds

Hi Bajwa, Yes, it can be done in one page, provided you use JavaScript or ASP (or something like that), and use frames. You can't do it using Cognos' Dynamo manager (I think). But using frame sets are pretty cumbersome. Rgds

Thanks Dave, From your response it looks like I won't be able to get exactly what I want. For example, if I were to select only 2 managers, I would possibily get South, South, East, East in the second prompt. I was hoping, if I could get distinct values: South, East in the second prompt...

Hi there, I have researched into all the discussion on cascading prompts, and followed them. But I still have a problem. Here is the scenario, suppose: Prompt 1: Manager (I have a long list) Values: Tom, Harry, Jane Prompt 2: Area Values: North, South, East, West (A manager can have...

Thanks Gary. I thought so too, just took a wild shot.

I have a question, and am not sure if it is possible to accomplish this in Impromptu (7.2)? Basically, what I would like is for the user to be able move the mouse over a particular ID (ID is a column in my imr) and a text bubble would show up and give a small description or comment about the...

Thanks mp9 for all the help.

Thanks VBSlammer, This is another great post. I will test it out this evening, and modify it to do what I have in mind.

Hi VBSlammer, That was really great. I just tested it out, and it works like a charm. Thanks a lot for your help and you deserve a star, the reason being, I have more or less searched this and other sites, and many have offered solutions, but this was the most straight forward, and extremely...

I have a question on compacting. Originally, I had one db. But when I would run some macros, I would have to compact again in midprocess. The macros run series of queries that bulid tables, and append to existing tables. So, I broke it up into a frontend and backend. The backend still need to...

Hi, I use the Hal scheduler to compact and run some macros. How would I use the scheduler (or the Windows scheduler) to close Access completely. I tried using Application.Quit acQuitSaveAll in the scheduler, but it just doesn't do anything (no errors, and doesn't close it). Is there a macro...

Well, you can insert a calculated filed in the header of your report, and use a formula like this count(Distinct(ID)) where ID is a field. --Ram

Hi Mark: This is directly from the COGNOS Support Link. Hope this helps. Also is it possible for you to share the Cognos script. Just would like to see how it was dealt with. Thanks, Ram ******* From Cognos Support Link Here’s a technique that you can use to you to automatically display a...

Hi I have a power prompt application with two prompts. The first one is Status with options Active, Expired, Closed. The second prompt is called BudgetYear, with options 2000, 2001, 2002 etc (for years). When I run the application in IWR, both the prompts come out fine, but frequently the...

Hi Mark I don't think there is a way not to show the blank pdf. What I have done is to use conditional formatting that displays a message "no records listed ..." when the report is blank. This works fine, as the user can specify (if using prompts) some other conditions. If you are interested...

Hi AndrewPaul: I have worked with powerprompts for a while, but still struggling with it. From what I have read so far (not tried it), it is possible to have the prompts in one page if you use frames. You can use borderless or invisible frames for the prompts and I guess show/hide the frames...

I tried this. I had a couple of power prompts and then had a data-range prompt in Impromptu. The power prompts work, but not the date-range. My guess is they won't work together. Its one or the other.