Search results for query: *

I use an iSeries Access ODBC Driver to connect to DB2. In the configuration for that ODBC driver, under the 'Server' tab, there's a naming convention drop-down with 2 choices: *SQL or *SYS. My ODBC drivers have always used *SQL with Cognos products. You may already know this, but what that...

I'm unable to see a list of my database functions in the Import Metadata wizard in Framework Manager. I see tables, views, and procedures -- and am able to select and import those objects -- but no functions are listed, and never have been listed. I'm connecting to a DB2 iSeries database. I...

Just a note to let you know that I'm still working on this project. I'm having a few issues, but soon I'll post the solution I came to with a lot of assistance from your code. Thanks a bunch!

Using Excel, let's say I have a spreadsheet with 6 columns of data, 4 of which are required. In database terms, these 4 columns make up my composite key. Branch Month Year Contract Salesperson Amount 101 9 2005 1234 Judy 100.00 (The column names above in bold...

My (white) South African friend talks of his obtaining US citizenship often. He would then be, literally, an African-American! But to distinguish himself from black African-Americans, maybe he should be an African-American of European ancestory. That could be a great conversation starter for...

goofaholix, If I'm understanding your problem correctly, you need to take one more step. First, start with a fresh copy of your original catalog. Then delete the folders from the catalog: Catalog...Folders, then click on the Cut button for each folder. Now delete the views from the catalog...

If more people pronounced it with 1.5 syllables as indicated by ESquared and Genimuse, we probably wouldn't see as many misspellings such as this: "I see that your in line for a promotion." Or maybe I'm just an eternal optimist! :-)

Dimandja, I think you're exactly right about writing phonetically. However, I like to think that people pay more attention to detail. Oh well.... [ponder] -Todd

First of all, I have been lurking in this forum for quite some time. I share your affinity for language. Thanks for your thought-provoking questions and comments. My question regards the use of the word 'supposed' in informal usage. An example: I am supposed to go to lunch at 12:30 today. I...

Is it possible that other rules are interfering with your rule in question? I noticed that neither sample rule has 'stop processing more rules' as the last line of the rule. You can check the checkbox for this option at the same point where you select to move the message to a specific folder (at...

Could you post the rule? For example, in the Rules and Alerts window (OL 2003), what is in the Rule description box? -Todd

When you position your pointer over the Page Explorer area, a "popup" window appears and you can see a folder called "Report Pages..." that contains all the pages of your report. Click on the "Report Pages..." folder. A "pages" window appears and lists all the report pages. Select the page you...

Thanks, Phil, for the info. In working with Cognos support, we discovered that bursting does not work with cross-tab reports, and the report I need burst is a cross-tab report. Cognos development confirmed this finding. Bursting works great for me on list reports, however. Now I get to...

UPDATE After re-reading (and re-re-reading) the documentation, I believe the Burst Recipient section should read as follows: Burst Recipient Query: Leads Region Query Item: userid Type: Directory entries I have changed this setting, but the report output didn't change. It still shows all...

I am trying to burst a report on Region and am having no luck. Users are signing on to CRN using our WinNT namespace. Those users receiving this report have been included in a burst table on the database with the following columns: username real_name region In Framework Manager, I have...

Hi, all. We use Access for querying and reporting of data that's in an Oracle-based datamart. After researching the subject of query performance, we have observed marked improvement in our query performance by changing the RecordSet Type in the query propery sheet from DynaSet (the default...

Kathryn's solution worked for me. Do you have the Repeat Section property set to "Yes" for the header? I did. Here's how I think it works: The header is simply repeating, not being calculated, when you want "Continued" to appear. A portion of the detail section has already...

Kathryn, Your suggestion worked like a charm! I never even thought of using a record count. Thanks for your advice! :) -Todd

Hi, all. I would like to format my report so that if the detail section spills over to the next page, the word "continued" appears in the text box that's in the group header. In other words, on page 1, the group header says something like "California". Then the detail section...