Search results for query: *

Please : where can I find the list of all variables that I can use in the URL such as init = java, user0 = ... password0 = ... I'm looking for one who will be able to change language used by the applet .... Thank U Daph

OK I solved it in changing language of the "register data", All parts are in american and I get my decimal back ... Thanks for help ... daaf

I work with View joining several tables. When I change the view, the only way I found to "refresh" CR, is to go in database, Show sql ..., and reinitialize it. Daaf

I think I resolve the Pb ... I change language used by Oracle Custumer in american, so it seems to work .... Thank you Daaf

Done, It returns 0,00 .... Thank you for help

Hello, Using a Odbc connexion(Oracle 8 ODBC Driver), CR8 trunc all numbers ... I've test my ODBC Connexion (with ODBC test), all decimals are presents, when I put this field on my report I can't see any of them (I think I've try all formating solutions - default format, personalized format ...)...

Hello, Using a Odbc connexion, CR8 trunc all numbers ... I've test my ODBC Connexion, all decimals are presents, when I put this field on my report I can't see any of them. I've made a formula with myfield*100, it's just like it was a integer and not a decimal field ... Help me please ...

try not to use a default format for all numbers ....

Here is how I made the connection in native Oracle : CrystalReport1.Connect = "DSN = SERVICE_NAME ;UID = user ;PWD = pathword"

thank you for answering, but actually, I set the selectionformula in VB. To test the selectionformula send by VB, I put the selectionformula directly in CR. And then I've seen that Cr translate the selectionformula by adding a comma after each number value .... I also try to send the...

Sory i'm french.... I'm using a native connection to Oracle, the formula selection is send by VB6 like that : CrystalReport1.ReportFileName = serveur & Acces CrystalReport1.Connect = Str_Connect CrystalReport1.SelectionFormula = selection CrystalReport1.ParameterFields(0) = "TITRE;" &...

So, you can try this, it will be easier : WhilePrintingRecords; Global numberVar Tot:=0; Global numberVar Rev:=0; Global numberVar Imp:=0; Global numberVar AMT:=0; Global numberVar DAM:=0; Global numberVar UPGE:=0; Global numberVar BILL:=0; Global numberVar PTI:=0; if not isnull({Ccs.REV_WT})...

here is what i'm doing on reports (I'm using a global variable) " WhilePrintingRecords; Global numberVar TotFrais:=0; if isnull({#SomFrais}) then if isnull({VIEW_CR8_NOTACCPRO.MTTGS}) then TotFrais := 0 else TotFrais := {VIEW_CR8_NOTACCPRO.MTTGS} else if...

Did you check if the fiels are null in the formula : if isnull(a) then if isnull(b) then 0 else b else if isnull(b) then a else a+b

Sory i'm french.... I'm using a native connection to Oracle When I make a selection on a number field, in the "Show SQL Query" CR is adding a "," just after the value, so the query is not correct. Here is the CR SQL : SELECT ... FROM ..... WHERE myfield = 2371, AND...