Search results for query: *

In Excel this can be done by sumproduct. I am just wondering if this is possible by Crystal?

On details section are the order lines. They are grouped by Sale order number. {@total} is sum on Sale order number group. I have following formulas: {@Undelivered}: If IsNull({Table.Delivered_Quantity}) Then {TableElement.Quantity} Else...

Hi All, Im trying to create a barchart that displays order backlog. Main idea of the chart is that on current month it sums whole backlog {@total}. Next month it shows whole backlog {@total} except those orders which {@shipday} is on the first month, and so on. Basically I have the...

Hi again, So is it possible to calculate average on your own daterange. If that isn't possible how about based on recordnumber. Then average on the records 1 to 5, 2 to 6, 3 to 7 etc.... Don't really need to know if either is even possible. Arde

Hi, I am making a report of our maintenance time. How can I make chart that calculates average based on last 3 months. Data: {@FixingTime}=number (how many days the device was on repair) {@RepairDate}=date (date when the device was repaired) Chart idea: month1 =average({@FixingTime}) of...

Thanks LB for your help. The formula {table.revisionno} = maximum({table.revisionno},{table.offer}) worked to hide the smaller revision numbers, but it still calculates the data from all revisions. Ie. subtotals from all revisions. How can that be stopped?

So, the basic idea is to look each order by saleordernumber and group them by confirmed and delivered orders. ie. saleordernumber customername subtotal profits date confirmed group 100 Custname 4$ 30% 2009.1.1 delivered group 100 Custname...

The fields that i have or I can count are. {@deliveredAmount} {@UndliveredAmount} {@SaleOrderNumber} SaleOrder.status (1=confirmed, 2=partly delivered, 3=delivered) etc. I tried to use the SaleOrder.status as to group the orders, but I can't figure how the {@deliveredAmount} and...

Hi, Can one data cell be separated into two cells? I am making a report where partly delivered saleorders needs to be in both confirmed and delivered saleorders. Example: Saleorder number is x and saleorder total is 10$ where delivered amount is 6$. 4$ needs to be in confirmed saleorders...

No it's access db and CR is 2008. Do I need to make the group first?

Hi, How is it possible to show only the biggest datacell. In one cell there is Offernumber and on the next cell is the offer revision number. How can I show only the one offer number where the revision number is the highest. All Offer numbers don't have revision number. example offer N:o...

I'm trying to connect to Oracle database by OLE DB (ADO) -> Microsoft OLE DB Provider for Oracle. What is Service? I'm using CR2008 server.

Hello, I am using ODBC (ADO) /SQL to connect to database. In my report I use the fields of our ERP-program. The problem is that I need the fields that are specified in the ERP-program as string, but the values are dates and there are some random text too. I only need the fields that are dates...

It works if the cell only reads Maintenance, but in the end there is number of the order i.e. Maintenance 100, Maintenance 101, ...

Hi I am using database where in the comments cell there is a string value Maintenanceorder z, if the order is maintenance and empty or random text if the order is Stock order. In the report I need to categorize the orders by letter: M=Maintenance order S=Stock order But when the comments...