Search results for query: *

Hi, I checked the recieve connector and this is already ticked and enabled. Thanks

Hi, The only authentication settings I have changed was the outlook anywhere settings, but I would have thought that would have had any bearind on just affecting my default domain.. Thanks

Hi, I have an issue where the default domain on my test server has stopped sending mail to any domain, all the other accepted domains are free to do what they like. The NDR is stating that the mail wasnt delivered becuase of security policies, and delivery not authorised, message refused. I...

Hi, Sorry yeah I did mean internal e-mail addresses. I have set up the restrictions on incoming mail for the these accounts on the 'mail flow settings' under 'delivery restrictions', in there I only appear to be able to select either contacts or mailboxes and not use wildcards. For the outgoing...

Hi, Ive been given the go ahead to start looking at moving to Exchange, so far in testing im pleased with everything ive found but I have one issue at the moment which is looking like it will cause me a lot of work. Basically its company policy that certain e-mail addresses are not allowed to...

Hi, Thanks for the reply, yeah im using the Domain Administrator account, I have got in contact with Adaptec again as they told me this unit would not need an upgrade to join a Win2k3 domain, and now they are telling me it does!! Thanks

Hi, Wonder if anyone can help im having issues trying to join a snap 4500 to a windows 2003 domain, there are no issues joining machines to the domain just thist snap server. The first error i recieve when joining to the domain is: Membership in the new domain could not be confirmed- please...

Ive just looked at the SQL if i open it up in 8.5 and i get this: SELECT OR_STOCK.RETAIL_PRICE, OR_STOCK.CATEGORY, OR_PORDER_PRODUCT.PRODUCT_CODE, OR_PORDER_PRODUCT.QTY, OR_PORDER_PRODUCT.DUE_DATE, OR_PORDER_PRODUCT.QTY_RECVD, OR_PORDER_PRODUCT.NET_LINE, OR_PORDER_PRODUCT.UNIT_INVOICE...

Hi, Here is the SQL that the report uses, also i dont think the SQL is incorrect as it runs fine under crystal v8.5. SELECT OR_DATE.EXT_PERIOD, OR_PORDER_PRODUCT.DUE_DATE, OR_PORDER.A0, OR_PORDER_PRODUCT.NET_LINE, OR_STOCK.RETAIL_PRICE, OR_PORDER_PRODUCT.ORDER_LINE_COMPLETED...

Ive searched on the forums and found that a lot of people are getting this error, but i seem to be getting a slight variation, the full error message is: Failed to open a rowset. Details: 4200:[OpenRetail]Syntax error in SQL statement(Near'--'>): It then shows the two tables that are linked...

They are formatted as numbers.

Hi, Ive already gone through this, and set the machines to match mine, but to no avail.

Ive got a problem where, decimal places are appearing on reports when other people are running them. Ive checked the reports on my machine and they are fine, but as soon as they open the report up, and look at it, the decimal places are back. If i make changes to the decimal places on there...

Hiya, Thanks for the help, but its not quite what i need to do, im not adding the {@SumBranch} feilds together, i have a list of these {@Sumbranch} feilds in the GH, and i have a counter in the header, what i want the counter to do, is look at the {@SumBranch} Feilds and if any of them are 0...

I am using 8.5, but i cannot just use a running total, to look through the subtotals, and increment the counter by 1 if there is a zero in there. thanks

I have a report that looks at stock information, on the right hand side i have the product, then i have a variable for each branch, these are contained in the detail section, i have then grouped on the product feild, and created a subtotal for each branch. GH1: Product SumBranch21...

There could be any amount of repeats, which is the problem, ive now managed to get the report to work with the arrays, so cheers guys. -Scott

lbass, Ive just tried to use the NthLargest formula, it works, but the only problem is i have in some groups two dates which are the same, is there a way to ignore a record if it already exists in that group? My counter did this, the records were sorted by date, and if the next date was the...

For some strange reason its partly working now!?!?! although there is still a problem, the array now displays the second element in the group header, although it is showing the element from the previous group? -Scott

Hi, Yes i only need the second elemtent of the array. Here are my formulas: @Counter WhilePrintingRecords; NumberVar Counter; If {OR_RECEIPT.TRANS_DATE}=Next({OR_RECEIPT.TRANS_DATE}) then Counter:=Counter+0; If {OR_RECEIPT.TRANS_DATE}<>Next({OR_RECEIPT.TRANS_DATE}) then Counter:=Counter+1...