Search results for query: *

Hi, I have been using simple formulas for my reports and now my boss has asked to add time to this formula. Before: The requirement was to pull stats from yesterdays data, formula below: {W000001.DATETIME} = currentdate-1 Now: Requirement is to pull stats from 2 days ago at 4pm all the way...

I am very new to Crystal and usually use MS Execel. However, when outputting this report automatically I'd like for the report to remove duplicate lines, instead of surpressing them. How do I do that? Here is the example. Raw Data: Date-Time-Item-Account 3/16/2011 - 12:00PM - Orange - 001...

Hi all, This is probably easy but I've spent 30 minutes in the Format Editor-Number-Customized menu and can't figure it out. My output is without decimal places and I require two in the field. However, I want to place it within the existing data, I know I can just add them to the end but...

Hi, Just looking for a simple month formula that will filter all data from the quarter. (ie last quarter from today Oct 16- Dec 16) {TABLE.KEY_DATE}=currentmonth -3 Hopefully there is a easy solution for this, thanks!

I don't know if this is possible but please let me explain and let me know if there is a formula for it. Here is a simple example, time=column 1, fruit=column 2 Time-Fruit 13:00-Apple 14:00-Oranges 13:00-Apple 15:00-Grape 16:00-Apple I want a formula that will remove the duplicate...

Hi all, My question is how do I create a date/time formula that runs for the current/yesterdays business day. I want the formula to pick up data from yesterday 3pm to today 3pm. This is the formula I have in the system now: {ABC.EVENT_DATTIM} in DateTime (2010, 10, 27, 15, 00, 00) to DateTime...