Search results for query: *

Thanks guys that information helped alot and the report is working. Instead of calling it date() I called it datetime()= currentdate. Thanks again for your help. I knew it was something small.

How can I get a report to pull information on a currentdate.. For example if I run a report (today) it would give me stats from today's date and today only. I have tried (date.field) = currentdate, I also tried (date.field) = today...none worked. I know it is something simple..i just can't put...

Thanks again svampire, i modified my report to your formula equaling the year of the currentdate. Thanks again you have been a great help!!

I got it to work guys by doing this, it just came to mind: year(Time call received)= [2002] and then grouped the field by month... Thanks for your help anyway svampire...

What is a good formula that would pull data for me starting from the beginning of the year(2002) to date (today). For some reason I tell crystal to give me data for example: {Time Call Received} in YearToDate and it is only pulling up dates from the start of year to May 7th which is not what I...

I am having problems with this business days formulas...How can I modify this formula to give me an accurate number of days. Right now this formula, for example, if a ticket age is actually .5 days open it would give me 1 day. If it was 1.5 days open it would give me 2 days. Even when attempting...

Where can I find the business days zip? What is the name of the website.

Sorry guys, I gave you the wrong formula, this is what I am using: IF {BSCC-FL-TM&ACTION_JOIN.Call_Status} = 'PENDING' THEN {BSCC-FL-TM&ACTION_JOIN.Status-History.PENDING.TIME} - {BSCC-FL-TM&ACTION_JOIN.Status-History.OPEN.TIME} else If (Today - {BSCC-FL-TM&ACTION_JOIN.Call_Time Call Received})...

How can I get an aging formula which does not take into consideration the weekend? So it would be how ever long a work order was open not counting the weekends into the age. Note: There is no end date...until a work order is in "close" status. So the only field from the database that...

How can I get an aging formula which does not take into consideration the weekend? So it would be how ever long a work order was open not counting the weekends into the age. The formula would give it to me the age in days. Any help would be greatly appreciated thanks. I am using crystal reports...

How can I get an aging formula which does not take into consideration the weekend? So it would be how ever long a work order was open not counting the weekends into the age. The formula would give it to me the age in days. Any help would be greatly appreciated thanks. I am using crystal reports...

How can I run a report that shows me that a particular field is NULL or blank. For example, a report that shows me all trouble tickets that do not have a computer name in them. Note: ComputerName is a field in the database tables I am working with. Any help would be greatly appreciate. I am...

What would be a formula so that I can get data for the last 2 months using a date field? Any help would be appreciated thanks

Thanks for you your reply. Here is a little bit more clarification. This was the last part of your reply.. "If so, place the explicit (Call_Assignee Group) = "DESKTOP FL" in the record selection criteria." But if I where to do that it would just give me the current ticket...

A submitter can also be in a group as well. The submitter is most of the time in a group called "HELPDESK." A submitter can actually be in any group...all a submitter is somebody who opens up a ticket in the remedy system.

I basically have two fields in a table in a Remedy (trouble tracking system) database that I am working with. One is {Submitter}and the other is (Call_Assignee Group). A submitter is basically the person who originally creates a trouble ticket and an Assignee group refers to a region a computer...

Thanks Guys, both formulas worked thanks for the help..greatly appreciated.

Does any body know a formula that gets dates for the Last8days rather than using Crystal 7.01's Last 7 days. Any help would be greatly appreciated. I am currently having a problem now when I run a report for the last7days and it is not giving me the dates for the last 7 days. For example,the...

I need to a get a formula that would give me the age of a ticket in our ticketing system. I have a simple age formula for example this is how it would look from the REMEDY Tables (Status.History.Closed.TIME - Call Time Received)...This formula would give me that age. But the way our ticketing...