Recent content by hmohrmann

Problem: move files from sql2000 server S1 to sql2000 S2 the fastest way possible. S1 is 4 times faster than S2. Which is faster: 1. DTS on S1 to push to S2 2. DTS on S2 to pull from S1 3. bcp on S1 to push to S2 4. bcp on S2 to pull from S1 According to Microsoft a bcp doing export is 3 to 6...

Crystal seems to have changed some of their licensing requirements in version 9. At least for those people that only use the reports inhouse. Check the license agreement on their web site. Here is the part that applies inhouse. 4.2 Deployment Within Your Organization of Server/Web...

Yes, Oracle is important, but also Microsoft SQL Server. I work for a government agency and we have one large Oracle server. But because of the expense, all of our other databases are in SQL Server (200+ databases on six servers) Because of this we have one Oracle DBA and 4 SQL DBA's.

Been there, done that. First thing I tried. I have tried every number up to 255. Harry

If you look at my original posting you will see my basic code. I am opening the report, discarding the data, and exporting a new copy in crystal report format to a new disk file. Harry

I currently have two(2) folders. 1. This folder has the original reports. 2. This folder has the reports with the refreshed data. My routine opens each report in folder 1 and saves a new copy with the refreshed data into folder 2. If it runs on a machine with version 7 only installed it works...

My reports are on a web site. Currently there are about 60, expanding to 300. Every morning at 4am my routine refreshes the data in the reports. We do not allow the web viewer to refresh (saves a lot of time, and we do not have to allow them access to the supporting database). The routine has to...

We are trying to maintain all our reports in version 7. Most of us are using version 8 and then saving in version 7. This works fine. I have to run the VBA routine on a machine that only has version 7 installed so that all the reports are maintained in version 7. If I run the VBA routine on a...

I am using the following VBA code to automatically refresh my crystal reports: Dim crpApplication As CRPEAuto.Application Dim crpReport As CRPEAuto.Report Set crpApplication = CreateObject("Crystal.CRPE.Application") ... Set crpReport = crpApplication.OpenReport(strStartDirectory &...

We use Crystal Reports Automation Server (CPEAUT) which came with version 7. All information about the reports is stored in an Access database on the server, and we use asp to display the reports and descriptions and then allow the user to select the report. There is no royalty and no limit on...

In Crystal: 1. On the tool bar select Database. 2. On the drop down menu select Set Location 3. On the Set Location Popup Window: Select each table in the report and click the Set Location button. You will get another popup that will allow you to select another DSN and table name. 4. When you...

I don't know if this will help but the following code works in VB and Access. It opens an existing report, refreshes the data, and then saves a new copy. You will have to change it just to display the report, but this will give you some idea how the process works. P.S. you have to add the...

The code below is on one of my asp pages. I pass the name of a field that has an area code (1,2,3 etc), and a set of values from a multiple select box ("1,5,8") and I build an SQL statement that limits the results in the report to just the selected area's. Hope this helps! Harry...

I don't know if this helps but when you install version 8 on a machine you install version 8 of cpeaut32.dll, which is the crystal reports version 8 engine. It over writes version 7. Even if you uninstall 8 and reinstall 7 you still will have the version 8 engine on your system. If you...

I use a Visual Basic routine that works stand alone in VB or as part of a Access database. The routine opens the original report, refreshes the data, and then saves the report in a different folder. That way I don't have to worry about damage to the original report. Dim Rs As Recordset...