Search results for query: *

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...

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...

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...

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...

It seems that when I select numeric fields through ADO, they are not available for my report. If I change them to character fields they come in. What's up with that?

I have text that I need to format on my spreadsheet. It needs to span multiple columns (merge) and then wrap. I don't know how many lines it will wrap to in advance. Is there a way to calculate what I should programatically set the row height to since &quot;Wrap&quot; doesn't change the row...

MSSQL Server Report: I created report with three tables left outer joined to one another. The code that Crystal created for me joins them in the where clause ... table1.fld *= table2.fld, etc. I get a GENERAL SQL ERROR when running it. If I change the code to table1 left outer join table2 on...

I am printing Tenant Statements and must print the total due at the top of each statement. The details for the total are printed in the detail section. How can I do this?

I have a table with a field varchar2(512). After I add this table to my report, this field is not on the list for me to select from. What's up? Work arounds?

I am creating a report with font Arial 6pt. (Very small). I need the fields to be underlined. If I use the border set on the line is way to thick. So far I've just drawn a hairline line under each field. This of course is a maintenance nightmare. Is there a way to change the line width on...