Recent content by deborahb

There is a French Version but then everything comes in French which is not okay. I guess a brute force function is about the best I can do. Thanks for your time :)

Thank you for your reply but I think it is an over simplification of the problem. If I have a number like 1234.56 and I send it through the ToWord function I get one thousand two hundred thirty-four and 56/100 which is exactly what I want - In French. With your method I'd have to have a...

I need a function (UDF) or equivalent that will translate numbers into French. This could be a two step deal if necessary. Right now I can use ToWord to change the number "1" to "One". I'd like a function that will change "1" to "Un" (that is French for one?). If you have something like this or...

Actually I think I figured it out. The field is a varchar2(16). The length of the field in the database that works is 8 and the one that doesn't work is 16. SO the program that created the records filled one with blanks at the end and the other one not. Using a rtrim solves the problem. Thanks...

I have two Oracle databases. I am running the same query in both: select * from accttreedetail ad where ad.scode >= '11100000' and ad.scode <= '11100000' In both databases I have a record in the ad table with an scode = '11100000' In database A I find no records and in database B I find...

Thank you. Adding a default printer indeed solved the problem. I still have a few questions about this. How come it didn't happen to all my reports, reports that were built as clones of one another? In other words, is there something I can do to a report that will make it work without adding a...

We are using RDC, Sql Server 2000, IIS and running Crystal reports 9. We are using activexviewer9.cab#Version=9,2,2,511. I have a set of reports that previously worked fine. Now when I attempt to run them from a 2003 Webserver some of them return a report that looks like it is trying to put...

I am trying to pass parameters in .Net to my Crystal report. My code compiles fine and runs but I keep getting prompted for the parameters even though I believe I am passing them. When I step through it seems that I cannot even instantiate the Crystal objects. Dim paramFields As New...

How about functions? Is it possible to have optional parameters in functions? I've been trying to use the stored procedure syntax (@v_field = null) and it compiles fine but when I run it with less than the total number of parameters I get an error. Thank you.

Thanks again. You have been very helpful.

In the interim, I wrote my long command into a bat file and changed the code to rc = sh.Run(mybat, 1, True) This turned out to work great. Now I would like to suppress seeing the command window. I assume it is the second parameter. I am in the process of looking this up now. Thanks for this...

I need to do the same thing. I am runnning Excel 2000. My code looks like this: Set sh = CreateObject("WScript.Shell") rc = sh.Run("c:\""program files""\""fff systems""\runabout\runabout.exe -O Export -U dufflive -P somepass -D mydata -S Deborahb2 -DT 1 -T...

Seems so long ago.... The problem is that the default code writer that writes sql such as table1.fld *= table2.fld is outdated and only supports one level of outer join. But - one can write code such as table1 left outer join table2 on table1.fld1 = table2.fld4 left outer join table3 on...

Is it possible to create a formula in a header that uses next() or previous()?

I have a report that has a running total. I am using a running total since I am not adding in the values from every record but only when there is a change in one of the fields. All works fine except that I'd like to display the final value in the group header. Ex. fld1 fld2 fld3 fld4 aaa...