Search results for query: *

Mike and poujor thank you for your help. At this point I have some understanding of what I am doing and will post back after taking time to figure out exactly how to formulate things. I tend to use the Record Selection Formula and that is why I have more problems.

I do not receive this error in my testing file - does it highlight one line or the other (or a portion of one line) when it returns the error? - Not sure In the field explorer, right-click your datasource and check the "Show Field Type" box - what data type is {W000001.DATETIME}? (I would...

Hi Mike, When I type this in, here is the error I receive 'a date-time is required here'? {W000001.DATETIME} >= {@Test} AND{W000001.DATETIME} < CurrentDate I inputed the formula no problem into the formula fields, but am unsure how to use this formula in the select expert. Sorry for begin...

Hi Mike, So how do I plug this into the formula? //Provide a lower bound for selection criteriaDateTimeVar TriggerDate:=CurrentDate-2;DateTime(Year(TriggerDate),Month(TriggerDate),Day(TriggerDate),16,0,0) Selection Criteria works no problem: {W000001.DATETIME} >= {@YourNewFormula}...

Hi Mike, Well I know we have some weekend work, so it would be 7 days a week, but if you could post both formulas that would be a great help to me. Thanks!

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

Hi Bellkras I cannot seem to get this to work. When I go to insert it asks for one field, how am i to insert the 4 fields and have them remove all duplicates? Thanks

Sorry Bellkras, I'm still a newbie to Crystal and am not sure hwo to group these fields together. Do I go to Insert-Group? How do I select all the fields? Thanks again for your help.

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

Sorry, after trial and error I was able to implement your formula, thank you for your help!

Sorry, I'm still a newbie to Crystal. When I input the formula: ToText(({WRK.AAMT_001}/100), 2) The system gives me the error 'A number, or currency amount is required here.' The field is definitely numbers, so i'm not sure why this is happen.

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

Thanks for your help, that worked out perfectly!

That did not work. Is it something as easy as changing 'currentdate' to 'currentmonth' or am i way off line?

Hi, Sorry for bringing this back up from the dead. Was looking for a formula that pulls data from the month before. The other posts here do not work, I've been trying to change this to make it work. Please let me know where I went wrong. {TABLE.KEY_DATE}=currentmonth -1

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!

Hi turkbear/LB, I've tried totext({WB3.KEY})+{WRKLOB.ACT} However, it doesn't appear to do anything in the output even though I am able to input it in as a formula without error. I'm a beginner at this, can you define what "totext" does?

So from your example just put the two fields in the formula to eliminate duplication? totext{WB3.KEY}+{WRKLOB.ACT} I tried a variation and it states that "there is an error in this formula. Do you want to save it anyways?

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

Thank you briangriffin