Search results for query: *

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

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

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

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