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

    Can the output of one report be the parameter for another report?

    I had a random number of records concern last month where I needed 25 random Entry Numbers for the previous month. I also wanted several line level pieces of information from another 1 to many table. My IT gura could only do it for me if I didnt want the line level data, so now I get a...
  2. jeffreygreen

    Need to filter on ASCII characters

    COGNOS 8.4 In report studio - I have users that enter a site code, which is supposed to be a 5 character, alpha numeric code. They continue to screw this up. I can filter for Length <5, but I need to filter for characters that are not 0-9 or a-z or A-Z. Any thoughts of how to do this? I see...
  3. jeffreygreen

    Report out random records

    I have about 10,000 +/- 400 or so records that get uploaded to my COGNOS DW a month. Then monthly, I have to audit 25 of them, at RANDOM. So what I have been doing is dumping out all 10,000 to Excel, running EzQuant (random number generator) to give me 25 random numbers from 1 -10,000. Then I...
  4. jeffreygreen

    Report Studio Criteria for Date Range = Current Month # minus 1

    I run reports every month, for the PREVIOUS month. I always run them between the 9th of the month and the 15th of the month. Currently I have a prompt for Month Number, but with the number of reports I am beginning to run, I would like to be able to have the date range criteria (filter) be the...
  5. jeffreygreen

    flagging inconsistent text fields based on previous row

    I have a report I run and i sort this list by Part number. I have an SPI column next to my part number and all similar part numbers should have the same SPI indicator (usually "MX" but could be a few others . . . so i will just say if "row" 15 is populated at all, and row 16 has the same part...

Part and Inventory Search

Back
Top