Search results for query: *

Is it possible to write a script using Cognos Script to access ReportNet Objects?

I have a report with 4 Drill-through text items.Each one has to open a different report. I am able to set the drill through properties for each of the text items and they each point to a different report,but when I run the report, all links open the same report. What could be the problem?

I need to create a 'Menu' Selection,wherein a user will select the report that needs to be run. I want to display the list of reports as a List Box and when the user selects the report, the particular report should be run. Can this be done in ReportNet,if so how? Thanks

Hi, I need to create a drill-through Reportnet report from a PowerPlay cube.The PP cube sends a range of dates,which I am using as parameter to the Reportnet filter. I am using the in_range function(Schedule_Date in_range ?Sched_date?). The data seems fine, but I am unable to display the dates...

I am trying to get the Order Count for Items and Products,and am running into a problem. I have a query that gets the count of distinct orders for each item.(Select Item_Key,count(distinct order_no from orders group by item_key).This count needs to be rolled up to the Product Line Level. This...

I am trying to open an print a report from a macro, and the macro fails even while creating teh Report Object. Can someone pls look the code below and tell me what's worng? thanks for the help! btw, i am running Impromptu Ver7.2 on Win 2000. Sub Main() Dim objImpApp as Object Dim objImpRep...

Hi, I have a Form that has a List report on the top and a Form at the bottom.The Bottom form has the summary (the Header Information),and the List Report on the top has the details (Detail Line Info).If the number of detail lines is greater than 25,I want Impromptu to go to the next page.The...

Hi, I have a VB application, that reads data from a database and manipulates it and stores it back. While running the application from the VB editor, I am getting an VBexe error, that closes the Visual Basic editor. I don't get any other application error. The error message is: The Open...

What is the signaficance of allocations in the Transformer Model.How do we use them? Can someone help me with an example? Thanks Bob

I developed a Transformer Model with 3 different measures(M1,M2,M3),coming from 3 different data sources. Data is present only for the current month.But when I build the cube, the current month's data is also shown for all the other months. The first Measure M1(coming from the first data source)...

Hello, I am encountering a strange problem in Impromptu: I am unable to add a New Database to the Catalog.And when I try to look at the Catalog tables (Catalog -> Tables ), Impromptu crashes. Does anyone have a clue about this? Thanks for the help Bob

When summing up values,does Impromptu sum them on the database or on the report? I have a report which shows summary quantities,but to my surprise i found that though the report showed only the summary, it did actually bring in all the records and then summed them in the report. Does anyone have...

Hi, If anyone has ever migrated to a Windows 2000,while using Cognos 6.0,I would like to know: i)if there were any performance issues? ii)if there were any, possible solutions. we have just migrated from Windows Nt to Wind2k server,but the version of Cognos(Ver 6.0) reamined the same. I have...

Hi, I have a macro to open and save a report as Excel. I need to add a column to that Excel Spreadsheet.Can someone who has done that before tell me how to do that. thanks bob

Has anyone used Impromptu to create a Form,and Print it? I want to use Impromptu to create a Bill of Lading Form!! Does anyone think it is not a feasible idea? Also, can someone guide me through a complex form creation process? Thanks Bob

Hi, I have a macro that opens a report and saves it as an excel file with format(using the Send Keys),and then emails the excel file.I scheduled this macro to run automatically everyday.I have a strange problem. This macro waits at the point where it has to do the Send Keys. I work in a terminal...

Is it possible to display multiple measures on a single PowerPlay Report? As far as I have seen, we can have them all as measures in the Cube,and toggle between the measures.But say,if I have Orders and Shipments as measures,how can I show a both the Orders and Shipments simultaneously? Another...

Is there a way to email reports automatically using Cognos Tools?

Hi, I just started using Cognos Series 7.0,and am updating my reports and macros. The macros are failing because the CreateObject Function is failing. The Code I used is as follows: Dim ImpApp as Object Dim ImpRep as Object Sub Main Set ImpApp=...

Hi, I am working with Impromptu 6.0 and I observed in one of my reports that Impromptu is not sending the Date filter to the database. The data on the report is filtered,but the date filter was not sent to the DB, because of which the report is taking a long time. has anyone ever faced this...