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.
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.
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...
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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.