Recent content by santango

Sorry for my terrible english, this is about what i need on the 2 if i need the input box so i can inter manualy the weight of this parts cr11 sqlbase(gupta 8.1) win2000 server. If NOT IsNull({PART.WEIGHT}) Then formula = {PART.WEIGHT}*{@BACK_ORDER} If IsNull ({PART.WEIGHT}) Then...

have a report that indicates all the products to be ship (between 20 to 100 lines of products normally) every time I need to manually enter the final weight of each packed product I need the sintax in vbs for crystal I reported xi that I would have to use. Thanks

when I bring a report, created with CR11 , I can run it without problems. If I start the report a 3 time, I get the following error: "Unable to connect: incorrect log on parameters". I have to restart CE to run the report a 2nd time. As I read, the report should be saved without data. It didn't...

thanks but give me same error?

All of the reports I set up using my company's database return the error message "the database table "(tablename)" can not be found. Proceed to remove this table from the report?". I then click no for all of the tables that I am querying (it shows up for every table). The thing is, the...

please help cal = -10.00 i need 10 (bolt) abs is working ok but int is not if {PART.QTY_ON_HAND}-{@calculo de qty} >0 then formula = "Qty OK" else dim cal as Number 'cal = Int({PART.QTY_ON_HAND}) - Int({@calculo de qty}) cal = {PART.QTY_ON_HAND} - {@calculo de qty}...

Win Server 2003 SqlBase 8.1 conection obdc(user dns) Northon corporative 9.0.3.1 crystal server XI all this is now on my test maching p3 950mhz 1gig mem thank you

Failed to open the connection Has anyone run into this problem before? Any ideal why I get this error? Mick

Failed to open the connection Has anyone run into this problem before? Any ideal why I get this error? Mick

who to make .exe report with cr 11?

ok finaly works thanks to all of you this last formula works very good

i fild that i am close with this but i dont know where or who to use Minimum({VENDOR_QUOTE.QUOTE_DATE}, {CURRENCY_EXCHANGE.EFFECTIVE_DATE}) if i do new formula erro massage there must be a group that matches this field

IF {VENDOR.CURRENCY_ID} = "CAN ($)" THEN FORMULA = {VENDOR_QUOTE.DEFAULT_UNIT_PRICE} ELSE IF {VENDOR.CURRENCY_ID} = "US ($)" THEN dim x x = datediff("d",{VENDOR_QUOTE.QUOTE_DATE},{CURRENCY_EXCHANGE.EFFECTIVE_DATE}) FORMULA = x END IF END IF this formula...

i cannot advance on this well may be if onyone know who to select the first smoll date Rem Basic syntax Dim d1, d2, total,x d1 = {VENDOR_QUOTE.QUOTE_DATE} d2 = {CURRENCY_EXCHANGE.EFFECTIVE_DATE} total = DateDiff ("d", d1, d2) formula = total <= 1 'Here i need the first < only

IF {VENDOR.CURRENCY_ID} = "US ($)" THEN DIM DATE_DIF DATE_DIF = DateDiff ("d", {VENDOR_QUOTE.QUOTE_DATE}, {CURRENCY_EXCHANGE.EFFECTIVE_DATE}) if DATE_DIF < 0 then formula = {VENDOR_QUOTE.DEFAULT_UNIT_PRICE}/{CURRENCY_EXCHANGE.SELL_RATE} end if there 10 firerent date on te table currency date i...