Search results for query: *

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

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

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

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?

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.

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?

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.

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?

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

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

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?