Recent content by waugh

I know for a fact that: 1. Group on server is not checked. 2. The query on it's own via Query Manager works fine. 3. I'll remove groups and try again. I think if I supress that grouping the error message goes away. Michael Doig http://www.coastart.net/mike I have a pretty damn good website.

Crystal 8.5.0.217 and a transactSQL database. Michael Doig http://www.coastart.net/mike I have a pretty damn good website.

I don't have a formula yet because I don't know how to accomplish this. When the previous post asked me to choose summary options after right clicking the formula field, I right click "a different" formula field so I could investigate what summary options do. Can a formula be written...

I can get my grouping and output peachy. At runtime I get an error 523. Crystal reports this as an invalid group condition. I found a site that said grouping on date fields cause this. It made no recommendation.

Is there anyway to get around this? I have yet to find a site with an actual solution. I have a report called Credit Card Deposits. What it does is grab all transactions that have a CC transaction type, then lists the cards and what their respective sales were for the day. Example: August 11...

This is a formula field. I don't have Summary options when right clicking.

And another question I have: A retail store has 5000 SKU's. Within all those SKU's are items that are similar, for example Pepsi/Coke/Sprite may all be represented as soda. Example: SKU 0001 Soda Pepsi Qty sold 150 SKU 0002 Soda Coke Qty sold 250 SKU 0003 Soda Sprite Qty sold 350 How...

Here's what I am trying to do. A customer has items that range in retail price. An example is: Item 1 - $4.95 Item 2 - $5.95 Item 3 - $6.95 Item 4 - $7.95 I am using DISTINCTCOUNT({db.Price}) to get a value of 4, the 4 different price points. Now I want to get a count of price points greater...