Search results for query: *

Using BOXIR2; Oracle 10 Using a given Date field, is it possible to create a formula that will return the date of the next nearest first Thursday of the month or, if the given date field is already past the first Thursday, then the third Thursday?

Using BOEXIR2 Our underlying data platform was recently upgraded from Oracle 9i to 10g. Since the upgrade, we have had numerous performance issues with Crystal Enterprise. It is thought that the issues are within Oracle itself but I am curious to know if we should have expected this change to...

Using BOEXIR2 Our underlying data platform was recently upgraded from Oracle 9i to 10g. Since the upgrade, we have had numerous performance issues with Crystal Enterprise. It is thought that the issues are within Oracle itself but I am curious to know if we should have expected this change to...

BOEXIR2 - Crystal Pro XIR2 - Oracle 9 We are on a hosted system; I manage the Enterprise CMC via the web and develop reports on an Oracle connection logon. I also have direct access to the Crystal server via remote desktop. My issue is that, although I can access the Repository through the...

BOXIR2; Oracle 9 Problem: Create a Running Total that evaluates on a formula; duplicate the Running Total, then edit the formula in the duplicate; the formula in the original also changes. Example: Formula in the Evaluate X2 - Mid({%Date_Char},6,2)="01" and {WS_SCALE_TICKET.GROSS_WT} in...

CR XIR2, Oracle 9 I would search the Knowledge Base for this but I'm not sure how to form the question... In CR10, there were a couple of time-savers that seem to have disappeared in XIR2. I am wondering if anyone knows how to activate these or if they are just GONE ??? 1) In CR10, clicking...

CR XIR2 - Oracle 9 This probably has a simple answer that I have just overlooked but I need to be able to change the default Grid Size in the Report Options from .083 to .010. The .083 comes back each time I start a new session. I would like for it to be .010 on new sessions. It may be a...

Using BOEXIR2; Oracle 9 Question 1 - Back in CE10, there was a CMC option that displayed the different datasources being used and the number of reports hitting each source. We cannot locate this in BOE and I'm wondering if it was just dropped or is it hidden under another name or option...

Enterprise BOEXIR2 (Note : this issue is for a single user, it is not global) Up until a couple of days ago, in the History list for a report run in Excel format, clicking on the time/date stamp of a successful instance would bring up the dialog box with the option to Open or Save As. Today...

using BOXIR2; Oracle 9 A parts list report is grouped by part number and each detail row's unique value is a Site Code where the part is stocked. Each group will have anywhere from 1 to 10 different site codes. What I need in terms of layout is to place the part number information in the...

Using XIR2 (Oracle db), revised reports are republished via the Enterprise Save As procedure to retain the history. But recurring instances that were in place prior to the revision continue to run with the PREVIOUS report criteria. The Reschedule option doesn't pick up the new version either...

Crystal 10; Oracle 9 Is there a way to convert parameter string values to upper case? I need to retain the * option in the parameter, so this precludes the use of the edit mask character >. I can't use the UpperCase function on the parameter in the report filter because it is set to Allow...

Currently using CR/CE10 on Oracle 9; migrating to XIR2 by year end. I have a new report request that calls for a single recurring (daily) instance with multiple pages where each page must be routed to a distinct email destination (all destinations would be outside the enterprise network). The...

Oracle 9; CR10 Objective: to use Business Views to create a single data source from mulitple stored procs. Data Sources: 13 databases (from different locations) that are the same in structure. Currently, a single report that calls a stored proc is repointed to each database and run to produce...

Crystal 10; Oracle 9 Does anyone know if page width can be set within a formula or parameter? For example, if a parameter has selections for Summary and Detail (formats), can the page width be set to portrait for one and landscape for the other? I would like to eliminate the excess margin on...

Crystal 10, Oracle, CE10 Is there a way to make the Crystal Enterprise User ID ("Run By" in History) show up in a scheduled instance?

CR10 - Oracle - CE10 Cross-tab header is formatted for 90 deg. text rotation; works fine in Pro but fails to rotate in Enterprise when report is run in Crystal Report format. When run in Adobe format, text is properly rotated. Is there a setting in Pro or CE that can correct this?

CR10; Oracle Does anyone know a way to suppress a zero value in a crosstab cell? I know about the suppression options in the Customize Style tab, but they only apply to rows/columns. The usual technique of inserting a suppression formula in the field format does not work.

CR10; Oracle; CE10 I can run Business Views within a Remote Desktop application (we are on a hosted system) but I also want to be able to run it on the local client. We tried to set this up but encountered a communications failure related to ports not being open. Does anyone know any "tricks"...

CE10, WIN platform. On 2 occasions, a report run by the Administrator failed with an error message of "Object failed to run due to insufficient security privileges." There are no other failed instances of this report. Part of the mystery is that none of the Administrators ran this...