Search results for query: *

Hello Everyone, I am trying to setup SAP R/3 data source connection using cognos 8. The cognos support informed we need to have SAP GUI installed on the server but it did not resolved our issue. I am able to connect to SAP R/3 using SAP GUI on the cognos server but having issues setting up...

Hello Everyone, We are getting following cq error "Can not get property number for:table" The error is not consistent. It usually occurs when the load on the cq server has increased. Only workaround is to stop and start the cognos query services. I haven't found any document related to our...

If you unable to run any of the reports on the web check for the following Option. In Internet explorer browser go to tools & select Internet Options.click on general tab and click on settings tab. In settings check for newer versions of stored pages set to automatically or not.If not select...

In previous Cognos version ,open the report & save as different report.Then try to upgrade this report. I am not sure whether it works or not. bhas79

Hi, In Impromptu report,You can right click on Date data element & select Format & click on data tab.you can select the format required under normal & can also edit it. Bhas79

I think it may be the problem with the database connection. you can give that info in two ways. 1)Open the catalog go to the Catalog->user profiles click on database tab.In database logon give the user name and password.close the catalog and republish the report 2)if you are giving database...

I am trying to pass the type-in prompt value to a IWR report using an URL.please help me how can I do that. I am using IWR Ver 6.1 and Impromptu Ver 6.0 Thanks in Advance, Bhas79

they are some problems with exporting data to Excel in IWR 6.0 the data will be pushed to other columns.this problem has been resolved in IWR 6.1. you can publish the report and select the format has Excel and changes in the report like Bold and font size will refelect in the Excel report. you...

TNo Value entered date 1 200 8/1/03 0:00 2 200 4/1/03 0:00 2 300 4/1/03 0:00 2 400 4/1/03 0:00 2 400 5/1/03 0:00 2 23 5/1/03 0:00 2 213 5/1/03 0:00 3 13 5/1/03 0:00 3 123 5/1/03 0:00 3 123 4/1/03 0:00 3 113 4/1/03 0:00 I hope you are getting data from the same table. define current month=...

Is they any column to know when the record has been entered.how will you know whether the record has been entered last month or current month.Please post the specific details of the table structure

If you are using ODBC connection go to ODBC Data Source Administrator Go the tracing tab and check whether start tracing Now is running or not.if it's running stop the tracing and try to retrieve the views. Also try to retrieve the views on some other machine and run the report.it may narrow the...

I am assuming that your are connecting to the Oracle database. Open the catalog which you are using to run the reports From the file menu Open the catalog->databases.It opens in a new window.From Oracle select the database name you are using to connect.Click on Edit button and make sure that in...

I installed Cognos IWR Ver 6.1 .Now I am not facing that many formatting problems with Excel

I appreciate for your response.I will let you know if i am able to find a solution.

griffindm, I appreciate for your response.In report server I am checking the option to view in Excel format and after that in web browser i am selecting view in Excel format.what I found is that IWR exports to Excel using the Excel format for windows 95 version 7.0a.I heard that they are some...

I am using IWR Ver 6.0.508 on windows 2000.My reports are displaying data correctly in PDF format.but when i open same report in EXCEL some of my data values are jumping to other columns.My report contains tons of calculations and runs for couple of pages.please help me to figure out the problem

I am using IWR Ver 6.0.506 on windows 2000.my reports are displayed in Page Layout.How can i change my display to screen layout.Please Help me to find a Solution

Cosmicnerd, Thanks for your reply.In my report I have to compare main query total to a calculated value.I don't want this value to be repeated on every page.Now we modified our tables to get needed data into our main table and calculated the value. we can align this value to a particular...

I am trying to create a sub-report which consists of main query and sub-report queries and running couple of pages.problem is sub-report query data is repeating in other pages too.how can avoid that one ? Anyone can help me to figure it out.I am using Impromptu ver 6.0.