Search results for query: *

Hi, I'm having difficulty with the following: --------------------------------------------------- SELECT COUNT (*) FROM OE_Orders AS s WHERE EXISTS ( SELECT * FROM OE_Orders AS t WHERE s.CustomerKey = t.CustomerKey AND t.CustomerKey= 1 ) GROUP BY...

Hi, I'm currently working on generating invoices with original content. However, non-relevant content needs to be blocked out. I've been able to block non-relevant information using formulas in the format field section for each row. However, when I run invoices for a period, Crystal will...

Good Morning...I need help. I have the following situation: In my details section I have a column with 5 years the first year is counted as 0 X 0 1 2 3 4 The total number of years is 5 on the formula summary section in the footer. then I need only the value of 5 to be used as a denominator...

Hello, I'm stuck! I want to create a report to that a rolling totals. Here's what I mean: Year Quarter Quantity Rolling total 2013 1 10 2 20 100 ---> 100 = 10+20+30+40 3 30 140 ---> 140 =...

Hi All, I have two summarized fields I need to add in a Cross Tab: Median @Cases Sold + PopStdDev @Cases Sold How can I create a third Column in the same Cross tab that adds these two up? Thanks in advance

Hi, I'm trying to generate a report that tells me all the items each customer purchased in the period of one year. I want to include this in my filter, so that we don't have to manually enter dates in parameters. Crystal does not give me a pre-defined Function for my purpose. I currently...

Hi all, I'm a new member and a big fan. I've come to an issue for which I haven't found a solution in any of the threads. Here goes... I'm using Crystal Reports 2008. I have a field in which there are numerical codes seperated by spaces (text string format). Each code has a value. CODE...