Search results for query: *

I have discovered a piece of information regarding the problem I am having. The PC where the CRViewer gives me the error is a laptop. Don't know if that matters, though.... Kristie

All I get is a pop up window titled "CRViewr" and the phrase "a string is required here". All this report does is collect a string (a policy number) that is entered into a VB text box. It then passes this value as a parameter to Crystal. That parameter is used within...

Hi, I have an interestig problem. I am using CR8.5 & VB6. I have a reporting system that I have successfully deployed on about a dozzen PCs. All reports run fine on these PCs. On one particular PC, I am receiving the error "A string is required here" from the CRViewer. Is...

Thank you so much. This worked like a charm! Kristie

sorry for the confusion. What is happening is that I have a new page printing after each Agent (and I want that), so when I've reached the end of all the agnets in a state, the state totals print on its' own page. What I'm trying to avoid is having the state footer priniting on a new page...

Hi, I have a report that has two groups, one for State and one for Agent. State is group #1 and Agent is Group #2. I always want to print a new page after the Agent EXCPET when I am also at the end of the State Group. I would like to have the State Group Footer print with the Group Footer...

Hi, I am using CR8.5 and using vb.net (windows app) as the font end. Does anybody have the commands needed to login to a database connection. I am using an ODBC to connect Crystal to Oracle. By the way, I have the book Professional Cyrstal Reports for VB.net (WROX) which provides an...

Hi, I am using CR8.5 and using vb.net (windows app) as the font end. Does anybody have the commands needed to login to a database connection. I am using an ODBC to connect Crystal to Oracle. By the way, I have the book Professional Cyrstal Reports for VB.net (WROX) which provides an...

I'm having trouble with some VB commands for Crystal Reports 8.5. I am using RDC, and am trying to sort a report by a user selected option. I get into trouble when attempting to refresh the report with a different sort. I am using the method Report.RecordSortFields.add x, crAscendingOrder...

Hi, I'm using CR 8.5 and VB 6.0. I recently upgraded from CR 8.0 to CR 8.5, and have an exsiting report application in VB. For existing reports in the VB application (ones that I created in CR 8.0) the report.discardSavedData command works fine. For any reports that I've made changes to...

I've never solved this one. I have a hunch that the tables that I could not see may have memo field in them. My workaround was to export the data from the foxpro tables and import them into Access (yucky), but you can have the import/export process automated, so that you only need to go...

Johnwm, I did what you suggested, and it gave me a 0. Thanks for trying, Kristie

Here is the code. I haven't used control arrays, yet. This is the code that finds what the user selected for the option 'The following statments determine the sort order of the report If InsOpt.Value Then Set IndPaySort = IndPyRpt.Database.Tables.Item(1).Fields.Item(4) End If 'Sorts by...

Hi, I'm using VB6 with Crystal Reports 8.5. I have a list of options buttons in a form that will sort the report in various ways. I did some work in this project, and now I am getting a "Subscript out of range". It has something to do with my sorting options, but I'm out of ideas...

I've been struggling with this one for months. For some reason, Crystal is not seeing several foxpro tables. It does not matter if I use an ODBC connection or a native drive connection, the results are identical. This problem also has nothing to do with the length of the table names, as...

Hi, Using Crystal Reports 8 Does anybody know why crystal does not show all available fields when attempting to add a group, or even a sort for that matter?? Frustrating to no end!

Is CR8 compatable with vb.net? We are having a difficult time getting an ODBC connection established.

Hi, I'm using CR8 within VB6 via the RDC. I have an option screen where the user can select the sort order for the report. One of these sort options is using a formula. I'm having trouble passing formula to the sort equation. The other options work because they are database table fields...

Thank you for the helpful suggestion.

Is there a way to pass a value (in my case a date) that is entered on a VB form into a Crystal Report? I'm using VB6 and CR8. I don't want to display the record selection formula as it is far to long and un-end-user friendly to view.