Search results for query: *

Hi, I normally use crystal to report on MSSQL DBs but I've got a requirement to report on a UniVerse database (IBM). I connect to the database easily via ODBC and the files/tables are retreived. When I drill down on a file, not all fields/uniVerse dictionaries are getting displayed. Are there...

Thanks lbass. Worked well.

Sorting by Month and Year in a crosstab. Need some help with this one. I currently have a formula that works out the month and year (IE Jan-05, Mar-05 etc...) but when this formula is used in my cross tab, the months and year are not sorting correctly. (Looks like alphabetically/numerically)...

I have talked to the programmer and he has given me the following VB6 code that runs my report: ------------------------------------------------- Dim Cr As New CRAXDRT.Application Dim CrxReport As CRAXDRT.Report Dim strParameters As String strParameters = "StartDate...

Thanks Larry, This formula is ok if you enter parameters values via crystal but unfortunately it does not solve my problem. I also use this method when I create date parameters in my reports. This situation is different in that the programmer is passing the values directly to the date field...

Is it possible to write a formula to retrieve date values passed into a date field via VB program?(builds the Crystal SQL statement) That is, a programmer calls my report via his program which prompts a user to enter in a date range (Start date and End date). These values are passed onto the...

Still having problems with this report. The parameter is date type. The error indicates that the calculation cannot be down now butlater. Any ideas? Thanks in advance.

Thanks Ido, I gave this a go but I'm still having problems. I forgot to mention that I'm using a parameter (Enter Date...) I've created the formula Maximum({visit_date}, {client}) Problem encountered with Group Selection Formula. It is expecting a date value but I'm using a parameter in the...

Hi, I need to create a report that shows me clients that I have not visited since a particular date. (For example: Show my all clients/companies that I have not visited since the 20 Sep 2004.) Are there any special date formulas that I can use? (Using the Record Selection Expert does not...

SQL server database... Sorry I meant CRW crashes after I recieve the "Not Supported" error. The database has been updated and is on a different server. This is why I am doing a Set Location. Furthermore, veryfying the database does not seem to rectify the problem. Please note the...

Currently running 8.5. using SQL database. I need to to do a Set Location on my reports as the database location has changed. Some table and fields may have also changed within the database. I am finding that I am getting a "Not supported Error" when I do a Set Location for some...

Thanks Brian.

I am fairly new to crystal and I need some help creating a formula that will calculate the the number of Calls that we have received in a FY. Our FY starts 1st July and ends 30th June. (I will probably use a cross-tab). I suppose what I really need is the formula that will calculate the FY...