Recent content by dm21

DoubleD, I did have a problem when I have scheduled my reports. My Monthly reports run for longer period. Within the same macro I create a new object for Impromptu. So, one of my monthly report runs twice with different parameters which got conflicted. so this is what happened 1 - Report...

DoubleD, You are correct, I have added more info: 1. User requests Report A to run. 2. All records of User requesting Report A should be removed from the table. (Within Stored Procedures) 3. A new record should be added to the table stating User requested Report A. (Within Stored Procedures)...

Hi DoubleD, I am asking both the scenario, first to save it unique and secon how to retrieve that unquie data from Impromptu.

How can I filter that in Impromptu report? Currently I am using user() function to filter data in Impromptu. I do not want to use prompt as it will not look good.

When I say same time it means it could also have difference of 1 minute. For eg. process 1 starts and trying to save data in table and process 2 starts and it will try and delete data based on user id and report id from the table and will save data based on 2nd request. In result the out put...

Hi, I am using Impromptu 7.1 version with Sybase database. I have created a few macros where I call Impromptu stored procedure report which saves data in physical table with unique id of database user id and report id. And finally creating simple list report going against the physical table...

Thank you for your help

Is it possible for you to share your bakcup procedures? It will give me some idea? Currently I am working on backup procedures. How do you backup LAE files? Do you export to LAE file every time you do the changes in namespace?

Is it neccessary to stop the services to do the backup?

Dave, Thanks for the macro. I will look at it. Cindyw, Are you not having problem with File processor. My File processor takes two long. In 3 to 4 hours it just loaded 3 to 4 sessions in the database. I am using Sybase.

You can do with Microsoft outlook as follows: Dim ImpApp As Object Dim htmlObj As Object Dim ImpRep As Object Dim objOutlook As Object Dim objOutlookMsg As Object Sub Main() Set ImpApp = CreateObject("Impromptu.Application") ImpApp.OpenCatalog "C:\Program...

Dave, Is it possible to send the sample macro you are using to load audit data. The Impromptu File Processor takes too long............... Thanks

Is it possible to open pdf file through macro?

Prasad, What solution did find finally?

JimTekki, The way I have been using macros is I create a batch file containing "C:\Program Files\Cognos\Cer3\runmac32.exe" "C\Macro\ACL.mcx" You would schedule this batch file. This is been working for me and I have sp4 upgraded.