Search results for query: *

What function are you using to produce the time? There's a difference between CurrentTime() and LastExecutionTime(). CurrentTime() will be the time that the report finished refreshing. LastExecutionTime() will be the time that the report began refreshing. Put both on a report that takes 5...

Generally speaking, it's a DLL Hell problem. BOBJ and TAPS are installing different versions of a crucial DLL. Since you're talking NT, it's probably that the TAPS kit has an older version of the DLL or DLLs than the BOBJ kit. One of the most common mismatches is in the MDAC software -...

I believe that the Business Objects company line is that you should stick with one repository and create domains for DEV, TEST, and PRODUCTION. But lots of people prefer separate repositories. Since you've created a new repository, there's some stuff already in the B.O. tables of the new...

On the B.O. Version 5 CDROM, there's a directory called "Freeware" which has a file called "repostry.htm" that details the repository tables and columns. Or you can use/purchase B.O. Auditor which comes with pre-defined universes designed for tracking usage of B.O.

BCA allows you to specify a date/time to refresh the report AND a file to watch to kick off the refresh. If you don't specify a file, then the report just kicks off at the appointed time. If you specify a file, then BCA begins looking for the file at the date/time. If the file never appears...

If this is the only parameter in the report, then the index is 1. Otherwise, it's whatever the index is with the first parameter being 1, etc. cReport.ParameterFields(1).AddCurrentValue "Text" And you need to place the parameter somewhere on the report, of course.

You can create parameters in the Crystal Report and pass values to them from VB. These parameters need not be part of the SQL statement to run the report. They might be a custom header to the report, who is runnnig the report from VB, etc. After you add the parameters in the report, you can...

You are using the older OCX technology. Use the RDC technology. Place a CRViewer control in a VB form.

Unfortunately, Crystal has made the Report Distribution software functional only with the Crystal Reports Developer Edition. So, if you want to go that route, Crystal Reports Professional will not work.

It's not in Crystal and it's not going to change because Compiled Reports / Report Distribution Expert are moving out of the product. With V8/V8.5, you have to download the software from Crystal. It's no longer in the shrink-wrapped version. In VB or ASP, create a drop-down box, populate it...

1. After you open an old report, you can save it to the new format. 2. You can continue to use the OCX technology, but it was obsoleted as of V6. You should start using the RDC technology. 3. Yes

You cannot edit the SQL via SHOW SQL QUERY in Crystal Reports Designer and add the word DISTINCT. In V8 there is a menu option for DISTINCT, but not in previous versions of Crystal. Use groups. Add groups to your report. They give you the same functionality as DISTINCT. These 2 SQL...

You can do it, but you need a little help beyond the 3 tables. You can only join what you have, so first you have to create something that has all possible combinations. I'm just going to assume that you're using SQL Server or Oracle, although I'm sure it will work the same in Access. - You...

I believe that the Scope_Identity() function is new to SQL Server 2000. Earlier versions, use @@Identity. Just from an VB/ASP efficiency aspect, if you're calling an stored proc to do an INSERT, UPDATE or DELETE, using an ADO Command object is more efficient than using an ADO recordset.

Where are you creating the record? VB, ASP or some other programming language? If so, then you cannot use @@Identity unless you're calling a stored proc. If you're using a .AddNew function of a recordset in VB/ASP, then you're stuck with the doing a Max() after doing a .Update to the...

Use @@Identity immediately after the INSERT From the BOL: INSERT INTO jobs (job_desc,min_lvl,max_lvl) VALUES ('Accountant',12,125) SELECT @@IDENTITY AS 'Identity'

On the Crystal Web site at http://support.crystaldecisions.net/updates/default.asp there is this self-extracting .exe: aspxmps8.5exe It's also on the Crystal Developer CD.

Whatever you see in the Show SQL Query window should be the SQL going to the database. Hopefully, anyway. I would try copying the Crystal SQL and pasting it into SQL Server Query Analyzer to see if it works. You might have to fix up the joins with respect to the { brackets that Crystal uses.

No. You can use the Report Distribution Expert. It's right under the Compile report option in V7.

Well, it's off the original topic but.... Certainly dependency errors can be safely ignored. But only a few. Crystal has a few support articles on those issues. The Package and Deployment Wizard that comes with VB / Visual Studio is not the most robust tool in the world. If you're looking...