Recent content by msi30502

Hi, this is a proprietary program that was developed by Aspen Systems. They included a report generator that allows me to creat reports using SQL expressions.

Almost there. The values are now 4, which IS the total number of stops. See attached

My appologies I incorrectly typed OE_Orders.OrderDate where I should have written OE_Orders.InvoiceDate In your code, Where OrderDate = '08/06/2021' And RouteCode = 12 you assigned hard values. I need it to pull the values from my parameter settings. How can I do that?

Just tried it and didn't work: It assigned each transaction/invoice a default value of 423, then summed by customer and by grand total (see attached) Select COUNT(DISTINCT CustomerKey) From OE_Orders Where OrderDate = OE_Orders.InvoiceDate And RouteCode =...

Okay, let me back up. I have two tables AR_Customers and OE_Orders. AR_Customers is just the list of customers with basic information (name, number, address, etc.) OE_Orders holds information about each order that is processed (product, prices, item codes, etc.) They are both linked by the...

Is this what you mean? SELECT COUNT (*) FROM AR_Customers AS s WHERE EXISTS ( SELECT * FROM OE_Orders AS t WHERE s.CustomerKey = t.CustomerKey AND t.CustomerKey = 1 ) Because the result is still zero.

Thanks for the Reply @Andrzejek. To answer your questions/comments, 1. When I select a particular customer code I get zero. 2. "Why here is an Order By?" - I copied the code from another website and filled in the blanks. After your question, I removed the GROUP BY. 3. I don't mind getting...

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

Thanks LB worked out beautifully! [pc2] I don't know why I didn't think of that before? Your the best!

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

Thanks for the reply, but that's not going to work. I din't want to complicate things further, but the year numbers are derived from a number formula not from the database itself. They are actually formulas using global and shared variables. So, I wanted to simplify by just extracting the...

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

By the way, I'm using CR 2008

Sorry guys this didn't come out looking right. Please see attached file.https://picasaweb.google.com/lh/photo/77dVV_H07do6Th-WBIbu7dYHTvCxFQZKv3vDnTu-4lg?feat=directlink

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