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!

  • Congratulations strongm 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. shricky

    how do I create a hierarchy of Prompts

    if the user chooses Prompt A then I want either one or the other to happen: 1) they go to another prompt page where the next set of prompts/questions are applicable depending on their choice in step 1 2) or if i could hide or make appear those prompts that are applicable when they choose...
  2. shricky

    Function that will increment a number by 1 each time

    i need it to perform like a "sequence" in Oracle at least conceptually. I am wanting some function that increments each row by 1 (almost acting like a primary key for that row).
  3. shricky

    How can I find patterns in Cognos

    I am wanting to find out if we have 5 skus (1,2,3,4,5) which skus people buy together. Any thoughts on that? Crosstab would be best and lays the report out correctly but it will only make a connection b/t the same skus. sku 12345 1 2 3 4 5 in this example, it will show the number of...
  4. shricky

    how to force a 0 for skus that don't have sales

    i have 10 skus and i am trying to find the customers that have not ordered some of the skus. so...if a customer has only ordered 2 of the 10, i want the sales of the 2 but 0 next to the SKUs they have not ordered. i cannot get this to work. any thoughts?
  5. shricky

    summing discrete values(?)

    that doesn't work b/c i am looking for a sum not a count...
  6. shricky

    summing discrete values(?)

    if i have 4 of a sku on order but the report is repeating that sku 4 times (b/c of the way the data is set up) is there a way to only have it give me a sum of 4 instead of 16? I can't use MAX or MIN b/c there will be times when I will need it to sum all the values if they are different.
  7. shricky

    Section Expert (Reset Page After) not working like I want

    It didn't work when i put it in. Group 1 H Status xx xx xx Group R Status all white space until the next page then detail starts xx xx xx
  8. shricky

    Section Expert (Reset Page After) not working like I want

    sorry, it is called "new page before". It does create a new page but there is a lot of "white space" in the output (which makes the report not look right). It only does this if the detail is more than one page for that group. if the detail for that group is <= 1 page then it formats it perfectly.
  9. shricky

    Section Expert (Reset Page After) not working like I want

    If Group 2 has multiple pages of data in it then Group 1 will not reset properly. I have a large gap (white space) in the report output if there are multiple pages to that section. If there is only 1 page in that section then it resets fine. any thoughts on how to fix this?
  10. shricky

    using substring in crystal

    how do i turn this into a crystal function? SUBSTR (col.user_1, INSTR (col.user_1, '.') + 1) I am asking it to find the . (10.34009) and return the 34009.
  11. shricky

    Cannot see my Stored Procedures

    I cannot see my Stored Procedures under the Schema I created it under in Database Expert. I have gone under Options and the "stored procedure" box is checked. Any thoughts?
  12. shricky

    finding orders who ordered in odd/even numbers

    How would I write a formula to show me a count of orders that were ordered in our minimum or multiples of the minimum? For example, if we require you to order a minimum of 2 of a Frame are our customers ordering 2,4,6,8 or are they ordering 2,3,4,5(b/c they only have to order the minimum and...
  13. shricky

    Last Year To Date by Month

    I am using Cognos 8, what function do I use or query calculation do I write to return last years data for a particular month? For example, I am trying to compare this years sales this month (current month) to last year's sales, this month last year. Since this month is May, I want to see...
  14. shricky

    Function for Week that pulls week number

    Actually that is very interesting. How do I link by the week?
  15. shricky

    Function for Week that pulls week number

    Thanks for the quick reply. Yes, that would work if I used my order_date, but I am trying to compare 2007 $ to 2006 $ and when I group it by the week function that pulls from the order date and it will not bring comparative results because of the year in the order date. So I want the week...
  16. shricky

    Function for Week that pulls week number

    I am looking for a function that will pull the week of the year outside of any date in the table. I want to group from the week and then my order_date will fall into the correct week buckets. Does that make sense?

Part and Inventory Search

Back
Top