Recent content by rci

I'm using the inserted summaries, not running totals.

Yes, the SQL Command does the lowest level of summarization, but the group levels are dynamically chosen by the user at run time so that's all I can pre-sum. The owners of the database are extremely reluctant to allow any use of stored procedures. It's an ongoing battle. Thanks for your help...

I'm using Crystal Reports XI with a BOE Business View and I'm trying to optimize the performance on a report. I use a SQL command in the Business View which runs in less than two minutes and returns 215K rows. Then the report takes an hour to process those rows. CR spends a lot of time on what...

In Crystal Reports XI, I'm using a Business View which calls a SQL Server stored procedure which has parameters. In the BV, I defined dynamic lists of values (LOVs) for some of the parameters to the stored procedure. This works fine if I only select a single value from the drop down, but if I...

If you are referring to the report developers workstation, where the reports are being created in Crystal Reports, then they have to have DB2 Connect on their workstation. After the report is published in CE, anyone accessing it there will not need DB2 connect. The CE server will need DB2...

Hi Ben, For CE 8.0, the Crystal Support site says that you can't base a report on a Crystal Query. Here's the URL: http://support.crystaldecisions.com/library/kbase/articles/c2007877.asp For later releases of CE, there's a white paper that covers how to implement Crystal Query-based reports...

rptQueen, Depending on your exact security needs, you might be able to use the Processing Extensions in CE 9. You can write your own, but we opted to purchase View Time Security from APOS. VTS is a processing extension that can be used to determine at view time who can see what rows on a...

SI_MAIL_ADDRESSES is not a property/field of any CI_INFOOBJECT. Are you looking for data from one of your databases? The query builder is only for retrieving data from the CE system database.

There are settings in the CMC that say how many instances are kept and/or how long the instances are kept. In version 8.0, you can only set these limits on a global level, meaning that they will apply to all reports in CE. In version 8.5, you can set these limits for individual folders and...

dbew is running version 8.0, so the global setting is all he gets. Keith

Yes, you're in the right place and the instance you want to delete will have a status of "Recurring". That's the one that keeps scheduling new reports to run. Keith

Yes, CE 8.0 has the same basic scheduling options as CE 8.5. And running the reports through 'schedule' will use the jobserver, which is better equipped to handle long-running reports. Keith

Even restricting them to Schedule only will still allow them to run the reports on demand. They can 'schedule' a report to run right now. The restriction will just prevent them from doing a Refresh from the viewer and it won't let them use the View command in CE. Keith

We've seen this error in CE 8.0 and CE 8.5: The cacheserver has lost communication with the pageserver. We've been working with CE to solve the problem. You can try to stop and restart the pageserver, but if your problem is the same as ours, the pageserver will hang in a "Stopping&quot...

In the Crystal Management Console (web-based admin tool), just delete the recurring instance of the report. Keith