Search results for query: *

P.S. to my previous post - I have not applied service pack 3, so apparently this capability to change isolation levels was introduced in an earlier fix pack or service pack. I'm currently running SP 2.

Reading through the readme for Crystal Reports 9 service pack 3, patch ID 35586459 contains instructions on how to change the default isolation level. It requires a change to the registry key value IsolationLevel as described below. The subkey is located at HKEY_CURRENT_USER (or...

Yes, synapsevampire's way is how we routinely do this in our CR9/CE9 environment - that is, open the report in Crystal Reports, then Save As and save directly to the location of the existing report in Enterprise, using the same name. With CE9, however, there are a couple of potential gotchas...

I thought I'd offer some clarification on this thread as I stumbled on it looking for answers to the same question. In my case I'm using CE9/ePortfolio but regarding parameters, I don't think the options have changed in CE10/Web Desktop. (The option under discussion can be found in the CMC on...

v10 is supported on Red Hat 3 ES/AS (press release: http://www.businessobjects.com/news/press/press2004/20040607_ce_linux_prod.asp). We are considering moving from 9 on Windows to 10 on Red Hat but are facing some challenges including which DBMS to use for the CMS database and how/if we can...

Sounds as though you're setting the destination at schedule time to something other than 'Default', then specifying the file name. I have a report that is run multiple times every month with different parameters, specifically different customer numbers, and it is written to unmanaged disk with...

Mrees, I'm also in a CE9 environment with NT authentication. I'm stuck right now trying to sort out why 3 users can't log in that could just last week. They all say they changed their NT passwords in the last week and just one claims that he was able to access CE after the password change...

Thanks folks. I'm reading... just haven't been able to take any action on this due some other things going on. But from what I read in Turk's last post is that View does use the page server which kind of makes sense. And I've got a vague concept (and manuals) of how to set up additional...

Synapsevampire, I think you're right -- it's going to take some coding and maybe a couple of tables in the APS database. I do like the idea of a condescending message though! Kingfisher, we've tried #1. When we set up a report, we use a specific account to connect to the database, so this...

Turkbear - The reports are running against an application where the data changes from minute to minute. Of the 10 reports they have the capability of running, 9 of them should only be run from say, 6am to 3pm, and after that they "should not" run any of these reports. However, there's one...

We have a series of reports in CE9 that we want to put limits on as to when the users can run them. I think I see a way to manage this as long as the reports are run via Schedule, but these reports are run on demand (i.e. via View, not Schedule). When running a report using View, my...

I was having this problem as well and lbass' directions helped me fix the problem. By unchecking keep object together on format subreport->common, the first page is now being populated as expected. Thanks!

You might be right regarding the other joins to your item table but this differs from one database to another. You should be able to see how CR is handling joins by looking at the SQL query it created. To do this, go to the Database menu, then Show SQL Query.... If that doesn't answer your...

Thanks for your input Dave. What you say points to the verify database action as the source of our problem, but my understanding is that verify simply compares the table/column structures stored in CR to what's actually in the database. Why/how could that cause update stats to kick off? --Bearden

On a few occasions I have run reports which have initiated update statistics on a table referenced in the query CR has created. This most recently happened this morning when my coworker clicked refresh on a report and update statistics was started on one of the tables contained in the report...

Is anyone aware of any news in the area of view-time security capabilities in CE 10? That is, the ability to have one report instance but control who sees what within that instance, based on their account ID or group membership. I had heard that function was being added to CE10 but I don't see...

For the record, we figured out how to set PDQPRIORITY on the client PC where we're running Crystal Reports and/or Crystal Enterprise. It is just a matter of setting an environment variable in Windows. To edit environment variables in XP, it's a matter of going to Control Panel | System |...

Edit the subreport and check the record selection formula to make sure the records in the subreport are being limited by the date parameter. In other words, you should see a similar statement to what you have in the main report. We frequently do this in reports to accomodate reporting on...

I am using CR9 and CE9 connecting to an Informix 9.4 database using the Crystal-supplied Informix driver. Outside of CR, when we are issuing queries from the query environment of Informix (using the server side utility dbaccess), we set two options to improve performance of our queries: set...

If you're using the default APS database which is MSDE (Microsoft Data Engine), you can have a look at the Microsoft support knowledgebase article at: http://support.microsoft.com/default.aspx?scid=kb;en-us;241397 If you have problems with the link, it is article #241397. --Bearden