Search results for query: *

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

Is it possible to open pdf file through macro?

how can I display last transaction date for a client in cube? If I add it as date wizard, the performance is really bad to display Client .... Last transaction date, creation date Any Idea?

Is it possible to merge two reports in pdf? Say I have report1.imr and report2.imr I would like to save those two report as report.pdf Is it possible to do it via macro? Manually you can insert pages in Acrobat distiller. Thanks.

Hello, I was wondering if any body knows if I can keep my IMPORMPTU.ini in shared drive so that all the users are pointing to one file. so any time I add any style, I just need to change one file.

I need to keep two versions of catalogue, one pointing to Production database and one pointing to Development database. I tried changing servername to point it to dev. It works fine on my machine but does not work on other pc. In that pc cognos.ini still pointing to production. How can I...

Hi, I am trying to schedule macro in Scheduled Task - Windows 2000 Server. It is not working. Do I have to call macro through a batch file ? I would appreciate any help on this matter. Thanks.

Hi I have a crosstab report where my columns are month and year i.e. Dec 02 | Jan 03 | Feb 03 etc. But when I apply the date format to column, it is not applying the date format. How can I do this?

Hi, I was wondering if there is any way to suppress message "Report is locked by another user" when user opens a Impromptu report. Since this reports are Read Only to users this message keeps comming when user opens the report. Is there any way to suppress this message. Thanks.

Hi, How can do the follwoing. I have Region , City , Sales Team , Employee Cascading promtps. Employee is filtered by Region , City and Sales Team. What if I have multiple Sales Teams and I need to choose 'ALL' employees. How can pass values of Sales team and employee to the report? Thank you.

Hi Is there any ways to pass multiple values to Type in Prompt. I have a client prompt where I need to pass more than one values to a report. If I use Report picklist, it becomes huge because I have 8000 records for clients - which is not user friendly. Please let me know is there any way...

Is it possible to create Database UDF for Sybase database?

Is it possible to append two pdf files in one via macro? With distiller you can add two or more files manually with opening as pdf option and appending it. I was wondering if there is any possiblity to do that in macro at the time of publishing impromptu report to pdf. Your suggestions are...

Hi, I was wondering if it is possible to open a detailed report from the parent report by passing parameter values from main report. for eg. parent report has columns sales_team volume revenue ========================== 1 10 20 2 100 200 3 50 100 Child...

I am having promblem with conditional formatting in Impromptu. I have one reports which uses few condtional formatting. It works fine on my machine. But it disappears on user's machine. Is there any other way I can handle this problem without having to change IMPROMPTU.ini on user's machine...

I am trying to get a database user name in impromptu. I am using sybase as a database. In sybase if try to get name using user_name() or suser_name()function, I get different value. I am using a physical table to report from, where I insert records through stored procedure. Now I want to...

Hi I am trying to open a hotfile (imr type) through macro by passing prompt values. OpenReport property opens the report but does not accept prompt values. It opens the prompt window. If I try to open the regular report the sameway it works fine. Does anybody have idea on this issue?

Hi, I have a report where user wants to see all the dates between the Start Date and End Date prompt in the report even if there is no data in the table. i.e. If user enters start date as '20030401' and end date as '20030403' user wants to see as 04/01/2003 abc 100.00 04/02/2003 abc 0.0...

Hi I would like know if there is any good solution to following situation. I have three tables - Account , Employee_Team and Tdata with three conditions 1. where account.account_cd = Tdata.account_cd and account.employee_team_id = employee_team.employee_team_id 2...

Hi, I would like to know how can I pass multiple values in stored procedure call. Impromptu versesion = 7.0 and databae is sybase 12 Thanks