Search results for query: *

One last piece of advice. Build the filter one element at a time, testing after each one. Depending on the use of wildcards, greater than or less than items, dates, etc, you may build one incorrectly or filled in improperly and if you try to build all 25 at once you won't know which one blew...

Damzi, actually they are all AND clauses connected in the filter and by using LIKE with the wildcard "%" it flows smoothly. I wish I could cut and paste the filter, but it won't let me. Here is part of the sql code after I ran it for a single project. where T1."PROJ_F_TOT_AMT"<=500000000...

This is a sample of the prompt for a report I have. I feel inferior, it only has 13 prompts in all. :-) Enter Start Date Less Than or Equal To: 2006-10-01 Enter End Date Greater Than or Equal To: 2001-10-01 Contract Type: % Project Number: % Customer Number: % Funding Source: % Project...

Maybe I'm off track and thinking too simplistically, but if you use the LIKE command and default in the wildcard "%" allowing the users to fill in only the prompts they wish to use. If some of them are date fields or dollar values, you can set them to extreme dates for >= or <= so that...

... or instead of modifying an existing style, just create a new one.

OK, this still doesn't "remove" the column and column header but I found a solution for Gary's "grayed" out column header issue. Use the conditional format as you were for the column itself. Then for the column header, go into conditional formats, click on STYLES, pick one at random such as...

Generally that means it's a continuation of grouped data from the previous page if you're looking at a printed report.

Coincidence, I'm attending a Cognos training session and they provided us a copy of their SupportLink magazine that comes out quarterly. In the Jan-Mar issue, I was thumbing thru and they have a helpful hint that helps with this. The article is entitled Multiple Type-in Prompt Report in...

Betty the best/easiest/possibly the only way to do this that I'm aware of is by using headers or footers. Group on your vendor name (or whatever you're using as your key grouping such as vendor ID) and place the data items as you'd like in either the header of footer for that grouping. I've...

Mike, I just noticed your response on 4/2... if memory serves me (and I can't promise you that it does), but you should be able to upgrade the catalogs and reports straight from v4 to v6 without going thru v5. I just looked thru my thin notes and I even have noted that with one particular...

Mike, I had the same hopes and questions when I went thru it 2 years ago. Unfortunately at that time, and I'm willing to bet it's the same situation, you have to upgrade them one at a time. Upgrade the catalogs, then upgrade the reports one by one. I had over 1,000 reports to do. Sorry to be...

Those are the options. Depending on how many customer numbers you have (which appears to be in the hundreds of thousands), a catalog picklist probably won't work, there are limitations to the number of rows it can show in the picklist. I've had similar needs and the workaround I used was to...

FYI to all who are interested. The agenda, seesions and travel information is now posted on the Cognos website for the upcoming User Conference being held in Orlando, FL June 27-30.

Thanks Dave, yes, I was hoping to avoid using the &quot;upper&quot; function because I'd have to check all 1700 of my imr's to see if they have grouping on the project number. I'm trying to get my system admins to try to get everything in upper during the upload process so it's a moot point on...

I am conjuring up the great minds of Impromptu to guide me (actually to save me from hours of searching for an answer). Dave Griffin, I'm willing to bet you have the answer on the tip of one of your brain cells. I have reports gathering data from Costpoint by Project. Apparently in some of...

benbotektips, you're right that putting the zero test before the division should/does work occassionally, but we found that in 6.0 and higher, doing it the way griffindm stated is more reliable. It had something to do with a list footers problem. We found this out the hard way... staring at...

Holy cow, what a useful tool! All of these years crossing my eyes looking at the SQL or .iqd .....

First of all, this question came from my boss, so don't laugh at the messenger... He's wondering what language capabilities Impromptu has... for &quot;translating&quot; into other foreign languages. My gut reaction is that Impromptu merely pulls data from databases, therefore it's up to the...

Hi Dave, thanks for the response. In the iqd, a samplie piece of it shows like this in both the working and non-working output files: ((substring('08550.001' from 10 for 1)) IS NULL)) THEN (T4.&quot;L2_proj_name&quot;) So, it's treated it as a NULL in both cases, I thought maybe we were on...

For those of you using Impromptu in conjunction with Costpoint databases, have you had this issue come up. We just upgraded from Costpoint 3.0c to v4.0. All has been fine overall, however had an issue come up yesterday where the following data def that has worked fine for 3 years (prior to the...