Search results for query: *

Yeah, I thought of that, I was just hoping to avoid it. Thanks everyone for all the help

OK, this is perfect, but one thing. Is there anyway I can display this in the report header?

I am using Crystal for VS.Net 2003. Beyond that, I cannot tell you the version number. It wont let me create a running total for it. I am not sure how to go about redesigning the report to get around this.

I am running Crystal for Visual Studio.Net. I need to sum a formula for an entire report. The field is just calculating the discount of an order and it looks something like this: if left({discount},1) = "$" then tonumber(mid({discount},2)) else if left({discount},1) = "%" then...

Worked like a charm, thanks so much. BP

The products table is the master table for SKUs Table: Inventory Products LineItems Field SKU many - one SKU one - many SKU Field quantity quantity

Crystal Version: Visual Studio.Net Package Datebase: MSDE (SQL Server basically) Sample Data: small numbers, just adding 1 + 2 + -1, etc Expected output SKU On Order On Hand Product 1 4 5 Product 2 1 0...

Here is the situation: I am attempting to design a report that will show the products on order as well as the quantity on hand. I have 3 table I am working with: Products Table, LineItems Table, and Inventory Transactions (this is where our on hand comes from) table. I need to sum the...

The Setup: I have a small business network setup I'm working on with a D-Link DFL-80 separating the internal network from the T1 (which is split between two buildings upstream). On the DMZ side of the firewall, I'm running a server with 8 sites pushing an average of about 8-12 kilobits/second...

Thanks so much, worked like a charm BP

I am needing to write a report that essentially is a receipt. Our database stores a discount as a string. Depending on if the discount is a percent or dollar amount, the date is stored with a preceding identifier. For example: $10 for a dollar amount discount %15 for a percentage discount...