Search results for query: *

Does anyone know whether you can filter on a returned java resultset WITHOUT executing another SQL with a filter (i.e. without performing another call on the DB)? For example if I had a resultset with a list of Sales Reps and Province, could I filter on that returned resultset for the Sales...

JVZ, Thanks for the link about Microsoft Access Project and for clearing up the supportStoredProcedures() method for me. That's interesting...I'll check it out.

Thanks for both your responses. ******************************************************** Response to: JVZ I was able to execute the Access query using the SELECT statement as suggested, but I was hoping to be able to execute the query by calling on it as a Stored Procedure. However, since...

Hi, First of all, is it possible to execute a query in Microsoft Access using the jdbc-odbc driver? I have tried using a CallableStatement to try to access my query. CODE EXCERPT: ******************************************************** Connection conn =...

I think Dave is right. Try using Set objImpApp = GetObject("CognosImpromptu.Application") instead of: Set objImpApp = CreateObject("CognosImpromptu.Application") NCU

Thanks a million - it worked perfectly. Things are always so much easier with a bit of direction. :-) NCU

Does anyone know how to pass a prompt value from a report to a macro? I have a main report that presents the user with 3 prompts. I need to use these prompt values to pass to a macro which is run from this main report. This macro opens 3 other reports using these prompt values. Any ideas? Thanks.

Issue resolved. I had a problem with the installation of the software - the User Workspace folder was missing.

I am trying to create a Cognos Impromptu report that is a multi-page report i.e. all the data that needs to be presented in the report cannot fit on one page. I understand that Cognos does not really handle this. Has anyone discovered any tricks that can be used to facilitate this sort of reporting?

I am trying to run one of the existing Cognos Impromptu macros by opening the related catalog, selecting the Tools menu item and the Macro option. When I browse to find the macro, the "Run" button remains disabled. Do I need to have certain privileges to run a macro? Any ideas why this...