Search results for query: *

I have an application that relays emails to the Exchange Server the application has a string in its preferences to input a user and password for authentication when i enter a user and attempt to send a message the log shows "454 5.7.3 Client does not have permission to submit mail to this...

I have an application that requires me to set my Exchange 2003 server to 'Basic Authentication' with the 'Anonymous Access' checked. What are the ramifications of setting the security in this fashion?

This is the exact Copied formula from the working report whileprintingrecords; trim(split((split({AMGR_Notes.TextCol},"as follows:")[2]),"Case description:")[1])

I have written a query and tried to export it to a CSV file but query analyzer dosn't put in the header column, tried to run query through excel but it didn't like my cast statement. Tried through export wizard but it didn't like my multiple alias. Tried to save to file but the format wasn't...

Thanks everyone it works now with the following formula: trim(split((split({AMGR_Notes.TextCol},"as follows:")[2]),"Case description:")[1])

I couldn't get the above example to work, however this one does work whileprintingrecords; trim(split((split({AMGR_Notes.TextCol},"as follows:")[2]),"Case description:")[1]) But eventually returns this error: A subscript must be between 1 and the size of the array. Ideas?

Sorry Crystal Version 9

I have a memo field that contains a bunch of text that has an obnoxious header and footer that vary in length for each entry. EG This case was resolved by Darren Louie on 7/22/04 12:15 PM as follows: 1. Disabled Orderdesk. No more ODBC error. 2. Deleted AMGR. Settings now saving. 3. Looks like...

I am querying an index table and I would like the case to accomodate where no record exists in the table. Here is my query so far. select isBP = case when uf.code_id = 19 then (Select 'BP') when uf.code_id is Null then (select 'Null') when uf.code_id <> 19 then (select 'Not BP') end...

if len(case_monitor) > 0 then true if the field is populated then do not show this record

I have a details section that has a suppression formula in it. If the suppression cancels all rows from showing for a particular group the group header still shows because there are records there, they are just supressed. How can I count the number of displayed (non suppressed) records so I can...

Your a star. Would you mind explaining how that formula works?

I have a report that returns notes in the details section. But only the notes that are type 9 and have the text 'escalated' in the note. This works. Sometimes more than one note is returned to the report per group. In this case I want to select the note in that group that has the lowest...

I was able to do it by making a formula if opp_status = 3 then revenue Then made the running total to evaluate on change of group, this way i didn't need to use the formlula in the evaluate on section. Thanks for your help.

Great! How would you reccomend using a sum in this situation? There is no distinct sum option.

Your a star Lbass! Any idea why it would count the details section even though i specified the opp_Id in the criteria?

I have a report with a group on opportunity ID then in the details i have the notes for that opportunity. I want a running total that counts the Opportunity Id but only when that opportunity is won (status 3). So I make a running total with the following evaluate criteria (opp_status = 3). The...

Thanks Brian. You Rock! can i do the same thing for the entire month?

Thank bdreed35 and everyone else that worked like a charm. Now if you wouldn't mind explaining the logic of that formula I would be very happy.

Crystal Version 9 SQL Server 2000 database. Basically i have an appointment table with all appointments scheduled. I input a date parameter and I want the report to return all appointments for that day (No problem), and all appointments for that week, so if today is wednesday then all...