Recent content by griffindm

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