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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. tskelton

    cognos8 framework manager db2 SQL5001 error

    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...
  2. tskelton

    Importing Functions in ReportNet

    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...
  3. tskelton

    Checking for required values in Excel

    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!
  4. tskelton

    Checking for required values in Excel

    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...
  5. tskelton

    Politically Correct

    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...
  6. tskelton

    The Owner of SQL Server Database Views

    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...
  7. tskelton

    Pronunciation of "you're" and other contractions

    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! :-)
  8. tskelton

    Supposed

    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
  9. tskelton

    Supposed

    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...
  10. tskelton

    Rules (that DO work) won't run automatically

    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...
  11. tskelton

    Rules (that DO work) won't run automatically

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

    Delete Page in ReportNet

    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...
  13. tskelton

    Bursting Reports in ReportNet

    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...
  14. tskelton

    Bursting Reports in ReportNet

    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...
  15. tskelton

    Bursting Reports in ReportNet

    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...
  16. tskelton

    Changing default property values for select queries

    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...
  17. tskelton

    Repeating Group Headers

    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...
  18. tskelton

    Repeating Group Headers

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

    Repeating Group Headers

    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...

Part and Inventory Search

Back
Top