Search results for query: *

I inherited a report which I need to make a revision and would like to do so without having to rewrite it. The report is currently grouped by customer segment and within segment each customer can have multiple orders. Here is an example of what the data may look like...

I was able to find this formula when searching through the threads. It seems to work but only if all of the columns have a value. My problem is that some columns have null values. I don't want to just convert them to a 0 but exclude them entirely. Any help would be greatly appreciated...

I'll try my best to explain what i'm trying to do. I have a report that returns several rows of data for each customer. My data is grouped by customer and I have been asked to display the minimum order date and the second order date. For example a customer that placed 4 orders but i only want...

I'm trying to insert a parameter which allows the user to input a list of email addresses for a certain date range and it will return a list of orders for those customers. I've looked at several other similar posts however have been unable to come up with a solution for the problem that I'm...

Sorry for such a long post but i'm trying to be as thorough as possible. Thanks for any help in advance. I have a very simple report which I need to create and am having trouble doing so. Heres what I need to do... Our Technology department has an excel spreadsheet which it maintains as new...

I am designing a report which the date field is actually a binary number. The table WM_ARTSEARCH2 was created on 12/31/03 and the data in binary field BIN goes back to 01/22/2004 which is binary # 22. I was able to create a formula: DateValue({WM_ARTSEARCH2.BIN})+37986 which I could use as a...

I am using Crystal XI and accessing an Access DB. I have a recurring report that I wrote however when I opened the report today and clicked the refresh button I received the following error. I am unable to determine what the problem may be. Can anyone please help me? Database Connector...

I created a dropdown list using a data validation table in Excel. My sheet look something like this. Both column B and D are empty and I would like to keep them this way for presentation purposes. I need my Vlookup to return the value in Column D based off the the value I have selected in...

I am using CRXI and reporting on an oracle db. I want to first apoligize for having such a long post however i wanted to include as much useful information as possible. I have done this before and somehow my report was deleted and I cannot remember the formula I used. What I am trying to do...

I am using Crystal XI and accessing an oracle db. I am attempting to show the value of multiple strings as one value in the group footer. I have grouped all orders by OrderID. For example my report is displaying the following data. ORDERID SUPPLIER TOTALCOST Item name 364849 ACC 98.55...

Using Crystal XI and am currently working on a very complex report (so I think). What I need to do is determine total revenue by customer based on which year their first order was placed. Sounds pretty easy. The catch is I only want a summation of the total revenue for each custmer from year...

I am trying to create a report that excludes certain data based on the value of another field. Basically this is what I need to do. The report is for company wide surveys and is sent to upper level managers. For instance I want to send the Adminstrators all employees survey results with the...