Search results for query: *

I have controls for which I want to display information at times, but not let the user enter or modify data. Setting the enabled property to false caused the control to be hardly visible. It there a way to disable controls and still have the control be seen. I keep looking for a...

I want to record the date and time, but I will only show the user the date. I tried the following line as an insert string into SQL and it will not work. It works without the timevalue portion. lstrUpdateStmt="Insert into CEEmpNearRel(CEENR_EmpNo,CEENR_EffectiveDate) values...

Well, I finally got a VB 6 application using Crystal Reports 8.5 installed on a Windows 2000 machine. I promise to write an article about it as soon as I get all the items in place. However, I have another issue to conquer. I am creating invoices and they appear to be created on the screen...

I have a complex report for which I want to suppress a section programmatically. The section contains a subreport. Since there are several sections to the report, I will want to be able to "spin" through the objects to determine whether or not the subreport is actually contained in...

What are the appropriate steps needed to install Crystal report designers with a VB 6.0 application? The designers are created by adding a Crystal 8.5 report. We are developing on Windows XP machines and need to deploy on both Windows 2000 and Windows XP machines. Carolyn

I am compiling a VB 6.0 project that contains several Crystal 8.5 reports. It is not an easy job! The project is being developed on a machine with Windows xp Professional. I finally got the project to compile. I then created a package to load on a machine with Windows 2000. I have made sure...

I have a report for which I have changed the parameters. I want to eliminated one of them totally. There is a green check mark on it, but I cannot locate it anywhere on the report. It is not involved in any grouping situation or formulas. When printing out the report definition, it does not...

I want to have the report headings be added dynamically. It is for a report for labor. The cycle can begin on any day of the week and can be for multiple weeks. This report is a sub report and the data I am using is from SQL 2000. This is a portion of the code to get the daily totals. The...

I have a report that is using the RDC component. The data is stored in an SQL database so the parameters coming must be in the order that I want. When I add them to the report itself they are assigned an index number lower than the original parameter. They have to be in a consistent order...

I have several Crystal Reports that I want to produce through VB 6.0 and SQL Server 2000. I have developed these reports outside of VB and want to integrate them at this time. I have used the RDC with a DSR method. And then I used the following line of code to connect to the data base...

I have a complex report with several sub reports developed outside of VB. It accesses a Stored Procedure in SQL Server 2000. Now I want it to be viewed with the Crystal Report Viewer. This is the code: Report.Database.LogOnServer "P2ssql.dll", "mysrv&quot...

(If you copy the code into an editor without proportional fonts, the columns will line up.) I have the following table: BCCODE BDATE BUV BPRICE BQUAN Ext. Price 5069 7/1/2002 0 0.11 62 6.82 5069 7/1/2002 0 1.1 38 41.8 5069 7/6/2002 6.977 150 1 150 5069 7/3/2002 18.605 400 2...

I know this must be simple but I have yet to figure it out. What does the input parameter have to look like for a DateTime variable? I have a very simple test: Create PROCEDURE DateTest @MyDate DateTime AS Select @MyDate By going to the Debug feature in the Query Analyzer and typing...

I wish to distribute reports as a package. The report is an invoice. Keep in mind that our company is a service company. 1. The top page(s) will be a summary of items that are being billed to customers and the charges for the items. This part of the invoice is to be done on printed...

I have a report (CR 8.0) that uses a SQL 2000 stored procedure. In the past this report worked. I recreated the stored procedure to get new data and tried run the report again. The problem is that some of the characters in specific fields are not readable. One value is expressed as a natural...

I am accessing data from SQL server using VB 6.0. I have reconciled myself to the fact that I will not be able to use the recordsets to update data to the server. However, I would like to be able to update the recordset that was returned because I use it to populate a grid. The recordsets all...

I am accessing data from SQL server using VB 6.0. I have reconciled myself to the fact that I will not be able to use the recordsets to update data to the server. However, I would like to be able to update the recordset that was returned because I use it to populate a grid. The recordsets all...

I want to find a record whose field name is contained in array element pFieldNames(0, 0) and the value of the field is contained in pFieldNames(0, 1). In this case the value of pFieldNames(0, 0) is "Emp #" How do I represent this using the criteria that is set out by ADO? Carolyn

I have a report that sometimes will have more than one page per group. However, each new group will start on a separate page. How do I get the word "continued" to display on subsequent pages? Carolyn

I have Crystal 8.0. Periodically while trying to use the Insert Fields dialog box, it will not appear. I have to completely remove and reinstall the program. Is there a less radical way? Carolyn