I am using VFP8 and executing an SQL statement which is getting the following error.
"Connectivity Error: ODBC SQL Server Driver .... Insert Failed because the following SET options have incorrect settings: 'ARITHABORT'"
I can copy this exact statement to the Query Analyzer and it runs fine...
In CR9 I preview a report giving values to the parameters. After the first preview, refresh the report using "Prompt for new values" and only enter values for some of the parameters. On the preview, the parameters that I did not enter new values for still have the values from the first preview...
In CR9 the parameters do not have the same defaults as the earlier versions. For example, a date parameter used to default to the current date even when it was not selected in the prompting window. CR9 only does this if you click on the parameter in the prompting window. Is anyone else...
Does anyone know how to raise or pass an event to a specific session. I have a tcpip control that receives network messages and i need to diplay a certain aspx page when a message comes in. Any ideas?????
I have an HttpApplication object oUpdateClient(Winsock control) listening for network messages which fires the NetworkReceive() event. I need to raise an event or something in a specific Session that notifies the user that a certain type of message has arrived. I am using Forms Authentication...
I have a textbox on a report that is set to stretch on
overflow. The box grows, but when using a proportional
font such as Arial, some of the words disappear when they
should be wrapping around to the next line. Example: the
word DEMANDING will not show on the report. If i take off
the G at...
when printing bitmaps on a foxpro report the application keeps changing the printer setting to grayscale. Does anyone have any ideas on what is causing this? The code that runs the report is as follows:
report form formname to printer noconsole nooptimize
Both computers have SQL 2000, Windows 2000, Crystal Reports 8 Pro. When I try to run the report on both computers, one works fine with the 0/1 comparison and the other errors out and wants a true/false value. Does anyone know if there is a setting in Crystal or a patch that will fix this problem?
I am trying to distribute a VB aplication that uses an Access object to automate the import of a text file into an Access DB. I want to be able to run this on a machine that does not have access installed on it. If I run the Package and Deployment wizard I get "MSACC9.olb is missing the...
When looking at two different SQL tables that have "Incident_Index" fields which are real data type precision 24, a record will appear to have the same values in this field in both tables yet somehow they are not the same. In my foxpro application it will not recognize these as the...
I am trying to write a report in CR 8.0 that will go out to several companies. I want to put the company name in the report title; however, it is only stored in a config("config.ini") file. The rest of the data is in a SQL database. Does anyone know a way to retrieve the company name...
I have a report that deals with phone calls and the database has a call number and 3 different fields of operator1, operator2, and operator3. I need to be able to group the calls by operator. How can I make the call show up in the operators group whether they were the 1st, 2nd, or 3rd operator...
Can anyone point me in the right direction? I am trying to read X and Y coordinates stored in a SQL table and determine what region that they would be in on a MapInfo map. I need to filter so that only points from the table that are in a specified region on the map are included in the results. I...
Does anyone know of a resource that will tell me the things in CR 8.0 that I can not use in a CR 5.0 preview control in an application. I am having trouble with any type of looping structure and multiple value parameters. The report works fine in CR 8.0 but CR 5.0 gives an error on the formula...
I have Crystal reports 8. I have 2 SQL databases that are identical in structure, just have different names and data on the same server. The report works fine on one and when I either set the location of the tables or change the database driver the report acts like it locks up. I have 3...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.