Recent content by AHFMR

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

Yes that is what I am saying. I have a type In Prompt (the only prompt for the report) and when I pass the data into the prompt it will cut it off at the comma. The data I am passing into the reports looks as follows Smith, john Smith, Joe Below is the macro. It is straight forward...

Thanks for your responses. drlex the report requires One prompt "Name". The format of the name in the DB is "Lastname, Firstname". Converting the comma to a space will not work because then you will find no matches in the DB. griffindm you are correct passing a prompt in with commas is the...

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

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

nagornyi, you state there is no way to do anything beyond drop down list using Oracle Reports only. Do you know of any tools that can be purchased that will allow you to use List Boxes. Thanks for your help

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

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

What package will you be using to execute the custom SQL.

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

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

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

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