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

    Newb questions

    To follow up, here is an actual Case statement, where I am getting an error, apparently on the "substr" part of the code. Background: we use financial periods instead of months. The field [Current Fiscal Period] is a 6-character field in the format 201107 for the current period. Here is the...
  2. PaulP2

    Newb questions

    Thank you very much. On a more general note, is there any written resource that will cover these kinds of syntax questions? The few books out there don't seem to get very good reviews. Paul
  3. PaulP2

    Newb questions

    I am migrating reports from Crystal 11 to Cognos 8.4, after one week of training. I am having a lot of trouble, and I can't seem to find resources, other than forums, that will help with the detailed syntax questions that keep coming up. For example, why does this sample code test ok case when...
  4. PaulP2

    How can I account for the "dreaded" null when doing a dist count

    The last phrase of the second-to-last paragraph should read "and doesn't subtract when thare are [b]no[\b] empty values.
  5. PaulP2

    How can I account for the "dreaded" null when doing a dist count

    I just joined this board to research this exact problem, so I am really glad to see a recent thread on this. I seem to have been inspired by what I read here to stumble on a solution (at least it seems to work in my report): Create a formula @formulafieldnull if @formulafield = "" then 1 else 0...

Part and Inventory Search

Back
Top