Search results for query: *

Hi, I am using Congnosscript macro to display a form to the user which has selection for running multiple impromptu report. On this user form I want to put a list box containing values (for e.g. list of portfolios). This list is available in the catalog. It is just that I have to retreive it...

Hi, Environment: 1) Cognos 8 2) System DSN created using OMNI drivers provided by third party. When I work in the framework manager I could connect to the datasource using the DSN created and I could look at the data in the tables. I have created a new Query Subject using the new DSN source...

Hi, Thanks for your time. In my scenario I have to schedule 5 reports that I have created using the Report Studio in Cognos 8.0. While configuring the schedule there is no place to enter the output file name. Because of this each time when the scheduled report runs it creates a dynamic output...

HI, I am using cognos 8.0 and want to filter records based on the system date. But there is a possiblity that the dates in the database are greater than the system date due to different time zones and people from different zones updating the database. So if I want to get all the records from the...

Hi, Im my database the dates are stored in an integer format for e.g. for today's date they are stored as 20070515. But the current_date is in the format 2007-05-15. If I want to put a filter to the query to return rows for today's date only then how should I go about doing it. I am using...

Hi, I am using a single check box to on the prompt page to get the user input and use that input to set a filter on one of the column of the query. The paramter that I use while creating the prompt was Prompt_IncludeCash and I have put a sinle value in the static choices list with the value...

Hi, Thanks in advance for your help. I have data in the following format in a table No SecID Cur MarketValue 1 abcd USD 100 2 abcd EUR 150 But on the Report I want the fields to look like SecID Cur(local) Cur(Base) MV(Local) MV(Base) abcd...

Hi, I am using Cognos 8.0 and am building reports using the report studio. I want to give a prompt to the user with a single check box which has a text "Include Cash". When the user check the check box then do not filter the records and show all the transactions. It the user does not check it...

Hi, Thanks for your help. I want to add an image to my report header. How should I go about doing it? Also, all my reports want the same image, font style and font color on them. So can I create a template or something which can be used for all the reports. Thanks again. $wapnil

Hello, This might be a basic question but I am finding it hard to resolve it. Please be patient with me. I am creating a report in report studio. After adding the columns, I wanted to give a portfolio selection prompt to the user. So I add a prompt page and draged the value prompt onto the...

Whenever I try to connect to a secure site(128 bit encryption), Netscape 4.78 gives a Dr. Watson error and the application kills itself. Is there any problem with the machine itself or are there any setting to be done to connect to a secure site through Netscape?