Search results for query: *

Hi.... Thanks for that, No the fields in both databases are completely different, 1 is our MIS system, and the other is our Time Planning system. The only true link between them is the job number, of which has been modified slightly in the planning database. Also, i need it to not display the...

Just to add (sorry) Im using Crystal Reports XI with a MS SQL 2000 Database

Hi all, Ok, i have an issue that i cant get my head around. I have a report which exports a CSV file, to allow a SQL DTS to import automatically into another database. What i need in the report, is for it to check the new database, and if it already exists in there to suppress the record...

Gary your a star!!! My formula now looks like if isnull({QR.QR_QUANTITY}) then if {QP.QP_JOB_QTY} > 0 then {QP.QP_JOB_QTY} else {QM.QM_JOB_QTY} else {QR.QR_QUANTITY} Seems to work perfectly :) :)

Running CR XI - SQL 2000 Im linking 3 tables together... QM / QP / QR I need to get the furthest most quantity value. So im looking at QM (the master record set) to get a list of job numbers (displayed on report) im then running an if statement to check the QR table, and if the value is above...

I have decided to do this using variables (only way i can think of doing..) So i now have 2 formulas acting as my summaries.... These display and work correctly, however, when i try to call the variable into another formula, it always returns a 0..... so i am unable to do stockin - stockout :(...

Hi... System - CRXI I have a group sort in place, stock transaction, it identifies whether the stock came in or out. I have a summary in the group footer showing the total qty. What i now need to do is Stock in - Stock out to show the difference... (i.e. did we order too much in) But i cant...

Yeah as a destination. Thats not a problem, i know they are there... they contain all the settings for smtp connection etc.... But we have changed our mail server... and the new mail server doesnt support ehlo handshakes, and requires helo handshakes.... I remember seeing the setting ages ago...

Currently running BOXI, our e-mail server has been changed, and i need to change the e-mail commands from BO... I remember seeing the setting, but cant find it anywhere anymore..... Thanks in advance

I have BOXI - How do i change the e-mail from ehlo to helo etc?