Search results for query: *

I am trying to pass an Optional 'ALL' Parameter to Oracle in the SQL statement below... USER.STATUS can be either 0 or 1 in the Source-Data (Inactive or Active). However, the :P_STATUS Parameter can be either 0, 1 or 2 (ALL). I tried an IF/THEN/ELSE statement in the SQL below - but it doesn't...

Think this is just a limit of CR-2008, but want to Confirm... Trying to produce a Table-Style report where the GroupHeader 1 contains the Summary level of a Project - and there can be multiple sections of GroupHeader 2 and 3 that contain the Details of the Sub-Projects and Deadlines. In order...

Once again having an issue with exporting a "Highly-Formatted" Crystal Reports 2008 file to EXCEL format. Not sure what I hate more the EXCEL export routines from Crystal, or the customers who love the PDF version of the export - and want it to be "exactly" the same in EXCEL format. I have...

Crystal 2008 running on top of ORACLE 10g. I have a report made up of three (3) tables - EVALUATION_CASE BOARD_MEETING COMM_MEETING There can be MEETING details for a single CASE_ID in both MEETING tables - but I only want to show the details of BOARD_MEETING or COMM_MEETING based on the...

Crystal 2008 against an Oracle 10g Stored Procedure using Crystal "Oracle Native" connection.. The report runs MUCH slower when running against the Stored Procedure - vs a RPT that goes against a TABLE or VIEW. It is also MUCH slower than running the Stored Procedure via TOAD, etc with same...

Good info on the two (2) product streams and timelines here... http://wiki.sdn.sap.com/wiki/display/BOBJ/From+Crystal+Reports+2008+to+SAP+Crystal+Reports+2011+or+SAP+Crystal+Reports+for+Enterprise Senior Business Intelligence Consultant Toronto, Canada SeagateInfo 7 -> Crystal Enterprise ->...

Release notes are here - http://help.sap.com/businessobject/product_guides/cr2011/en/xi4_cr2011_release_notes_en.pdf This CR-2011 is really nothing more than a service pack. Most people will stay on CR-2008 for a while. What have they been doing all this time...? All of the development effort...

If you are using an ODBC connection to ACCESS make sure that it has the same configuration on the Crystal desktop, and on the server. Also, remember that ACCESS doesn't normally allow multi-thread connections to the database... Senior Business Intelligence Consultant Toronto, Canada...

Also, if it is a NEW computer - it may have a different OS / IE version (eg. Windows 7, IE-8) that has new ActiveX blockers on it. Senior Business Intelligence Consultant Toronto, Canada SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design |...

Please provide details of the Report type - and the export options you are trying to use. If you are SCHEDULING a Crystal Report to PDF format and have the "Create bookmarks from group tree" option selected you will get the "Error detected by export DLL" issue if there are ZERO (0) records...

Can you point me to a SAP-BOBJ link that clearly states that "There is no version of XI that will integrate with Visual Studio 2008 and .NET 3.0"...? Thanks! Senior Business Intelligence Consultant Toronto, Canada SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 ->...

If we convert it to a string then it is no good for anyone who exports the RPT to CSV or EXCEL as it is not shown as a NUMBER. There's lots of Science and Financial applications that use more than 10 digits of decimals. Kind of surprised that this is the Crystal limit. Senior Business...

Crystal Reports XI or 2008 The NUMBER formatting options for decimals supports a MAXIMUM of Ten (10) decimals. 1.0000000000 We have database fields that have up to Fifteen (15) decimals that can be used. 1.000000000000000 Is there any way to support that increased level of decimal-detail in...

You mentioned ORACLE in your posting. What version of the Oracle driver do you have installed on the SERVER that is running SP4 and FAILING...? Sometimes the versions of Oracle and BO that "play nice" together are very-specific. (eg. patching to the most recent Oracle driver might not work with...

In 12+ years of Crystal consulting, I can count the number of times I have been asked for ACE, BOCP certification on one-hand. If it is requested / required more in the Asia-Pacific market, then I would say take them...but if it is NOT being asked for, it's probably not worth getting. Senior...

Also, keep in mind that CR-XI (R2) has a Tech Support End-of-Life of 30-Jun-2010. http://www.sdn.sap.com/irj/boc/index?rid=/webcontent/uuid/c018fb0e-8724-2b10-c489-9b8333e5e0f9 Therefore, you are less than a year away from having your customers on a non-patched / non-supported product. From...

No, you are only allowed one-level of sub-reports in any Crystal Report version. Senior Business Intelligence Consultant Toronto, Canada SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design | Best practices for Java / .Net / Web Services

An active support/maintenance agreement includes the right to upgrade to the current product. However, upgrading to XI (R2) at this point would be a bad idea - since it is only supported to July 2010. Your client would be better to move directly to BOE-XI (Release 3.1) so that they are on the...

Migrating a report from CR-9 to CR-2008 which uses the "Oracle Native" driver (Oracle 9i). There are a large number of LINKED tables with LEFT-OUTER JOINS in the Query which runs fine in CR-9. In CR-9, the SQL is executed with the LEFT-OUTER JOINS in the WHERE statement - eg. WHERE...

Turkbear : I have re-posted to the OTHER TOPICS forum. This issue isn't really about parameters. It would be the same if we had multi-page cross-tab(s) or chart(s) in the REPORT HEADER. If a REPORT HEADER can run over multiple pages, how do we show the page number on each page of the REPORT...