Search results for query: *

I am using Outlook 2007 on a WinXP Pro (SP2) machine at work to access email on an Exchange server. Whenever I go to TOOLS, then RULES AND ALERTS; Outlook will error out and close. I am able to access my rules via Outlook 2003 on a terminal server (Windows 2000 Server) at work, and also using...

Sorry, the setting was in IIS on the CE server. Bumped up the settings in IIS SMTP to 5 MB.

Our administrator found that there is a limit in Crystal Enterprise. He increased it, and it took care of the problem.

Could anyone tell me if there is a limit on how large of an email Crystal Enterprise can send? I have some reports that average about 1.8mb, but I receive the following error message when they run. [COLOR=red]SMTP_E_EXCEEDED_STORAGE(552)[/color red] Our Exchange server limit for individual...

Thank you so much. Worked like a champ!

This is probably absurdly simple and I am just making it harder than it has to be. In our ticket system, I have to show the past 12 months of tickets that were closed. I am trying to get a formula that will look at the last 12 full months. These reports run on the first calendar day of each...

Although it isn't working in this report, I am using some of the ideas you've shared in other reports.

I can not create a summary on my formula. Here is how I got to where I am so far... Here is my formula (@TimeDifference) for calculating the time difference: {CL_PROBLEM_HISTORY.FORWARD_TIME} - previous({CL_PROBLEM_HISTORY.FORWARD_TIME}) This gives me a time in days. I then use this formula...

That gives me records where the total action time is greater than 1 hour. I need it to look at the individual action times. If one of them is greater than 1 hour, they need to show all of action items.

I can not modify the database, but I have tried something similar. The time was calculated in minutes instead of seconds, but did not show all of the history, only the history items that were greater than 60 minutes.

I'll try to describe. The table that I pull this from is CL_PROBLEM_HISTORY, a history table. It contains the history entries for the tickets. It is linked by the ticket number to CL_CALL_LOGGING, which contains only the most recent entry into each ticket. When someone makes an entry into a...

I am doing a report on tickets stored in an SQL database. What needs to show is the entire history of the ticket when at any point, it takes more than 1 hour between actions. I have a field in the details section that shows the DateTime of an action, it's format is "mm/dd/yyyy hh:mm:ss". I...

FYI - I just found out from Crystal that this is a known issue. In the SQL options of Dictionary, you can check "Change DateTime field to Date" and it does keep it as a DateTime field. Just won't be able to use the clock in a report.

I'm using the dictionary because I was told to. I'm not using CR Dictionary Designer becasue I don't have it.

Yep, it shows up as a string, but it is a DateTime field on the database.

I had already tried that. I get the message "A string is required here", and the cursor positions itself in front of the selected function (in this case LastFullMonth.

We created a dictionary using Crystal Dictionary 8.0.0.0. When we use it in Crystal Reports Professional 8.5.0.217, the Select Expert does not contain the criteria "In the Period" and "Not in the Period" are not available. If we build the same report from the same tables...

Thank you both for the suggestions. Thanks to you, my report works exactly as I had hoped. I was just making it harder than it needed to be. ::-)

I have created a formula that shows all logged calls from a tracking software database (SQL). I have similar formulas that show me the total calls open and total calls closed in the time period. This only shows the overall total, but I need to break it down by the officer that logged the call...