Search below to find the answer to your Showcase questions. From helpful step-by-step how-tos to solutions to error messages, you'll find the resource you need.

Create Sequence Numbers in Query and Report Writer Specify Different Subsystem or Port Number for Showcase 9.x Query CAST Function Causes iSeries Error Query Numeric Prompt Returns Operands Not Compatible Message Warehouse Manager Audit Error Batch Query Issues Data Mapping Error Error 0x0012 Opening Existing Report Check if JAVA is Working on the iSeries SCXADD32.xll Could Not be Found Conversion Error on Prompted Query Unnamed File Not Found Message Opening Warehouse Manager Setup Timeout Feature for Showcase Query & Report Writer Excel Missing Showcase Add-in Menu Opening Excel Workbook with Query Reference Produces Error Display Query Summary Totals in MS Excel--Not the Details Uninstall and reinstall Showcase Client Showcase and JDE World A9.1 Support Showcase QSQSRVR Jobs Multiply Over Time Query Output Table Contains Bad Characters Excel Add-in Macro Error Internal Error in Showcase Application Licensing Convert From Standard Date Format to Julian Date Invalid Date or Time Format Error Scheduling Query Job Showcase iSeries Driver Error in getObjectLibrary Report Writer and Problem Creating IDAPI Table Unnamed File Cannot be found in Warehouse Manager Client Monitor Which iSeries Jobs are Invoked by Submitted Queries In Warehouse Builder Adding a presql or postsql AS400 Command with quotes fails Showcase Query Excel Add-in Fails with Unrecognizable File Format ErrorShowcase Restrict Batch Query Jobs to Specific Time Limits Showcase Products Backward Compatibility SCSERVER Job at 86 Percent of CPU Query Error - Specified DSN Contains an Architecture Mismatch Connection Errors After Installing Server 9.1.0.2 Patch Creating an ODBC Data Source for Showcase Query Showcase 9.x Connection Ports Database Name Component of Object Qualifier Must be Name of Current Database Variables File Renamed in Client Version 7.10 SAVSRVRINF and RSTSRVRINF to Move User Profile Settings Error 'Ox2108 received while initializing BDE in Report Writer Use Showcase Security for JD Edwards EnterpriseOne ( JDE E1 ) Profiles Host Install Fails Before Displaying License Agreement How does ShowCase apply JD Edwards E1 Inclusive Row Security? Unable to Open Report Writer Report Memory Allocation Failure for pRSData in Function How to Change Showcase Server Ports or Swap Ports Between two Showcase Servers Batch Queries Fail After Java PTF's or New Licensed Programs Installed Warehouse Builder/Manager Connection Error-Processing of the SQL Statement Ended Schedule a Batch Query to Run Every Day or Month Batch Query to Temporary Storage Space Offset Error Uninstall a Showcase Server Showcase ODBC SQL Negative Scale Not Valid Query an Excel Worksheet using Showcase Query Parser Error Creating Query Batch Query Resource Limit Exceeded and Stack Overflow Errors Opening Existing Report generates 'BDE error 0x2b05-permission denied' Message MCH0601 Space offset error when selecting the Table drop down in Query Error When Creating JDBC Connection Within MS ODBC Administrator Excel Add-in Not Attached After Install Mirror Showcase with MIMIX Excel Spreadsheet as the Source of a Query Prompt Configure ShowCase ODBC/JDBC Data Source with MS ODBC Administrator Windows Server 2003 Receives Unhandled Win32 Exception Showcase Driver CLOB Support Search for an Occurrence of a String Supplied with a Prompt Variable Convert Gregorian Date Prompt Value to Julian Format Security and Aliases of Warehouse Manager Client Showcase Datasource on Windows 7 64-bit: Tabs vs. Menu Bar Query to Return Every Other Record Add or Subtract Days, Months, or Years From a Date Write Batch Query Results to a PC File Query a Multi-Member File Showcase Query Excel Add-in API's Showcase Windows Support Schedule Batch Queries Understanding Date Functions and Date Wrappers Uninstall the Borland Database Engine File is Not a Recognizable Format in Excel Windows Server 2008 R2 support for Showcase Client Create a Virtual Optical Drive for Showcase Server ISO Install Showcase Client Patch Modify Showcase Java Properties File Showcase Install Quick Start Install Showcase Server Patch SQL Server Fix for Showcase Client 9.1.0.7 Change Config File for Java Heap Error Showcase Support Questions Install C&DS Adapters Select the Most Recenct (Invoice) Specify the JDE Security Table and Libraries in JDE World Environment Profile Required for Install Clear Out Warehouse Builder Log Messages Link the System Date in a Showcase Query Date Condition Calculate the Last Day of the Previous Month Showcase iSeries ODBC Driver Not Loaded Due to System Error Change the SQL Database Name for Excel Data Source Excel Extendable Detail Area Features and Capabilities JD Edwards World/OneWorld/EnterpriseOne Integration with ShowCase v9.1 Migrate Showcase Queries from Pre-version 7.0 to Version 9.x Debug Steps for Showcase Warehouse Manager Server Unable to Create a Data Source on Windows 7, 64-bit Query Results in Excel Viewer Error 'Viewer selected could not be started' Setup Non-DB2 Data Sources Use the Auditing Function Within Warehouse Manager Client Showcase and Single Sign-On Check Which IASPs are Defined on the iSeries Can Showcase Query be Used with Non-iSeries Databases? Change the Location of the Paradox File-pdoxusrs.net Calculate Time Durration from Date and Numeric Time Fields Make Query Run Faster Using the SQE Engine Add a Column to Sequentially Rank Records Check if Mult-thread Job Queue Used For Showcase Install Using Date Wrappers in Showcase Query Check for Locks if Showcase Server Fails to End Data Source Error Code 126 Showcase Journals and Journal Receivers Prompt From a PC File Showcase and QSQSRVR Jobs Using the CAST Function in Showcase Query Warehouse Manager Resource Settings Part II Error Occurred in SQL Call Level Interface CAST Function Fails with SQL0802 Error Batch Processing in Showcase Generates Only HEX or GRAPHIC Fields Showcase 9 Copy and Paste Works Differently Than Previous Releases Showcase Support for Microsoft Office 2010 Showcase JD Edwards Support Temporary Batch Tables Not Cleaned From the Showcase Server Library Run QSQSRVR Prestart Jobs in the Showcase Subsystem