Recent content by spattewar

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

YamaCog56, first let me thank you for providing your input and time on this. I haven't tried it and I am trying it now. Thanks again.

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

that is great. I can use this now. Also with the _age function if the DateLastUpdated is 31st may then (_age(cast([DateLastUpdated],date))) will yield - 1. Am i correct. Thanks again. $wapnil

Hi. Ties. Thanks for your reply. Will this also help me for lets say if I run the report now on 30th May 2007 I will get data which has last updated date as >= 30th May 2007. ie for e.g. 31st May 2007. Thanks again. $wapnil

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

I could get it working by putting something like (_age(cast([DateLastUpdated],date)) = 0) AND ([TimeLastUpdated]=maximum([TimeLastUpdated] for [VendorTradeNumber])) I do not know if it is the correct approach. Kindly provide your comments. thanks.$wapnil

Thanks for your input. I tried your suggestion but it gave an error saying The function "year" is not available as an external, database, or built-in function Is there something which I am missing??? $wapnil

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

This is nice. Thanks MF for you valuable inputs! Let me give this a try now and will let you know how it goes. $wapnil

Hey Nuffsaid.....it worked. Thanks a lot! you were of great help. I added 2 static choice as suggested and used the OR condition instead of the if then else statement and it worked. The only small issue here is that when I added 2 static choices 1) it displayed 2 radio button on the prompt...

Thanks for the input Ties. It is little cumbersome but works as expected!

any help on this will be greatly appreciated. I am kind of stuck with this issue. Thanks again. $wapnil

Actually the condition that I want is 1) When user selects to include cash [MajorAssetTypeDesc] IN ('Equities','Fixed Incomes',...,'Cash Balance') 2) If cash is not to be included [MajorAssetTypeDesc] IN ('Equities','Fixed Incomes',...) any suggesstion on how to compile a condition for this.