Search results for query: *

Try changing your line in question to: Set objImpApp = CreateObject("CognosImpromptu.Application") And see if that fixes your problem. The support for a registry call using the syntax you have in your current line ended with Impromptu version 6. Hope this helps, Dave G. The Decision...

For that version you need to create a dummy group header and move the report objects you would normally place in a page header into this dummy group header. Hide the page header, set the new dummy group header to repeat on each page and to page break before, and you have a report that will save...

Is the catalog and/or copy read-only? The Decision Support Group Reporting Consulting with Cognos BI Tools Magic with Data [pc2] Want good answers? Read FAQ401-2487 first! http://www.decisionsupportgroup.com

I've done the second page generation in Impromptu before by creating an extra artificial grouping and making the group footer appear under a conditional format. That gets you a page two based on data. Pulling from a different paper tray is another story. I've tried that years ago using a macro...

It's been a while, but I think you need at least Impromptu 7.1 MR1 to be fully supported under XP. I have had some luck running prior versions using XP's compatiblity options. Dave Griffin The Decision Support Group Reporting Consulting with Cognos BI Tools Magic with Data [pc2] Want good...

Filter on the maximum date value, but realize that this must be a summary filter, and is subject to grouping within the report. Dave G. The Decision Support Group Reporting Consulting with Cognos BI Tools Magic with Data [pc2] Want good answers? Read FAQ401-2487 first...

timepasse, As it would happen, I just had a similar situation yesterday. The report is grouped on all of those columns because subtotals are required. In my case, I was also doing an "Auto-Group", to get a group by clause in the SQL for performance benefits. In my particular instance I needed...

Another useful technique to use for this type of issue is to create the calculated column in SQL within a view of the original table. Then all Impromptu has to do is to report the database result of the calculation, as in: begin tran create view combo_data as select a.*,b.week_no from table1 a...

Write a macro and have it determine which report to open based on a user input. You can't do this within Impromptu itself. Dave G. The Decision Support Group Reporting Consulting with Cognos BI Tools Magic with Data [pc2] Want good answers? Read FAQ401-2487 first...

HaleyJo, Look for an eliminate any local-only functions in the report. Even with these gone there may be issues with editing the SQL. Does the report include multiple outer joins? If so, Impromptu will not let you manipulate the SQL, as it is doing the work of creating multiple SQL statements...

Does Impromptu still allow you to create a valid new report? (i.e. is the error specific to the report you are trying to open, or generic to your Impromptu application). Dave Griffin The Decision Support Group Reporting Consulting with Cognos BI Tools Magic with Data [pc2] Want good...

As a long-time user of Impromptu, I am accustomed to being able to insert objects in a report footer that do not directly relate to displayed list column data. From the classes I have had on CRN and my limited playing with the product I am not sure how to do this. An example would be showing a...

If you need to show a prompt with the results of two columns you can either use a report picklist and concatenate the columns in the picklist report, or create a SQL view and use the view in a catalog picklist. Remember that the matching results for the filter will have to have both values...

default page widths are determined by the default printer for the user. Check to see if there is a difference between the default printer for admin id than the one that is being used when it runs as a service. Not sure how to check the latter, but check with your IT staff and they may be able to...

I would either write a SQL Union view to combine data from both sources (Impromptu) or use custom SQL in ReportNet to do the same thing. Dave Griffin The Decision Support Group Reporting Consulting with Cognos BI Tools Magic with Data [pc2] Want good answers? Read FAQ401-2487 first...

It's in the machine registry. Do a search there for runmac32.exe Dave Griffin The Decision Support Group Reporting Consulting with Cognos BI Tools Magic with Data [pc2] Want good answers? Read FAQ401-2487 first! http://www.decisionsupportgroup.com

It has to do with the availability of the barcode font on the upfront webserver. Make sure it has the same font available as your local machine. Dave Griffin The Decision Support Group Reporting Consulting with Cognos BI Tools Magic with Data [pc2] Want good answers? Read FAQ401-2487 first...

I know the application comes with an executable called "CatalogPicklock.exe". I know of no documentation for this, but it's purpose seems obvious. It does not run with a simple arguement of the catalog name and path. I suppose Cognos support could help you with it if you have support. Dave G...

Rattler, Assuming all of the fact you need are in the employee table, what you need is a catalog self-join to the employee table. Add the employee table to a new catalog, then add it again using an alias name [i.e. Employee for Supervisor]. Join the two where the Empl.Supervisor =...

drlex, Can you put this into a Transformer FAQ so that it doesn't get lost as it ages? Dave G. The Decision Support Group Reporting Consulting with Cognos BI Tools Magic with Data [pc2] Want good answers? Read FAQ401-2487 first! http://www.decisionsupportgroup.com