Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MJRBIM
  • Content: Threads
  • Order by date
  1. MJRBIM

    Syntax for Optional 'ALL' Parameter in Oracle SQL

    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...
  2. MJRBIM

    Multiple-Groups with "Underlay Following Sections"

    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...
  3. MJRBIM

    Opening CR2008 exported XML in Excel 2003

    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...
  4. MJRBIM

    Dynamic Table LINK in Crystal 2008...?

    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...
  5. MJRBIM

    Slow performance Crystal 2008 against Oracle 10g Stored Procedure

    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...
  6. MJRBIM

    NUMBER formatting with more than 10-decimals

    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...
  7. MJRBIM

    CR-9 to CR-2008 (Oracle Native SQL issue)

    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...
  8. MJRBIM

    Show Page Numbers on a Multi-Page Report Header

    CR-XI (R2) I have a REPORT HEADER section that shows all the parameters that are entered at runtime. I have the Page Number "X of Y" in both the REPORT HEADER A and PAGE HEADER sections. In some cases, these parameter lists can be very long and run to over 3 pages. This results in the Page...
  9. MJRBIM

    Show Page Numbers on a Multi-Page Report Header

    CR-XI (R2) I have a REPORT HEADER section that shows all the parameters that are entered at runtime. I have the Page Number "X of Y" in both the REPORT HEADER A and PAGE HEADER sections. In some cases, these parameter lists can be very long and run to over 3 pages. This results in the Page...
  10. MJRBIM

    SPANISH InfoView 3.1 Guide...? (xi3-1_bip_user_es.pdf)

    Anyone know if there is a SPANISH InfoView 3.1 Guide...? Based on the naming of the EN and FR which I found in the SAP MarketPlace, I would expect the file to be called xi3-1_bip_user_es.pdf - but I have had no luck finding it. Anyone know if one exists, and if so - how to find it...
  11. MJRBIM

    [Missing Link] CR-2008 : Exporting to XML (Sample XSLTs)

    In CR-2008 it allows you to define your own Extensible Stylesheet Language Transformations (XSLT) to be used during an Export to XML. There is a "link" in the CR-2008 application to samples of different XSLTs...but it points to the old Business Objects website (now dead). Anyone know where...
  12. MJRBIM

    TIMEOUT : ReportJobServer - DESTINATION (SMTP)

    BOE-XI (R2) We get a sporadic problem, when we have a large number of reports that are set-up for e-mail distribution around the same time. The SMTP server threads get overwhelmed and some of the instances FAIL or do not get delivered to the e-mail recipient. We have increased the SMTP...
  13. MJRBIM

    Reboots and "FILE EVENT" triggers.

    We have some PENDING report instances that are dependent upon TXT files that are created by an Oracle process on a different physical server - which is monitored by the BOE servers using a UNC-path. This all works fine, except when the various servers are rebooted for monthly "Microsoft...
  14. MJRBIM

    Optional Ignore Parameter in a COMMAND

    CR-XI (R2) ORACLE 10g Database ====================== The report is written by someone else using a COMMAND to provide so total counts from an ORACLE table. Now we want to add OPTIONAL parameters for REGION, STATE and CITY. I can get the STRING parameters to work if I provide an explicit...
  15. MJRBIM

    MSG 824 Errors - Virtual PC 2007 - Windows Server 2003 - SQL Server 20

    MSG 824 Errors - Virtual PC 2007 - Windows Server 2003 - SQL Server 2005 I am running a Windows XP-PRO (SP3) workstation hosting a MS Virtual PC 2007 session with the following.... WINDOWS SERVER 2003 (SP2) MS-SQL 2005 STANDARD I tried a number of times to RESTORE a 6.59 GB database from a...
  16. MJRBIM

    Difference between "Service Pack 5" for CR-XI (R2) and BOE-XI (R2)

    Difference between "Service Pack 5" for CR-XI (R2) and BOE-XI (R2) ======== There are two different "Service Pack 5" files available for download... CRYSTAL REPORTS XI (R2) = crxir2win_sp5.exe BUSINESS OBJECTS ENTERPRISE XI (R2) = boxir2win_sp5.exe If we have workstations that have both...
  17. MJRBIM

    [XI 3.1] Issues during "Clean" install on Windows Server (64-bit) OS

    Started setting-up a SANDBOX yesterday of BOE-XI (Release 3.1) on a "Clean" Windows Server (64-bit) OS. I hit a couple of issues that I think may be related to the DEFAULT "Program Files" location on the OS being... C:\Program Files (x86)\ ...rather than... C:\Program Files\ I chose to...
  18. MJRBIM

    (Print Set-Up) AIX vs. Windows server [XI R2]

    We have a LANDSCAPE-LEGAL report that runs OK to PDF on our Windows BOE-XI (R2) server. It produces a PDF document in LANDSCAPE-LEGAL format. When we publish the same RPT-file to our AIX - BOE-XI (R2) server the report runs to PDF, but the PDF document is in LETTER-LEGAL format, and crops-off...
  19. MJRBIM

    (Print Set-Up) AIX vs. Windows server [XI R2]

    We have a LANDSCAPE-LEGAL report that runs OK to PDF on our Windows BOE-XI (R2) server. It produces a PDF document in LANDSCAPE-LEGAL format. When we publish the same RPT-file to our AIX - BOE-XI (R2) server the report runs to PDF, but the PDF document is in LETTER-LEGAL format, and crops-off...
  20. MJRBIM

    Moving FAX CONSOLE archive to a new PC..?

    I am getting a new laptop with XP Pro, and need to move all my FAX history from my current laptop. In Windows FAX CONSOLE there is an option for IMPORT, but not an option for EXPORT. Anyone now how to move all my FAX history...? I tried looking for the .tif files, but couldn't find the path...

Part and Inventory Search

Back
Top