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!

Register Log in
  • Congratulations TouchToneTommy 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: AHFMR
  • Content: Threads
  • Order by date
  1. AHFMR

    Export Query to Excel using DOcmd.OutputTO

    When I use the DoCMD.OutputTo to save a query to an Excel file the statement works fine the first time but it deletes the SQL statement after it is done saving the excel file. DoCmd.OutputTo acOutputQuery, "Query Name", acFormatXLS, strXLfile, True Any assistance is appreciated. AHF
  2. AHFMR

    Cognos Impromptu Macros

    I have a macro that reads data (LastName, FirstName) from a file. This data is used in the macro as prompt data. When I pass this into the report it breaks it at the comma. I under stand why that is happening. How can I use data that has a comma in the prompt data that is not a LIST. i.e...
  3. AHFMR

    Packed Decimal Error - Impropmtu 7.0

    I am receiving the following error when running a report. General Exception has occured during operation 'asynchronous Open' EXPENG-E-PACKFMT, A <packed decimal> number has an invalid digit or sign. Any help would be appreciated. Thanks, AHF
  4. AHFMR

    Multiple Selection List Box

    Our organization is currently using Cognos as our reporting solution but thinking about going to Oracle Reports. Does Oracle Reports support Multiple Selection List Box. i.e. Ohio Oklahoma North Carolina South Carolina The user wants to select Ohio and Oklahoma as one of the user...
  5. AHFMR

    Buffer Info Bulk Fetch

    Impromptu version 7.0.809.0 SQL Version 2000 Every once in a while our report users receive the following error "Buffer Info passed to Bulk fetch is Invalid". Has anyone else in the past received this error, if so how were you able to resolve this. Any thoughts are appreciated. AHF
  6. AHFMR

    Using Stings as Prompts for Stored Procedure Reports

    Using Impromptu Versiov 7.0.809.0 SQL Server 2000 Have a Stored Procedure report that I need to pass in String information as one of the prompts. I can passin Integers, dates, etc but when I add a prompt that passes in a string the call fails. I know it is not the Stored...
  7. AHFMR

    Saving IMR to Excel W.Format results in Read Only Error

    We are Using Impromptu 7.0 Build 809.0 Windows 2000 Professional Excel 2002 SP-2 This situation occurs randomly. Without any symptoms our users will save the IMR to Excel W/Format. No errors are reported during the save process. When the user tries to open the excel file an error message is...
  8. AHFMR

    Displaying prompts on report do not reflect Prompt Value

    SQL Server 2000 Impromptu 6.0 build 613.0 On my reports I display the date range the users type in the prompts. When I display the prompts on the report, the prompt value does not reflect what the user entered. However if I display the detail filter the detail filter reflects what the user...
  9. AHFMR

    Eceeded 64 K Limit

    We are running SQL Server 2000. Cognos Version 7 Build 809 Every so often we receive the following Error SQL Has exceeded 64K Limit. Is this referring to the SQL stmt that is being executed? If not Any thoughts? AHF

Part and Inventory Search

Back
Top